Use the Posted Invoice Register to review accounting lines for invoices that have been transferred and posted to your general ledger. Because it presents amounts that have been charged to liability accounts, this report is valid only for an accrual ledger.
The Posted Invoice Register is primarily a reconciliation tool. Use this report along with the Posted Payment Register and the Accounts Payable Trial Balance Report to reconcile balances between Payables and your general ledger. To make their output easier to read, each of these reports can be generated for a single liability account. For example, if you are using Automatic Offsets and the liability for your invoices is allocated across multiple balancing segments, then you can use the Liability Account parameter to limit your reports to a single balancing organization.
You can generate the report in summary or in detail. When generated in detail, the report displays invoices charged to liability accounts and the accounting information that has been transferred to the general ledger. Also included is the supplier and amount information for each invoice listed. Payables displays the total invoice amount in the invoice currency, and the transferred distribution amount in both the invoice currency and accounted currency for easier reconciliation with your general ledger.
Note: The posted distribution amount only includes distribution lines that have been transferred to general ledger.
When generated in summary, the report lists totals for each liability account and does not include any invoice detail.
The report always sorts first by liability account. If the report is submitted in detail, it then sorts in the following order:
The report sorts using the Order By parameter, either Journal Entry Batch or Entered Currency. The default value is Entered Currency, and you can change the parameter value only if the report includes journal entry batch names (the Include Journal Entry Batch parameter is Yes).
The report then sorts by supplier name, invoice number, and invoice date.
Transfer your accounting entries to general ledger.
To ensure that the general ledger information for the journal entry batches appears on this report, you must enable the Import Journal References option for the Payables source in the Journal Sources window. See: Defining Journal Sources.
To review information for parameters used in multiple reports, such as ledger Currency, see: Common Report Parameters.
From/To Accounting Date. Inclusive accounting date range for invoices in the report.
Liability Account. If you want to submit the report for a single liability account, then specify that account here. Leave this parameter blank to submit the report for all liability accounts.
Include Journal Entry Batch. Enter Yes if you want the report to include the names of all journal entry batches in which the invoice transactions were transferred. Note that if you choose to include this information the report will take longer to generate.
Journal Entry Batch. If you want to submit the report for a single invoice journal entry batch, then specify that batch here. Leave this parameter blank to submit this report for all invoice journal entry batches.
Order By. This parameter is used to sort reports that are generated in detail. The default value is Entered Currency. You can select the Journal Entry Batch option only if you first enter Yes for the Include Journal Entry Batch parameter.
Entered Currency. Sort the report by:
1) liability account
2) invoice currency
3) journal entry batch name (only if you enter Yes for the Include Journal Entry Batch parameter)
Journal Entry Batch. Sort the report by:
1) liability account
2) journal entry batch name
3) invoice currency
Summarize Report.
Yes. Summarize the report by liability account and do not include invoice detail.
No. Include invoice detail.
Invoice Amount. Total invoice amount.
Posted Distribution Amount - Entered/Accounted Currency. Total of the transferred invoice distributions in the invoice currency and the accounted currency.