QuickBooks Inventory Management Software | Acctivate

QuickBooks Inventory Management Software

  • Home
  • Solutions
  • Explore
  • Support
  • Contact
  • Schedule Demo
  • Onboarding
  • Training
  • Downloads
  • Documentation
  • Knowledge Base
 

Create or Edit Existing Sales Order Import Template

Acctivate offers a built-in utility which allows users to import sales orders from text files (like Excel spreadsheets) or an Access database. The sales order import utility is designed to dramatically speed up the process of creating orders in Acctivate which were originally placed outside of Acctivate.

This page covers creation of a new or modifying an existing import using a text file source. We recommend using a CSV file type but there are other flat file options. This process most commonly uses one file but can have up to three source files. You can download templates from this zip file to see the difference between using one or multiple source files to create orders. View a full list of fields available for this import here.

If a template is already setup, check out this training page Import Sales Quotes and Orders for instructions on daily use. Go here for steps on how to sync webstore orders or process EDI transactions.

Create or edit existing sales order import

Create New or Edit Existing Sales Order Template

  1. File > Import Sales Orders or click Import Orders icon from the icon bar.
  2. Click Create or select the Template to modify > Edit.
  3. Select the correct Source File(s).
    • For flat files, choose Type of Text and how it should be parsed. The most common option is delimited. CSV files use a comma while some TXT files use tab as a delimiter.
    • Toggle the option for 1st Row Field Names option based on whether your file has column headers in the top row. If no column headers, each column will be assigned a number starting at 0 for column A, 1 for column B, etc. It’s good practice to open a copy of the file used for import to add a header row of numbers to make the mapping process easier. You’ll see this in the preview window in step 5 when option not checked.
    • When using multiple files, make sure to include Order Number on each row within the files to relate the details back to the proper record. Column headers need to be unique in each file, therefore distinguish the order number column header in some way (order number details, order number header, etc.). Make sure no other duplicate headers exist before import.
  4. Click Next to and choose Options for import.
  5. The Preview window shows the information in the file, as well as the user the ability to modify data on the fly before import.
  6. Click Next
    • When using multiple source files, the Relationships window is the next step. This is where you specify which columns in the sheets tie the data together. Typically, you’ll have order number on each row in both files to relate the details to the header information. After relating the proper columns in each file, click Next.Relationship between files for multiple source files in import
  7. The Mapping window opens next which allows you to select the columns to be imported into Acctivate fields. Expand each section to map all necessary data for your import.
    • Order Detail: Product details for the sales quote or order. Typically, the mapped fields are product ID, quantity ordered, and price. Feel free to use any available data point, including custom fields setup on the order detail lines in Acctivate.
    • Order Detail Lot/Serial: Assign lot or serial numbers to the products listed on the sales order. Make sure the product ID and sales order number is on each row showing a new lot/serial number. Only map fields here when needing to assign a lot or serial number.
    • Order Header: Set the order number, order date, shipping address, customer, and any other header fields available for import. When needing to distinguish between quote and order, set the Order Status and Order Type as a default or mapped to field(s) in the file.
  8. For each Acctivate field you’re importing into, click in the Mapped field column to select the appropriate column. Use the Default Value to assign a value for all orders when there is no value in the column or in the sheet at all. Users can also setup data conversions on each mapped field to convert a value like “Ready to Fulfill” to “Scheduled” as the order status by clicking in the appropriate field and choosing Show Conversions. In the screen shot below, I mapped Quantity Ordered in Acctivate to the column named Product Quantity in the file. All of these orders flow through one warehouse so the Warehouse is set to default to the F warehouse in Acctivate.
    Map fields for importing
  9. Once all necessary fields are mapped, click Next. If you wish to close and save without importing, click Cancel and then Yes to saving import template.
  10. If option to provide confirmation before importing sales orders is checked, click Validate Orders. Otherwise, select Import Orders.
    • Validate Orders adds a step to the import where the data is validated prior to import. The user will be shown any warnings or errors found to resolve before completing the process. Once validated, click Next to be able to Complete Import.
  11. Import Complete will show on screen when finished with the list of orders created. Any unresolved warnings or errors will be listed to review.
  12. Close when done.

Sales Order Import Complete


Next Steps

Previous Training Topic

Previous Topic:
Catch Weight Pricing on Quotes & Orders 

Purchasing Training

Training:
Purchasing 

Customer Training

Training:
Customers 

Next Training Topic

Next Topic:
Pick Ticket 

 •  Overview

General

 •  Getting Started

 •  Windows & Features

 •  Create & Modify Filters on Lists

 •  Synchronize with QuickBooks

Business Activities

 •  Activities List

 •  Relate Activities to Documents & Transactions

 •  Business Activity Review

 •  Overview

Product Basics

 •  Product List

 •  Create a New Product

 •  Product Prices

Product Management

 •  Import Products

 •  Manage Product Components

 •  Manage Alternate Units of Measure on Products

 •  Setup Catch Weight/Variable Pricing

 •  Overview

Purchasing Basics

 •  Purchasing List

 •  Purchase Order Statuses

 •  Vendors List

Create a Purchase Order

 •  Create a PO Manually

 •  Reorder Inventory Based on Demand

Receive & Invoice a Purchase Order

 •  Purchase Order Receipt

 •  Purchase Invoice

 •  Allocate Other Amounts on Vendor Bill via Landed Cost

Additional Processes

 •  Vendor Returns

 •  Purchase with Catch Weights

 •  Overview

Sales Basics

 •  Sales List

 •  Customer Price Check Utility

Quotes

 •  Create a Sales Quote

 •  Print & Email a Quote

 •  Manage Quotes

 •  Convert Quote to Order

Order Entry

 •  Create a Sales Order

 •  Import Online Orders via Webstore Sync

 •  Import Sales Quotes & Orders

 •  Mobile Order Entry

Order Processing Basics

 •  Approve Credit Holds

 •  Send Order Acknowledgment

 •  Rescheduling Sales Orders

 •  Kitting on Sales Orders

Service Orders

 •  Add Time & Materials to Business Activities

 •  Create Service Orders

 •  Service Scheduling

 •  Service Billing

Advanced Order Processing

 •  Drop Shipments

 •  Special Orders

 •  Process EDI Transactions

 •  Catch Weight Pricing on Sales Quotes & Orders

 •  Create/Edit Existing Sales Order Import Template

Order Picking

 •  Pick Ticket

 •  Create a Pick List

 •  Select Bin Locations on Orders

 •  Select Lot or Serial Numbers on Orders

 •  Mobile Order Picking

 •  Mobile Pick Lists

Order Packaging

 •  Packing Slips

 •  Packaging Management

 •  Create a Shipment in Packaging Manager

 •  Packaging Shipment in Packaging Manager

Order Shipping

 •  Process Shipments via Shipping Workstation Integration

 •  Shipping with Packaging Manager

Payment Entry

 •  Enter Customer Payments

Order Invoicing

 •  Create Invoices from a Sales Order

 •  Batch Invoices

Credit Memos

 •  Create a Credit Memo

 •  Invoice a Credit Memo

 •  Overview

Edit Customer Window Overview

 •  Update Basic Customer Information

 •  Manage Customer Ship To Locations

 •  Customer Contact Management

 •  Customer Credit Specifications

 •  Product Invoice History for Customer

 •  Customer Orders

 •  Customer Specific Product IDs

 •  Invoice & Payment History for Customer

 •  Sales History, Marketing Information & Webstore Customer ID

 •  Emails Sent from Customer Window

 •  Customer Pricing Rules

 •  Business Activities Related to Customer

Customer List & Credit Management

 •  Customer List

 •  Credit & Collection Features

Create Customers

 •  Create New Customer Manually

 •  Import Customers

 •  Create Customer Jobs

 •  Overview

Receipts

 •  Purchase Order Receipt

 •  Mobile Receiving

 •  Inventory Receipt for Lot Number Split/Product Breakdown

Adjustments

 •  Inventory Adjustment

 •  Inventory Balance Adjustment

 •  Inventory Issue

 •  Inventory Count

 •  Mobile Inventory Counts

Transfers

 •  Inventory Transfer

 •  Mobile Inventory Transfers

Assemblies

 •  Inventory Assembly

 •  Mobile Inventory Assemblies

 •  Assembly Workflow Status Configuration

Landed Cost

 •  Vendor Bill Allocation to Inventory Cost

Track & Trace

 •  Track & Trace Inventory Movement for Lot/Serial Items

Void Transactions

 •  Void Inventory Sessions

 

Company

  • About Acctivate
  • Branding
  • Privacy & disclaimers
  • Careers
  • Contact us

Community

  • Technology partners
  • Referral program
  • Partner directory
  • Partner program
  • Partner resources
  • Inventory glossary
  • Blog

Features

  • Barcoding software
  • Bill of materials (BOM), Kitting & Assemblies
  • Tracking inventory task activity
  • Catch weight management
  • Credit management
  • Customer management
  • eCommerce inventory management
  • EDI management software
  • Hosted inventory management
  • Import export software
  • Inventory dashboard
  • Inventory forecasting
  • Landed cost
  • Manufacturing
  • Matrix inventory
  • Multi-channel inventory management
  • Multi currency
  • Order fulfillment
  • Order management
  • Pricing tools
  • Process manufacturing
  • Purchasing management
  • Reporting
  • Retail counter sales
  • Service and repair management software
  • Traceability
  • Wholesale distribution

How to buy

  • Learn Acctivate
  • Acctivate Benefits
  • Inventory Module Features
  • Acctivate Onboarding
  • System requirements
  • Free Trial
Connect with us
Acctivate on Facebook Acctivate on Instagram Acctivate on Linkedin Acctivate on Twitter Acctivate on YouTube

© 2023 Alterity, Inc. All rights reserved. ACCTivate! is a registered trademark of Alterity, Inc., registered in the U.S.
Privacy & Disclaimers