170
i m using GP10.0. some of my inventory items are showing zero. But when we are checking through item transactions, the calculation is fine and its shows the actual stock figure. how can i correct this issue. i have checked the item masters and it seems to be perfect. Please give me some solution for this..
*This post is locked for comments
@Richard
Yes you are right, adjusting inventory without knowing/rectifying the reason will regenerate the wrong calculations every imt reconcile is run.
@Sunbeam
I faced a similar problem here. Run these queries in you company Database and check whether they return something or not
SELECT TOP 100 PERCENT IV10001.IVDOCNBR, IV10000.BACHNUMB
FROM IV10001 INNER JOIN
IV30300 ON IV10001.IVDOCTYP = IV30300.DOCTYPE AND IV10001.IVDOCNBR = IV30300.DOCNUMBR AND
IV10001.ITEMNMBR = IV30300.ITEMNMBR AND IV10001.LNSEQNBR = IV30300.LNSEQNBR INNER JOIN
IV10000 ON IV10001.IVDOCNBR = IV10000.IVDOCNBR
GROUP BY IV10001.IVDOCNBR, IV10000.BACHNUMB
and
SELECT *
FROM SOP10200 INNER JOIN
SOP30200 ON SOP10200.SOPTYPE = SOP30200.SOPTYPE AND SOP10200.SOPNUMBE = SOP30200.SOPNUMBE
Look at the PO line table (it may be in history by now) using SQL Management Studio and check the non-inventory field for these items. That is the ONLY way to tell what the po was thinking at the time of the receipt. The receipt transaction would be posted and viewable even if the item is non-inventory. But the Item Site/Quantity table (not the item master btw) would not be updated if the non-inventory or drop ship flag was set.
Sunbeam...if we cannot determine the cause before adjusting, reconcile may re-create the problem in the future.
this could be a database issue, why not create an adjustment to correct system qnty against actual.
the item is marked as an inventory item only and PO was made before purchasing. And if i checked the item transaction wise, everything looks perfects. the entries are fine and even the database showing fine.As i told you there is no allocated qty this issue is not happening for all items. I have checked the Itme setups, item class setups and all. everything seems to be perfect. Its like sometimes GP is not updating the transaction entries with the Item Master.
Was the item purchased (a po issued) and orders entered before the item was entered into the inventory tables? If so, those transactions would be marked as non-inventory transactions and would not update the quantity on hand when posted. If the PO was created before the item was listed in inventory, this will happen!
Just to clarify (when I read the entire thread it seems there might be some confusion on the quantities)...
Quantity On Hand should match the physical shelves if every transaction is posted (receipts received, orders shipped, etc)
Quantity Allocated is the total quantity of the item appearing on un-fulfilled sales orders and invoices.
Quantity Available is Quantity on Hand minus Quantity Allocated.
Hi,
When you say that some of your inventory items are showing zero...where exactly are you looking? What is the window / report name or what is the path to the window / report.
When you say the calculation is fine.....what calculation are you talking about?...and where does it show the actual stock figure?
There are a number of reasons why your stock could be out. But you need to tell us exactly what windows / reports / smartlists you are looking at.
For sure, try a reconciliation. However if this does not resolve your issue, perhaps you cold answer the above so we have more to go on.
Best regards,
now both stock on hand, qty available and allocated qty is zero.Actually the qty available must be 136.when i calculate the total in and out figure from the item transaction enquiry window, i m gettting 136.only in the item total is showing like this.
when you say zero, is it on hand or available? have you thought of allocated qnty?
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (