5,195
Hi,
please advice me how can i get the previous month onhand quantity infomation. kindly provde any querry if anybody is having to run in db.
thanks,
Refeesh Ali
*This post is locked for comments
thanks its works
Hi Refeesh,
If you have the Historical Inventory Trial Balance(HITB) Report installed you can go to Inventory >> Reports >> Activity >> Historical IV Trial Balance >>New or Modify button to run the HITB Report for a specific date range. If you just want to look at SQL data you can run a script like this on the IV10200 which is your Purchase Receipts table and houses your inflows and quantities sold from each receipt layer.
SELECT SUM(QTYRECVD) - SUM(QTYSOLD) FROM IV10200 WHERE (DATERECD BETWEEN '2017-04-01' and '2017-04-30') and ITEMNMBR = 'xxx'
Also, for balancing your General Ledger to your Inventory Subledger the only report we recommend is the HITB and I highly recommend using this report to ensure your are reporting your inventory's valuation correctly. See the following article I wrote that goes over this more in depth.
Best Regards,
Andrew Ganje
Support Engineer
Microsoft Dynamics GP
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
