VAT Daybook was redesigned in GP 2016, and so now the VAT Daybook summary report returns highly inflated and incorrect totals (as compared to sum of the detailed transactions) if the DOCDATE on the data being pulled crosses a year and includes dates back to a year old. The summary report has this problem, but the detailed report does not. We need to get the summary report to be able to pick up any transactions from the TX30000 table that is not marked off, regardless of the date, and produce a correct total in the 'net sales/purchases' boxes on the summary report (Box 6,7,8,9). The totals on the VAT Daybook summary report and VAT Daybook detailed reports need to match, and be correct.
Needs Votes