How to Find Out Total Standard BOMP Cost for All Parent Items

How to Find Out Total Standard BOMP Cost for All Parent Items

Release Date: 10/06/2023
Version: 8.2 & Up

Q - Is there a way to run a report from Elliott that shows the total standard BOM costs for all our parent items? Instead of going one by one and running each BOM?

A - Please use the following procedure and example:
  1. You may run "Print costed of bill material" from BOMP/Processing (see screen example parameter below, include Routing) to CSV file.
  2. You may eliminate "blank" row from column AT (as shown below).
  3. Example: Sheet "bomcost" is detail. Sheet "Summary" is after eliminating the "blank" row from column AT.
  4. Example: Print parent item from F1111 to F3333, column AS (ParentOrgCost) = Item Standard Cost (field # 26), column AT (ParentNewCost) = new calculation from BOM.
  5. Example: Parent item # F1111, original standard cost = $1280.44, new calculation from BOM = $1291.46
Below is the sample of "Print Costed Bill of Material" with export to CSV option.


Bring up the CSV in Excel and follow the steps above to get your final result similar to the below example:




EMK/RSS


    • Related Articles

    • BMITMVRS Bill of Material Production Cost Variance Report

      Production Cost Variance Report Application Overview The Production Cost Variance Report prints the cost variance between planned cost and actual production cost for selected items. Planned production cost is calculated based on the routing for each ...

    • BM24S1 Bill of Material Resequence Component Items

      BM24S1 Bill of Material Resequence Component Items ← Bill of Material / Work Order Plus Resequence Component Items Application Overview When many changes are made to a product structure over a period of time, the sequence numbers of the component ...

    • CPISSULS Customer Order Processing Issue Serial/Lot Component Items

      Issue Serial/Lot Component Items Application Overview After posting invoices to Accounts Receivable which includes a line item which is non-stocked and controlled and has a product structure which contains Serial/Lot components, a record for each one ...

    • ARPRGSCN Accounts Receivable Purge Closed Open Items

      Purge Closed Open Items Application Overview Periodically, you will want to remove from the A/R Open Item File all transactions that have been fully paid off. Otherwise, the file could become very large over a period of time. This application will ...

    • BM26S1A Bill of Material Copy COP Orders into BOMP

      BM26S1A Bill of Material Copy COP Orders into BOMP ← Bill of Material / Work Order Plus Copy COP Orders Into BOMP Application Overview The Copy COP Orders Into BOMP application allows the user to import orders for Feature Items entered in Customer ...