Aged balance/currency
The BALAGEGRPDEV report categorizes BP open items that are not overdue into an aging schedule based on the open item due date or by the open item invoice date.
The aging schedule is based on three report parameters: No. of days 1, No. of days 2, and No. of days 3. The report calculates the number of days using the invoice date or the due date depending on the Age invoices by report parameter setting. The Age invoices by parameter default is due date. If you select Age invoices by invoice date, open items that exceed the Pivot date are not included.
If you select Yes for the Open item overrun report parameter, the report only includes customers who have exceeded their authorized credit limit amount.
Prerequisites
List of criteria
Parameter | Parameter title | Type |
|---|---|---|
societe | Company | |
sitedeb | Site range | |
coldeb | Range of control accounts | SAC |
grpcol | Control group | |
tiersdeb | Range of business partners | |
borne1 | No. of days 1 | C |
borne2 | No. of days 2 | C |
borne3 | No. of days 3 | C |
devise | Selection currency | |
regnv | Settlement not validated (Local menu No, Yes) | |
ecrisim | Simulated entries (Local menu No, Yes) | |
depasse | Open item overrun (Local menu No, Yes) | |
ageinvby | Aged invoices by (Local menu Age by invoice date, Age by due date) | |
datref | Pivot date | D |
sens | Sign (Local menu Debit, Credit) | |
detpce | Detail by open item (Local menu No, Yes) | |
tri | Sort order (Local menu Number, Title, Short title) | |
typcur | Rate type (Local menu Daily rate, Monthly rate, Average rate...) | |
datcours | Rate reference date | D |
impselections | Print selections (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function CONSCPT (Accounts).
Description of the report
The open items included in the report depend on the Age invoices by report parameter setting. The Age invoices by parameter default is due date. If you select Age invoices by invoice date, open items that exceed the Pivot date are not included. If you select Yes for the Open item overrun report parameter, the report only includes customers who have exceeded their authorized credit limit amount.
The report header displays the following information:
- The selected company
- The currency used (company currency)
- The reference date
For each BP, the report shows:
- The BP code
- The BP title
- The telephone number
- The partial balance for each open item date range
- The final total balance of the BP account
If Detail by open item is Yes, the report includes for each open item:
- The Type/Document number
- The date by due date or invoice date
- The difference in days from the reference date
- The open item amount if more than No. of days 3 + 1 day
- The open item amount if the range is between No. of days 2 + 1 day and No. of days 3 late
- The open item amount if the range is between No. of days 1+ 1 day and No. of days 2 late
- The open item amount between the reference date and No. of days 1
- The open item amount if not overdue
- The balance
If Detail by open item is No, the report displays for each BP:
- The open item total amount if more than No. of days 3 + 1 day
- The open item total amount if the range is between No. of days 2 + 1 day and No. of days 3 late
- The open item total amount if the range is between No. of days 1+ 1 day and No. of days 2 late
- The open item total amount between the reference date and No. of days 1
- The open item total amount not overdue
- The open item total balance
The report also displays the following information at the company level:
- A general total amount by open item
- Company balance