Tag Archives: ax2012

Prepayment must be created in a journal where amount is including of sales tax, A2012

When user try to post the vendor payment journal and try to check the prepayment checkbox, system given an error as “Prepayment must be created in a journal where amount is including of sales tax:.


To remove the above error, user need to remove the check from parameter. as shown below.



ERROR :Enter an Activity number. The require Activity number for Expense forecast is marked in Project. In AX2012

When user want to create a Expenses Forecast in project.
System give an error as shown below ;
“Enter an Activity number. The require Activity number for Expense forecast is marked in Project.”

Solution :

The above error comes in project module, due to activity check at parameter ”

Path : project management -> SETUP – > Project Management & Accounting Parameter.

Uncheck the below checkbox.


Changing the Decimal Places to More than 2, in AX2012

In AX2012, By default system accept two decimal places but if user want to change the decimal places to more than 2 than there are few setting need to be changed at operating System instead of AX, as AX store the financial data up to 16 decimal places.

Step to increase the decimal places :

login to server – Control Panel -click on language.

Click on Change Date Time or number Format.

Click on Additional Setting

Change the Decimal places to 3 ( if user want to use three decimal places in AX)

SETP 2 :

Login to AX – GL- Setup -Currency.

Change the Currency Round Up to “.001″ ( AX to accept 3 Decimal Places)


Changing Decimal Places or Quantity In Microsoft AX

To change the number of decimal places in Microsoft Axapta 2012, follow these steps:
[ Note : the below example are given for Four Decimal Places, user can be can the same for more than 2 decimal places ]
1. Change the NoOfDecimals property of the AmountCur and Qty ExtendDataTypes to 4.
2. To do this, follow these steps:
a. Open the Axapta Object Table (AOT) by pressing CTRL-D on the keyboard.
b. Click Data Dictionary, and then click Extended Data Types.
c. Locate the AmountCur and Qty fields, and then change the NoOfDecimals property to 4.
d. Save the changes that you made in the AOT.
3. Change the round-off value for the exchange rates. To do this, follow these steps:
Path : Main Menu window -> General Ledger -> Setup -> click Exchange Rates.
a. Select the Currency -> Click the Round-off tab.
b. Set the round-off value to .0001 on all four modules. These are the following:
• General
• Sales Order
• Purchase Order
• Prices
Note You may have to expand the window to see all four modules.
The AmountCur ExtendDataType is used for pricing, and the Qty ExtendDataType is used for quantity amounts. When you change the NoOfDecimals property to 4, all fields and controls that are using these ExtendDataTypes are changed globally. The user can then type values with up to four decimal places.

When you change the round-off value, the value that the user types is saved correctly to the database. Make sure that you add enough zeros for the NoOfDecimals property that you specified. You must make sure to correctly set the NoOfDecimals property so that all four decimal places are used. For example, if you leave the round-off value at .0100, the Net Amount on a purchase order will be rounded to two decimals instead of four.

To make the changes to the decimal place visible for Production sessions and for Master Planning sessions, follow these steps:
1. In the Main Menu window, click Basic, click Setup, click Units, and then click Units.
2. Locate the unit of measure that you want to affect.
In the Decimals field, type 4.

Posting Defination Issue : Voucher Do not balance,AX2012

There are cases While doing the Purchase Invoice, System give an error as Voucher Do not Balance and show the accounting Currency and Posting Currency.
Actually the error Comes because system do not get the Vendor account and if you see the Sub ledger posting, you can figure that only one account is displayed and other vendor account is missing.

Solution :
The one of the Reason why System does not bring the Posting Definition account is, if there are more than one account structure configured in Company than all accounting structure should be defined at Posting Definition

At Matching Cetria : you have to select all the Account structure and at Generated Entries you have to map the appropriate Account.

as in the above case accounting structure CV contain the vendor account but for above three account structure we have to set the Cv account structure Account. ( Screen shot attached)





Management Reporter (MR2012) Exchange Currency Rate Issue, AX2012

When Ever we create a Financial Report through Management Reporter  and Run time we have the option to view the Report with different Currency, but there few setting which we have to keep in mind while configuring the MS AX 2012.

Step 1:
GL – Common – Main Account
Please select the Exchange Rate Type and Current as given below.

Based on the below setting,MR reporter will exchange the Accounting currency into different Reporting currency.


We can run the Report based on AX accounting Currency and Reporting Currency.

Secondly : When we create a consolidation Report and Used different Company for consolidation than in that case it is very useful because base on the above configuration, MR Report will convert the accounting Currency  to MR Reporting Currency.



Ledger Account Combination is not valid Error in AX 2012

Ledger account Combination does not match the Journal control Setup in AX 2012

While posting the invoice journal AX 2012 is through an error.


Solution: when you get this error while posting the journal, just follow the step to rectify

Go to Journal Names

Path: GL -> Setup -> Journal -> Journal Names

Click on Journal control as shown below and delete the line.




Encumbrance & Pre- Encumbrance in AX2012



When we activate the encumbrance process at GL Parameter, when we post the purchase order than all the transaction are gets recorded at Encumbrance table

Encumbered Value on a purchase order are released when a vendor invoice is posted to spend all or part of the encumbered amount. Released amounts are subtracted from the value of the purchase order encumbrance.

Pre- Encumbrance

A pre-encumbrance is a process of request to reserve funds for planned expenditures i.e., purchase requisition. The funds have been requested, but have not yet been approved for a purchase order. If the pre-encumbrance process is activated, you can create purchase requisitions with a pre-encumbered amount for the planned Expenses.

The pre-encumbrance amount will be released and transferred to PO once the PR is approved and converted to purchase order

Account Number for Transaction Type Customer Balance Does not Exist. AX2012

In Ax 2012 we usually get this Error :Account Number for Transaction Type Customer Balance Does not Exist. AX2012

Accounting structure error

Solution : This error is due to Accounting Structure, either the account structure is not active or it has not included in Ledger Form.

If it has not included in ledger form than add the Accounting structure at ledger form and recalculate the Dimension Balance.

Now if you pass the transaction system will not through any Error

Enjoy :)