QuickBooks Inventory Management Software | Acctivate

QuickBooks Inventory Management Software

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

Vendor Bill Allocation to Inventory Cost

Through the Landed Cost module, Acctivate allows users to create a vendor bill and allocate the cost across posted inventory transactions. Landed cost allows a user to load items from multiple transactions and enter the vendor bill information, such as invoice date, vendor name, and total amount.
IN THIS ARTICLE
 •  Review Landed Cost Sessions
 •  Create Vendor Bill via Landed Cost

Landed cost can be generated from specific Inventory Receipts, all Receipts related to a Purchase Order(s), Assemblies, and Transfers. For example, you may receive a vendor bill for freight charges for a load that needs to be allocated over multiple receipts and/or transfers of product.

Review Landed Cost Sessions

  1. Choose the Transactions list from the left navigation bar.
  2. Search for and locate the session or transaction types in question.
  3. Select session for review.
  4. Sessions saved, but not posted will show Draft on the list, as well as a watermark on the read only window for the transaction. These can be modified before posting by clicking the Edit button.
  5. Posted sessions will show more information, such as unit cost and amount allocated.

Vendor bill allocation to inventory cost: Review Landed Cost Transactions from List

Create Vendor Bill via Landed Cost

  1. Go to Inventory > Landed Cost.
  2. Click New (Ctrl+N) on toolbar to create a new Landed Cost session.
  3. Select the Vendor from the lookup.
  4. Enter the Invoice Number.
  5. Check Create Bill to create a vendor bill during the next sync.
  6. Choose Invoice Date.
  7. Enter Invoice Total.
  8. Click Load Items to select the associated inventory transactions to link the new Landed Cost. Users can load items by Receipt(s), Receipt(s) from PO, Inventory Transfer, and Inventory Assembly sessions.
  9. Continue loading items until all affected sessions are selected.
    • You can add products to the transaction on the row marked with an *, but this will affect the entire warehouse value rather than a specific transaction.
    • When doing this for lot / serial numbered items using Actual cost, you will need to select the specific lot / serial number.
  10. Click Allocate By to choose allocation method.
    • Quantity: Allocation based on total quantity listed.
    • Value: Allocation based on percentage of total value listed.
    • Weight: A calculation based on the weight of the product listed on the Tech Specs times the quantity listed on the row.
    • Volume: Similar to Weight, but uses the Volume field on the Tech Specs of the item.
  11. Users can modify the Alloc % and/or Landed Cost amount on each line manually. Make sure to allocate entire cost of the vendor bill to each row. You’ll see a Discrepancy message with the amount outstanding under the Invoice Total until all is allocated.
  12. Save session.
  13. When ready to complete, click Post.
  14. Once posted, users with proper access will be prompted to Preview, Print, or Cancel report printing. This report can be accessed at any time through the inventory reports menu.

Vendor bill allocation to inventory cost via Landed Cost in Acctivate


Next Steps

Previous Training Topic

Previous Topic:
Assembly Workflow Status Configuration 

Customer Training

Training:
Customer 

Inventory Transactions Training

Training:
Sales 

Next Training Topic

Next Topic:
Track/Trace Inventory Movements for Lot & Serial Items 

 •  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