How do I resolve inconsistent quantity avail on Itemsite table, It shows Quantity Avail higher than QtyonHand. QtyAvail =1425 pcs QtyOnhand = 9 pcs. Location and Lotserial table shows 9 pcs for both QtyAvail and Qtyonhand fields. Also check the transaction history, It totals to 9. I already to manually update this field through SQL but the erroneous quantity keeps on returning.
I also already tried doing the IN Integrity Check hoping that it would correct the value for the Qty Avail field on itemsite to no avail. Kindly advise me on how do I correct this. We are using Dynamic SL 2011 FP 1.
Please also advise me on when does the itemsite, location, and lotserial tables are in Dynamics SL.
*This post is locked for comments