Understanding the As Of Date Feature
When you review invoices using the Customer Ledger Inquiry program, you can review them as of a specific date by completing the As Of Date field on the Work with Customer Ledger Inquiry form. This enables you to review a customer's account for a previous period.
When you use an as of date, the system compares the value that you enter with the Date Closed field of the invoice. If the "as of" date is after the closed date, the system skips the record. If the "as of" date is before the closed date, the system compares the "as of" date with G/L date of the Receipts Detail records (F03B14) that were applied to the invoice to calculate the open amount of the invoice as of the date entered.
For example:
Invoice 1234 for 1000.00 is due June 30, 2008.
Receipt 44321 for 200.00 is applied June 10, 2008 (G/L date).
Receipt 44955 for 800.00 is applied June 30, 2008 (G/L date).
Date Closed is June 30, 2008.
As Of Date is June 15, 2008.
Because the as of date (June 15, 2008) is before the closed date (June 30, 2008), the system reads the Receipt Detail records. Because the G/L date of the first receipt is before the as of date, the system calculates the invoice open amount on June 15, 2008 to be 800.00 (1000.00 − 200.00), and continues to the next receipt record. However, because the G/L date of the second receipt is after the as of date, the system ignores it.