Credit Balances (tfacr3507m000)
Use this session to view the credit balances and statistics for a specified credit analyst, invoice-to business partner and financial company.
Field Information
- Credit Analyst
-
The credit analyst linked to the invoice-to business partner.
- Invoice-to Business Partner
- Parent Business Partner
-
Note: This field displays the top or direct parent business partner, based on the value in the Top Parent Business partner field in the Update Credit Balances & Statistics (tfacr3207m000) session.
- Financial Company
-
Note: This check box is visible only when credit collection is performed for multiple financial companies. If this value is 0, credit collection is done for shared financial companies.
- Total Not Due
-
The sum of all the disputed and not disputed amounts of the invoice or the invoice schedule that is not due.
- Currency
-
The currency of the received (not due) amount.
- Not Due Amount Disputed
-
The disputed amount of the invoice or the invoice schedules that is not due.
- Not Due Amount not Disputed
-
The not disputed amount of the invoice or the invoice schedule that is not due.
- Overdue Amount
-
The sum of all the disputed and not disputed amounts of invoices or the invoice schedule that is due.
- Due Amount Disputed
-
The disputed amount of the invoice or the invoice schedules that is due.
- Due Amount not Disputed
-
The not disputed amount of the invoice or the invoice schedules that is due.
- Total Open Amount
-
The sum of all the disputed and not disputed amounts of invoices or invoice schedule.
- Unallocated Receipt Amount
-
The total of anticipated advances and unallocated receipt.
- Total Balance Receivable
-
The business partner's open entry balance in the current financial company.
Total Receivable Balance= Total Not Due amount+ Total Due amount+ Unallocated Amount
- Credit Limit
-
The credit limit for the invoice-to business partner, expressed in the credit collection currency. The conversion is performed using the internal rate type.
Note: The credit limit cannot be specified for each accounting department. - Reminded Amount
-
The balance amount of the open invoices for which the reminders are sent.
- Overdue Not Reminded Amount
-
The balance amount of the open invoices for which the reminders are not sent.
- Last Letter Date
-
The latest reminder date for the invoice-to business partner.
- Average Days Overdue
-
average number of days overdue
The formula to calculate the average days overdue:
Average days overdue = sum (invoice * overdue period) / total amount of all invoices
Where
- end of period = last date when Update Credit Balances & Statistics (tfacr3207m000) is run.
- period= number of days between invoice creation and the date the average is updated by Update Credit Balances & Statistics (tfacr3207m000)
- Average Days for Payment
-
average receipt period or payment period
The formula to calculate the average days for payment:
Average days for payment= Sum of A for all receipts / sum of receipt amounts Where, A= receipt amount * (receipt date - doc date)
Where
- end of period = last date when Update Credit Balances & Statistics (tfacr3207m000) is run
- period= number of days between invoice creation and the date the average is updated by Update Credit Balances & Statistics (tfacr3207m000)
- Average Days Outstanding
-
The formula to calculate average days outstanding:
Average days outstanding = (sum of outstanding amounts * number of days between invoice date and end of period) / total outstanding amount)
Where
- end of period = last date when Update Credit Balances & Statistics (tfacr3207m000) is run
- period= number of days between invoice creation and the date the average is updated by Update Credit Balances & Statistics (tfacr3207m000)
- Number of Overdue Invoices
-
The number of invoices due.
- Number of Reminded Invoices
-
The number of reminded (open) invoices.
- Disputed
-
The number of disputed (open) invoices.
- Open
-
The number of open invoices.
- Number of Unallocated Receipts
-
The number of unallocated/advance receipts.