Share
ReportHello,
How can I get a list of the current stock with the last entry date and last exit date?
Thank you,
João
You’re offline. This is a read only version of the page.
Announcements
5
Hello,
How can I get a list of the current stock with the last entry date and last exit date?
Thank you,
João
You can pass the Item Ledger Entries to Excel with an appropriate filter (like Sales|Purchase) and then create a pivot table on that data.
In the PivotTable, you can then set the Posting Date as value field (in this case the “Posting Date”) to Sum value field by Max and get a list with the corresponding values.
Note that in this case the value field Posting Date is set as Date.
If you need the evaluation more often, as already mentioned, then another solution is recommended.
I can recommend you our app NCE Excel Builder from AppSource, when you need it more often, there you can make the settings once and then create the report and add formulars etc. also without PivotTable function or with - as you like it.
Hope we could help
Hi, As far as I know, there is no out-of-the-box reports for this feature in BC, but the data is stored in Item Ledger Entries, which you can query manually, or customize a new report.
PS: Using Inventory Valuation report, you can view the increase or decrease of inventory during a period.
Hope this helps.
Thanks.
ZHU
#1
Sohail Ahmed
1,452
#2
YUN ZHU
1,313
Super User 2025 Season 1
#3
Gerardo Rentería Ga...
1,083
Most Valuable Professional
All responses (
Answers (
