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
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...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (