SKU (Stock Keeping Units) (Fields)

A SKU has the following fuel related fields that can be edited in the SKUs (Stock keeping units) (Administration) page.

Tables:

Stock keeping units (SKU)

A stock keeping unit represents a fuel type kept in stock at an FBO location.

FBO LOCATION

The FBO location for this SKU. A SKU always applies to one FBO location. Mandatory field.

name

The name of the SKU. This can describe the type of fuel and location, for example: JET A1 AMS.

Fuel type

The fuel type for this SKU. See Fuel types (Administration)Mandatory field.

Revenue ledger

The ledger that margin on sales are booked. See Ledgers (Administration).

Stock difference value ledger

The ledger that fuel stock differences are booked. See Ledgers (Administration).

Stock value ledger

The ledger that fuel stock are booked. See Ledgers (Administration).

Purchase supplier ledger

The ledger to book the purchased amount from the fuel supplier. It is also used to create a counter booking for the purchase in case of a throughput sale. See Ledgers (Administration).

Purchase supplier sub administration

Identifies a supplier for making a reservation for purchases. Is also used for the counter booking in case of a throughput. See Sub administrations (Administration).

Reward program cost ledger

The ledger to book the costs of the awarded points of the reward program on. See Ledgers (Administration)Add Reward Program Account - add/edit screen.

Cost center

The cost center for this SKU. See Cost centers (Administration).

Unit of volume

The default unit in volume in which the fuel stock quantity is calculated. See Units (Administration)Mandatory field.

Default unit for defuelling quantity

When defuelling an aircraft the quantity can be expressed as a weight or as a volume. If the quantity is expressed as a weight, the system will automatically calculate the volume for inventory tracking and sales purposes.. See Units (Administration) & Stock mutation workflows (Administration)Mandatory field.

Unit of weight

The default unit for measuring the weight of the fuel. The system is using the weight and the density to calculate the volume for inventory tracking and sales purposes. See Units (Administration) & Table Conversions (Administration)Mandatory field.

Fuel temperature unit code (C for Celcius, F for Fahrenheit)

Fuel temperature unit. Must be 'F' or 'C' for Fahrenheit or Celsius.

Maximum temperature

The maximum value allowed for temperature on fuel tickets and stock takings. This is useful to prevent incorrect data entry for fuel tickets.

Minimum temperature

The minimum value allowed for temperature on fuel tickets and stock takings. This is useful to prevent incorrect data entry for fuel tickets.

Fuel density unit code (M for Metric, A for API)

The fuel density unit code. Must be 'M' or 'A' for Metric Kg/L or Degrees API.

Default density in kg/liter

Default fuel density value expressed in Kg/Liter.

Maximum density in kg/Liter

The maximum value allowed for fuel density on fuel tickets and stock takings expressed in Kg/Liter. This is useful to prevent incorrect data entry for fuel tickets.

Minimum density in kg/Liter

The maximum value allowed for fuel density on fuel tickets and stock takings expressed in Kg/Liter. This is useful to prevent incorrect data entry for fuel tickets.

First workflow state for stock takings

The first stock taking workflow state for fuel stock takings. See Stock taking workflows (Administration)How to enter End of Month Fuel Stock Takings.

Prompt for fuel temperature in uplift ticket

If unchecked, the fuel temperature field is removed from fuel ticket screens for uplifts, with the default temperature applied automatically (60F/15C).

Prompt for fuel temperature in purchase ticket

If unchecked, the fuel temperature field is removed from fuel ticket screens for purchases, with the default temperature applied automatically (60F/15C). See Stock mutation workflows (Administration).

Prompt for fuel density in uplift ticket

If unchecked, the fuel density field is removed from fuel ticket screens for uplifts, with the default density applied from the 'Default density in kg/liter' field. See Stock mutation workflows (Administration).

Prompt for fuel density in defuelling ticket

If unchecked, the fuel density field is removed from fuel ticket screens for defuels, with the default density applied from the 'Default density in kg/liter' field. See Stock mutation workflows (Administration).

Prompt for transaction time

The fuel ticket transaction time is shown empty and to be filled, instead of taking the current date and time. 

Prompt for parking position in uplift and de-fuelling tickets

Parking position is required for uplift and de-fuelling fuel tickets for fuel location. If left unchecked the order's parking position is used. See How to add parking areas and positions.

Auto-generate ticket numbers

Automatically generates a ticket number for each ticket removing the ticket number field, starts at 1. Enable this, if the fuel tickets produced at the trucks have no ticket number. See ID Generators (Administration) to change the start number with 'TableName' as 'StockMutation'.

Volume rounding decimals

Used to round the result of unit conversions to volumes. 0 = no decimal rounding. See Units (Administration)Mandatory field.

Weight rounding decimals

Used to round the result of unit conversions to weight. 0 = no decimal rounding. See Units (Administration)Mandatory field.

First inhouse fuel transfer order workflow state

The first stock taking workflow state for fuel transfer orders. See Stock mutation workflows (Administration)Mandatory field.

Fuel Amount custom value

The custom value assigned to price components (assigned to fuel products) that make up the basic fuel amount. Used in 'stock mutations report' to populate the amount column for 'Basic Fuel Revenue'.

Airport Fees custom value

The custom value assigned to price components (assigned to fuel products) that make up the airport fees. Used in 'stock mutations report' to populate the amount column for 'Airport fees'.

Duty Tax custom value

The custom value assigned to price components (assigned to fuel products) that make up the duty tax. Used in 'stock mutations report' to populate the amount column for 'Duty Tax'.

Throughput Fees custom value

The custom value assigned to price components (assigned to fuel products) that make up the throughput fees. Used in 'stock mutations report' to populate the amount column 'Throughput fees'.

Labour Fees custom value

The custom value assigned to price components (assigned to fuel products) that make up the labour fees. Used in 'stock mutations report' to populate the amount column 'Labor'.

Anti-icing additive product (Prist)

Adds the 'Is Prist (anti-icing) added' field to mutations and indicates which anti-icing additive product is added to the fuel (when field is checked).

Anti-icing additive mixing ratio

The quantity of the anti icing additive service compared to the fuelled quantity (example: 0.001 is 1 per 1000).

Column config back office

Columns to be displayed in the back office fuel tab. Available columns (separated by semi-colon):

  • TicketDate - 'Date'. Shows the ticket date references 'ShortDateTimeWithoutYearFormatString' application setting for format. 
  • OrderKey - 'Order key'. The Order key
  • TicketNumber - 'Ticket'. The fuel ticket number.
  • ServiceState - 'State'. The current service state for the fuel ticket.
  • RowType - 'Type'. The type of fuel stock mutation type for this ticket. For example: Uplift, Purchase, Transfer, Defuel, Stock taking. 
  • Volume - 'Volume'. The gross volume of fuel.
  • Into - 'Into'. Where the fuel was transferred to. For uplifts, this will be the aircraft registration. For purchases, transfers, defuels it will be a stock location
  • Meter - 'Meter'. The meter count start and end for the stock location/truck. Format: (Meter Name) StartNumber → EndNumber
  • OrderState - 'Order state'. The order state.
  • Debtor - 'Debtor'. The debtor for the order.
  • RowSalesType - 'Sales type'. The type of sale for this fuel ticket. For example: Direct sale, Delivery, Throughput.
  • FormOfPayment - 'On account'. The form of payment for the order.
  • BackOfficeApprovalWarnings - 'Approval info'. Shows back office approval warnings. For example: Duty tax status, imported ticket warnings, anti-icing additive status, miscellaneous ticket warnings (ticket number missing), entry periods warnings.
Column config ramp

Columns to be displayed in the front office 'Running stock' fuel page. Available columns (separated by semi-colon):

  • TicketDate - 'Date'. Shows the ticket date references 'ShortDateTimeWithoutYearFormatString' application setting for format. 
  • TicketNumber - 'Ticket'. The fuel ticket number.
  • ServiceState - 'State'. The current service state for the fuel ticket.
  • Type - 'Type'. The type of fuel stock mutation type for this ticket. For example: Uplift, Purchase, Transfer, Defuel, Stock taking, Start balance, End balance. 
  • Source - 'Source'. Where the fuel was transferred from. See Stock locations (Administration).
  • Into - 'Into'. Where the fuel was transferred to. For uplifts, this will be the aircraft registration. For purchases, transfers, defuels it will be a stock location.
  • InStockVolume - 'Inventory'. The running stock (net) for this stock location.
  • DeltaNetVolume - 'Delta net'. The net volume for this stock mutation. 
  • DeltaVolume - 'Delta gross'. The gross volume for this stock mutation. 
  • Meter - 'Meter'. The meter count start and end for the stock location/truck. Format: (Meter Name) StartNumber → EndNumber
  • Remarks - 'Remarks'. Fuel ticket remarks. 
Enable imported fuel tickets

Set to true if fuel tickets are imported with an automated link. 

Track fuelled by

Indicates if the name of the fueller must be recorded in the fuel ticket. Users for this Fbo location are shown. 

Track inventory

Enables fuel inventory tracking for all stock locations that are set to the same 'Owner' as specified in the Administration of the FBO. With inventory tracking enabled, the Fuel Running Stock screen can be used to view the current inventory for each stock location. The system will also warn if meter readings have overlaps or gaps.

Main stock location

The main fuel stock location where hydrant carts are connected to.

Maximum timespan for grouping fuel tickets

Groups fuel tickets based upon the ticket date/time entered. The overall fuel quantity is combined and this allows for discounts based on quantity tiers. See Grouped fuel tickets.



SKU price components

Defines the list of price components for fuel, used to define the value of the fuel stock at per entry period.

Name

The name of the price component. For example: PLATTS FOB, Purchase differential or Duty Tax.

Copy prices to next SKU price component period

Indicates if the price of the previous SKU price component period should be copied to the next period automatically. If left unchecked, then prices will be blank on the next period. 

Included in stock keeping unit value

Indicates if the price component should be included in calculating the stock value.

Sort index

The sort order for the price component in this table. Lower number results in a higher sort. 



SKU periods

Unit of measure for volume

The volume unit of measure for this period. See Units (Administration).

Entry period

The accounting entry period for which the fuel value is defined. See Admin Entry periods (Administration).



SKU price component periods

Lists the prices for the SKU price components in a given period.

Price component

The price component defined in the 'SKU price component' table above.

Unit price

The unit price for this price component and period. 

Currency of unit price

The currency for the unit price. See Currencies (Administration).

Unit of measure for unit price

The unit of measure for the unit price for this period. 



Gross to net volume conversion table

Assigns a volume temperature conversion table to a SKU.

Conversion table

The conversion table used to convert gross fuel volume to net fuel volume based on temperature. See Table Conversions (Administration).

Valid from date in local time

The valid from date that the conversion table is valid from. Fuel ticket dates will reference this date to choose the applicable table conversion.

Gross Density

Density as inputted on the fuel ticket. Only use this if you use both inputted gross temperature and measured (gross) density to obtain a correction factor for the net volume and net density. Leave blank if only the gross temperature is used to lookup a correction factor.


Related pages: