shilburn 3/17/2016 10:04:05 AM

Serial Number Allocated on Screen but not in database

I have a serial number that shows to be allocated when I do a serial number inquiry. Yet, the Inventory Serial & Lot Number Work file does not include any serial numbers for the part number in questions and the Item Qty Master file shows the Qty on Hand to be 6, and Qty Alloc to be 0.

What script can I run to unallocated this serial number?

 Any help would be greatly appreciated as we are trying to add this serial number to an invoice.

 

Thank you in advance! 

 

Version: GP 2015
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3