I have a scenario wherein i have to store the available customer credit limit in a separate new table as per our requirement.
The Credit Limit needs to be calculated as:
→ Available Credit for the Customer = (Credit Limit for the Customer ) – [ (Open A/R Balance) + (Open Sales Orders)]
How can we get this information and store it in our new table as and when the Credit Limit for the customer is changed so that the new table always has the updated credit limit for the customers.
Would appreciate for your quick help.