SharpSync
  • Welcome
  • Fundamentals
    • Getting Started
      • Registration
      • Landing Page
      • Support
      • Subscription
    • Data Sources
    • Property Mappings
      • Adding Property Mapping
      • Property Mapping Settings
    • Rules
      • Import / Export
        • Append text
        • Calculate number
        • Export manipulation
        • Format as decimal number
        • Prepend text
        • Remove property
        • Replace all instances
        • Replace first instance
        • Round to nearest X
        • Select from JSON
        • Set cell value
        • Set empty cells
        • Text manipulation
      • Display
        • Number between
        • Text contains
        • Text ends with
        • Text evaluation
        • Text is a number
        • Text is exactly
        • Text is in list
        • Text is not a number
        • Text is not empty
        • Text is not in list
        • Text length between
        • Text length is exactly
        • Text maximum length
        • Text minimum length
        • Text not contains
        • Text not ends with
        • Text not starts with
        • Text starts with
      • Advanced Scripting
    • BOM Comparison
    • Data Safety
    • Troubleshooting
      • Duplicate component paths
      • OAuth 2.0
  • Data Sources
    • Autodesk Inventor
    • CSV
      • Getting Started
      • Importing a Bill of Materials (BOM)
    • MS Dynamics 365 Business Central
      • Getting Started
      • Item Fields Json & Internal Names
      • Resource Fields Json & Internal Names
      • List Names For nestedObject Mappings
    • NetSuite
      • OAuth Setup
        • Permissions
      • RESTlet Script Setup
        • SharpSync RESTlet Script
      • Thumbnail Folder Setup
      • Authentication + Configuration
      • Common setup
        • Configure quantity mapping
        • Configure accounts mappings
        • Configure itemType mapping
        • Configure isPhantom mapping
        • Configure subsidiary mapping
        • Configure price mapping
        • Configure Where Used Link mapping
        • Configure thumbnail mapping
        • Read-Only NetSuite Fields
        • Common Mapping Rules
        • Common List names
      • Advanced Bill of Materials
      • Configure Routings
      • Integration tips
      • Troubleshooting
    • Odoo
      • Getting Started
        • Authentication + Configuration
        • Debugging tips
      • Common Setup
        • Map BOM Codes
        • Map BOM Types
        • Map Attribute Values
          • Reading Attributes - Overview
          • Display All Attribute Names
          • Display Single Attribute Values
          • Writing attributes
      • Product Management
      • Hosting Options
      • List Names
      • Permissions
      • Troubleshooting
    • Onshape
      • Getting Started
      • Setting up Derivatives
    • Propel PLM
      • Getting Started
    • SolidWorks
    • SolidWorks PDM
      • Downloading and installing the add-in
      • Configure the add-in
      • Setting up the Solidworks PDM Web 2
      • Troubleshooting
      • Submitting a BOM for update
  • Advanced
    • Derivatives
  • User management
    • User Management
    • Application Permissions
Powered by GitBook
On this page
  • BOM row updates
  • BOM Comparison Legend
  1. Fundamentals

BOM Comparison

The view where all data is displayed overlayed on top of one another on screen.

PreviousAdvanced ScriptingNextData Safety

Last updated 4 months ago

The BOM comparison screen is where you will ultimately spend most of your time

BOM row updates

BOM row updates can occur in the primary or secondary Data Source and is influenced by your settings for:

  • Property Mappings

  • Rules

BOM row updates are also influenced by whether the PROCESS checkbox is checked or unchecked. You can use the context menu of any given row's PROCESS cell to bulk check/uncheck the PROCESS checkbox of related rows and children rows.

Primary Source updates

When updating BOM rows the following table illustrates how updates occur at the primary source.

A primary source is typically a CAD or PDM or PLM system. For primary sources, quantity values are typically not updated.

Using the default color scheme for BOM comparison, you can expect the following results:

Process Row
Row Background
Item Creation
Bom Structure
Quantity
Item Properties
Routings
Derivatives

☑️

⬜ White

N/A

Unchanged

Unchanged

Updated

N/A

N/A

☑️

🟩 Green

N/A

Unchanged

Unchanged

Updated

N/A

N/A

☑️

🟨 Yellow

N/A

Unchanged

Unchanged

Updated

N/A

N/A

☑️

🟥 Red

N/A

Unchanged

Unchanged

Ignored

N/A

N/A

⬜ White

N/A

Unchanged

Unchanged

Ignored

N/A

N/A

🟩 Green

N/A

Unchanged

Unchanged

Ignored

N/A

N/A

🟨 Yellow

N/A

Unchanged

Unchanged

Ignored

N/A

N/A

🟥 Red

N/A

Unchanged

Unchanged

Ignored

N/A

N/A

Secondary Source updates

When updating BOM rows the following table illustrates how updates occur at the secondary source.

A secondary source is typically an ERP or PLM system. For secondary sources, quantity values are typically updated to reflect the quantities of the primary source.

Using the default color scheme for BOM comparison, you can expect the following results:

Process Row
Row Background
Item Creation
Bom Structure
Quantity
Item Properties
Routings
Derivatives

☑️

⬜ White

Unchanged

Updated

Updated

Updated

Processed

☑️

🟩 Green

Created

Linked To Parent

Updated

Updated

Updated

Processed

☑️

🟨 Yellow

Linked To Parent

Updated

Updated

Updated

Processed

☑️

🟥 Red

Unlinked From Parent + Children Ignored

Ignored

Ignored

Ignored

Ignored

⬜ White

Unchanged

Ignored

Ignored

Ignored

Ignored

🟩 Green

Not Created

Not Linked To Parent

Ignored

Ignored

Ignored

Ignored

🟨 Yellow

Not Linked To Parent

Ignored

Ignored

Ignored

Ignored

🟥 Red

Link To Parent Kept + Children Ignored

Ignored

Ignored

Ignored

Ignored

BOM Comparison Legend

Color scheme
Description

Blue border - DS1 and DS2 values are different. Without user modifications

Blue & green border - DS1 and DS2 values are different. With user modifications

Green border - DS1 and DS2 values are identical. With user modifications

Orange border - Value did not pass display mapping rule (Warning)

Red border - Value did not pass display mapping rule (Error)

Red background - Component is missing from the DS1 BOM. Will be unlinked from the DS2 BOM

Orange background - Component is present in DS2. Will be linked to the corresponding DS2 BOM

Green background - Component is missing from DS2. Will be added to DS2 and linked to the corresponding BOM

Blue background- Row line type is drawing used to configure drawing types derivatives