Sage 50 Product BOM Import/Update

Search

Sage 50 : Import Product BOM Record (Pro Version)

To extract Product BOM (Bill of Materials) data simply press Extract button, on the PostTrans Toolbar, this will allow you to extract Product BOM data from Sage Line 50. You can also add filtering criteria in row 2.

Import BOM for Sage 200

Amending BOM Data

Having extracted data, the user can now simply edit the Sage Product Bill of Materials data in Microsoft Excel, before re-importing it back to Sage 50. Note only changed records will be updated in Sage.

Importing Bill of Materials Data

Simply add new lines to the spreadsheet from row 4 on-wards. Then press Import button, on the PostTrans Toolbar, to import new Sage Product BOM records.

Filter

The customer data can be extracted, using the Extract button, and optionally filtered. see How to filter Sage 50 extracted data.

In Cell Search

The user can search for Nominal, Price List, Department codes by entering the start of the code. Or any part of name, see Code Search for more information.

Demonstration Video

Sage Line 50 - Import Bill of Materials, and manage
	0:00	Video Introduction
	0:48	Open an Example Bill of Material Data Template
	1:30	Extract data, edit, add BOM sub components
	2:15	Searching for Sage Line 50 Products
	2:50	Import amendments
	3:30	How to find more information and Training

Download BOM Extract/Import Template

Related Example Sheets

You can easily access the example sheets by pressing Help button, on the PostTrans Toolbar to access these related examples.

	Product Records	Allow Extract/Amend/Import of Product records More info Product records Import
	Bill of Materials (Pro Version)	Extract, Add and Amend Bill of Material More info Bill of Material Update

Product BOM Extract/Amend/Update Template

This PostTrans function allows the user to easily extract, amend, and import Sage 50 Product BOM (Bill of Materials) data.

The cell A1 has a tag “Sage50prodBOM” to designate the type of import. It uses a series of tags, placed in row 1, to identify the data to be processed.

These tags, listed in table below, can be easily added to a spreadsheet using the Tags button. See Training for an explanation of this.

Price List Required fields

To Import/Extract/Amend Exchequer Enterprise Product BOM Data, the following Tags/Fields must be specified:

Sage50priceListsupp, PsErrorDesc, PsSupplier, PsProductCode, etc... see table below

Cell A1 must equal “Sage50priceListsupp”

PbParentCode is used to detect end of spreadsheet. PostTrans will stop Importing/Amending, from row 4 on-wards, when this field is empty.

Restrictions

Sheet must be sorted by PbParentCode before importation. PostTrans does this automatically.

Tags for Product Bill Of Material Records (PRO Version)

.

See Online Training for Static templates for a full explanation of tags, and how PostTrans reads them to define the Extract/Import template.

Tag Name	Data Type	Description
Important Fields:
Sage50prodBOM	Text Req	Returns `POSTED` if Trans line has been posted and will be ignored if `POSTED` (required). Also reports errors/warnings in data row
PbCRC	Text Req	Contains CRC number to help PostTrans detect changes in current row.
PbDelete	Text 1	This cell is very important, as it allows PostTrans to let you know of any errors or warnings while importing. If data is extracted out of the system, then it will contain a number. This number is calculated so PostTrans can work out if you have changed
PbSearch^	Text 30	Search for BOM record by entering code or pasting list, at top of column, and pressing `Extract` button In Cell Searching values in table PRODCODE_BOM
Bill of Material:
PbParentCode^	Text 30 EOF Req	Stock Code of BOM In Cell Searching values in table ProdCode
PbBOMcode^	Text 30 Req	BOM sub component code In Cell Searching values in table ProdCode
PbBOMqty^	Double Req	BOM sub component qty. 0 will ignore/delete item Changes in this cell will recalc other cells. Delete ^ to disable this calculation.
PbIsBOM	Text 30 Req Read	Y if Sub-BOM. Included to help identify sub components easily
PbLinkLvl	Integer Read	Link Level - How many times this stock item has been used in BOMs
PbAssLvl	Integer Read	Assembly Level - The number of levels of components and sub-assemblies below the product assembly. PostTrans sets this to 1 on when adding subcomponents
Lookup Other Values:
PrCost	Currency Read	Cost of Item (Qty * Cost)

Req = Field is required EOF = End of file, Stop when no more values

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a In Cell Code Search, delete ^ at end of tag, to turn off code search

All Text fields are trimmed (spaces before) by default. Add ' to the end of the tag name to stop this.

	Filter Extracted Data	Training on Static Data	Bill of Materials
	Product	Expand BOM on Order