Skip to main content
Skip table of contents

Asset Setup / Inventory Adjustment Setup

What is Inventory Adjustment Setup

The Inventory Adjustment Setup is used to capture inventory-related parameters including calculation/allocation of gain/loss and allocation of allowance and gravity deduction.

Why would a client use Inventory Adjustment Setup

A client would use this setup screen to define how certain volumes, depending on their usage should be handled with regards to gain/loss and gravity and allowance deduction.

How to setup Inventory Adjustment Setup in the system

  1. First, navigate to Asset Setup / Inventory Adjustment Setup

  2. Next create a line item for the different usages that are setup for the particular asset

  3. From there the below out lines what each field refers to that can be selected for a particular usage

Product

Select appropriate product from dropdown list which is populated from the Products code table

Usage

Select appropriate usage from dropdown list which is populated from the Usages code table

Unit

Select appropriate unit from dropdown list (bbl, decimal, gal, LT, mcf, mmbtu, USD)

Reflect Settlement Type

Determines how any adjustments to the inventory tables should be handled

Apply Contract Limits

Determines whether logic for contractual limitations (secondary allocation based on the limit provided on any contracts) should be used during the value process for that product and usage

Available for Marketing

Determines if this product and usage should be included for and shown in the marketing available for sale volumes (displayed on the Deal Capture screen to allow users to estimate what they have available for a given period)

Include in Book Inventory Calculation

Will use this product and usage to calculate the book inventory in the Gain/Loss calculation

Include in Physical Inventory Calculation

Will use this product and usage to calculate the ending physical inventory (usually volume measurements from inventory tanks or specific inventory / storage meter readings)

Function

Dropdown (+ or -) for how the inventory adjustment is functioning

Adjusted Party

Specific to the gain/loss, allowance, and gravity deduction usages, this field tells the system to whom gain/loss should be applied. If “Pipeline” is selected, will apply the gain/loss, allowance or gravity deduct for the asset 100% against the contract listed as the associated contract on the asset setup screen. If “Shipper/Producer” is selected, will allocate the gain/loss, allowance or gravity deduct for the asset back to the shippers on the basis of their allocated receipt or delivery volumes depending on what is selected in the Transport Allocations and adjust their calculated ending inventory accordingly. If “Affiliated Third Party” is selected, it will allocate to the 3rd party selected on the asset setup screen.

No Allowance

If box is checked, then there will be no allowance calculated for the product/usage combination

Allowance Rate Name/ Allowance Number

The user will assign the allowance rate value from the previously created rate picker from the rate menu.

Based on inventory adjustments need to be handled will determine how this screen is setup, there is not one way to set it up and will based on what the clients needs are.

How does this concept impact/feed other areas in the application?

How Inventory Adjustments are setup impacts how the system with calculate different inventory fields. What is setup in this screen will directly impact Book Inventory Transaction and also any fees that are based on inventory data such as gain/loss.

Frequently Asked Client Questions

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.