--- title: "Payables Invoice Distribution" slug: "payables-invoice-distribution" description: "View GL account distribution of AP invoices and payments as of the run date, filtered by vendor and bank account." updated: 2025-08-26T16:59:46Z published: 2025-08-26T16:59:46Z canonical: "docs.restaurant365.com/payables-invoice-distribution" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Payables Invoice Distribution The Payables Invoice Distribution focuses on the distribution of specified GL accounts within AP invoices and the payments applied to them. Since payments in R365 are applied at the invoice level, they will be distributed on a weighted average basis if any balance remains on the invoice. The report includes AP invoice distribution lines and reflects payments and credits as of the report’s run date, regardless of the date range specified. Users have the option to filter by bank accounts, vendor, AP invoice date, paid date, and GL account. > 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. --- ## Navigation The My Reports search bar can be used to search R365's entire catalog of reports. 1. Open the **Reports** app. 2. Navigate to **My Reports**. 3. Enter all or part of the report name in the **search bar**. 4. The **Results** tab will open with the list of search results. 5. From beneath the report name, click **Run** to run the report with the selected report view. -OR- Click **Customize** to adjust the report parameters and run the report. ![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png) --- ## Report Parameters ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-1POYBCET.png) | Parameter | Description | | --- | --- | | Filter By | Filter options for the report: - Location - legal entity - [Location Group](/doc/docs/location-groups-overview) - [Location Reporting Category](/doc/docs/location-reporting-categories) | | Filter | A list of filter options determined by the 'Filter By' category selected. | | 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. | | Start Date | The start date of the report. | | End Date | The end date of the report. | | Unapproved | This option will either include or exclude unapproved AP invoices. **Yes -** includes unapproved invoices. **No -** excludes unapproved invoices. | | Vendor Group | A listing of all [vendor groups](/doc/docs/add-a-vendor-group). | | Vendor | A listing of all vendors. | | Account | A listing of al GL Accounts. | | Bank Account | A listing of all bank accounts. | | View Options | This section provides options to select, save, edit, or delete a [report view](https://docs.restaurant365.com/docs/report-views). | | Run Button | Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report. | . --- ## Report Columns ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-KRVV7RNW.png) | Column/Field | Description | | --- | --- | | GL Account Number | The GL account number. | | Document Date | The document date for the invoice. | | GL Date | The date the invoice posts to the general ledger. | | Type | The R365 assigned transaction type (AP Invoice). | | Vendor Number | The number associated with the vendor as noted on the [Vendor record](/doc/docs/vendor-record). | | Vendor Name | The vendor name, as selected from the Report Parameters. Users can click the hyperlink to the open the [vendor record](/doc/docs/vendor-record) in a new tab. | | Vendor Group | The Vendor Group associated with the Vendor, as noted on the [Vendor record](/doc/docs/vendor-record). > [!NOTE] > 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. | | Number | The invoice number. > [!NOTE] > 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 | | Legal Entity | The name of the legal entity assigned to the location. | | Location Number | The number associated with the location as noted on the [location record](/doc/docs/legal-entities-location-record). | | Location | The name of the location associated with the invoice. | | Expense Amt | The amount of the distribution line from the AP Invoice. | | Date Last Paid | The date of the most recent payment or [credit memo](/doc/docs/ap-credit-memo) applied to the invoice. | | Payment Ref | The R365 document number assigned to the payment or credit Memo that was most recently applied to the invoice. | | Total Amt Paid | The portion of the payment or credit memo that is applied to this distribution line of the invoice. > [!NOTE] > 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 | | 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. | | GL Account Name | The name of the GL account. | | Current Balance | Header for current balance details: - Date Last Paid - Payment Ref - Total Amt Paid - Amt Remaining | | Expense Amt Sum | Total of all expense amounts from distribution lines associated with the same GL account. | --- ## Email, Export, or Print the Report This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to [send, export, or print this report](/doc/docs/my-reports-send-export-or-print-reports). ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-U3S8UCR9.png) Restaurant365 Financial account used to record specific transactions in the general ledger. An organization or company configured in R365 that represents a distinct legal and tax-reporting unit. Legal entities contain one or more locations and define how financial and operational activity is grouped, reported, and filed.