Bill Of Materials Function - Multiline templates for creating and amending BOMs in Sage 200

Sep 12, 2026

Upload by Aria

The Bill of Materials function provides two Excel templates to emulate Sage 200 BOM screens, enabling creation and amendment of bills of materials. One template supports standard multiline BOM entry, while the version-controlled template adds the ability to maintain multiple BOM versions for the same product. The document explains how to create a new BOM, describes the available worksheet sheets, and details the purpose and validation-dependent behavior of key fields across status, header, details, components, and operations.

LanguageEnglish

CategoryForms

FormatPDF

Pages13

Reading Time5 min

AccessFree to download

Introduction

Templates and creation workflow

Worksheet structure and sheet options

Map fields: Status and URN

Map fields: Header fields

Map fields: Details fields

Map fields: Component fields

Map fields: Operations fields

Introduction The Bill Of Materials function includes two separate templates :- • The Multiline template emulates the New BOM and Amend BOM screens in Sage 200, which allows you to create or amend a Bill Of Materials • The Multiline template with version control allows for the same functionality with the addition of version control. This allows you to have multiple versions of a BOM for the same product. To create a new BOM start by entering in the data required on the template and click Create There are multiple sheets within both templates. The first is AllFields this covers all fields from all tabs normally shown in the BOM screen in Sage 200. Alternatively, they are also broken down into different sheets such as AllFields_NoaAnalysisCodes, Details, Components, Operations_Full, Operations_FromRegister etc. Each of these sheets can still be tailored to only contain the data relevant to you. Map Fields The table below explains the purpose of each of the fields available to the worksheet: - | Status | Populated when selecting either the Validate or Create buttons on the Excel Data Bridge ribbon.
• The default status on a successful validation will be Pending
• The default status on a successful creation will be Processed
When attempting to post to Sage 200, the status field should either be cleared, or display a status of Pending. Any other data entered in this field will prevent the transaction being created in Sage 200.
Should an error be returned in this cell when attempting to post, it will appear in red. The error should be corrected in the worksheet, and the status field cleared before attempting to post again | | | --- | --- | --- | | URN | Populated when Create button is clicked. | | | GroupByID | If no group ID is given it will default to different for each line. Further details at end of user guide | | | HeaderAction | Header Action determines what action is being taken against the Bill of Materials, the options are:
• Create
• Update
• Delete
• Ignore | | | The following fields relate to the header section for Creating/Amending BOM screen in Sage 200 | | | | Code | | The Stock Item Code | | Name | | The Stock Item Name | | The following fields relate to the details tab for Creating/Amending BOM screen in Sage 200 | | | | Reference | | Reference for the BOM | | Description | | Description for the BOM | | ChangeReference | | Change reference for BOM | | QualityStandard | | Quality Standard for BOM | | Revision | | Revision for BOM | | OnHold | | Use TRUE to put on hold or false to not put on hold | | Reason | | If on hold a reason code can be entered | | DefaultBuildQuantity | | Set default build quantity for BOM | | DefaultCostQuantity | Set default cost quantity for BOM | | | --- | --- | --- | | CalculateOverheadsAutomatically | Use TRUE to turn on FALSE to turn off | | | OverheadContribution | If previous field is FALSE the overhead contribution can be entered | | | UseOnlyInBOMModule | Use TRUE to turn on FALSE to turn off | | | ComponentAssociationRequired | Use TRUE to turn on FALSE to turn off | | | DateEntered | Displays the date of BOM creation | | | EnteredBy | Select user BOM is entered by | | | EffectiveFrom | Set effective from date | | | EffectiveTo | Set effective to date | | | The following fields relate to the components tab for Creating/Amending BOM screen in Sage 200 | | | | CompReferencesRequired | Use TRUE to turn on FALSE to turn off | | | ComponentAction | Component Action determines what action is being taken against the component line, the options are:
• Create
• Update
• Delete
• Ignore | | | ComponentID | Should not be changed if amending a component | | | CompSequence | Set BOM component sequence number | | | CompCode | Set component item code | | | CompName | Set component item name | | | CompQuantity | Set component quantity | | | CompUnitofMeasure | Set Unit of Measure | | | CompType | Set compon

FAQs

What are the two Bill of Materials templates included in the function?

One multiline template emulates the standard New BOM and Amend BOM screens in Sage 200. The second multiline template adds version control to support multiple BOM versions for the same product.

How do you create a new BOM using the template?

Enter the required data on the template and click Create.

What does the Status field do when posting to Sage 200?

The field is populated after Validate/Create actions. When posting, it should be cleared or show Pending; any other value blocks the transaction, and posting errors appear in red for correction.

Sep 12, 2026

Upload by Aria