VAT Report By Tax rate/Area (R74S450)

You can print the VAT Report By Tax Rate/Area to document accounts payable VAT.

You use the processing options on the VAT Report By Tax Rate/Area to create an accounts payable version of the report.

You also need to indicate which rate from the Intra-Community VAT tax rate/area is included on the report. On the Accounts Payable version, include the positive tax rate. On the Accounts Receivable version, include the negative tax rate.

Also, you can define the value in the Report By Country processing option to process the tax rate/area by country for the selected transactions.

The VAT Report By Tax Rate/Area sequentially numbers vouchers with suspended VAT and vouchers with regular VAT. The report prints suspended VAT transactions based on the payment date and amount. The report selects only those suspended vouchers from the F704200 table that were reclassified in the specified period and not the ones those were received in that period. The report groups transactions by document number and the execution number in the F704200 table.

For suspended VAT transactions, the report displays GL date in the voucher records under the GL Date column and payment method from the 74S/PM UDC table under the Payment Method column. The system assigns a value of C in the Payment Method column if the payment method is not set up in the 74S/PM UDC table.The report also displays the bank account number based on the payment method. If the payment method is C, the system retrieves F0030.CBNK corresponding to this value. If the payment method is blank, the system retrieves F0030.IBAN and when the payment method is O or T, the system retrieves F0413.DOCM.