Daily stock query

The Daily stock query is used to show a daily overview of all mutations and stock level changes.

For multiple stock locations, the sum of all mutations and stock levels are shown.

Contents:

Filters

Filter

Description

Mandatory

Filter

Description

Mandatory

SKU

Filters on the stock keeping unit, e.g. JET A1 or AVGAS. Multiple SKUs can be chosen for filtering. Note: Multiple SKUs will show one after the other on the report

NO

Stock location

Filters on the stock location, e.g. Jet Truck. Note: If used in conjunction with SKU filter, then ensure the stock location matches the SKU to show mutations.

NO

Start date (LT) / End date (LT)

Filters on the start and end of fuel tickets/mutations. Use Start and End dates together to create a date range of mutations.

NO

Data provider settings

There are no data provider settings for this query.

Columns

Name

Description

Example

Name

Description

Example

Date

Date for the daily stock.

01-Apr-20

Delivery gross 

Sum of deliveries/purchases in gross volume (before any density/temperature conversions).

0

Delivery net volume

Sum of deliveries/purchases in net volume (after any density/temperature conversions).

0

Delta gross volume

Gross delta volume change (change in stock level for the day).

(Delivery gross volume + Direct sales gross volume + Meter difference net + Stock taking difference net + Throughput gross volume)

302

Delta net volume

Net delta volume change (change in stock level for the day).

(Delivery net volume + Direct sales net volume + Meter difference net + Stock taking difference net + Throughput net volume)

299

Delta temperature adjustment volume

Difference between delta gross and net.

(Delta gross volume - Delta net volume).

3

Direct sales gross volume

Sum of direct sales in gross volume (before any density/temperature conversions). Note: Values will show negative as a deduction of stock.

-334

Direct sales net volume

Sum of direct sales in net volume (after any density/temperature conversions). Note: Values will show negative as a deduction of stock.

-337

End stock gross volume

End stock gross volume at 23:59 of the ‘Date’ column

19113

End stock net volume

End stock net volume at 23:59 of the ‘Date’ column

19110

FBO

FBO location short name for the daily stock summary.

GVA

Meter difference net

Sum of all meter differences. Meter difference are any non consecutive meter readings for subsequent mutations.

0

SKU

The SKUs (Stock keeping units) (Administration) for the stock locations.

Note: Daily stock reports can be generated for single SKU at a time.

JET A1

Start stock net volume

Starting stock net volume at 00:00 of the ‘Date’ column

18811

Stock location

Stock location for the daily summary.

Note: If multiple stock locations are chosen, each will be separated by a comma and summed as a total.

142

Stock taking difference net

Sum of all stock taking differences.

636

Throughput gross volume

Sum of throughput in gross volume (before any density/temperature conversions). Note: Values will show negative as a deduction of stock.

0

Throughput net volume

Sum of throughput in net volume (after any density/temperature conversions). Note: Values will show negative as a deduction of stock.

0