Determination of Invoices and Payments
To prepare the list of customer invoices and payments, the Sales Ledger report proceeds as described in the following.
First, the report reads all tax-relevant documents (tax transfer documents, invoices with target tax codes, and down payments), and determines which invoices and payment documents relate to them as follows:
In tax transfers, the report reads the number of the invoice and the number of the payment from the Reference
and Assignment
fields respectively. If the Assignment
field contains a clearing
document number instead of a payment document number, the system uses the payment date and number from the first payment item in the clearing document.
In invoices with target tax codes, the number of the payment document is stored in the customer item.
In the case of down payments, the payment number counts as the invoice number as well as the payment number. The report does not mark down payments as such, nor is this required.
If you posted VAT from Sales and Distribution
(SD) invoices for goods in transit, the report reads the Reference Document Number
field of the accounting document that was created during the VAT posting. If it finds the “VAT^” prefix
in that field, it enters the relevant SD invoice document number as the invoice number and the billing date as the date of the invoice. The invoice amount, VAT amount, and customer data fields are also retrieved from the SD invoice. Once payment has been made and an FI invoice has already been created,
the report enters the payment data (payment document number, payment date, and so on) using the data from the FI invoice.