cancel
Showing results for 
Search instead for 
Did you mean: 

Show both Moving Average and Standard Price of an item in Report Composer

Former Member
0 Kudos

Hello

I do follow all my items at standard price. But i wish to get on the same report both the standard price and the moving average price.

How can i do so :

1 - either by a default report

2 - Or by using report composer

3 - By using a SQL Query

Thanks

Stéphane

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks but is there a way to get both data on the same report ?

The solution you gave me allows me only to output two different reports....I don't mind working with a vlookup from time to time but on a daily basis, this is a bit laborious

Thanks for your continuous support

Stéphane

Former Member
0 Kudos

No. By SQL query, you could get multiple price lists in the same report easily.

Former Member
0 Kudos

Hi Stéphane,

If you need to show these two prices as list, SQL query would be the best tool.

Thanks,

Gordon

JesperB1
Advisor
Advisor
0 Kudos

Hi Stephan,

If you are using a continuous stock db and the Items are defined as 'Standard' then use the Inventory Valuation Report to update the Last Evaluated/Last Calculated Price and use this price in the report. The field in oitm is LstEvlPric.

I hope it helps.

Jesper