How to get the Available Credit Limit for a Customer in AX 2012 R2 CU7


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.



Look at



Hi Kranti,

Thank you so much.