Vendor Bill Allocation to Inventory Cost

Full training library

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.

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.

When needing to add other amounts or fees to a PO Invoice related to a purchase order, check out the training page for allocating other amounts listed on vendor bills.

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