R0018P1 VAT Report

 Our Swiss office runs R0018P and R0018P1 for Sales each month.

Normally, the report totals agree and the sub-totals by Tax rate/area agree.

From 1st January, Swiss VAT rates changed and we have two effective date ranges for many codes, for the first time in E1.

Since the beginning of January, the two reports have been different on one Tax rate/area code. Each day, the difference changes and the Summary Report R0018P1 is higher than the Detail report R0018P.

This report is based on business view V0018A that joins F0018 and F4008 on Tax rate/area. The data selection includes selecting the Tax rate/area code from F4008, which should assure that only documents where the tax rate/area exists in F4008 are selected.