Credit Limits in AX for Developers

by | Updated December 23, 2014 | Development, Dynamics AX

Recently I extended the credit limit functionality in Dynamics AX 2012 for a customer. In developing the changes I did quite a bit of research on the existing classes and decided to document them here. Given that, here are the important pieces of credit limits in AX:

1. The CustParameters table and the CustParameters form define and persist what credit limits can be applied to. In AX the options are free text invoices and sales orders. The customer I was working for wanted the functionality expanded so credit limits were also verified on sales quotations.

2. The class CustCreditLimit is the base class for credit limit functionality. The class is extended by the two types of documents credit limits can be checked on free text invoices and sales orders.

-The extension classes are CustCreditLimit_CustInvoiceTable, CustCreditLimit_SalesTable and CustCreditLimit_SalesParmTable. The SalesParmTable accounts for sales orders that have been partially delivered.

-The construct method on CustCreditLimit instantiates one of the extending classes.

-The initQuery method defines the query used to retrieve open sales orders so it is arguably the most important method. The method is called by the balanceEstimate and calculateBalance methods in the CustCreditLimit class when calculating the current open balance of sales orders is for a customer.

3. The SalesTable table has three important pieces. The method checkAgainstCreditLimit instantiates the CustCreditLimit class, passing in the current sales order and runs the credit limit check. The update and validateWriteServer methods on SalesTable call the checkAgainstCreditLimit method. When a user enters a sales order for a customer that has a credit limit and the sales order goes beyond their credit limit, the validateWriterServer method is called when the sales order is saved. It fires up the credit check and the CustCreditLimit class throws the message to the infolog that says what the customer’s open balance is, and how much they’ve exceeded their limit by.

4. Credit limits are displayed on the customer, on sales orders and on free text invoices. For example, in AX go to Accounts Receivable > Common > Customers > All customers and select a customer. Click the Balance button in the ribbon at the top of the form, and in the form that opens will be a Credit limit and a Credit remaining amount. The Credit limit value is how much the customer can spend. The Credit remaining is how much they have left out of that credit limit. The same kind of values are displayed on a sales order and a free text invoice. When these totals/balances forms are opened they call into the CustCreditLimit class to retrieve the totals, so they use the same functionality that is used when the a sales order is entered and exceeds the credit limit.

Becky Newell

Related Posts

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

april

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Jumping into the Deep End of the Data Lake

14apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

21apr10:00 am10:30 amSetting Your Sales Team Up for Success: A Modern Look at Revenue Operations

21apr12:00 pm1:00 pmGetting Started with Barcode Scanners and WMS Apps for Business Central

21apr2:00 pm3:00 pmMoving to the Cloud: Today's Solution for Leading Field Service Companies

22apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Moving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turnover

28apr12:00 pm1:00 pmPower Up Microsoft Dynamics by Automating Budgeting, Dashboarding and Reporting

may

05may10:00 am10:30 amAchieve More with Zetadocs for Business Central

05may2:00 pm2:30 pmSimplifying Item Pricing, Availability, and Tracing for Batch Manufacturers

06may11:00 am12:00 pmD365 Field Service – New Features to Empower Your Remote Workforce

12may10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

12may12:00 pm12:30 pmFinancial Implications of Moving from Dynamics GP to Dynamics 365: Licensing and Infrastructure

17may(may 17)8:00 am28(may 28)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

26may10:00 am10:30 amThe Modern Manufacturer - Enterprise Asset Management

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X