Item Price Import in AX 2012 R3

(0) Share

Report

Posted on by Anand AX

2,172

Hi All,

I have five companies in Ax, In which i have imported and released items in two companies through DIXF "Product" entity. Now i want to import items along with item prices to all five companies. But i do not find any entity in DIXF to do. Here i need to do two things,

1. I just want to import item prices alone to already items imported companies

2. I want to import item and item prices to the remaining companies.

How to do this, Is that possible through Excel Addin? Please help me..!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

RamK 2,580 on at

Like (1)

Report

Use "Price discount agreement journal" DIXF entity. Refer technet.microsoft.com/.../dn507088.aspx or you can also use thedynamicsblog.com/trade-agreement-data-import-utility

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report

Hi Ram,

Thanks for the reply, I need to import following fields in item prices, Is that possible by "Price discount agreement journal" DIXF entity? Can you please clarify me!!

1.Price type

2.Version

3.Item Number

4.Name

5.Site

6.Warehouse

7.Price

8.Price unit

9.Unit

10.Price quantity

11.From date

Was this reply helpful? Yes No
RamK 2,580 on at

Like (1)

Report

Hi Anand, I hope that you are familiar with DIXF. In that case, from target entities list, select price discount agreement journal entity, select entity structure and then target fields...you will get your answer...

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

Hi Anand,

To get the items into the three companies which do not already have them, I think you should use the 'Items' entity. This entity is different from the 'Products' entity, in that it can be used to release products that already exist.

Importing of prices is separate. From your second comment, I think that you don't want to import Price / discount journals. You want to import what can be seen by going to the 'Manage inventory' tab in the ribbon bar of the Released products list page, and clicking on 'Item price'. Is that right?

If so, I do not think the 'Items' entity will import data here. In fact, I can't find any standard DIXF entity that will. You could create a custom entity, or you could try the Excel Add-in. I think this data goes into one table, so it might not be too hard to create the import. My suggestion would be to import 'Pending' item prices, and Activate them using the 'Activate' button on the Item price form.

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report

Hi Guy Terry,

Thanks for the reply, Yes you are correct, i want to import item prices in Released products->manage cost->item price.

If i use Excel addin to import pending prices, what are all the table sholud i need to select?

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

If you're importing Pending prices, you should look at the table ItemPriceSimulated. The table ItemPriceActivated contains prices after they have been Activated.

Was this reply helpful? Yes No

Community site session details

Item Price Import in AX 2012 R3

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Item Price Import in AX 2012 R3

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates