AP Transactions

Approval Status

Indicates whether the transaction is in an Approved or Unapproved status.

Location

Default location for the transaction.

The transaction details might display one or more different locations, other than the default.

Location Number

Unique number used to identity the location.

Legal Entity

Legal entity associated with the transaction.

Missing Items

Indicates that a vendor item on the invoice is not mapped to an item in R365. For more information, see Missing Items.

Transaction Type

Indicates whether the transaction is an AP Payment, AP Invoice, or AP Credit Memo.

Email

Email address for the vendor.

Number

A unique number used to identify the transaction in the system.

For payments processed through the R365 Payments service, payments in the following statuses will show ‘R365’ without a specific number:

• Not Sent

• Submitted

Once processing begins, the check number will be automatically updated.

Reissued checks will result in updated payment numbers.

Date

Document date for the transaction.

Posting Date

Date when the transaction posted to the General Ledger.

R365 Transaction ID

A unique number used to identity the transaction in R365 Payments.

This column only populates if R365 Payments is enabled.

R365 Payment Status

Indicates the status of the transaction in R365 Payments.

This column only populates if R365 Payments is enabled.

Status Last Updated

Date when the R365 Payment Status was most recently updated.

This column only populates if R365 Payments is enabled.

R365 Payment Method

Method of payment used when paid through R365 Payments.

This column only populates if R365 Payments is enabled.

Batch Code

A unique number used to identity the payment batch in R365 Payments.

This column only populates if R365 Payments is enabled.

Vendor

Vendor associated with the transaction.

Vendor Group

Vendor group to which the vendor belongs, if applicable.

1099 Form

1099 Form on which the transaction's 1099 amount is reported.

1099 Box

1099 Box on which the transaction's 1099 amount is reported.

1099 Amount

Amount of the transaction to be reported on the vendor's 1099 Form.

Company

Name of the vendor.

Paid To

Recipient of the payment. This is usually the same as the vendor.

Priority

Indicates the priority status as marked by a user, if applicable.

Amount

Total amount on the transaction.

Amount Remaining

Remaining balance on the transaction.

Comment

Comments attached to the transaction.

Checking Account

Bank account used on the transaction.

First Account

GL Account from the first line of the transaction.

First Amount

Amount from the first line of the transaction.

Only One Detail

Indicates if there is only one line on the transaction.

Current Approver

Name of the current approver.

Approved By

Name of the person who approved the transaction.

Approved On

Date when the transaction was approved.

Origin Data Source

Indicates whether the transaction was created manually, by EDI, or by OCR.

Created By

Name of the person who created the transaction in the system.

Created On

Date when the transaction was created.

Modified By

Name of the person who last updated the transaction.

Modified On

Date when the transaction was most recently updated.

Spread Type

Description of the spread transaction, if applicable.

Attachment

Indicates that there is one or more file attached to the transaction.

Start Date

First date on which an accrual is attached to the transaction.

End Date

Last date on which an accrual is attached to the transaction.

Due Date

Date when payment is due.

Days Till Due

Number of days remaining until payment is due.

JE Type

Type of journal entry, such as Standard, Payroll, Beginning Balance, and so on.

Operation Status

Indicates whether the Operations Status of the transaction is In Progress or Completed.

Bank Reconciliation

Link to the bank reconciliation record that includes the transaction.

Payment Terms

Payment Term on the invoice.

PO Number

A unique number used to identify the purchase order.

Voiding

Indicates if the transaction exists to cancel out an earlier transaction.

Voided

Indicated that the transaction was cancelled.

Print Status

Indicates if the payment was printed.

Check Run

Payment Run that includes the payment for transaction.

Payment Method

Method of payment used: ACH, ADD, check, credit card, or R365 Payments.

Aging Status

Indicates 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. For more information about R365 Payments payment processing times, see Payment Methods.