Skip to main content

Keg Deposits - Inventory Account Mapping

Distributor steps for mapping keg deposits on the Inventory Asset Account Maps table: set up full and empty keg maps, Deposit Asset Account vs Inventory Asset Account, plus empty keg products and Packages Deposits. Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Pre-Conditions

Empty Keg Products

Create a new empty shell product for each size keg that will be sold. When collecting the shell from a customer, this product should be invoiced with a negative quantity.

  • Example Product: Empty 1/2 Keg

Packages Deposits

On the Packages Deposits table, create a new record for each size keg. Creating this record will automatically add the deposit amount on an invoice.

Steps

How to set up Inventory Asset Account Mapping for Keg Deposits

  1. Using Universal Search, navigate to the Inventory Asset Account Maps table
    ​
    ​

  2. Click the 'Add Inventory Asset Account Maps' button
    ​
    ​

  3. Create an Account Map for Full Kegs by entering values to all required and applicable optional fields displayed in the 'Add Inventory Asset Account Maps' form and click the 'Add Record' button when complete.
    ​
    - Company
    ​
    - Location (required if your company has multiple locations)
    ​
    - Product Type, Supplier, OR Product
    a. One of these must be filled out. Follow your company’s standard mapping practice.
    ​
    - Inventory Asset Account
    ​
    - Freight Accrual Account
    ​
    - Tax Accrual Account
    ​
    - Other Cost Accrual Account
    ​
    - Deposit Asset Account
    ​
    ​

  4. Repeat steps 2 and 3 to create an Inventory Asset Map for Empty Kegs
    ​
    NOTE:
    Product/Product Type should relate to an empty keg record
    ​
    ​

Fields And Definitions

Inventory Asset Account

  • Full keg mapping: Inventory account that is responsible for tracking the liquid being sold.
    ​
    ​

  • Empty keg mapping: Inventory account that is responsible for tracking the keg shell. This should match the Deposit Asset Account on the full keg mapping.

Deposit Asset Account

  • Full keg mapping: Inventory account that is responsible for tracking the keg shell. This should match the Inventory Asset Account on the empty keg mapping.
    ​
    ​

  • Empty keg mapping: There is not a deposit associated with the empty keg product - there should not be an impact on inventory from this field.
    ​
    ​

Did this answer your question?