Hi Experts,
Plz take a look on this FMS. I have created this for copying NumAtCard from A/P Invoice to Outgoing PAyments.
SELECT NumAtCard from OPCH where cardcode = $[ovpm.cardcode] and docnum = ($[$20.1.Number])
This is going well but when NumAtCard comes in Character it returns error as below
1). [Microsoft][SQL Native Client][SQL Server]Conversion failed when converting the nvarchar value 'R-0193' to data type int. 'Withholding Tax' (OWHT)
Plz help for same.
Regards,
Ravi