Finally fixed: Product Receipt cannot be cancelled if a line has multiple Batch numbers

This is one peculiar issue that has been bothering us quite some time now. It was present in AX 2012 and well into Microsoft Dynamics 365 for operations.

When a purchase is made and the product has multiple batch numbers, we use the split functionality in the Item arrival journal to split the quantity and assign batch number.

The problem comes when we want to cancel the Product receipt. When we try to cancel the product receipt with a line that has a split, The product receipt cancels only partially.

Finally, we reported the issue with Microsoft and our dedicated friends at Microsoft decided to fix this issue outright. Enclosed below is the Repro steps of the issue that we reported with Microsoft Dynamics team

Repro Steps for Complete Product Receipt not cancelled when split exists

The below is the Fix provided by Microsoft (Available through LCS- Hotfix# KB 3214547)

KB 3214547Partial Product Receipt cannot be cancelled if item quantity on item arrival journal is split with different batch numbers

Credits to Chandu Naresh (Me), Paul Dipankar & Nikhil Pujar for having worked together in identification of this bug in Microsoft Dynamics 365 for operations and reporting to Microsoft team.

Note: This issue and the fix is relevant to customers using tracking dimensions such as Batch Number, Serial Number or Consignment

Print multiple Purchase Orders from AX (Dynamics 365 for operations)

It is a common requirement for many companies that the print out of the Purchase Order. The option of printing multiple purchase orders (or any other Business documents such as Sales Order, Invoice etc.,) is available in AX.

This can be achieved using the Print Management settings in AX. Below I am going to show you the setup required for the setting up Print Management to generate Purchase order as a PDF format (alternatively it can be directly sent to printer).

First things first. We need to setup the Print Management settings for the Purchase Order as below.

Go to Accounts Payable > Setup > Forms > Form setup

 

The form setup page is opened as below. Click on the Print Management button as highlighted below:

The Print Management for is opened as below. in the below form under the Purchase order select printout type (in our case : Original) and this shows the properties on the right hand side.

In the highlighted Tab "Destination", The current destination is "Default" this is where we need to change to achieve the required goal.

 

Click on the Arrow shown and it will display options as below. In the options select the "Printer Setup"  as shown below:

This will open the "Print destination settings" dialog box. This is a familiar dialog box for many of us. In this box on the left side, choose Printer (as below):

I am selecting the Printer as "Microsoft Print to PDF" as in my case, I wanted to print the Purchase order into a PDF and Click "OK"

You may choose a different printer as is required. The print management functionality can also be used to send Purchase Order via Email. You may choose different options as per your business needs.

Once the setup is done, the destination is changed to "Printer: Microsoft Print to PDF" as below

With this setup is completed. Now we need to go to the Confirmed Purchase orders, which lists down all the Confirmed POs:

Navigate to  "Procurement and sourcing >Purchase orders >Purchase order confirmation >Purchase order confirmations". This opens the Purchase order confirmations form as below

from the list, Select all the Purchase Orders to be printed:

Click on the "User Print Management" option in the screen above and that's it, the selected Purchase orders are printed as separate PDF files and the prompt asks us for the location to where the file needs to be saved.

The same process can be applied to any type of Business document and I hope this article is useful for your AX implementation

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. 

 

Multiple exchange rates for consolidating entities

In continuation to my earlier posts on consolidation Financial accounts in AX, this post is to highlight how AX allows multiple exchange rate types and exchange rates.

While consolidating data from companies from different regions (countries) around the world, due to a local business practices and requirements the exchange rates may vary for different subsidiaries although they belong to the same umbrella.

Below is an example of how to handle such a scenario as explained below. I am using the AX Demo data for the purpose of Consolidation.

S.No	Parent Company	Subsidiaries for Consolidation	Accounting Currency
1	GLCO		USD
2		USMF	USD
3		GBSI	GBP

There is no currency conversion required from USMF to GLCO since both these currencies are in “USD”. Now for the subsidiary “GBSI”, the accounting currency is “GBP” and hence it requires conversion to “USD”.

AX provides options for the users to select the Exchange rate type for direct conversion into consolidation company. Further the users may also choose different exchange rate types for different ledger accounts. 

In my case, I wish to choose “Average” exchange rate type for conversion for Main Account types: “Balance Sheet”, “Asset” & “Liability” and “Default” exchange rate type for conversion for main account types: “Profit & Loss”, “Revenue” & “Expense”.

Navigate to Consolidations > Consolidate Online:

Enter the Basic criteria as below:

 

Select the Legal entities for consolidation:

 

Go to Currency Translation Tab and enter the following:

•  For USMF, since the accounting currency is same “USD”, just select all accounts. Note that system is not allowing user to select the fields highlighted 
   
  
  
  
  
• ·        For GBSI, select the accounts from 110110 to 399999 (Balance Sheet, Asset, Liability & Equity accounts) note that that Exchange rate type field has now become mandatory
  
  
  
  
  
  •  Select the Exchange rate type as “Average”
  • The Apply exchange rate from field provides 3 options to user
  o   Consolidation date: This takes the exchange rate as on consolidation date
  o   Transaction date: This takes the exchange rate as per the actual transaction date in the source system
  o   User defined rate: This option enables user to provide a custom exchange rate
  
  
   
  
  
  
  
  • For our example, I will proceed with “Consolidation date” as is the norm
  • To continue further, create “New” and select main accounts from “401100” to “899999” (Revenue, Expense, Profit& Loss accounts).
  • Choose the Exchange rate type as “Default”
  
  
   
  This is it, once the rest of the parameters are set as per requirements, click “OK” to complete the consolidation.