Page Comparison

Fuel card transactions were created by the system when importing a the data record together with writing a 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.

The A fuel card transaction contains data from the financing contract, from the an imported data record, and data about invoices created and posted.

Field:

• Import File No. (Import File No.)

  • The internal file number is linked to the Import History and the Invoice Interface Buffer

• File Created (File Created)

  • File Creation Date in Data Recordcreation date in data record

• File No. (File No.)

  The file

  • File number in the header of the data record header

• Card No.(

  • Internal Fuel Card No.

  )

  • Internal fuel card number, the system traced during import by Card No. - Company

• Card No. – Company (Card No. - Company)

  • Key data of the card company for transactions from the data record transactions and communication. (After delivery of the fuel card, the user wrote on the fuel card)

• Licence Plate No. (Licence Plate No. )

  From

  • 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)

• Vendor No. (Card Vendor No.)

• Card Vendor Name (Card Vendor Name)

• Contract No. (Financing Contract No.)

• Customer No. (Customer No.)Customer Name

• (Customer Name)

• Customer Business Place No. (Customer Business Place No.)

• Customer Business Place Name (Customer Business Place Name)

• Driver No. (Driver No.)

• Fuel Card Type (Card Type)

From the Imported Data Record, the system filled in:

• Transaction Date and Time (Transaction Date, Transaction Time)

  • Data from a data record

• Vendor Invoice No. (Vendor Invoice No)

  • Data from a data record

• Country/Region Code (Country/Region Code)

  • According to the Country Code in the data record, the system has added the standard OC country code from the Country of Import code list in the data sentence.

• Petrol Station No. and Location (Petrol Station No., Petrol Station Location)

  • Data from a data record

• Product No. and Name (Item No., Item Name)

  • Data from a data record

• Quantity (Quantity)

  • Data from a data record

• Purchase Currency (Purchase Currency)

  • Data from a data record

• VAT Rate (VAT Rate %)

  • Data from a data record

• Unit Price Incl. VAT (Unit Price Incl. VAT)

  • Data from a data record

• VAT (VAT)

  • Data from a data record

• Total Price Incl. VAT (Price Total Incl. VAT)

  • Data from a data record

• Price Total Incl. VAT (LCY) (Price Total Incl. VAT (LCY))

  • Data from a data record

• Unit Price Excl. VAT (LCY) (Unit Price Incl. VAT (LCY))

  • Data from a data record

When refuelling abroad, prices are usually listed in the data file usually lists prices in both local currency and foreign currency.

• Odometer Status (Odometer Status)

  • added 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 to fill in that the Object Handover Date .is completed

  • Invalid odometer check is not in progress

• Product Code (Product Code)

  • When importing according to the mapping of goods from the Fuel Card Type Products code list

• Standard Sales Code (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 Method (Discount Calculation Type)

  • will be automatically completed according to the Service No.

The total price of the goods item in the data record is the price after discount.

Vendor discounts are recorded for the fuel card service on the contract in the table Tank type discount detailTank Type Discount Detail table. cards.

• Discount Value (Discount Value)

  Vendor discount amount

  • The amount of the vendor's discount (the system has tightened up the discount on the fuel card service discount on the contract, for the given product in the data sentence)

...

• Unit Price Excl. VAT (LCY) - Without Discount ( 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 (Total Price Excl. VAT (LCY))

  • From the total price in the data record, the system calculated the total price without discount

• Discount Value – Customer (Discount Value - Customer)

  • The system has been added from the set discount for customers in the detail discounts of the tank type discount. Cards for the a given service

• VAT Rate % – Customer (VAT Rate %)

  • 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 amount for the customer on the contract service:

• Unit Price Excl. VAT (LCY) – Customer (Unit Price Excl.VAT (LCY) - Customer)Total Price Excl. VAT (LCY) – Customer

• (Total Price Excl. VAT (LCY) - Customer))

• VAT Amount – Customer (VAT Amount - Customer)

• Total Price Incl. VAT (LCY) – 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

...

The system records the next steps taken over the fuel card transactions in the transaction:

• Purchase Invoice No. (Purchase Invoice No.)

• Posted Purchase Invoice No. (Posted Purchase Invoice No.)

• Sales Invoice No. (Sales Invoice No.)

• Posted Sales Invoice No. (Posted Sales Invoice No.)

• Sales Invoice Posting Date (Posted Sales Invoice Posting Date)Invoice Issued

• (Invoiced)

  • The system flag system changes to Yes after a sales invoice is issued

Important Also important data for a fuel card transaction are also:

• Service Code (Service Code)

  • It is the fuel card price list used on the contract service

• Source Code (Source Code)

  • A tracing trace code that goes from the invoicing interface settings to the invoice invoicing interface buffer, the fuel card transaction and the created accounting documents

• Bugs (Error)

  • If the system detects an error when importing a data record, it will record the flag Error=Yes for the recordsentence. The flag then prevents the erroneous transaction from being reinvoiced to the customer.

• Buffer Entry No. (Buffer Entry No.)

  • The link to the buffer item is completed by the system during import

...