You’re offline. This is a read only version of the page.
Announcements
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.
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
