Apology for not being specific on issue, let me provide full history
* We running GP ver 10 with SP 5 and we are having database of more than 10 years.
* Having mix of items including normal inventory and inventory items with lot track enabled.
* using SOP fulfillment process, POP receivings
* since years we had FIFO valuation method and recently we moved to Average perpetual and installed HITB
* last month we did full inventory reconciliation (which i guess was the first complete reconciliation after valuation method changed)
* during reconciliation for lots of items we found below error message
- The On hand qty has been adjusted from 100 to 99
- purchase receipt ABC is marked as sold
- Added qty sold detail record qty 1 for receipt PQR
- Adjusted purchase receipt qty by 1 for receipt ABC
- On hand qty at bin BIN1 has been adjusted from 0 to (1)
* Physically we have 100 qty for the item but system has reduced 1 pc. after reconciliation
* while looking at Database I found below changes done after reconciliation
- system has added a new record in table IV10201 with SOPNumber "RECON" and with old date
- system has updated a record in Table IV10200 and mark one receipt with qty 1 as "Sold receipt"
* Checking records manually in IV30300 and SEE30303 I am getting 100 Qty perfectly
* Item stock inquiry first line also changed with wrong balance , means first line showing In qty = 50 and Balance = 49
I understand by passing inventory adjustment entry will solve the problem but my question/concern is why this happened all of sudden? even few items are not having any transactions since long time.
How to make sure if this won't happen again with other items in future?
Hope this will make everyone understand the issue and appreciate your help.
Thanks,
Dharmesh Vyas
