When I look at a certain FG profile, under manage costs it gives me a current cost based on the latest cost price. Is there anywhere in the system I can pull a historical list of prices?
Yes, it looks like there is a lot of records from my predecessor. I have it live in the system, but it is a great idea to try it in test to make sure I have the right table and field.
Thank you very much Mohit!
For testing, you can setup in Development or Test environment, change value of price and you can see the record in Database log form in System Administration-->Enquiries-->Database-->Database Log
Tip: There might be lot of historical records from another table, you can search (Ctrl+F) in the form by table name (Inventory module parameters), Table name field is non editable, so probably after search if you get the record, note down Reference table Id and you can filter using that field in future.
I have it set, it looks like it should work. Thank you!
Hi Mohit,
Thank you! It looks like I have found it, but need to perform this during non-business hours (later tonight) due to potential performance issues (warning that comes up). I will let you know how it goes.
Thank you for your help! Talk to you soon.
Jet
In your screenshot, You can find it under 'Trade' category under the name InventTableModule(Table): Inventory module parameters
Do you know where I can find that table/field in the database log setup list:
Price field in managed costs is mapped to 'Price' Field in 'InventTableModule' table.
Hi Mohit,
That may actually work if I know which table/fields to choose when accessing the database log wizard. I seen some items already setup from our previous CFO, so I assume that what he was doing as well for other items.
I go under Product Information Management > Products > Released Products. I am looking at the "Managed Cost" section as shown below. It would nice to have that database log to track my FG costs.
Hi Andre,
Yes, Finished Goods. I am looking under Product Information Management > Products > Released Products. I am looking at the "Managed Cost" section as shown below. It would be nice to see the historical price before the $1.00216 it is currently.
Hi Billur,
Thank you! I was actually thinking of doing that if no other option was available. I was hoping to have something simple to click on a see a list of historical costs.
Jet
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156