Sage 100

New Customer to Sage, v2017. They are currently using a software called Everest. They buy/sell serialized items. They will order from a vendor and have the vendor blind ship to the customer or they might get a shipment in and the receiving person will scan the MAC address in error rather than the serial #. They currently have the option to change/fix the serial # after the receiving (much like QB that you can basically just change with a click). Reversing the PO and Receiving again isn't feasible as they also have a solution that will Average Cost their Serial Items so when doing a Return of Goods, the items came out at Average Cost rather than PO Cost. What ideas do you all have for a workaround for this?

Script to check for MAC like address being scanned and if true message to user to scan the serial # not the MAC address.

That might work for that part of the problem and in rereading my verbiage realized I missed finishing a sentence. The Blind Ships will get invoiced to customer before my customer receives the invoice from vendor so they don't know what the serial # will be.

Are they just tracking the serial number for registration reasons? Do they need it applied at an SO invoice level, or could it just be to the customer? I'm thinking to keep the items average cost and to just use a UDT to store the serial numbers for reporting purposes. Otherwise, you'd probably want to invoice the items with a dummy serial number and then create an automation script to credit-memo and re-invoice so that you can apply the serial number when you learn what it is.

EDI? That would take care of the shipping confirms for the blind shipments at least.

I'm exploring a UDF on the Lot/Serial Distribution, having system generated serial numbers and Mfg SN in the UDF. Then a Button on the Lot/Serial Inquiry Screen to edit the UDF when necessary.