QuickBooks Inventory Management Software | Acctivate

QuickBooks Inventory Management Software

  • Home
  • Solutions
  • Explore
  • Support
  • Contact
  • Free Trial
  • Onboarding
  • Training
  • Downloads
  • Documentation
  • Knowledge Base
 

Customer Product IDs

Any customer can have a customer product ID assigned to any product in the system. These are added to the individual customers which need them on the Edit Customer window > Product IDs.
IN THIS ARTICLE
 •  Assign Product IDs/Descriptions
 •  Find Product IDs

This tab allows products in the system to be assigned customer product IDs and descriptions. For each Acctivate Product ID and Description, users can enter a customer specific Product ID and customer specific Description.

Once added, users can do things like add products to orders by entering or looking up products by the customer ID and setup translations for EDI or webstore integrations. You’ll be able to manage not only your internal product IDs, but also the customer product IDs. This enables you to keep your product list down to a minimum with all related history on one record.

Assigning Customer Product IDs and Descriptions on Edit Customer Window

  1. Navigate to the Edit Customer window.
  2. Select the appropriate customer by using the Lookup button next to the Customer Name field or manually enter the name in that field and press the Tab key.
  3. Select the Product IDs tab.
  4. Click Edit.
  5. Place cursor in Product ID field.
  6. Click the Lookup button that appears and from the Product Lookup window select the product ID that you wish to assign a customer ID. The Description will automatically populate based on the existing information in the system for that product.
  7. In the Customer Product ID field enter the ID the customer wants to use for that product and enter their product description in the Customer Description field (optional).
  8. You can also enter a note (optional) in the Note field. Click the Browse button within this field to type inside a larger text box.

Acctivate also has the capability to import this customer product ID list from a file. This is done via the Import Data utility in the File menu. The required fields are customer ID (name), internal product ID, and customer product ID. Each field would have its own column in the spreadsheet. For a full list of fields, check out this article.

Customer product IDs assigned to any product in Acctivate for any customer

Using the Product Lookup window to find customer product IDs

After you have assigned a customer’s product ID, you can look it up in the system by that ID rather than by your Product ID. Product Lookup windows are initiated from product Lookup buttons found on various windows (i.e. the Sales Order and Purchase Order windows > Details tab > inside the Product ID field, Product List, and the Edit Product window) throughout the system.

  1. Click a product Lookup button to open the Find Product (Product Lookup)
  2. In the first top left-hand drop down menu, select Customer Product ID.
  3. If you are entering a Sales Order only the Product IDs specific to the customer selected on the sales order will display, but if you are in a window not customer specific (i.e. the Product Information window) all products with customer product IDs will display. You can then use any of the other filtering options available in the Lookup window to find the product you need.

Note: When you select the customer product ID from the Lookup window, it will display in the main window (i.e. the Sales Order or Product Information window) by your product ID, not the customer’s product ID.


Next Steps

Previous Training Topic

Previous Topic:
Customer Orders 

Sales Training

Training:
Sales 

Inventory Transactions Training

Training:
Transactions 

Next Training Topic

Next Topic:
Invoice & Payment History for Customer 

 •  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

Create a Purchase Order

 •  Create a PO Manually

 •  Reorder Inventory Based on Demand

 •  Purchase Order Statuses

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

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