Price Change Report

fahd

Dear Experts,
We are changing the prices for items continiously. So is there any default report in Navision that we can review or like if we can see the history of price changes???

Andwian

There is a master setup for Purchase Price.
You should fill this table.
And from this table you could generate a report.

fahd

Dear Andwian,
Thanks for the reply. But we have stored prices in Table 7002 "Sales Price". I can get almost all the data here but the only thing i am missing is the description field. Is it possible if i can get that description field in that table??


If yes than what programming codes i have to give in the Table's design so that i can get the "Description" Field?? I am talking about item's Description.

vijay_g

If you are talking about item description then you need to add a field Description in table 7003 with field type flowfield and formula is Lookup(Item.Description WHERE (No.=FIELD(Item No.))).

vaprog

If you do a Report you will most likely want to have a Dataitem for the Item table anyway, for selection and structuring purposes, and you will likely need to show more information concerning the item anyway. Thus, enhancng the table 7002 might not be needed for you.

fahd

Dear All,

thanksssss alot it's done i can see that field now Thanks alot once again !!!
MIBUSO IS THE BEST!!!!!!