I have Sage 50 Canadian Accountant company file and following setting are configured in it.
- HST tax name is setup
- Tax code H is setup and mapped to HST Tax name
For Receivable accounts , Tax code H is setup for new customers sales
Now we are sending Sale invoice to Sage 50 Company file and while preparing data to be posted, we are making a call to get tax name by tax code 'H'. Following query is being used which is executed by method RunSelectQuery() which is defined in SDKDatabaseUtility Class in Sage_SA.SDK.dll
SELECT tTaxAuth.sName FROM tTxCdDtl INNER JOIN tTaxAuth ON tTaxAuth.lId = tTxCdDtl.lTaxAuth INNER JOIN tTaxCode ON tTaxCode.lId = tTxCdDtl.lTaxId WHERE (tTaxCode.sCode = 'H')
But this query is returning tax name 'GST/HST' instead of 'HST'. This tax name is causing issue while saving tax amount by tax name 'GST/HST' using method SetTaxAmountByName() which is defined in TaxSummaryInfo Class in Sage_SA.SDK.dll . I am getting following message in response:-
“The value you are attempting to set for this field is invalid.”
Can you please help me why tax name 'GST/HST' is returning although i have setup tax name 'HST' for tax code 'H'?
Thanks in advance