We use a separate warehouse for consigned inventory. Easy reporting, easy reconciliation.

Steve

MAS 200 V4.4.8

My problem with using the separate warehouse is that when I receive Items into the warehouse with a value attached it impacts my accounts payable.  I only want to reflect payment due after I have sold the inventory.  Today we leave the inventory at zero balance and issue purchase orders each week for the negative quantities to bring them back to zero.  This works in managing our accounts payable but does nothing for my inventory management.  I have to track stock outside of Sage.

IF done correctly receiving items into the warehouse should not impact you AP. It would just post to Inventory and Purchases Clearing.

We use master/child orders and warehouses.

We create a PO based on the Master Quantity of a sales order then receive that into the consignment warehouse for the customer then create child SO pulls off of that master and out of the consignment warehouse based on pull reports from the customer.

It gets a little funky in that we deal in long time sea shipments so we actually have a transit warehouse in there.  So we receive to a "transit" warehouse when our vendor ships, then when received at the customer's consignment, transfer to the consignment, then pull.  This gives us a better view of product flow as it is shipped from our Vendor -> Transit -> Consignment -> Pull (SO). 

Of course, all of this leads to a ridiculous amount of warehouses which have to be coded well enough for people to know what they are looking at.

How do you keep Consignment Inventory from going negative....how do you prevent overselling?  It seems as if Sage will warn you, but not prevent negative.  We use Average Cost on version Sage ERP 2013 5.0

Dan,

We are using warehouses to track the completed goods that we build, but are trying to figure out how to generate a packing list to accompany outgoing consignment orders without actually recording a sale.  I don't think we can create a packing list for a warehouse transfer, can we?

You would have to create this via Crystal Reports, but we did this exact thing.  You create the transfer in Sage 100 Inventory Transactions and then we have a Crystal Report that prints out a "Packing List" that we can give to the driver that transports the items to our other warehouse.

Tyler