Troubleshooting:Why the same GetSingleValue can work in Debtor Statement but not in A/R Receive Payment?

From AutoCount Resource Center

Question: I have created a UDF in Debtor Maintenance, and using get single value function to show the UDF value at Debtor Statement report. But why when I copied the tag and use it at A/R Receive Payment report and preview, it cannot work and prompted with error “Unknown Sql exception (Number=102, Message=Incorrect syntax near ‘?’.)” ?
@GetSingleValue:Debtor:UDF_Title:AccNo=?::AccNo

Version: 1.8 / 1.9 / 2.0


Udf tag1.png


Udf tag2.png


Udf tag3.png


Possible Reason:

Each report will have its own column name which you can find them from report designer field list.
Column name used in Debtor Statement and A/R Receive Payment are different, so the same tag value may not work at A/R Receive Payment.


Solution:

Format: @GetSingleValue:TableName:ColumnName:Condition:Format:Parameter
To show the UDF from Debtor Maintenance at A/R Receive Payment, you should use

@GetSingleValue:Debtor:UDF_Title:CompanyName=?::DealWith

Udf tag4.png


Now the UDF from Debtor Statement is shown.

Udf tag5.png


Note: For more details about Advanced Tag Function, please refer to the link as below.


Report Design: Advanced Tag Function – Get Single Value & Execute Scalar


By: Lay Swan 220218, P220224


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations