Method Used with Retainage
Retainage, when cleared, creates a new voucher with a different document number. Therefore, if you use retainage, you must use the A/P method. The record for this new document that the system writes to the Account Ledger table (F0911) contains only those credit and debit accounts that are not part of the original expense.
The following table is an example that describes the original document and the new document that the system creates for the retainage:
Date |
Document Number |
Payment Amount (F0411 table) |
G/L Distribution: Debit (F0911 table) |
G/L Distribution: Credit (F0911 table) |
---|---|---|---|---|
December 5th, 2023 |
123 |
4500.00 USD |
5000.00 USD |
{500.00 USD} PCRETN (retainage) |
January 5th, 2024 |
456 |
500.00 USD |
500.00 USD |
{500.00 USD} |
In the preceding table, document number 123 shows the payment amount of 4500 USD, which will be reflected on the 1099 for the supplier. The following year, document number 456 is included for 1099 processing by using the A/P method only. The system cannot use the G/L method, to include the document number 456, because the record in the F0911 table did not use an expense account that falls within the PX AAI range.