Correction - Message - Validation Results, Item tracking defined for item XX-123 in Purchase Line accounts for more than the quantity you have entered

Correction - Message - "Validation Results, Item tracking defined for item 'XX-123' in Purchase Line accounts for more than the quantity you have entered.

Correction of the received weight on a purchase ref.

Issue

A purchase ref. has been received (Use Pickup = 'off') but the weight received is incorrect & the system will not allow a new value to be entered into Expected Purchase Qty  due to a tracking error message.


You have undone the posted purchase receipt using the standard Business Central function Post -> Undo -> Receipt.

Resolution

In section Document Entries the purchase order will be present with the incorrect Quantity value & tracking will be set to this value. The purchase order needs to be opened, the quantity updated & the tracking reset to the new value. Receive the purchase order.

Steps

  1. Go to section Document Entries & select the PO line.
  2. Go Document Entries -> Line -> Tracking -> Item Tracking Lines & copy the existing Lot #. Then delete the entry (3 dots, delete line). 'Undefined' will not be zero. Escape back to the ref.
  3. In section General, reset Expected Purchase Qty to the new value.
  4. Go Document Entries -> Line -> Tracking -> Item Tracking Lines & paste the Lot # back in. Set the Quantity (Base) to the correct value checking Undefined = zero.
       (Item tracking quantities are always in Kilogram regardless of that the purchase (or sale) unit of measure is)
  5. With the PO line still selected in Document Entries, do Line -> Post -> Receive
Note, you may have to 'reopen' the PO if the PO has been 'released'.
  1. Go to section Document Entries & then open the purchase order: Line -> Open Document
  2. In section General check the Status is "open" & if not reopen.
  3. In the PO header 'reopen' the purchase order: Release -> Reopen
  4. Continue with correction as per above.