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

I have the same question (0)

All responses (8)

Answers (0)

waseem 230 on at

Like (0)

Report

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The checklinks process did not return any errors or warnings. Reconciliation was run from the reconcile window with regards the module.

Was this reply helpful? Yes No
Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
waseem 230 on at

Like (0)

Report

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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..

Was this reply helpful? Yes No