- EBMS Knowledge Base
- Inventory
- Components (BOM) and Accessories | Component Formula Tool
-
Client Resources
-
EBMS Main Documentation
- Introduction
- Getting Started
- Getting Started | Initial Installation
- Getting Started | Company Setup
- Quick User Guide | Financial Staff | Accountant
- Quick User Guide | Financial Staff | Accountant | Accountants Journal
- Quick User Guide | Sales Staff
- Quick User Guide | General Staff
- Features
- Reports
- Reports | Excel Add-In
- Reports | Excel Add-In | Troubleshooting
- Security
- Server Manager
- Technical
- Technical | Data Import and Export Utility
- Technical | SQL Mirror
- Automotive
- Automotive | Parts Catalog
- Automotive | Pricing
- Automotive | Point of Sale
- Automotive | Product Application
- Automotive | Keystone Interface
- Metal Supply
- Fuel Sales
- Horticulture
- Horticulture | Farm Setup
- Horticulture | Processing Payroll
- Horticulture | Managing the Farm
-
Sales
- Introduction
- Customers
- Customers | Miscellaneous Customers
- Proposals
- Proposals | Processing Proposals
- Proposals | Sets and Templates
- MyProposals
- MyOrders
- Sales Orders
- Invoices
- Materials Lists
- Sales and Use Tax
- Sales and Use Tax | TaxJar
- CRM
- CRM | Auto Send
- Recurring Billing
- Credits
- Customer Payments
- Payment Card Processing
- Payment Card Processing | Gift Cards
- Payment Card Processing | Loyalty Cards
- Payment Card Processing | Verifone Gateway
- Freight and Shipping Tools
- General Ledger Transactions
- Point of Sale
- Point of Sale | Point of Sale Hardware
- Point of Sale | Xpress POS System
- Point of Sale | Advanced Tools
- Signature Capture
- Salesperson Commissions
-
Inventory
- Product Catalog
- Product Catalog | Using Product Codes for No Count Items
- Product Pricing
- Product Pricing | Special Pricing
- Tracking Counts
- Unit of Measure
- Purchasing
- Special Orders and Drop Shipped Items
- Receiving Product
- Barcodes
- MyInventory and Scanner
- Components (BOM) and Accessories
- Components (BOM) and Accessories | Component Formula Tool
- Made-to-Order Kitting
- Configure-to-Order Kitting
- Multiple Inventory Locations
- Multiple Inventory Locations | Creating Locations
- Multiple Inventory Locations | Using Multiple Locations
- Multiple Inventory Locations | Product Catalog Sync
- Multi-Vendor Catalog
- Serialized Items
- Serialized Items | Purchasing or Manufacturing an Item
- Serialized Items | Selling and/or Associating an item with a customer
- Lots
- Product Attributes
- Product Attributes | Selling and Purchasing Items with Attributes
- Product Attributes | Custom Attributes
- Mobile Scanner (Legacy)
-
Labor
- Getting Started
- Workers
- Taxes and Deductions
- Work Codes
- Time and Attendance
- Time and Attendance | Time Track App
- Processing Payroll
- Closing the Payroll Year
- Processing Payroll - Advanced
- Salaried Pay
- Piecework Pay
- Direct Deposit
- 3rd Party Payroll Service
- Subcontract Workers
- Flag Pay
- Prevailing Wages
- MyDispatch
- MyTasks
- MyTime
- MyTime | Communications
- MyTime | Setup
- Tasks
- Tasks | Getting Started
- Tasks | Creating Tasks
- Tasks | Scheduling Tasks
- Tasks | Customizing Task Views
- Tasks | Managing Tasks
-
Financials
- Introduction
- Fiscal Year
- Chart of Accounts
- Budget
- Financial Reporting
- Transactions and Journals
- Transactions and Journals | Journals
- Account Reconciliation
- 1099
- Departments and Profit Centers
- Fund Accounts
- Bank Accounts
- Bank Feed
- Vendors
- Vendors | Miscellaneous Vendors
- Purchase Orders
- Expense Invoices
- Vendor Payments
- AP Transactions
- Landed Cost
- Fixed Assets and Depreciation
- Fixed Assets and Depreciation | Fixed Assets
- Fixed Assets and Depreciation | Fixed Assets | Adding Assets
- Fixed Assets and Depreciation | Processing Depreciation
- Fixed Assets and Depreciation | Disposing Assets
- MyJobs
-
E-commerce
-
Rental
-
Job Costing
-
Manufacturing
Inventory Settings
Complete the steps within this section to set up defaults for a finished good item with components calculated by formulas. Set up component formulas before continuing with this step. Review the Formula Setup section for details.
Open an inventory item that contains component formulas (also labeled Parts Calculate) and select the Parts Calculate tab as shown below:
-
Enter the Waste Multiplier value in a decimal format. This value will increase the inventory consumed to account for waste. For example, a waste multiplier of 0.1 adds 10% to the materials list quantity.
This setting is for items used as components on materials lists, not for finished goods. The remaining settings are for finished goods. -
Enter the Default Width/ Default Height/ 3rd Dimension settings. The dimension fields within a sales order or proposal will pre-populate with this information.
-
Enable the Item Number on Invoice Detail option to populate the Line Number field on a components lists containing this item with the parent item's inventory ID, plus the next line number.
-
Enable the Replace Key Words in Item Detail option to replace a variable referred to by wrapping it in {curly braces} in an item's description with the value. For example, {Width} in an item's description would replace it with the value of the WIDTH variable in that component list line. Review the following Variable Options list for additional variables.
-
Items by Size defines a placeholder item to go onto the component list. This item will be replaced by another item if its dimensions match the settings below.
-
Enter the Custom Item inventory ID of the placeholder item. This needs to be specified on both the custom item and the items that can replace it.
-
Enter the Width/ Height/ Dimension entries the custom item will replace, if one or more of its dimensions match the custom item's calculated dimensions.
-
Enable the Random Width/ Random Height/ Random Dimension option to ignore this dimension when matching.
Setting default dimensions for an item that are used within the formulas.
Variable Options
Standard Variables
-
{DEM} db.field("Dem")
-
{DEMD} db.field("Demd")
-
{WIDTH} db.field("width")
-
{WIDTHD} db.field("WidthD")
-
{HEIGHT} db.field("Height")
-
{HEIGHTD} db.field("HeightD")
-
{Dem} db.field("Dem")
-
{Demd} db.field("Demd")
-
{Width} db.field("width")
-
{Widthd} db.field("WidthD")
-
{Height} db.field("Height")
-
{Heightd} db.field("HeightD")
-
{Comment} db.field("Comment")
-
{COMMENT}db.field("Comment")
INCI Feet Inches Variables
-
{Feet} db.field("Feet")
-
{FEET} db.field("Feet")
-
{Inches} db.field("Inches")
-
{INCHES} db.field("Inches")
-
{Inchesd} db.field("Inchesd")
-
{INCHESD} db.field("Inchesd")
Metal Advanced Color Variables
-
{Color} - db.field("Color");
-
{COLOR} - db.field("Color")