Way to automate BOM Component Requirement Report with Sales Order line data?

Is there an automated way to generate the component shortage data provided by the Component Requirement Report using BOM item numbers and quantities from Sales Order lines as input? We have one product line with standing sales orders to which we add/modify lines by promise date. We would like to automate the generation of the same shortage information provided by the BOM Component Requirement Report, rather than having to manually enter the BOM items and quantities into the report setup window. Thanks!

  • 0
    Is there an automated way to generate the component shortage data provided by the Component Requirement Report using BOM item numbers and quantities from Sales Order lines as input? We have one product line with standing sales orders to which we add/modify lines by promise date. We would like to automate the generation of the same shortage information provided by the BOM Component Requirement Report, rather than having to manually enter the BOM items and quantities into the report setup window. Thanks!

    Hay Roadracer, 
    Yes, it is possible to automate the generation of the component shortage data using BOM item numbers and quantities from Sales Order lines as input. This can be achieved through custom scripting or programming using APIs provided by the software system used for generating the BOM Component Requirement Report. Alternatively, third-party tools may also be available that can interface with the software system and automate the process.

    Best regard,
    mymorri

  • 0

    For one layer of BM recipes you could do this in a custom report / Excel query.  For multi-layer bills, we've done such reports using SQL Views (to link the layers together).  The real complexity comes when you need to deal with multiple demands for the same component inventory (open WT, SO lines of the component item, SO lines for bills with the item as a component at potentially different layers... as well as including / excluding open WT that are being built for SO vs inventory...).

    At a certain level of complexity, you might want to consider the PM module, which does consolidate a few things together nicely, even linking in anticipated supply dates (from PO data).