Upload Account Structure in D365 Through Data management

User can Upload the Account Structure in D365 through Data management Utilities.

1st : To Create the account structure Header, we have user the data Entities ” Account Structure”.
Such as in account strucutre, what are the dimension we are going to use.

account structure1

2nd : To Enter the Account and dimension value in account structure, we have to use the data Entities ” Account Structure Allowed Value”

account structure2


style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">

Uploading Item Posting profile in D365 through Data management

If User want to Upload the item Potig profile in D365 through Data management then they have to use the following Data Entities.

ledger posting


style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">

Create a business unit value in D365

Kinldy follow the below path to create a new value in:
1. Business Unit
2. Department
3. Cost Center

Path : Organization administration > Organization > Operating Units.

org



style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">

difference in Item Posting profile naming from AX2012 to D365

Microsoft has change item posting profile Name, where we to map the account for Sales ,Purchase,Inventory,production.

The New name in D365 are as follows.
Regards
Amit Sahani
 
inventory


style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">

How to Import Data from D365 Using Data management Utility

User can upload the Master in D365 by using Data management.

With D365, Uploading Data has become much easy.

1
Click on Import tab
2

3

5

4

Export D365 Master Data Using Data management Functionlity

With D365, the Master Data import functionlity has been changed a lot with some very good feature, which make the consultant life easy.
How to Export Data From Data management.

path : Workspace > Data Management
1
Click on Export
2

3

4

5

1.If you click on dropdown box, system will give you various option such as ( (a) Incremental Push only (b) Full Push only)
6

7

8

Hours exist for project XXXXXXX posted to voucher XX/HRS/0000002 on 9/28/2016 that is not included in WIP, in AX 2012 R3

When user post the Elimination at estimate form at project management & accounting Module.
Path : AX -> project management & accounting
posting :

emilinate

Error :
elimination error

Solution :

The hours cost has been posted in the month of September 2016 and Elimination is posted in the month of August 2016, this is the reason why system is not able to reverse the WIP cost and posted in the asset.
Select the elimate month of the last cost posting transaction date month.

solution1

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:.
prepayment

Solution:

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

prepayment



style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">

The transaction combination Activate item relation Table is not activated, In Ax2012 R3

When user try to set the posting profile for item, he get the below error as given.

ERROR : The transaction combination Activate item relation Table is not activated.

item

solution :

user has to check the appropriate checkbox as shown below.
Path : Inventory management -> setup -> Posting -> Transaction Combinations.

item1

Please check the appropriate checkbox.



style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">



style="display:inline-block;width:300px;height:600px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="2699120041">

Wrong tax Calculation in AX2012 R3

When I am calculating the tax, system is showing the wrong value.

Example :- I am trying to create a vendor Invoice with invoice value of 1000 and VAT Tax of 5%
system is calculating a tax amount of 48 instead of 50.

tax1

Solution :

the reason of wrong calculation is wrong setup.

1st : check the sales tax code properties
path : GL – Setup – sales tax- sales tax code
tax2
Please check the properties which is color in yellow are correct.

2nd: at sales tax group.
check the use tax checkbox, if it is not checked.
tax3



style="display:inline-block;width:728px;height:90px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="1552071245">



style="display:inline-block;width:300px;height:600px"
data-ad-client="ca-pub-1564485619783574"
data-ad-slot="2699120041">