10
Hello community,
We would like to be able to extract in Excel the historical (by month) of the FIFO cost , by article.
This in order to see the trend of the article cost over a year, and also to see unrealistic fluctuations (internal control)
Thank you in advance for your help!
Hi, I vote for inventory valuation. You can download it to Excel once a month and analyze it outside the system.
If you want to customize or use external tools, you need to see both Item Ledger Entries and Value Entries. relatively complicated.
Hope this helps as well.
Thanks.
ZHU
You can do as Kim suggest or you can create a report based on the Item ledger entries.
But you probably need to customize the report either in AL or in Power BI to get the data you need.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (