Payables Invoice Distribution

1

Filter By

• Location

• Legal Entity

• Location Group

• Location Reporting Category

2

Filter

3

Date By

The Date by filter sets the criteria for applying the start and end date filters.

Select either AP Invoice Date or Date Paid to determine which dates will be used to filter report results.

4

Start Date

The start date of the report.

5

End Date

The end date of the report.

6

Unapproved

This option will either include or exclude unapproved AP invoices.

Yes - includes unapproved invoices.

No - excludes unapproved invoices.

7

Vendor Group

A listing of all vendor groups.

8

Vendor

A listing of all vendors.

9

Account

A listing of al GL Accounts.

10

Bank Account

A listing of all bank accounts.

11

View Options

12

Run Button

1

GL Account Number

The GL account number.

2

Document Date

The document date for the invoice.

3

GL Date

The date the invoice posts to the general ledger.

4

Type

The R365 assigned transaction type (AP Invoice).

5

Vendor Number

The number associated with the vendor as noted on the Vendor record.

6

Vendor Name

The vendor name, as selected from the Report Parameters.

Users can click the hyperlink to the open the vendor record in a new tab.

7

Vendor Group

The Vendor Group associated with the Vendor, as noted on the Vendor record.

If using the latest version of macOS Catalina (10.15.6) while downloading this report, ensure that the report is opened via browser rather than Preview to access hyperlinked items.

8

Number

The invoice number.

Users can click the hyperlink to open the invoice in a new tab.

If using the latest version of macOS Catalina (10.15.6) while downloading this report, ensure that the report is opened via browser rather than Preview to access hyperlinked items

9

Legal Entity

The name of the legal entity assigned to the location.

10

Location Number

The number associated with the location as noted on the location record.

11

Location

The name of the location associated with the invoice.

12

Expense Amt

The amount of the distribution line from the AP Invoice.

13

Date Last Paid

The date of the most recent payment or credit memo applied to the invoice.

14

Payment Ref

The R365 document number assigned to the payment or credit Memo that was most recently applied to the invoice.

15

Total Amt Paid

The portion of the payment or credit memo that is applied to this distribution line of the invoice.

When one invoice is applied to different GL Accounts, that invoice will appear for each account, and as the invoice amount is paid, the payment will be distributed among all GL Accounts based on the amount owed for each account, reflecting a remaining amount for each. For example, an invoice with a total of $1000 is partially paid in the amount of $750. This payment will be applied to the entire invoice, but is distributed among 3 separate accounts:

• GL Account #1 = $350 / $1000 = 35% x payment of $750 = $262.50, leaving a remaining balance of $87.50

• GL Account #2 = $500 / $1000 = 50% x payment of $750 = $375, leaving a remaining balance of $125

• GL Account #3 = $150 / $1000 = 15% x payment of $750 = $112.50, leaving a remaining balance of $37.50

16

Amt Remaining

The open amount of the distribution line as of the date the report is ran. For outstanding balances on an invoice with multiple expense accounts, review the note above for the 'Total Amt Paid' column.

17

GL Account Name

The name of the GL account.

18

Current Balance

Header for current balance details:

• Date Last Paid

• Payment Ref

• Total Amt Paid

• Amt Remaining

19

Expense Amt Sum

Total of all expense amounts from distribution lines associated with the same GL account.