Hi NetSuite Community,
I would like to understand how NetSuite calculates the Credit Limit Balance / Available Credit for a Customer.
For example, if a customer has:
- Credit Limit: MYR 50,000
- Hold: Auto
- Open Invoices: MYR 25,761.00
- Unbilled Orders: MYR 710
How does NetSuite calculate the customer's remaining credit or available credit?
Here my current Account Preference > General > Accounts Receivable
* Customer Credit Limit Handling: Enforce Holds
I would also like to understand:
- Which transactions are included in the Credit Limit calculation?
- Are Open Sales Orders included in the calculation?
- Are Invoices, Credit Memos, Customer Payments, and Deposits included?
- How does NetSuite calculate the Credit Limit Remaining / Available Credit shown on the Customer record?
- Is there a standard field or formula that can be used in a Saved Search to reproduce the same Credit Limit calculation?
My objective is to understand the standard NetSuite calculation so that I can reproduce the same calculation in a Saved Search or report.
Any explanation or example of the standard NetSuite calculation would be greatly appreciated.
Thank you.