Accounts payable invoice report

Requirement

The provision of a report over the accounts payable ledger, by an accounting system, is commonly required. This report must specify the invoices included in the balance in the accounts payable ledger and the general ledger.

In this country, no specific layout is required for printing outstanding invoices and credit notes out of the accounts payable ledger. Internal financial control practices include reconciling a balance in the general ledger with the invoice details from the accounts payable ledger.

A normal layout shows all open invoices, credits, and on account payments at a certain date.

M3 solution

The detailed Accounts Payable report shows the list of all open invoices at a given date. In addition, the same report can show a list of all open invoices that were open at a date and that were still open at a later date.

Configuration guidelines


Program ID	Program name	Description or comment
APS500	Accounts Payable. Print	Four invoice selections and two unique layouts.
APS905	Settings – Accounts Payable	In panel F, in the Supplier Payments section, clear settings 200 and 270, and define setting 240 as requested.
CRS165	Number Series. Open	For payment proposals, set the series type to 80-0. For payment references, set the series type to 89-1. For payment advice, set the series type to 67-A.
CRS045	Country. Open	We recommend that you follow the ISO 3166-1 standard.
CRS046	State per Country. Open	If applicable, we recommend that you follow the ISO 3166-2 standard.
CRS055	Currency. Open	We recommend that you follow the ISO 4217 standard.
CRS071	AP Payment Method. Open	Set the payment class to 3-Bank transfer. Set the transfer method to 3-Electronic payment. You can set the grouped payment to 0, 1 or 2. You can set the bank confirmation to 0 or 1. The electronic format and the number of characters can be used to define the length and the details of the payment information.
CRS405	FAM Function. Open	Configure function AP32.
CRS620	Supplier. Open	Define the supplier with the payment method for credit transfer, that is, payment class 3.
CRS622	Supplier. Connect Address	Supplier name and address using one of these address types: 10-Bank address 01-Postal address, if address type 10 is not defined
CRS690	Bank. Open	BIC (SWIFT code) of the company bank account and supplier’s bank accounts. See the settings for (CRS692).
CRS072	Bank Account Indicator. Open	See Format of bank account numbers.
CRS692	Bank Account. Open	Bank account type 1-Company defined with bank account indicator ABAN or BBAN: BIC or SWIFT code defined in (CRS690).
CRS692	Bank Account. Open	Bank account type 2-Supplier defined with bank account indicator BBAN: BBAN defined in the bank field 1 in (CRS692/E) or in the A/C number at financial institute in (CRS692/F). BIC or SWIFT code defined in (CRS690).