Sales Kit Part Pricing (BOMs)

SUGGESTED

I am looking to utilize sales kits to add and remove parts on sales orders. However I want the sales kit pricing to be a roll up of the part prices and not have to put a price on the sale kit parent part.   Individual part prices can change and I don't want to have to adjust the parent part pricing each time.    I have worked with Kits and BOM's with other systems and this has always how it has worked.

Thanks for any help or insight you can provide.

  • 0
    SUGGESTED

    I'm not aware of a native way to do what you are asking.

    You might be able to use the following enhancement by converting the components to items so their unit price is used.  It has different options on how to handle the parent kit item.

    https://www.dsdinc.com/enhancements/marketplace/products/so-1068-kit-explosion-to-convert-components-to-items 

    If that doesn't work for you, another alternative would be to write a script to do it.  It could be fairly complicated though especially if you have price breaks set up, you would need to determine how you would handle them.

    EDIT: Another option would be to set up a VI import that either reads a file or queries the Sage 100 tables which could sum the price of kit components in the kit detail table.  It sounds like you aren't using BoM kits so you should be able to query IM_SalesKitDetail and CI_Item.  Link the tables on IM_SalesKitDetail.ComponentItemCode and CI_Item.ItemCode to get the CI_Item.UnitPrice for each component which you would SUM by grouping on IM_SalesKitDetail.SalesKitNo.  You could then schedule the import job to run however frequently you want it to.

  • 0 in reply to David Speck

    Thanks for the response I will look into these.