Big Box Retailer Ordering Woes

Question

We sell bins of mixed product to big box retailers. We purchase and inventory those bins as 1 item number, but the stores will only order the individual eaches that make up the bin. For example, 
 
 Bin D is equal to 
 100 Part A 
 200 Part B 
 300 Part C 
 
 The store will order parts a b and c and expect to get Bin D. Is there a way to make this conversion work in Sage 500? As it stands the order comes in EDI and we have to manually adjust and then manually adjust back the invoice going out and it's not working well.

John Mitchell · Answer

Easiest would be to buy the components and inventory them individually. You could also set the items' type as assembled kits and purchase the kits, then disassemble them after receipt of goods.

John Mitchell · Answer

Sure does. You have to test it, but you could order them as kits, receive them as kits, and do 'process kits' to disassemble as needed. Your bigbox guy would work out too, because I'm fairly certain the invoice lines are the component item, not the kit partno. Sounds like you're off to the laboratory for a few days...

Sage 500

Big Box Retailer Ordering Woes

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING