Credit Balances (tfacr3507m000)

Field Information

Credit Analyst

The credit analyst linked to the invoice-to business partner.

Invoice-to Business Partner

invoice-to business partner

Parent 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

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.

Disputed

The disputed amount of the invoice or the invoice schedules that is not due.

Not Disputed

The not disputed amount of the invoice or the invoice schedule that is not due.

Total Due

The sum of all the disputed and not disputed amounts of invoices or the invoice schedule that is due.

Disputed

The disputed amount of the invoice or the invoice schedules that is due.

Not Disputed

The not disputed amount of the invoice or the invoice schedules that is due.

Total Open

The sum of all the disputed and not disputed amounts of invoices or invoice schedule.

Unallocated

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 Reminder 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

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)

Due

The number of invoices due.

Reminded

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.