Sage 100

Doing a quick search for the word 'consignment' in the 90 minds forums shows the last time the topic was discussed in depth was way back in 2012. Are there any new offerings I am missing? Currently, it seems that having multiple warehouses is the best bet, but it is still full of flaws. I feel like there should be a solution out there by now based on demand. They do ""both kinds"" of consignment. They place product in a clients warehouse, and hold product from vendors. Anyone have this in place and working well?

I think ACS's Multi bin can do that but not totally sure. I would check with them.

I posted a similar question last week. The user wants to segregate inventory for some of their large customers. below is what I recommended after a lot of suggestions from 90 Minds colleagues: 1. Add a multi-bin module. Multi-bin allows for multiple bin locations for each inventory item code. When you receive you need to specify a bin location. When you sell you have to specify the bin the item was picked from. Users with a lot of transactions typically use radio frequency (RF / WIFI) hand held computers and bar coding. You could have a DISCOVER bin location, a WALGREENS bin location, etc. 2. Use a separate warehouse code for each customer. For example, Walgreens might have warehouse ""WAL"". Purchasing would use this warehouse. 3.Use LOT as the inventory valuation method. When you receive you need to specify a LOT number such as WALGREENS or DISCOVER.

Thanks @DougHiggs, and @DianeRuth, I have a call in to ACS. Where the client has the Vendor inventory as well as customer, the Vendor inventory is a liability, right? So would you think using a contra-account for that inventory/warehouse would work? I am not super familiar with Multi-Bin, but I assume the GL account would be associated with the Warehouse and not the Bin...same as standard Sage. Does that change anything as it moves from being a liability to a sale? It still debits and credits the correct accounts when sold from what I can gather (reduces the liability), and the invoice from the vendor would hit the correct expense accounts. - I REALLY need to review my accounting books! Does that sound right?

@MichelleNichols if you are receiving in inventory that is owned by the vendor wouldn't the Purchase Clearing account work? I would just have one for that Prod lIne. Separate inventory and PC for that vendor or Whse if I am understanding you right.

That might work too @DianeRuth, I will give the client both options. They have been using several work-arounds as the work gets passed from person to person and we are trying to streamline and go back to basics. As long as they don't need to keep them completely separate, I think that would work very well.

I'm not an expert on consigned inventory but I don't think receipt of goods triggers a liability to the owner. Why not segregate the inventory as discussed via multi-bin, or just use a separate warehouse but receive the item at zero cost. Set the owner up like a salesperson and ""pay"" commission on the agreed upon rate when the item sells.