Item Quantity in GP

(0) Share

Report

Posted on by Community Member

Hi,

I have an issue on a particular item in GP where the Quantity on Hand is not showing the correct amount. I navigate to the below path Enquiry > Inventory > Item Stock and I am having quantities in negative, and i never allow negative quantity. Is there a process that I can run to solve this? I already tried reconciliation on that item and also checklinks on inventory.

Thanks and regards,

*This post is locked for comments

All responses (8)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

RE: Item Quantity in GP

Hi Alexander,

As suggested by Leslie, are you able to locate the transactions related to this Item to find out at which point the inventory went into the negative amounts ?

Inventory >> Inquiry >> Item Transaction

Sorting or filtering the transactions by the most recent dates should help to narrow down quicker on the transactions.. Start from a date you know the QTY on hand was still positive..
Community Member on at

Like (0)

Report

RE: Item Quantity in GP

Hi Leslie I have looked into table IV30300 and the data seems to be matching with that in GP when I navigate to Enquiry > Inventory > Item Stock and also in table IV10200.
L Vail 65,271 on at

Like (0)

Report

RE: Item Quantity in GP

If you zoom back from the inquiry window, do any documents show up? Can you match the quantities in the IV30300 table with the quantities in the IV10200 tables?

Leslie
waseem 230 on at

Like (0)

Report

RE: Item Quantity in GP

i have face this issue most of the time, when user post any inventory transaction and due to improper posting if user try again to post same batch, then inventory becomes -ve
Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

RE: Item Quantity in GP

Have you tried running the detailed historical inventory stock status report? there you can check and see if you can find the transaction that is giving you the negative ammount and maybe reverse such transaction, could be not an error on GP but an error on a transaction.

Hope this helps.

Regards.
Community Member on at

Like (0)

Report

RE: Item Quantity in GP

The checklinks process did not return any errors or warnings. Reconciliation was run from the reconcile window with regards the module.
L Vail 65,271 on at

Like (0)

Report

RE: Item Quantity in GP

What was the result the Check Links Process, or was it a reconciliation executed from the Reconcile window or did you run it from Check links for you?
waseem 230 on at

Like (0)

Report

RE: Item Quantity in GP

we have done it , from back end, (SQL SERVER) using self made quires. its most occurring problem, main cause, interruption in posting.