Skip to main content
Skip table of contents

Transportation - Gain/Loss Calculation

🤔 Problem

On ticket WESS-15407, the client recently created a new asset and encountered issues regarding the calculation of gain/loss. The gain/loss is determined by subtracting the Book Inventory (which includes Beginning Inventory, Receipts, Deliveries, Transfers, and Adjustments) from the Physical Inventory (actual tank/line fill readings). Various usages can be defined, which are specified in the Asset Setup under Inventory Adjustment Setup.

image-20250507-194340.png

The calculation will analyze the usages configured on this screen to determine Gain_Loss and Inventory. It was noted that the client had not selected the ‘Include in Physical Inventory Calculation' checkbox for one of their inventory usages.

Based on this configuration, the gain/loss should be calculated as follows:

(Inventory + Tank) - (Beginning Inventory + Receipts - Deliveries + Allowance)

🌱 Solution

    1. Confirmed that all instances were included in the calculations under Physical Results → Leveled Volume or Leveled Run tickets, depending on the version.

    2. The Tank usage option was not selected in the ‘Inventory Adjustment Setup’ screen, leading to an overstatement of the gain/loss.

    Results can be validated under Transportation Results → Book Inventory Results. Please note that this screen can be intricate and may require some adjustments to identify the correct combination for accurate inventory assessment.

📎 Related articles

WESS-15407

For more details on specific calculations please see: Liquid Transportation

JavaScript errors detected

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

If this problem persists, please contact our support.