ERPAG | Manual 2021
  • ERPAG Manual | MRP System for Small Business
  • ERPAG Introduction
    • ERPAG list functionality explanation
    • Create ERPAG Account
      • Oath 2.0
    • Setting up your company
      • General info
      • Database Settings
      • Localization
        • Language Set Up
      • Taxes
      • Users
      • Warehouses
        • Shelves
    • Document templates
      • Document/Product number setup
      • Default document settings
      • Notes: Templates
      • Custom Fields
    • Label templates
      • Label print layouts
    • How to setup ERPAG Cloud print app
      • Connecting Label Printers
    • Customers
      • Basic definition
      • Importing Customers
      • Price tiers
      • Terms of payment
      • Categories
    • Suppliers
      • Basic definition
        • Suppliers price list
    • Mail accounts
    • User activity
    • Widgets
    • Archive documents
  • Inventory
    • Inventory - introduction
    • Beginning inventory quantity
    • Products and services
      • On hand, reserved, committed and awaiting quantity
      • Basic definition
        • Product properties
          • Lot numbers
          • Variable product
        • Quantity below minimum
        • Minimum purchase quantity
          • Search scope / Where used / Set inactive
          • Transfer - Fulfillment
          • Second Unit of Measure (UOM)
          • Serial numbers
          • QR Code patterns
          • Inventory/Stock list
      • Types
        • Kit
        • Consumption products
        • BOM
      • Customer return
      • Serial and LOT numbers
      • Multiple Suppliers
    • Send inventory
    • Move inventory
    • Count Inventory
      • Stocktakings
      • Stock Adjustment
      • Stock card
  • Sales
    • Import Sales Order
    • PreSales
      • Define stages
      • Quotations
      • Reccuring orders
    • Sales report
    • Sales orders
    • Open Sales Orders
    • Outstanding pay-ins
    • Sales - Invoices report
    • Sales - Packing lists
    • Sales - Credit notes
    • Customer return
    • B2B portal (Customer portal)
    • Multiple currency
    • Discount field
    • Advance payment
    • Write-off
  • Purchasing
    • Purchase orders
    • Receive inventory items
    • Return to supplier
    • Suppliers SKU
    • Landed cost
    • Utility Bills
    • Outstanding pay-outs
    • Purchase report
    • Purchase by price
    • Supplier credit notes
    • Open purchase orders
    • Tier quantity
    • Price per quantity
    • Fulfillment flow
  • Manufacturing
    • Employees
    • Machines
    • Job titles
    • Time recording
    • Contracting
    • Manufacturing - Fulfillment
    • Standard Work Order
      • BOM based Work Order
      • Contracting Work Order
    • Work Orders - Convert to standard
    • Manufacturing project
      • Manufacturing project - Basics
    • Service Project
  • Accounting and finance
    • Opening Balance
    • Bank Accounts
    • Setting up US Sales Tax
  • Dropshipping
  • Mobile app
    • General
      • How to install
      • Basic Interface
    • Products
      • Item Look-up
    • Inventory
      • Receive
      • Pack
      • Ship
    • Manufacturing
      • Time Sheets
      • Load materials
      • Product Receipt
    • Other
      • Inventory checking
      • Transfer order picking
  • Integration
    • QuickBooks
    • Shopify
    • Woo Commerce
    • Square
    • Stripe
    • Postmen - shipping service
    • Google
  • Event dashboard
    • Download documents
  • POS - New Receipt
    • Vouchers
    • POS - Z report (closing the day)
    • POS - Payment report, Items sold report
    • POS - Backorder (Fulfillment)
    • POS - Managing and printing the receipt
  • Reporting
    • Chart - Categories and Trademarks
    • Reserved items
    • Chart - Stock by products
    • Chart - Stock by day
    • Chart - Sales by partners
    • Chart - Purchasing by time
    • Chart - Purchasing by products
    • Chart - Sales by a product
    • Chart - Sales by time parameters
    • Chart - Sales by categories
    • Serial/lot number report
    • Chart - Stock by time
  • Importing
    • Import - Work Operations
    • Import - BOM (Bill Of Materials)
Powered by GitBook
On this page
  1. Importing

Import - BOM (Bill Of Materials)

PreviousImport - Work Operations

Last updated 6 years ago

In case you have the Bill of Materials in an xls spreadhseet, you can easily import it in ERPAG.

If you have the finished product and parts (materials) entered in ERPAG, make sure that the SKUs and descriptions match exactly both in the system and in your xls, otherwise the system might double them. If you don't have parts and/or finished product entered in the system, they will be automatically added with the import.

You can download the template for the BOM import from the import window.

Inventory > products and services > import > bill of materials

When you get a window for importing the BOM, click on the more button and 'export to xls' in order to export the blank template to your computer.

You will get an empty xls spreadsheet with neccessary columns for import. You can either just add the captions of the columns to your xls, or copy/paste the information to the downloaded one.

The populated xls spreadsheet for importing should look like this:

Make sure that you have the captions of the column entered, otherwise the system will skip the first row when you copy/paste the information to ERPAG.

Just copy entire colmn from your xls, along with the caption of the column and empty rows (don't worry about those, they won't be imported).

And paste it to a matching column in ERPAG.

Do this for all columns. The finished table should look just like your xls spreadsheet.

From here, just save the document and the system will import the product, along with its bill of materials.

The imported products (the finished product and materials) will automatically appear in your list of products and services as well (unless you already had them entered before importing).