Table to Create a report with Price and Cost per article, with Addin for excel

(0) Share

Report

Posted on by Community Member

Hi All,

I am trying to search the name of the table for wich I could create a report showing the price and cost per article for a determinated Sale, using the addin for excel.

Thanks

Jose

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

InventTableModule holds the sales/purchase/average inventory cost price, based on the inventory model group's price calculation and other setups related to the modules above. If that is not what you have meant, please provide additional details with screenshots in order to identify your requirements better.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

something like that, but with the option to filter by product line.

Thanks

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

I am not sure what "product line" is, but in AX terminology we do have ItemId on InventTableModule which is the unique identifier for a specific product.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Product Line as the financial dimension

Was this reply helpful? Yes No
Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use the following job to filter the products based on financial dimension ProductLine.

So main tables are InventTable, DimensionAttributeValueSetItem, DimensionAttributeValue and DimensionAttribute, EcoResProduct along with InventTableModule.

static void ProductLine(Args _args)

{

InventTable inventTable;

DimensionAttributeValueSetItem dimensionAttributeValueSetItem;

DimensionAttributeValue dimensionAttributeValue;

DimensionAttribute dimensionAttribute;

while select inventTable

// where inventTable.ItemId == "XYZ"

join RecId, DisplayValue from dimensionAttributeValueSetItem

where dimensionAttributeValueSetItem.DimensionAttributeValueSet == inventTable.DefaultDimension

&& dimensionAttributeValueSetItem.DisplayValue == "001" // Specify dimension value here

join RecId from dimensionAttributeValue

where dimensionAttributeValue.RecId == dimensionAttributeValueSetItem.DimensionAttributeValue

join RecId, Name from dimensionAttribute

where dimensionAttribute.RecId == dimensionAttributeValue.DimensionAttribute

&& dimensionAttribute.Name == "ProductLine" // specify dimension name here

{

info(strFmt("%1-%2", dimensionAttribute.Name, dimensionAttributeValueSetItem.DisplayValue));

}

}

Was this reply helpful? Yes No