How to add inventory to a vendor PO

SUGGESTED

All,

I am new to Sage 100 and have been impressed with it so far.  

I currently have an issue I have been wrangling for a bit now and would like to hear my options on the subject.  I would like to know if there is a way to add inventory to a PO.  So here is the situation and why I ask.

I have a part I buy to stock (A). Part (A) has a component on the BOM that is difficult to acquire and is expensive (B). In order to reduce lead time we purchase some inventory of this part (B). Our vendor will not store the items so we have to ship part (B) to the vendor every order. The vendor then uses (B) to build Part (A).   Is there a way to issue the material in some way to the PO to have clean inventory transactions and traceability. 

I cannot seem to find any info using searches on this topic. 

We currently are using Sage 100 2020 with production management module.

Thanks

  • 0

    There's no way in Sage 100 to include inventory on a PO.

    However, you could do an inventory Issue Transaction in the inventory module and include the PO number in the comment field. The comment field doesn't show up on the inventory transactions tab by default, but you can use Custom Office to modify it to add that field to the display. Then you could keep track of each issue and which PO it was tied to. (Optionally you could use a UDF, but the comment field is already there.)

  • 0
    SUGGESTED

    I'd to an inventory Transfer into a separate warehouse (on site at vendor), then after receipt do a production entry to take the Part A (from the receipt warehouse) plus Part B (from the on site at vendor warehouse) to create the finished good item code (that you sell). 

    If the finished good item code is FIFO/Lot/Serial the produced cost tier will include the value from both Part A and Part B (plus any extra costs you might want to apply).

    Also, if you ever have quantity in the separate warehouse code you know you shipped more than you've received back... as a good control.