AP Transactions displays a list of all transactions recorded in the system, including AP Invoices, AP Credit Memos, and AP Payments. 

 

Users can customize their view by changing the column order and showing or hiding certain columns. To find specific Accounts Payable transactions, users can filter for specific information. Once a view is customized, users can save the view. This allows users to quickly view the information that they deem to be most valuable for their organization. 


Article Topics



  • From the Accounts Payable section of the left navigation menu, select AP Transactions.
    The AP Transactions screen appears.



Back to Top


Columns on the AP Transactions table


There are several ways in which users customize how information is displayed in the table. Use the Show/Hide Columns drop-down to determine which columns appear. Select the checkbox to display the column, or clear the checkbox to remove it from the table. Users can also select column headers to reverse the sort order within the column or drag a column left or right to change the order of the columns in the table.


The following table defines all available columns. Due to the highly customizable nature of the table, columns might not appear in the order they are listed below, and some columns might not be available depending on the user's permissions and configurations.


ColumnDescription
Approval StatusIndicates whether the transaction is in an Approved or Unapproved status.
LocationDefault location for the transaction.

Note: The transaction details might display one or more different locations, other than the default.
Location NumberUnique number used to identity the location.
Legal EntityLegal entity associated with the transaction.
Missing ItemsIndicates that a vendor item on the invoice is not mapped to an item in R365. For more information, see AP Transactions: Missing Items.
Transaction TypeIndicates whether the transaction is an AP Payment, AP Invoice, or AP Credit Memo.
EmailEmail address for the vendor.
NumberA unique number used to identify the transaction in the system.
DateDocument date for the transaction.
Posting DateDate when the transaction posted to the General Ledger.
R365 Transaction IDA unique number used to identity the transaction in R365 Payments.

Note: This column is only available if R365 Payments is enabled.
R365 Payment StatusIndicates the status of the transaction in R365 Payments.

Note: This column is only available if R365 Payments is enabled.
Status Last UpdatedDate when the R365 Payment Status was most recently updated.

Note: This column is only available if R365 Payments is enabled.
R365 Payment MethodMethod of payment used when paid through R365 Payments.

Note: This column is only available if R365 Payments is enabled.
Batch CodeA unique number used to identity the payment batch in R365 Payments.

Note: This column is only available if R365 Payments is enabled.
VendorVendor associated with the transaction.
Vendor GroupVendor group to which the vendor belongs, if applicable.
1099 Form1099 Form on which the transaction's 1099 amount is reported.
1099 Box1099 Box on which the transaction's 1099 amount is reported.
1099 AmountAmount of the transaction to be reported on the vendor's 1099 Form.
CompanyName of the vendor.
Paid ToRecipient of the payment. This is usually the same as the vendor.
PriorityIndicates the priority status as marked by a user, if applicable.
AmountTotal amount on the transaction.
Amount RemainingRemaining balance on the transaction.
CommentComments attached to the transaction.
Checking AccountBank account used on the transaction.
First AccountGL Account from the first line of the transaction.
First AmountAmount from the first line of the transaction.
Only One DetailIndicates if there is only one line on the transaction.
Current ApproverName of the current approver.
Approved ByName of the person who approved the transaction.
Approved OnDate when the transaction was approved.
Origin Data SourceIndicates whether the transaction was created manually, by EDI, or by OCR.
Created ByName of the person who created the transaction in the system.
Created OnDate when the transaction was created.
Modified ByName of the person who last updated the transaction.
Modified OnDate when the transaction was most recently updated.
Spread TypeDescription of the spread transaction, if applicable.
AttachmentIndicates that there is one or more file attached to the transaction.
Start DateFirst date on which an accrual is attached to the transaction.
End DateLast date on which an accrual is attached to the transaction.
Due DateDate when payment is due.
Days Till DueNumber of days remaining until payment is due.
JE TypeType of journal entry, such as Standard, Payroll, Beginning Balance, and so on.
Operation StatusIndicates whether the Operations Status of the transaction is In Progress or Completed.
Bank ReconciliationLink to the bank reconciliation record that includes the transaction.
Payment TermsPayment Term on the invoice.
PO NumberA unique number used to identify the purchase order.
VoidingIndicates if the transaction exists to cancel out an earlier transaction.
VoidedIndicated that the transaction was cancelled.
Print StatusIndicates if the payment was printed.
Check RunPayment Run that includes the payment for transaction.
Payment MethodMethod of payment used: ACH, ADD, check, credit card, or R365 Payments.
Aging StatusIndicates whether the payment is Current or Past Due.
Estimated Delivery Date

Date when the payment is expected to be delivered to the vendor. This date is an estimation based on average processing times and might not be exact.


Back to Top


Rearranging Column Order 


The AP Transactions table can be rearranged so that users can view information in any order. To rearrange columns, click the column header and drag the column to the desired position.



Back to Top


Changing and Saving List Views


Users can edit and save views. To learn more about working with views, click here.