Skip to Content
0
Jun 02, 2011 at 09:29 AM

FMS Issue

44 Views

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