Upgrade to 721 TaxRate Show A - Fast Report: Difference between revisions

Latest revision as of 09:21, 13 November 2015

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

Solution

01. Click Code Tab

02. Scroll down & look for procedure SetUp;

03. Replace this script with below script

  SQL := 'SELECT Dockey, Tax, TaxRate, Sum(CAST(LocalTaxAmt AS REAL)) LocalTaxAmt, Sum(CAST(LocalAmount AS REAL)) LocalAmount '+
         'FROM Document_Detail ' +
         'WHERE Tax <> '''' ' +
         'GROUP BY Dockey, Tax, TaxRate';
  AddDataSet('GSTAmt', ['Tax', 'TaxRate', 'LocalTaxAmt', 'LocalAmount'])

04. Click on Subreport1 tab

05. Double the Tax Rate memo

06. Replace this script with below script

[IIF(Trim(<GSTAmt."TaxRate">)='',<GSTAmt."Tax">,<GSTAmt."Tax"> +' @ ' + <GSTAmt."TaxRate">)]

07. Click OK button

08. Save the report

@@ Line 10: / Line 10: @@
 ==Solution==
 [[File:Error-721-FR-TaxRate-02.jpg|750px|center]]
-:01. Click Code Tab
+:01. Click '''Code''' Tab
 :02. Scroll down & look for '''procedure SetUp;'''
 :03. Replace this script with below script
@@ Line 22: / Line 22: @@
 <br />
 [[File:Error-721-FR-TaxRate-03.jpg|center]]
-:04. Click on Subreport1 tab
+:04. Click on '''Subreport1''' tab
 :05. Double the Tax Rate memo
 [[File:Error-721-FR-TaxRate-04.jpg|750px|center]]
@@ Line 31: / Line 31: @@
 :07. Click OK button
 :08. Save the report
+==See also==
+* [[Upgrade to 721 Script Error]]
+* [[Upgrade to 721 TaxRate Show A - Report Report]]
+* Others [[Customisation]]