Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Viewing Historical FG Costs

(0) ShareShare
ReportReport
Posted on by 256

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? 

  • Suggested answer
    Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical FG Costs

    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!

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Viewing Historical FG Costs

    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.

  • Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical FG Costs

    I have it set, it looks like it should work.  Thank you!

  • Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical FG Costs

    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

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Viewing Historical FG Costs

    In your screenshot, You can find it under 'Trade' category under the name InventTableModule(Table): Inventory module parameters

  • Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical FG Costs

    Do you know where I can find that table/field in the database log setup list:
    pastedimage1678070138305v1.png

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    RE: Viewing Historical FG Costs

    Price field in managed costs is mapped to 'Price' Field in 'InventTableModule' table.

  • Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical FG Costs

    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.

    pastedimage1678068540063v1.png

  • Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical 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.

    pastedimage1678068198618v1.png

  • Jsabanovski Profile Picture
    Jsabanovski 256 on at
    RE: Viewing Historical FG Costs

    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

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans