Monday, November 30, 2015

Dynamics NAV - There are more x unresolved serial numbers attached to this document

Related: Item Tracking serial number for ... cannot be applied

This occurs due to unposted assembly entries

Even if you post the assembly afterwards, the serial error stays on the statement

To resolve

  • Confirm if the assembly for the serial number was posted
    • View the error by opening the statement, click on serial no errors.
    • Search for the serial number under the item ledger entries under Serial no. column
  • Remove the error flag on the Trans. Sales Entry
    • Find the transaction number in the Trans.Sales entry table or Serial No.
    • Set Serial/Lot no not valid to 0 (untick it)
    • Find the transactions number or serial no in the Transaction Status Table
    • Set Serial/Lot not valid to 0
--Post all assemblies before the statement date
 update [CRONUS$Transaction Status] set [Serial_Lot No_ Not Valid] = 0 where  [Serial_Lot No_ Not Valid] > 0
  update [CRONUS$Trans_ Sales Entry] set [Serial_Lot No_ Not Valid] = 0 where  [Serial_Lot No_ Not Valid] > 0

No comments:

Post a Comment