QuickBooks Inventory Management Software | Acctivate

QuickBooks Inventory Management Software

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

Inventory Receipt for Lot Numbers Split/Product Break Down

Typically, an Inventory Receipt is utilized to receive product listed on a purchase order. However, there are times when using a standalone inventory receipt transaction is necessary.
IN THIS ARTICLE
 •  Split Single Lot Number into Multiple Lot Numbers
 •  Break Down a Product to Add Quantity to Other Items

When using the inventory receipt transaction to do things like splitting lot numbers or breaking down one product to create others, make sure to print the session prior to posting to ensure the total value of the session is $0. If not, let your accountant know they need to create a general journal to move the balance out of your purchases account into some other adjustment type account.

Split Single Lot Number into Multiple Lot Numbers via Inventory Receipt

Inventory Receipt transaction to split lot numbers.

  1. Select Inventory menu > Receipts to open the Inventory Receipts window.
  2. Click New to create a new session.
  3. Select the proper Warehouse record for this transaction.
  4. Fill in any optional header information, such as Reference, Receiving Document, or Description.
  5. Add the lot numbered product to be split up by typing the product ID and pressing tab or selecting from the lookup.
  6. Specify the quantity to be removed by entering a negative Received qty.
  7. Verify the Unit Cost of the lot number being removed to make sure it’s an exact match.
    1. If listed in a bin, enter the Location you are removing the lot number from.
  8. Type the lot number to be removed in the Lot / Serial number field just below the product description. Make sure this is the same lot number originally created.
  9. Add the same product to the session to add new lot numbers to it.
  10. Specify the quantity to be added by entering a positive Received qty.
  11. Verify the Unit Cost matches the unit cost of what’s being removed. If not adding the full qty to the new lot number, make sure the Amount matches the amount from the one being removed.
    1. If using bin locations, enter the Location the new lot will be stocked in.
  12. Type the new lot number to be added to the product, as well as Expiration Date, Reference or Specification when needed.
  13. When adding multiple new lots to the product, continue doing steps 8-11 until all new lots are added.
  14. Save the session.
  15. Print the Inventory Receipt register to verify the session amount nets at $0.
  16. Post when ready. This will remove the original lot qty and add new lots to the product.

Break One Product Down to Add Quantity to Other Items via Inventory Receipt

Inventory Receipt transaction to break down product to create others.

  1. Follow the same steps as above through step 4.
  2. Add the product being removed from stock by typing the product ID and pressing tab or selecting from the lookup.
  3. Specify the quantity to be removed by entering a negative Received qty.
  4. Verify the Unit Cost of the product being removed to make sure it’s an exact match of the current unit cost.
    1. If listed in a bin, enter the Location you are removing the lot number from.
    2. If product is a lot/serial numbered item, type the lot/serial number being removed into the Lot / Serial number field just below the product description.
  5. Add the product(s) being added to stock to the transaction. If these products are stocked in a different warehouse than the one being removed, Save the session and click + Add Transaction to add the other warehouse details. Do this as many times as needed when breaking a product down into multiple warehouses.
  6. Specify the quantity to be added by entering a positive Received qty.
  7. Verify the Unit Cost or Amount matches the unit cost or amount of what’s being removed. When adding multiple products to stock, you’ll need to manually calculate the allocation of the unit cost across these items.
    1. If using bin locations, enter the Location the new lot will be stocked in.
    2. If product is a lot/serial numbered item, type the lot/serial number being added into the Lot / Serial number field just below the product description.
  8. When breaking down into multiple products, continue doing steps 5-7 until all products being added to stock are listed.
  9. Save the session.
  10. Print the Inventory Receipt register to verify the session amount nets at $0.
  11. Post when ready. This will remove the product being broken down and adds the products created by this process.

Next Steps

Previous Training Topic

Previous Topic:
Mobile Receiving 

Customer Training

Training:
Customer 

Inventory Transactions Training

Training:
Sales 

Next Training Topic

Next Topic:
Inventory Adjustment 

 •  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