Sage 100

Anyone have an eloquent way to handle the following (without using BM module): PO is issued to vendor A for item. Vendor A ships item to vendor B, who does some additional work on it and sends the finished item to your warehouse. Each vendor bills you for their work separately. You want to track the process each step and assign the proper cost to the initial item as well as the finished good.

Do they know when Vendor A ships to Vendor B? (and maybe non-exploding kits?)

Hmm, you could do a PO for vendor A, drop shipping to vendor B who you also have a regular PO for the finished item. You could then do a landed cost for vendor A portion on the receipt for vendor B PO. You would have to make sure the landed cost and invoice for vendor A PO both hit the appropriate accounts. Very wild workaround but I never said it would be pretty. If it doesn't make sense, forgive me as I've been standing in front of about a dozen people all day shooting around ideas like this. There is USUALLY a workaround for everything. The question is, is it worth it?

Work order module.....

Receive the PO for vendor A to a clearing account. Receive the PO for vendor B for the full value to inventory, but process a second line on the ROG/ROI reducing the vendor B's invoice value by the amount of vendor A and charging it to the GL clearing account. Similar to @ThereseLogeais method.

You could probably sent this up on an internal PO to vendor B also so you don't have to remember to add the line.

Or use WO as @JeffSchwenk said...

JobOps handles this too. JO is not just mfg. Make each a Step in a Work Ticket. PO's and labor attached to each step. If this is a major process for the customer, it could be worth it.

BM or WO is the real answer but I have a client like this and they rec in vendor A into 999 WHS real item (boxes) and vendor direct ships to Vendor b when B ships item ( different item code - box with candy) to them they rec it in at standard cost item( box +candy). Then they have to issue out xxx amt of boxes the vendor used from vendor A... it really is not pretty.

@MarkKotyla - What is the transaction volume?

Thanks for the feedback everyone. The volume is light now, but I want the solution to scale. JobOps is overkill and BM would probably work OK. Just wanted to make sure I wasn't missing anything obvious.