Share
ReportHi All,
I am trying to do Arithmetic operations " (SettleAmountCur-UtilizedCashDisc)" in Insert_RecordSet query. Below is the query I am trying but getting error "Invalid Token (". But it works fine in Update_RecordSet. Can't we do Arithmetic operations in Insert_RecordSet.?
insert recordset impBankAccCustVendTransSettle
(BankTransDataAreaId, BankTransRecId, Voucher, SettleAmountCur, UtilizedCashDisc, SettleAmountIncDisc)
select crosscompany
DataAreaId,
RecId,
Voucher
From bankAccTrans
where bankAccTrans. SyncedToImp == NoYes:: No
join impParameters
where impParameters.DataAreaId == bankAccTrans.DataAreaId
&& impParameters.ActivateSetup == NoYes:: Yes
join bankAccTable
where bankAccTable.AccountID == bankAccTrans.AccountId
&& !(bankAccTable.Name2 like "*-P")
&& bankAccTable.DataAreaId == bankAccTrans.DataAreald
join vendTrans
where vendTrans. Voucher bankAccTrans. Voucher
&& vendTrans. TransType == Ledger Trans Type:: Payment
&& bankAccTrans. DataAreaId = vend Trans.DataAreaId
join SettleAmountCur, UtilizedCashDisc, (SettleAmountCur-UtilizedCashDisc) from vendSettlement
where vendSettlement.offsetRecid = vendTrans. RecId
&& vendSettlement.DataAreaId == vendTrans.DataAreaId;
Categories:
I have the same question (0)
All responses (
Answers (
127
