0 Replies Latest reply: Sep 27, 2013 5:03 AM by Marius Nel RSS

    Bills of Materials - explode to buy out level?

      We use Syspro as our ERP System. The data is stored in a sequel DB.

      The table contains the Parent Part and its components - the problem is that some components must be exploded further to get to the lowest level of the BOM which is called the Buy out level.

      So what i need at the end is a table with the parent and all its components where the part category = B - this replacing all components that are <> part category B by their components hence if the components part category <>B it becomes a parent etc

      It all sounds to much like a circular reference for my brain - Any ideas?