Fuel card transactions were created by the system when importing the data record together with writing the data record to the invoice interface buffer. Sentences in the Buffer are used to review, create, and post a purchase invoice. The fuel card transaction is the basis for re-invoicing to the customer.
A fuel card transaction contains data from the financing contract, from an imported data record, and data about invoices created and posted.
Field:
Import File No.
The internal file number is linked to the Import History and the Invoice Interface Buffer
File Created
File creation date in data record
File No.
File number in data record header
Card No.
Internal Fuel Card No., the system traced during import by Card No. - Company
Card No. - Company
Key data of the card company for transactions from the data record and communication. (After delivery of the fuel card, the user wrote on the fuel card)
Licence Plate No.
from an imported file
By Card No. - The company will add to the transaction the data according to the Fuel Card No. entered in the table Fuel Card, Contract and Financed Object - described in Tankovací karta
Fuel Card Type (Card Kind)
Card Vendor No.
Card Vendor Name
Financing Contract No.
Customer No.
Customer Name
Customer Business Place No.
Customer Business Place Name
Driver No.
Card Type
From the Imported Data Record, the system filled in:
Transaction Date, Transaction Time
Data from a data record
Vendor Invoice No.
Data from a data record
Country/Region Code
According to the Country Code, the system has added the standard OC country code from the Country of Import code list in the data sentence.
Petrol Station No., Petrol Station Location
Data from a data record
Item No., Item Name
Data from a data record
Quantity
Data from a data record
Purchase Currency
Data from a data record
VAT Rate %
Data from a data record
Unit Price Incl. VAT
Data from a data record
VAT (VAT)
Data from a data record
Price Total Incl. VAT
Data from a data record
Price Total Incl. VAT (LCY)
Data from a data record
Unit Price Incl. VAT (LCY)
Data from a data record
When refuelling abroad, prices are usually listed in the data file in both local currency and foreign currency.
Odometer Status
added from import file
When a purchase invoice is created, the system stores the odometer status in the Odometer Status History on the item. The condition is a completed Object Handover Date.
Product Code
When importing according to the mapping of goods from the Fuel Card Type Products code list
Standard Sales Code
When importing according to item mapping
The data sentence shows the price after the discount. During import, the system fills in the discount data according to the fuel card service and calculates the price for the customer.
Discount Calculation Type
will be automatically completed according to the Service No.
The total price of the item in the data record is the price after discount.
Vendor discounts are recorded for the fuel card service on the contract in the Tank Type Discount Detail table. cards.
Discount Value
The amount of the vendor's discount (the system has tightened up the discount on the fuel card service on the contract, for the given product in the data sentence)
The system recalculates prices without discount from the vendor prices listed in the data sentence according to the set discount amount for the given product on the contract service:
Unit Price Excl. VAT (LCY) - Unit Price Excl. VAT (LCY)
From the unit price in the data record, the system calculated the price without discount
Total Price Excl. VAT (LCY) - Without Discount (LCY)
From the total price in the data record, the system calculated the total price without discount
Discount Value - Customer
The system has been added from the set discount for customers in the detail of the tank type discount. Cards for a given service
VAT Rate % – Customer
The system will be completed according to the service on the contract
The system recalculated the prices for the customer from the prices without discount according to the set amount of the discount for the customer on the contract service:
Unit Price Excl. VAT (LCY) - Customer
Total Price Excl. VAT (LCY) - Customer
VAT Amount - Customer
Total Price Incl. VAT (LCY) - Customer
Example of a discount by the amount of the unit price excl. VAT:
The system calculates:
Unit Price Excl. VAT (LCY) without Discount = Unit Price Excl. VAT (LCY) + Discount Amount
29.51483 = 27.41483 + 2.10
Unity. Price Excl. VAT (LCY) Customer = Unit. Price Excl. VAT (LCY) Without Discount – Customer Discount Value
27.515 = 29.51483 – 2.00
The system records the next steps taken over the fuel card transactions in the transaction:
Purchase Invoice No.
Posted Purchase Invoice No.
Sales Invoice No.
Posted Sales Invoice No.
Posted Sales Invoice Posting Date
Invoiced
The system flag changes to Yes after a sales invoice is issued
Also important data for a fuel card transaction are:
Service Code
It is the fuel card price list used on the contract service
Source Code
A trace code that goes from the invoicing interface settings to the invoicing interface buffer, the fuel card transaction and the created accounting documents
Error
If the system detects an error when importing a data record, it will record the flag Error=Yes for the sentence. The flag then prevents the erroneous transaction from being reinvoiced to the customer.
Buffer Entry No.
The link to the buffer item is completed by the system during import
Fuel Card Import History (TK)
Above the fuel card transactions, it is possible to view the History.
Here you can see which files were processed and with what result.
If the import result is completed with an error, you can view it via the Errors button.