Upgrade to 721 TaxRate Show A - RTM Report

Introduction

This issue occurs when a report contains a script that retrieves the TaxRate from Maintain Tax.

The error is caused by changes in SQL Accounting's coding structure that affect how tax rates are provided to reports.

Problem

You will see the following error when previewing the report:

Solution

1. Click Calc Tab

2. Click View | Module

3. Click Event

4. Click OnCreate

5. Scroll down & look for SQL_6

6. Replace this script with below script

   

   SQL_6 := 'SELECT DocKey,  Tax, TaxRate, Sum(LocalAmount) LocalAmount, Sum(Qty) Qty, '+ 
               'Sum(LocalTaxAmt) localTaxAmt, Description '+ 
         'FROM Document_Detail ' +
         'Where Tax <> ''''' +
         'GROUP BY Dockey, Tax, TaxRate';

7. Click on Subreport4:plSQL_6 tab

8. Click on Event Handlers

9. Click on procedure VarTaxOnCalc(var Value:Variant);

10. Replace this script with below script

    

    procedure VarTaxOnCalc(var Value:Variant);
    Var s : string;
    begin
      if Trim(plsql_6.getfieldvalue('TaxRate')) <> '' then
        Value := plsql_6.getfieldvalue('Tax') + ' @ ' + plsql_6.getfieldvalue('TaxRate') else
        Value := plsql_6.getfieldvalue('Tax');
    end;

11. Save the report.