Skip to content
logo Knowledgebase

Update a purchase order to not show the postponed accounting VAT amount

Created on  | Last modified on 

Summary

On a purchase order, if you use the postponed accounting VAT code, normally T18, the VAT amount appears when printed. However this should not be showing. To resolve this you can either use a updated purchase order layout, or, if you have a bespoke layout, update the layout to remove the VAT element.

Resolution

Download and use an updated purchase order template

To install the new layout you need to download and restore the following layout only backup:

  1. Click the link below:

    IMPPOPPLAINA4.001

  2. The file either automatically saves to your Downloads folder or you are prompted to save the file.

    If prompted to save the file, browse to where you want to save it, for example, the Windows desktop, then click Save.

  3. Open Sage Accounts, on the menu bar click File, then click Restore.
  4. Click Browse, browse to where you saved the file, then double-click the file IMPPOPPLAINA4.001


  5. Below Description of data to be restored, check that it shows the following:

    Image

  6. To install the report, click OK.

  7. When a message appears advising you are about to overwrite data held in your company, click Yes.

    As this backup only contains a single report, no data is overwritten.

  8. Click OK then log into Sage 50 Accounts.

Your new report should now appear when you print a purchase order.

Image


Update an existing layout to hide the VAT element

If you're using a customised layout, you can edit it and make the changes manually.

TIP: If the changes on your layout are easy to reproduce, why not download the report by following the steps above, then customise the layout again.

  1. Click Purchase Order Processing, then select any order.
  2. Click Print, then click Layouts.
  3. Select the layout you want to edit, then click Edit.

    Report Designer opens

  4. In the details section, double click the ServiceText variable.

    Image

  5. In the expression editor, click Clear, then enter the following expression.

    TAX_CODE.IS_REVERSECHARGE <> 0 ? Substring(POP_ITEM.TEXT,2,Length(POP_ITEM.TEXT)-2) : POP_ITEM.TEXT

  6. Click OK.
  7. In the ORDER_NUMBER.Footer section, double-click the Total VAT amount variable;

    Image

  8. In the expression editor, click Clear, then enter the following expression.

    SumIf(POP_ITEM.FOREIGN_TAX_AMOUNT, TAX_CODE.POSTPONED = False)
  9. Click OK.
  10. Click File, then click Save.