Table that Stores Item List Price

(0) Share

Report

Posted on by JoeSeroski

What table(s) stores item list price in Dynamics AX 2012 R3? I need list price before any discounts (e.g. before line, group, table).

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report
Copy link

Link copied!

Isn't that InventTableModule(Sales) .Price?

Was this reply helpful? Yes No
Verified answer

Fredrik Sætre 12,644 on at

Like (0)

Report
Copy link

Link copied!

Price for Sales, Purchase and Invent is in the same table.

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Use the following job to get the default inventory, purchase, and sales price of a product.
Table: InventTableModule
Description: The InventTableModule table contains information about purchase, sales, and inventory specific settings for items.

Same information is available on the tabs Purchase, Sell and Manage inventory on Release product details form.

static void InventTableModule(Args _args)
{
InventTableModule inventTableModule;
InventTable inventTable;
EcoResProduct ecoResProduct;

while select inventTable
where inventTable.ItemId == "XYZ"
join ecoResProduct
where ecoResProduct.RecId == inventTable.Product
join inventTableModule
where inventTableModule.ItemId == inventTable.ItemId
{
if (inventTableModule.ModuleType == ModuleInventPurchSales::Invent)
{
info(strFmt("Default Invent price: %1, unit: %2", inventTableModule.Price, inventTableModule.PriceUnit));
}

if (inventTableModule.ModuleType == ModuleInventPurchSales::Purch)
{
info(strFmt("Default purch price: %1, unit: %2", inventTableModule.Price, inventTableModule.PriceUnit));
}

if (inventTableModule.ModuleType == ModuleInventPurchSales::Sales)
{
info(strFmt("Default sales price: %1, unit: %2", inventTableModule.Price, inventTableModule.PriceUnit));
}
}
}

Hope this information helps you.

If you feel your issue is resolved, please mark the answer as verified.

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No
JoeSeroski on at

Like (0)

Report
Copy link

Link copied!

Is there a different table that stores list price history?

Was this reply helpful? Yes No