Creating dummy invoices (or some kind of equivalent packing list) using Transaction Entries in Sage100?

Here's the deal: we need to create undervalued dummy invoices (or some kind of equivalent packing list) for international customers that work with us on CONSIGNMENT.

Because the shipment is on consignment and not firm sale, we can't use a normal sales order/invoice. We must use a Transaction Entry to transfer the stock from our warehouse to our partner's warehouse. The problem is, we still need a packing list attached to the shipment, both for customs purposes and for the customer to verify upon arrival.

What would you do in our situation?

  • Create a fake sales order, then delete it before invoicing? Obviously we want to avoid posting transactions that aren't real.
  • Create a fake packing list manually in Excel, then making a separate Transaction Entry for internal purposes only? But we also want to avoid the cumbersome practice of manually copy/pasting item descriptions and item costs into an Excel document, adding our company header, printing, etc.
  • Print the Transaction Entry/Register itself? But we need to have costs listed on the packing list/dummy invoice which we can't do in a Transaction Entry. At the very least we don't want to accidentally change our real unit costs internally.
  • None of the above?

Suggestions appreciated! Thanks!

  • 0
    I would think for inventory valuation and control, you would want everything leaving the building (and espeically leaving the country) to be captured on an invoice. Unless you have your international customers each set up as a separate warehouse (where a transfer ticket may do the job), I would think keeping track of what is out of the building would be an inventory and accounting nightmare.

    For consignment orders we invoice out and credit back in when returned.
  • 0
    We do the same thing and created a Crystal report using the Transaction Entry files and the Warehouse file (for address info) to generate a pretty nice packing list. We enter the transaction, run the Crystal report, then print and update the Transaction Journal. It doesn't provide much in the way of tracking and visibility, but at least inventory quantities are updated without the need for fake transactions in other modules.

    Anymore, a lot of companies deal with consignment inventory. It would be nice for Sage to build functionality into Sage 100 to allow proper processing and tracking. We consign inventory to our customers and have inventory consigned to us from vendors, both of which require workarounds in the system.