Configuration for currencies without decimals (Zero decimal Currencies) in Dynamics AX

Most of the currencies across the globe have decimals (for ex: USD 100.99 where 100 is the dollars and 99 are cents).

 
There are a few currencies that are exception however, below is a list of some such currencies where the smallest currency unit is 1 :

CLP  - Chilean Peso
JPY   - Japanese Yen
KRW - South Korean Won
VND - Vietnamese Dong

The currencies in AX (Dynamics 365 for Operations) can be configured to restrict decimals as below.

Open the Currencies form ( General ledger > Currencies > Currencies). In the rounding rules fast tab setup the following values:

General rounding rule = 1.00
Sales order rounding rule = 1.00
Purchase order rounding rule = 1.00
Fixed asset rounding rule = 1.00

As shown in the screenshot below:

 

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

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.

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.