Customize Tax Report - VAT Return

Hello,

There are some changes in our country for all Suppliers are required to include a QR code in their invoices. So when capturing the supplier invoice in pastel, users normally input the QR code in the User defined field.

The problem is when running Tax report for VAT claiming, that user defined field is not captured and the tax report requires QR code when filling for claim to the authority. We tried to include the QR code in the Supplier invoice number but the field is limited to 15 characters in some old packages.

It's a hassle to manually capture these QR codes per invoice into the Tax report which forces system user to use Excel VLOOKUP function and this is where human error occurs.

Is there a way we can customize the Tax report so we can include additional user defined field column?

Kindly advise the way forward or workaround to avoid human tampering the report.

Regards

Ally

  • 0

    Good day Ally

    Unfortunately, all the reports on Pastel cannot be customized and are all standard. 

    Instead of the amount being populated on the user defined field it can  be populated as a line
    to a sales account where the tax type which will be allocated is 100% (tax type 6 and 12)
    with that you will have the whole tax amount reflecting as desired.
    Please email [email protected] with any examples if you have any.
    Kind Regards.
  • 0 in reply to MagsNan

    On Pastel Partner/ Xpress you cannot edit the layout of any reports to add the QR codes. The reports cannot be customized.
    Not sure if Sage Intelligent can customize it. Adding the QR code as a line on the invoice won't work as the tax type report does not pull the invoice line but the invoice total, besides that the QR does not need amounts or tax type.
    Kind Regards