2,597
Hello,
Sales invoice got stuck while posting and quantity deducted from stock but invoice not posted.
we deleted the Sales invoice but quantity still deducted.
i run check links for all modules and reconcile but nothing fixed.
the one hand quantity is wrong and also the quantity balance showing after 1st trx on the item is not correct
any solution for this.
Without having a copy of the data that will be hard to say. The IV00300 should have corresponding records in the IV10200, IV30300,IV30301 and possibly others. If you could document one item by putting data in a spreadsheet that would be helpful.
yes but what we need to write in this script?
You will need to build this script yourself. It appears you have found the solution. Do you have access to someone who can build SQL scripts?
sorry didn't get you.
Support maybe able to provide such a script but there is generic script to do this.
the issue that the quantity sold in table IV00300 showing the quantity on the deleted Invoice
i checked one new item with Lot ID option and the deleted invoice was the 1st invoice on this item on this site and i found on table level that column QTYSOLD is updated by the quantity was on the deleted Invoice.
i am updating this filed manually and run item reconcile and system update the quantity to correct values.
is there any SQL Script or option from inside GP to fix this issue.
I would try using Utilities->Inventory->Remove Transactions
You know the item number and hopefully the transaction number. Be careful with this utility as it will delete records.
i adjusted the sold lot quantity for one item in table IV00300 then run item reconcile and got below result and quantity issue fixed fir this item in the warehouse with the issue and total WH
can you tell me what is the table name for this transaction ( purchase receipt )
The qtyonhnd is in the IV00102. This is what IV reconcile will adjust based on what inventory transactions it finds in IV10200 and IV30300.
i found in table IV10201 a record with name RECON in column ORIGINDOCID
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 (