Days Credit Sales Outstanding (days_credit_sales_outstanding with GENREPPAR.FMX)

Note: This report is only available when the CASHIERING > ACCOUNTS RECEIVABLES application function is set to Y.

The Days Credit Sales Outstanding report calculates the total AR outstanding (non-credit card) for the current business date. The report then subtracts daily balances from the outstanding until it reaches 0. The number of days it takes to reach 0 is displayed at the bottom of the report and represents the total Days Sales Outstanding.

Features of this report include:

• The report has no parameters. It always runs for the current business date.
• The daily balances are taken from the TRIAL_BALANCE table which is only calculated during End of Day processing. Therefore, the daily balances considered are from the current business date - 1.
• The total AR outstanding (non-credit card) is taken from the current outstanding and includes transactions made in AR on the current business date.
• The report includes all AR transactions excluding credit card transactions (payments made to credit cards which have an AR account). Any invoices made in AR are included, even if the invoice is associated with an AR account that belongs to a credit card.

Report fields are defined as follows:

Day. The number of days required to reach the balance outstanding.

Date. The business date and the outstanding on the business date. Starts from pms_p.business_date-1 and goes below.

Daily. The total balance for each date

Accumulated. Running total of the daily balance

Accounts Receivable Balance for Today. Total outstanding balance at the time of running the report(does not include credit card transactions)

1- XXX Days. This the accumulated running total on day XXX(starting from pms_p.business_Date-1 as day 1 and going backwards).

Difference. The amount difference between point 5 and 6. If there is a difference, then the percentage is calculated based on the balance on XXX+1 day.

Example:
1.Total AR receivable is 2000.00

2. Accumulated balance on day 5 is 1900.00

3. Accumulated balance on day 6 is 2200.00

4. Therefore, the daily balance on day 6 is 300.00

5. Difference (1-2 = 100)

The percentage is calculated using the difference (5) and the daily balance on day 6 (4). = 33%.

Result displayed on the last line. This gives the number of days + the percentage, to arrive at the result. In the above example:
Days Credit Sales Outstanding for the current business date = 5.33 days