Paradigm Support Desk

Importing BOMs into Paradigm

Create An Import

Bill Of Material Imports allows you to generate multiple BOMs within Paradigm from a spreadsheet template.
You can find 'Bill Of Material Imports' under the 'Data Imports' navigation menu item.

You can create a new 'Bill Of Material Import' by clicking the 'Add New Bill Of Material' button found at the top-left of the screen.

Select your 'Company'. The 'Document Status' will then default to 'In Progress'.

On the 'Import Details' pane, you can select 'Auto Generate Code'. This will generate a BOM code using the Paradigm naming scheme. Automatically generated BOM codes will apply to each unique finished good found in the import data. If you are importing multiple BOMs for the same finished good item, then you will have to manually input the BOM code on the spreadsheet template.

Setting Up Your Data Import File

You now need to attach your data import spreadsheet to your 'Bill Of Material Import' in Paradigm, the following steps will cover how to setup your import file.

Here is an example of a completed Data Import Template for Bill Of Materials.

You can download an empty template here at the bottom of this article.

Note : Do not format any of the cells on the template as Paradigm is designed to read this specific setup, only the data input is required.

The template's fields are as follows :

'BOM Code' : This code is used to identify a BOM, you can leave this field blank if you wish to use the 'Auto Generate Code' feature.

'FG Code' : This is the inventory code of the finished good item that is to be produced from this BOM.

'FG Unit Of Measure Code' : The code assigned to the relevant unit of measure used for the finished good item provided in the 'FG Code' column.

'RM Code' : This will be the Inventory Code of the Raw Material/Consumable item that is to be used up during production when creating the Finished Good item.

'Warehouse Code' : This is the Code assigned to the Warehouse from which the Raw Material/Consumable item is to be taken from when processing production.

'Unit Of Measure Code' : The code assigned to the Unit Of Measure used for the Raw Material/Consumable item.

'Wastage Percent' : This defines the amount of wastage of a Raw Material/Consumable item when processing production. In the above example, a 10% wastage is set for Raw Material Item COA001. This is to say there is a 0.51Kgs of wasted COA001 for each FLA003 produced.

'Qty' : This is the amount of the Raw Material/Consumable item required to produce the Finished Good Item.

'Is Auto Issue' : If a BOM line is set to Auto-Issue, it will automatically issue the quantity from the BOM onto the Production Ticket.

'Is Fixed' : If 'Is Fixed' is set, then the quantity to be issued must match the quantity on the BOM.

'ServiceItemCost' : This is an additional cost in the use of a Consumable/Raw Material Item when processing production.

Once you have filled in all the required data, you must now save the spreadsheet as a (Comma delimited) CSV file.

In Excel, click 'File' > 'Save As'.

In the file type drop down menu underneath the file name, select 'CSV (Comma delimited) (*.csv)'.

Generating BOMs from Your Import Data

Attach the CSV file to the 'Data Import' in Paradigm. You can drag and drop the file onto the open pane on the 'Data Import' screen. Alternatively, you can use the 'Add From File' button.

This button will allow you to browse your local files and select the file you wish to attach.

Once you have successfully attached the CSV file, click the 'Import Data from CSV Attachment' button.

This will populate the 'BOM Import Data' tab with the lines from the imported file.

If there are any validation errors or amendments that need to be made, you will have to amend the data on the spreadsheet template and then re-import the data. Start by clicking the 'Reset Data Import' button.

This will clear the 'BOM Import Data' tab.

Navigate to the 'CSV attachment' tab and click the 'Unlink' button.

This will remove the attached file. You can now amend your data in the Excel spreadsheet and then re-attach as a CSV file and re-import the data.

Click the 'Approve Data Import' button.

This will set the 'Approval Status' to 'Approved' and set the 'Date Approve' to the current day.

Once the data import has been Approved, the 'Process Data Import' button will enable.

You will now be able to view the newly generated BOMs under 'Production' > 'Maintenance' > 'Bill Of Material'.

Paradigm is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.