Upgrade to 721 TaxRate Show A - Report Report

From eStream Software
Revision as of 09:18, 13 November 2015 by Twfaung (talk | contribs) (→‎Solution)

Introduction

This happen if you had write script to get the TaxRate from Maintain Tax in the report

This due to changing SQLAccounting Coding Structure to cater future Changes in Tax Rate

Problem

You will get below error when you preview the report

Error-721-RB-TaxRate-01.jpg

Solution

Error-721-RB-TaxRate-02.jpg
01. Click Calc Tab
02. Click View | Module
03. Click Event
04. Click OnCreate
05. Scroll down & look for SQL_6
06. 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';


Error-721-RB-TaxRate-03.jpg
07. Click on Subreport4:plSQL_6 tab
08. Click on Event Handlers
09. 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

See also