Sage 100

End user drops ships computer equipment from the vendor to the customer. Many of the customers require the serial numbers for each item to be on the invoice. How to you designate an item as drop ship and report the serial numbers of the items on the SO Invoice?

Don't use the Drop Ship functionality in Sage; instead set up a warehouse for Drop Ship.

Helps you keep track that way, too. Receive when you get notification of shipment from the vendor - if you have QOH, that means you forgot to invoice the customer.

I recommended using a ""DS"" warehouse but they didn't like having to receive in and allocate out every serial number. They will receive a file each night from either Ingram, Tech Data, or Synnex with the invoice data reflecting the quantity drop shipped. No sweat receiving it in to inventory but allocating on the so invoice is a huge project. They can have hundreds if serial numbers for one line item. It would be great if we could keep the serial numbers in ar history, list them on the invoice, but not have to allocate them out of inventory.

What format is the 'received file' in? Can they copy paste into 1 UDF Multi-Line field?

@NancyHanson That is a good idea. We import the data to po receipts. It is quite a process to get the data formatted. All of the vendor files are encrypted and password protected. One is xml another is csv and another is tab delimited. Once they are in a common format the importing is easy.