Stop Purchase / Sale or Inventory adjustments for a Product (Item) in Microsoft Dynamics AX

Companies using ERPs often have one big complaint, they cannot delete a Product (Item) having transactions. For a corporation having few thousand products, it is a key requirement that they stop a product after few years on shelves (take for example the Nokia’s 1100 model was highly successful mobile phone. Alas! The company has to stop this product as part of their market strategy)

In Microsoft Dynamics AX (Microsoft Dynamics 365 for operations), a Product can be created globally and can be released to a legal entity as per requirement. Only upon successful release, the legal entity can transact on that product (termed as “Released Product”)

A released product cannot be deleted if transactions (Purchases, sales and Inventory) exist. However, a released product can be stopped from making new purchase, sales and/ or Inventory transactions. 

It is a good idea to ensure the On-hand inventory for this released product is zeroed out before a Released product is stopped

Note that each of this needs to be done separately as explained in the below:

1. Go to Released products and select the released product to be stopped. Click on default order settings under MANAGER INVENTORY tab (as highlighted in the below screen capture) 

   

  

2. The Default order settings for the selected released product is opened as below:

3. Stop new purchases: In order to stop the new purchases, go to Purchase Order fast tab and click on the Stopped

  

4. Stop new Inventory transactions: In order to stop the new inventory transactions, go to Inventory fast tab and click on the Stopped 

 

5. Stop new Sales transactions: In order to stop the new sales transactions, go to Sales order fast tab and click on the Stopped

 

This is it. Now the released product is stopped from making any new transactions. 

 

Automatic Settlement for Customers and Vendors in Microsoft Dynamics AX

AX allows automatic settlement of payments with Invoices (and vice-a-versa), The automatic settlements are of 2 types:

1. Automatic settlement with system defined priority
2. Automatic settlements with user defined priority

Automatic settlement with system defined priority: The automatic transactions with system defined priority settles transactions based on the due date. However, the both transactions (Invoice & Payment or adjustment) must be in the same currency

Automatic settlements with user defined priority: For user defined custom priority, the user may set priority based on Transaction type (Invoices, Fee on payment, Dunning letters, Interest) using the Settlement Priority form

In addition to this, AX allows users to specify which posting profiles are allowed for settlement. This functionality works the same way for Vendors (Accounts Payable) & Customers (Accounts Receivable). Below is a brief process on enabling the automatic settlement and setting up user priority.

•     Enable allow automatic settlement for the customer posting profile

•     Enable Automatic Settlement under the Accounts Receivable Parameters > Settlement tab

•     Enable Prioritise Settlement (If priority needs to be given for certain transactions) and “Use priority for automatic settlement”

•     Click on Manage Priority if user needs to change the order of priority (By default AX has its own priority defined based on the date of Invoice & due date on FIFO basis)

•   Activate the necessary attribute and move Up or Down to choose the priority

The necessary setups are done. Now you can proceed making transactions with automatic settlement. Good Luck.

Wish all of you AX consultants transforming towards the Microsoft Dynamics 365 Operations from AX 2012 and older versions a great success in 2017.