• Prerequisites
• Mandatory fields in the template
• Error messages
• Tables used

Use this template to import expense notes.

By default, this template includes the fields listed below. When you keep all these fields in the template, the import takes place with no VAT calculations, even if a field has a zero value.

• Tax amount (AMTVAT)
• Input VAT (DEDVAT)
• Tax amount (AMTTAX1)
• Deductible tax  (DEDTAX1)
• Tax amount (AMTTAX2)
• Deductible tax (DEDTAX2)
• Tax 3 (VAT)
• Tax 1 (TAX1)
• Tax 2  (TAX2)

Standard import behavior

When you do not remove any fields from the standard template, the import is carried out with no VAT calculations.

• Amounts in the imported file are used without recalculation.
• When the amounts are zero, the expense note is imported with VAT amounts = 0.
• When there is no VAT code in the file, no VAT code defaults from the expense code (GESTES).

Modifying the template changes the behavior

If you remove one or more fields from the standard template, the import behavior changes. Removing one or more fields triggers a recalculation for VAT amounts.

• VAT amounts and deductible amounts are calculated on import by Sage EM according to the VAT, TAX1 or TAX2 codes indicated in the file.
• If there is no VAT code in the file, the VAT code, if any, in the expense code (GESTES) is defaulted in the imported line and considered for VAT calculation.
• If there is no VAT field in the template, the VAT field in the expense code (GESTES) is defaulted.