Accounts Payable

• AP beginning balances entry for system startup
• Supplier terms table
• Supplier invoice entry
• PO invoice matching
• Invoice reversal
• Supplier default account
• Multiple account distribution
• Instant payment for manual checks
• Recurring supplier invoices
• Tax tracking from invoice through payment
• Check, manual, and file transfer payment types
• Supplier payment processing
• Automatic discounts within supplier terms
• Customizable check print format
• Payment register
• Void payment
• Supplier aging inquiry
• Payments due report
• Detail, summary, past due aging reports
• 1099 tax form

↑ Back

Accounts Receivable

• AR beginning balances entry for system startup
• Customer terms table
• Multiple bank accounts
• Customer payment processing
• Early payment discount processing
• Credit memos
• Tax tracking from invoice through payment
• Payment reversal
• Customer deposits for prepayment on custom jobs
• Deposit amount itemized on invoice footer
• Automatic application of deposits to invoices
• Bank deposit slips
• Customer statements
• Customer aging inquiry
• Detail, summary, past due aging reports

↑ Back

Activity Notes

• User-defined note types and analysis codes
• Notes attach to jobs, customers, suppliers, items, and descriptors
• Action date for follow-up
• Can be used to track engineering changes and collections
• Action report lists open and closed notes
• Each user's My Action List screen displays open activity notes

↑ Back

Administration

• User setup and password security
• Current online user monitoring
• Database optimizer utility
• License key installation
• Main setup screen
• System default settings

↑ Back

Banking

• Multiple bank accounts
• Customizable check print formats by bank account
• Bank deposit slips
• Bank account transfer
• Bank account reconciliation
• Bank charges entry
• Interest income entry
• Bank balances inquiry

↑ Back

Bills of Material

• Jobs optionally originate from BOM's and can then be edited
• BOM defaults screen with setup options
• Product structure includes up to 99 levels
• Phantom assemblies
• Multiple revisions
• Routing entry for labor, setup, subcontract services
• Batch size by revision (method)
• Component effective dates
• Component scrap percentage
• Unlimited decimal places in usage quantity
• Component notes and references
• Component formula calculates quantity at time of job creation
• Multiple outputs for bi-products, co-products, disassembly, remanufacturing
• Indented, tree view inquiries
• Sales kits with pricing at parent or component level
• Cost rollup
• Where used inquiry
• Multi-level BOM report
• Costed BOM report

↑ Back

Data Import & Export

• Import directly from Excel spreadsheets
• Record integrity validation
• Customer import
• Delivery address import
• Customer contacts import
• Supplier import
• Supplier contact import
• Item import
• Item sources import
• Base prices import
• Qty price breaks import
• Bill of material import
• Routing import
• Initial stock quantities import
• Data export from any table using export wizard
• Data dictionary

↑ Back

Document Management

• User-defined document groups
• User permissions by document group
• Documents directory viewer
• Document linking to items, descriptors, customers, suppliers, jobs
• Job retrieval of linked item, descriptor, customer documents

↑ Back

Financial Transfer

• Enables DBA to be used with any outside accounting system
• DBA handles manufacturing accounting with its own general ledger and standard chart of accounts
• Your system handles receivables, payables, banking, overall general ledger, and payroll
• Customer invoices are summarized and exported from DBA to your outside accounts receivable module
• PO related supplier invoices are summarized and exported from DBA to your outside accounts payable module
• GL account debit and credit totals are exported to your outside General Ledger and are cross-referenced with your accounts
• Data transfer is done through export to Excel spreadsheets or text files used for import into your outside accounting system
• Summarized data formats make manual transfer practical for systems without data import utilities
• All data transfer is one-directional from DBA to your outside accounting system

↑ Back

Forms Customization

• Forms edit utility enables adding logos, barcodes, special fields, font changes on forms and labels
• Forms include quote, acknowledgment, packing slip, invoice, PO, customer statement, check
• Labels include item labels, shipping address labels, shipping line labels

↑ Back

General Ledger

• 12, 13, or 4-4-5 accounting periods
• Account classes and groups
• Standard chart of accounts for manufacturing company (optional)
• Old account cross-reference
• Account Assignments screen controls all system posting
• Item, customer, supplier entry does not require account assignments
• Work in process accounting with overhead absorption
• Journal entry
• Financial cutoff date for period close
• Batch posting and posting history
• GL spreadsheet generator for comparative period analysis
• Budget entry
• Journal report
• Transaction listing
• Trial balance
• Balance sheet
• Income statement

↑ Back

Help

• Online Help
• Online Support Center
• Implementation Planner
• Operating Guide
• Manufacturing Efficiency Guide
• Product Update Guide
• Web Links

↑ Back

Inventory

• User-defined item categories
• Locations can represent bins, areas, warehouses, trucks
• 30-character part number
• 60-character description
• Unlimited notes
• Unit inventory cost, last cost, estimated cost
• Base price with quantity price breaks
• Tracking by lot number, serial number, expiration date, revision, attribute
• Default issue and receipt location
• Stock class
• Weight, volume, standard pack
• Reorder level, minimum order, lead time
• Up to six user-defined fields
• Multiple suppliers and default supplier
• Supplier part number and UM conversion
• Supplier line card with manufacturers and manufacturer part numbers
• Alternate and complimentary items
• Customer part number cross-reference
• Warranty codes
• Barcode cross-reference
• Linked documents
• Non-stock descriptors for service and fee billing, miscellaneous purchases
• Job and PO receipts with pre-fill option
• Order picking and job issues with pre-fill option
• Stock adjustments
• Stock transfer
• Stock counts for physical inventories and stock takes
• Mass item price change
• Mass estimated cost update
• Change inventory cost
• Reconcile book value
• Stock status inquiry
• Where used inquiry
• Transactions inquiry
• Inventory value report
• Item labels
• Transaction history report
• Transaction history by lot and serial number
• Hand-held device interface with barcode scan (Coming)

↑ Back

Job Costing

• Work center rates for setup, labor, and overhead
• Estimated job cost rollup at job creation
• Material costed inventory cost or PO cost
• Setup and labor hours costed at work center rate or pay rate
• Overhead burden applied to labor hours at work center rate
• Subcontract services costed at PO receipt cost
• Job receipts of finished items costed at actual or estimated cost
• Estimated vs. actual cost comparison in job inquiry and job cost report

↑ Back

Job Scheduling

• Shop calendar defines workdays and holidays
• Job Days Calculator estimates Job Days based on routing cycle times and work center capacity
• Manual Job Days setting if calculator not used
• Delivery date estimator establishes required date in order entry
• MRP backward schedules jobs from required dates
• Manual job creation forward schedules jobs from start date
• Overlap scheduling of subassemblies
• Job are released to the factory in Job Control Panel screen
• Work Center Scheduling screen schedules jobs daily by critical ratio
• Machine scheduling
• Job Scheduling screen aligns existing jobs with changes to required dates
• Daily dispatch report by work center
• Master job schedule report
• Work center schedule report
• Machine schedule report
• Subcontract work center schedule report

↑ Back

Job Traveler

• Can be printed when jobs are created or released
• Print for single job or batch of jobs by start date
• Optional short form with routing summary only
• Optional barcode printing of job number and routing sequence
• Materials listed within routing sequences or at end of traveler

↑ Back

Labor Tracking

• Worker table with pay rates
• Labor tracking is independent from payroll, enabling you to use the payroll software or service of your choice
• Job labor costing at work center rate or pay rate
• Labor hours entry or backflushing based on estimated cycle times
• Real-time job tracking based on item completions by routing sequence
• Routing sequence status values = Open, Next, Started, Closed
• Daily dispatch report by work center
• Job status inquiry
• Job history inquiry
• Worker history inquiry
• Worker job hours report
• Job Clock screen with barcode scan (Coming)

↑ Back

Lot & Serial Control

• Items can be tracked by lot number, serial number, expiration date, revision, or attribute
• Lot and serial numbers originate with PO and job receipts
• Lot and serial numbers are selected in order picking and job issues
• Transaction history by lot and serial number

↑ Back

MRP

• MRP item settings include reorder level, minimum order, order multiple, lead days, job days
• Job generation directly from sales order lines for make to order items
• Job generation from net demand relative to reorder levels
• Backward scheduling from required dates
• Stock status inquiry displays all supply and demand detail
• Batch conversion of planned jobs
• Buy-for-job option for purchased to order items
• PO generation from net demand relative to reorder levels
• Consolidated PO conversion by supplier

↑ Back

Order Entry

• Customers and customer types
• Customer terms, contact types, sales regions, lead sources, ship methods
• Sales reps and commission codes
• Base prices, price levels, discount codes, contract pricing options
• Mass price update
• Sales order
• Quote conversion to sales order
• Third party billing option
• Required date at line item level
• Delivery date estimator establishes required date on make to order items
• Stock status inquiry at line item level
• Custom job output generator for custom items and repair jobs
• Tax code designation at header and line item level
• Customizable order acknowledgment
• Email acknowledgment option
• Order picking, shipping, invoicing
• Sales order inquiry
• Sales order summary and detail reports
• Open items listing report
• Available to ship report
• Base prices and costs report
• Import utility for web store or EDI orders (Coming)

↑ Back

Outsourcing

• Services such as painting, plating, heat-treating and subcontract manufacturing can be outsourced to suppliers
• Supplier and cost are specified in BOM and job routing
• Subcontract materials are included in BOM and job details unless furnished by supplier
• Buy-for-Job screen generates POs for services or subcontract manufacturing
• Subcontract materials are issued from stock to supplier
• Subcontract PO's can be delivered to another supplier
• Subcontract PO's are received and costed directly to the job
• Subcontract scrap processing
• Subcontract purchases itemized on job cost reports

↑ Back

Payroll Import

• Import employee and payroll vendor payments
• Import detail transactions or account summaries
• CheckMark Payroll® import link
• Generic import from Excel spreadsheets
• Payroll setup specifications provided in Operating Guide

↑ Back

Purchasing

• Suppliers and supplier types
• Manufacturers and manufacturer part numbers
• Purchase price table
• Default supplier and multiple suppliers and line cards by item
• Automatic PO generation by MRP and Buy-for-Job screens
• PO Scheduling screen aligns existing jobs with changes to required dates
• PO quote status for use as RFQ
• Last cost used when purchase price record doesn't exist
• Job linking
• Supplier part number and UM conversion
• Tax code designation at header and line item level
• Customizable PO form
• Email PO option
• PO receipts with pre-fill option
• Over and under receiving allowed
• Cost change at time of receipt
• Lot and serial number designation
• Goods received note
• Immediate inventory and job costing without need for invoice
• Supplier invoice entry with PO matching
• Delivery history inquiry
• Open PO listing report
• PO receipts report
• Received not invoiced report
• Purchases by item report
• Purchases by supplier report

↑ Back

Quoting

• Four customizable quote formats: Formal, Letter, Letter with Detail, and Multi-Option
• Quote price based on markup/margin over cost or standard pricing rules
• Multi-level cost rollup by run size for estimated cost calculation
• Unlimited line items and notes per quote
• Email quote option
• Quote conversion to sales order

↑ Back

RMA Processing

• RMA processing guidelines in operating guide
• Ability to set up a sales order type for RMA processing
• Editable forms provide ability to create an RMA form layout.
• Ability to return items to stock by picking a negative order quantity
• Ability to assign used and returned item categories to their own sales and cost of goods sold accounts
• Zero-value invoicing for no charge replacements
• Procedures for converting credit memos to cash refunds
• Ability to set up a job type for repair jobs
• Ability to use custom manufacturing processes for repair jobs
• Unlimited job outputs for disassembly jobs

↑ Back

Routings

• Work centers with hourly rates for setup, labor, overhead
• Machines within work centers
• Sequence templates for copy of common processes
• Task templates for copy of common sequence tasks
• Job routing can originate from BOM routing and be modified for special requirements
• Routing sequences break job into discrete operations
• Work center and machine assignment by sequence
• Setup hours
• Cycle time expressed as time/process or processes/hour
• Items/process
• Number of persons for teams or multiple jobs worked
• Days to next
• Traveler notes
• Supplier and cost on subcontract sequences
• PO notes for subcontract sequences
• Tasks provide additional breakdown within sequences for inspection or other procedures

↑ Back

Shipping & Invoicing

• Numbered shipments generated from picked sales order line items
• Ability to change delivery address by shipment
• Customizable packing list, address labels, line items labels
• Number of packs, weight, and volume calculation
• Shipping charges entry
• Shipment reversal
• Automatic invoice generation from shipments
• Customizable invoice form
• Credit memo printing
• Invoice preview
• Email invoice option
• Invoice reversal
• Batch invoice printing and posting

↑ Back

SQL Database (Included)

• Firebird™ SQL database included in package price
• Supports up to 100 or more users
• Virtually no limit number of item, customer, supplier records
• Small footprint
• No special maintenance or tuning required
• Comparable functionality to SQL Server® and Oracle®
• Database optimizer utility
• Backup manager with auto-scheduling (Coming)

↑ Back

Taxation

• Tax codes
• Tax authorities within tax codes
• Tax on tax calculation
• Tax shipping option
• Tax group matrix option for different customer-item supplier-item tax code designations
• Non-taxable option on items, descriptors, customers, suppliers
• Optional tax authority breakdown on invoice footer
• International tax reporting with purchase taxes applied to sales taxes
• USA sales tax reporting

↑ Back

Utilities

• Spreadsheet generators for inventory, invoices, jobs, job actuals, payments, purchases, sales, supplier invoices
• Database query tool with spreadsheet output
• Email option for quotes, acknowledgments, invoices, PO's with saved history
• Forms edit utility
• User-defined fields for items, customers, suppliers, jobs, PO's
• User-defined menus for custom reports or other links

↑ Back