(Navision 4. SP3-SQL Server)
I am facing a problem using lot No during PO and SO and mainly after deleting an entry which used a lot No. The "story" begun when the customer posted a Sales Ship. document using Lot No. for the Item but he made wrong.
Then he used the Function "&Undo Shipment" (Sales history\ Posted Shipments \ [Functions]) and he tried to "undo" the false action.
Despite the logic of thiw action afterwards when he tried to use the same lot No in other Sales Shipm. he got a msg for unavailable qty for this Lot No.
In order to deal with the problem i tried to delete manualy the entries. The tables which i populate are:
T_110_Sales Shipment Header
T_111_Sales Shipment Line
T_32_Item Ledger Entry. Specialy in this table also, i changed fields "Remaining Quantity" equals to "Quantity" and "Open" as checked. The updating concerned the line of Entry Type "Purchase" and refers to Lot No. which i am interesting.
T_339_Item Application Entry
T_6507_Item Entry Relation
Althought i did the above actions i am having the same msg for unavailable qty.
Can anyone help me about this problem?
Thanks in advance