DMF: importing item prices

(0) Share

Report

Posted on by Community Member

Hi all,

Is it possible using DMF (2012 R3) to import (pending) item prices to existing products? I'm talking about the item prices found under manage costs tab > item prices on the released product. If so which target entity should I use?

Kind regards,

Tim

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Prashant Singh 8,802 on at

Like (0)

Report

Dear Timvn,

Kindly use entity product.

DisplayProductNumber, ItemId, EcoResProductTranslation_Name, EcoResProductTranslation_Description, EcoResProductTranslation_LanguageId,ProductSubType ProductType, NameAlias ItemGroupId, BOMUnitId, ItemType, EcoResStorageDimensionGroup_Name EcoResTrackingDimensionGroup_Name, ModelGroupId, InventTableModuleInvent_UnitId InventTableModulePurch_UnitId, InventTableModuleSales_UnitId, PmfProductType, InventTableModulePurch_Price, InventTableModuleSales_Price, InventTableModuleInvent_Price

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Prashant,

Thank you for your reply, but I want to only import the item prices to an existing product. It has been suggested to me I should use a custom entity.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (1)

Report

Hi Tim,

I took a quick look through the Entities available in DIXF. I can't see any that look like they cover Item prices. I don't think the Products entity allows you to import to the 'ItemPrice...' tables even when creating items.

As you say, a custom entity would be required.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (3)

Report

Hi Tim,

On this form the tables InventItemPrice and InventItemPriceSim are used. These tables are not handled by in the standard entities. Also not the Products entity.

So indeed agree with Guy; you need to create a new custom entity per table.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Guy and André!

Using the InventItemPriceSim I created a custom entity. The issue now however is that AX identifies fields as mandatory which shouldn't be, e.g. PalletID, Serial-, Batch number. Do you have any experience with these issues? And do you know how to solve this issue?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (3)

Report

Hi Tim,

In fact the InventDimId on the target table (InventItemPriceSim) is mandatory. The wizard probably added the Dimension fields instead of this InventDimId in the staging table. If you have used the standard naming convention the Stating table should have the name DMFInventItemPriceSimEntity. You can open the fields node and change the property Manual to 'No'.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

I turned off the mandatory status for all the InventDimId related field except InventSiteId. Then I use the following fields:

- ItemId

- PriceType

- VersionId

- InventSiteId

- Price

- PriceUnit

- FromDate

With these I can get the staging data, but when I want to copy the data to target I get the following error:

"SQL statement: SELECT T1.ITEMID,T1.VERSIONID,T1.FROMDATE,T1.PRICETYPE,T1.INVENTDIMID,T1.MARKUP,T1.PRICEUNIT,T1.PRICE,T1.PRICECALCID,T1.UNITID,T1.PRICEALLOCATEMARKUP,T1.PRICEQTY,T1.PRICESECCUR_RU,T1.MARKUPSECCUR_RU,T1.MODIFIEDDATETIME,T1.RECVERSION,T1.PARTITION,T1.RECID,T2.FROMDATE,T2.INVENTDIMID,T2.ITEMID,T2.MARKUP,T2.MARKUPSECCUR_RU,T2.PRICE,T2.PRICECALCID,T2.PRICEQTY,T2.PRICESECCUR_RU,T2.PRICEUNIT,T2.UNITID,T2.VERSIONID,T2.DEFINITIONGROUP,T2.ISSELECTED,T2.TRANSFERSTATUS,T2.EXECUTIONID,T2.INVENTBATCHID,T2.INVENTLOCATIONID,T2.INVENTSERIALID,T2.INVENTSITEID,T2.WMSLOCATIONID,T2.PRICEALLOCATEMARKUP,T2.PRICETYPE,T2.MODIFIEDDATETIME,T2.RECVERSION,T2.PARTITION,T2.RECID FROM INVENTITEMPRICESIM T1 CROSS JOIN DMFINVENTITEMPRICESIMENTITY T2 WHERE ((T1.PARTITION=?) AND (T1.DATAAREAID=?)) AND ((T2.PARTITION=?) AND ((T2.RECID=?) AND ((T2.ITEMID=T1.ITEMID) AND ((T2.INVENTDIMID=T1.INVENTDIMID) AND ((T2.VERSIONID=T1.VERSIONID) AND ((T2.FROMDATE=T1.FROMDATE) AND (T2.PRICETYPE=T1.PRICETYPE))))))) ORDER BY T1.ITEMID,T1.INVENTDIMID,T1.VERSIONID,T1.FROMDATE,T1.PRICETYPE"

Do you have any suggestions on how to solve this?

Kind regards,

Tim

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (1)

Report

This seems to be an SQL statement only. There is no real error message,

Did you add a generate method to convert the Inventory dimensions in to an InventDimId value?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I did not add a generate method, should I? And if so where and how can I do this?

Thanks in advance!

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (1)

Report

Hi Tim,

You can have a look at e.g. the sales line entity or the inventory journal entity for an example how to do the conversion form inventory fields to the inventdimid. I think a method name generateInventDim should be it. The name can be a bit different. Also a method getReturnFields should have a mapping to the inventDimId in the target table.

Was this reply helpful? Yes No