Announcements
No record found.
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?
Hi Jet, Not sure if system stores historical r cords for this, but one way is to setup Database Log on that field (provided it's a table field) and it will store data changes occuring after database Log is setup.
Can you provide more details on which form and field are you referring so we can help you better.
Hi Jet,
I do assume the abbreviation FG is in this case 'Finished foods'. Can you tell what form you are referring to?
You may use the inventory value report and select the date you want to report
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
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 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.
Price field in managed costs is mapped to 'Price' Field in 'InventTableModule' table.
Do you know where I can find that table/field in the database log setup list:
In your screenshot, You can find it under 'Trade' category under the name InventTableModule(Table): Inventory module parameters
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 536 Most Valuable Professional
André Arnaud de Cal... 363 Super User 2026 Season 2
CU-1234529-002 188
