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 |
|---|---|---|
|
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 the 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 |
|---|---|---|
|
Date |
Date for the daily stock. |
01-Apr-20 |
|
Delivery gross |
The sum of deliveries/purchases in gross volume (before any density/temperature conversions). |
0 |
|
Delivery net volume |
The 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 |
The sum of direct sales in gross volume (before any density/temperature conversions). Note: Values will show negatively as a deduction of stock. |
-334 |
|
Direct sales net volume |
The sum of direct sales in net volume (after any density/temperature conversions). Note: Values will show negatively 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 |
The sum of all meter differences. Meter differences 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 a 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 |
The 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 |
The sum of all stock-taking differences. |
636 |
|
Throughput gross volume |
The sum of throughput in gross volume (before any density/temperature conversions). Note: Values will show negatively as a deduction of stock. |
0 |
|
Throughput net volume |
The sum of throughput in net volume (after any density/temperature conversions). Note: Values will show negatively as a deduction of stock. |
0 |
Related pages:
-
Running stock query — The Running stock query is used to display the fuel stock mutations (uplifts, purchases, drains) over a specified period of time. Data included: ticket number, meter values, amount of fuel, and fuel stock.
-
Stock mutations query — The Stock mutations query is used to display the fuel stock mutations (uplifts, purchases, defuel) over a specified period of time. Data included: ticket number, amount of fuel, fuel pricing.
-
Daily stock query — The Daily stock query is used to show a daily overview of all mutations and stock level changes.
Comments
0 comments
Please sign in to leave a comment.