Versions Compared

Version Old Version 3 New Version Current
Changes made by

Tomas Nagy

Tomas Nagy

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Service Code

    • Non-editable field

    • The value of the field is automatically taken when creating the tire storage detail from the contract service overview

    • After clicking, the storage price list will open with a filter for the given service code

  • Vendor No.

    • Non-editable field

    • The system will be completed according to the Service Code from the storage price list

  • Vendor Name

    • Non-editable field.

    • The value of this field is fine-tuned according to the Vendor No.

  • Storage Price Excl. VAT (LCY) (pc/month)

    • Non-editable field

    • The system will finalize the value according to the Service Code according to the validity:

      • Valid from<=Reference date<=Valid to (can be empty)

  • Correction (+-%)

    • Editable field

    • For a description, see a separate chapter.

  • Contract Price Excl. VAT (LCY) (Contract Price Excl.VAT (LCY))

    • Editable

    • The system calculates the value of the field automatically every time the Correction (+-%) is changed according to the formula:

      • Contract Price Excl. VAT (LCY) = Storage Price Excl. VAT (LCY) (pcs/month) x (1 + Correction (+-%)/100)

    • When editing Contract Price Excl. VAT (LCY), the value of the Correction (+-%) field is recalculated retrospectively according to the formula:

      • Correction(+-%)=((Contract Price Excl. VAT (LCY)/ Storage Price Excl. VAT (LCY) (pc/month)-1) x 100.

      • The correction is recalculated only if the Storage Price Excl. VAT (LCY) (pc/month) is different from zero

    • When editing Contract Price Excl. VAT, the value of the Contract Price Excl. VAT (LCY) field is recalculated retrospectively according to the formula:

      • Contract Price Excl.VAT (LCY)=Contract Price Excl.VAT *Contract Exchange Rate from the contract header

  • Contract price excl. VAT (Contract Price Excl.VAT)

    • Editable

    • The system calculates the value of the field automatically even with each change in the Contract Price Excl. VAT (LCY) field according to the formula:

      • Contract Price Excl.VAT=Contract Price Excl.VAT (LCY) (100)/Contract Exchange Rate from the contract header

    • When editing this field, the Contract Price Excl. VAT (LCY) is recalculated retrospectively

  • Number of Stored Tires

    • Non-editable field

    • The system calculates the value of the field automatically:

      • If the value of the Dual Montage=NO field is then the value is 4

      • If the value of the Dual Montage=YES field is then the value is 6

  • Contract Total Price Excl. VAT

    • Non-editable field

    • The value is calculated automatically by the system:

      • Number of Months of Service Duration x Number of Stored Tires x Contract Price Excl. VAT

      • Number of Months of Service Duration is calculated=difference month/year from Valid From-month/year from Valid To but maximum Financing Period (in Months).

        • Note: when creating the calculation, he gave 1m more than the duration of the contract, if the Expected Handover Date was not on the 1st of the month. That is why the condition for Financing Period (in Month) has been added

  • Currency Code

    • Non-editable field

    • The value of the field is automatically tightened from the contract header

  • Total Storage Margin

    • Hidden field

    • The system will fill in the value automatically:

    • Purchase Price Excl. VAT (LCY):

      •  fill from Tires Storage Rates in the same way as fill Price Excl.VAT (LCY) but from the Purchase Price Excl. VAT (LCY) field 1pcs/Day

    • Purchase Price Excl. VAT (CZ: Nákupní cena bez DPH)

      • Conversion via the currency factor (exchange rate) is as sure as the conversion of Contract Price Excl.VAT

      • Purchase Price Excl.VAT (110)=Purchase Price Excl.VAT (LCY)(105)/Contract Exchange Rate from the contract header

    • Total Purchase Price Excl.VAT (EN: Total Purchase Price Excl. VAT)

      • Purchase Price Excl.VAT * Stored Tires Number x (Months of Service Duration + Tires – Months) x Tire – Avg. Days in a Month

    • Tire - Months and Tire - Avg. Number of days per month are from Contract with Services Setup

      • As sure as it is calculated in the Contract Total Price Excl.VAT

    • Calculates the margin:

      • Total Tires Storage Margin=Contract Price Total Excl.VAT - Total Purchase Price Excl.VAT

  • Invoiced Excl. VAT

    • Non-editable field

    • The value of the field is dynamic, which means that the amount that has already been invoiced to the current system date (used for recalculation) is displayed here

    • It is used for recalculation (change of time and/or mileage) – see Změny smlouvy Contract Changes

  • Theoretically Invoiced

  • Recalculation Settlement

If it's on the service Reinvoice=A (from a product/template) the system proceeds as follows:

...