Table of Contents

Update and Compare BOMs in Project Budget Calculation

After a BOM has been expanded, you can adapt the substructure for the project. If the master data changes later, or if you want to take over the substructure of another project line or of a project version, compare the substructures and apply the differences selectively. Choosing Expand BOM again deletes the whole substructure, including your project-specific adjustments, and is blocked as soon as follow-up data exists for the lines.

Action Use it to
Update BOM Compare the substructure of an item line with the current BOM and routing of the item.
Compare BOM Compare the substructure of a project line with another project line or with a line of a project version, for example to restore a previous state.
Copy from Copy positions and their levels from another project.
Search and Replace Components Replace a service, item, or general component with another component in several lines.

The comparison pages are part of COSMO Discrete Manufacturing and therefore must be activated (see App Activation).

Update BOM

Update BOM compares the substructure of an item line with the substructure that Expand BOM creates from the current master data. The action is available for item lines without a Document BOM.

For the comparison, a temporary project is created. It gets its number from the number series in the Project Temporary field on the Construction FastTab of the Configure to Order Setup page (see DM Setup). If the field is empty, the number series for projects is used. Set up at least one of these number series.

To update the substructure of an item line:

  1. On the Project Budget Calculation page, select the item line.
  2. On the Actions menu, choose Functions > Update BOM.
    If the project is completed, the message Project is completed. opens, and no comparison is made.
  3. If the item has a BOM or a routing, the BOM Selection request page opens. Select the same BOM, Up to level value, and options as for the original Expand BOM, and then choose OK. The comparison shows the differences to the substructure that results from this selection.
    If you choose Cancel, the message No BOM or routing has been selected for item ... The comparison has been canceled. opens, and the project is not updated.
    If the item has neither a BOM nor a routing, no selection page opens, and all lines of the substructure are shown as Delete.
  4. On the BOM Compare & Update page, review the differences (see Review the Differences). Select Skip for lines that you want to keep as they are.
  5. Choose Apply Changes.
    A message asks you to confirm: All changes will be applied. Do you want to continue? If you choose Yes, the page closes, the changes are applied, and the message Changes successfully applied. opens. If you choose No, you return to the page.

If the page shows differences and you close it without applying them, a message asks: Changes have not been applied. Do you still want to close the page? Choose Yes to close the page without updating the project or No to return to the page.

For example, the production BOM of item 1000 has been expanded in a project. Later, a component is inserted into the production BOM, and the Quantity per of another component is set to a different value. You choose Update BOM for the item line and select the same production BOM and options as for the expansion. The BOM Compare & Update page shows the inserted component as Insert and the other component as Modify. After you choose Apply Changes and Yes, the component is inserted into the substructure, and the quantity of the other component is updated. Lines without differences keep their values; the totals of the substructure are recalculated.

Compare BOM

Compare BOM compares the substructure of a project line with the substructure of another project line or of a line of a project version. The action is available on the Project Budget Calculation page and on the Version Project Budget Calculation page. It opens the Compare BOM page with the following values:

Started from Source Target
Project Budget Calculation Source BOM Type Project Budget and the current project. You select the source line. The selected project line
Version Project Budget Calculation Source BOM Type Project Budget Version and the selected version line The corresponding line in the project

To compare the substructures:

  1. On the Project Budget Calculation page or the Version Project Budget Calculation page, select the line, and then choose Compare BOM.
  2. Check or set the source:
    • In the Source BOM Type field, choose Project Budget for a project line or Project Budget Version for a line of a project version.
    • In the Source No. field, select the project or the project version. The list of project versions shows the versions of all projects with their Project No.. The Source Project Version field shows the selected version.
    • In the Source Ref. No. field, select the line.
  3. Check or set the target in the Target BOM Type, Target No., and Target Ref. No. fields in the same way. To exchange source and target, turn on Swap Source/Target.
  4. Choose OK.
    The BOM Compare & Update page opens. Review and apply the differences as described in steps 4 and 5 of Update BOM. If you close the page without applying the changes, no confirmation message opens.

If a project version is the source or the target, a temporary project is created with a number from the number series described in Update BOM.

If the target is a project version or a line of a completed project, you can only review the differences. The Apply Changes action is not shown.

The top line and sum lines cannot be compared. If a line of the version does not exist in the project, compare its parent line: the missing line is shown as Insert.

The comparison stops with a message in the following cases:

Message Cause
Project budgets and project budget versions can only be compared with project budgets or project budget versions. Only one of source and target is Project Budget or Project Budget Version.
A project line cannot be compared with itself. Source and target are the same project line.
A project line cannot be compared with a line of its own substructure or with one of its parent lines. Source and target are in the same project, and one line belongs to the substructure of the other.

Review the Differences

The BOM Compare & Update page shows the result of both functions. The project stays as it is until you choose Apply Changes and confirm. The page opens even if there are no differences.

The Action column shows how a line differs: Insert, Modify, Delete, or Move. Lines that need your attention also show a value in the Severity column. To read the message, choose the value in the Severity column.

Situation Severity and message Result when you apply the changes
A line to be deleted has related documents or entries, for example planning, procurement, postings, or Construction Orders. Error with the reason, for example Deletion canceled. The following record must not exist: followed by the record The line is not deleted.
A line to be deleted has lines in its substructure that cannot be deleted. Error: The substructure cannot be deleted completely. The line is not deleted.
A line to be updated has related documents or entries. Warning: Related documents or entries exist: followed by details The line is updated.
A line to be deleted has sales quote lines. Warning: Sales quote lines exist for the project line. You will be asked how to handle them. A selection opens: Delete existing Sales Quote Line, Delete Sales Quote, Reset Project Line Link in Sales Quote, or Not delete. With the first three options, the sales quote lines are handled as selected, and the line is deleted. If you choose Not delete or close the selection, applying stops with the message Deletion canceled. The following record must not exist: followed by the record.
A line to be deleted has a Document BOM. Warning: The document BOM ... will be deleted. The line and its Document BOM are deleted.

To keep a line as it is, select Skip. If you select Skip for a line with the action Insert, its substructure is skipped as well. Otherwise, if the line has a substructure, a message asks: Do you want to set/reset Skip for the substructure/children as well? For the other actions of the page, such as Move, Undo Move, and the skip actions, see Compare and Update Construction Orders.

Comparison Rules

The following rules apply when the Update BOM and Compare BOM actions compare the substructures and apply the differences.

  • For lines that exist in the source and in the target, the fields that are compared and updated are defined on the BOM Compare Fields page, view Project Budget. To open the page, choose Related > BOM Compare Fields on the Configure to Order Setup page (see BOM Compare Field Configuration). A default set of fields is provided for project lines.
  • A line that is inserted into the target takes over all values of the source line, regardless of the BOM Compare Fields settings. The Document BOM and the checklist of the source line are not taken over.
  • Quantities are compared relative to the quantity of the compared line, so you can compare the substructures of lines with different quantities. Inserted lines get their quantity converted in the same way.
  • Dimensions and comment lines are compared with Update BOM and when two project lines are compared. They are not compared when a project version is the source or the target. A line that is inserted from a project version gets the default dimensions that apply to it in the target project.
  • Inserted lines and moved substructures are placed in the order of the source structure.

See Also

Entering BOMs in Project Structure
Project Budget Calculation Page


Feedback
Submit feedback for this page .