Dataport error: 'XXX XXXX' is not an option. Option are .......

Business Central/NAV Developers Forum
1

Hi

I got this error when trying to update fileds in Item card using dataport.

‘Standard ACC01002NA’ is not an Option. The existing options are FIFO, LIFO, Specific, Average, Standard

I my template Standard & ACC01002NA are in separate column.

How am i going to resolve this?

Thanks,

NAV 5.0

MS SQL 2000

2

The fields are not separated by the same value that the dataport is expecting. It looks like a Tab (maybe). You can design the dataport if you have access, go to the bottom line, and go to View → Properties. There is a property called FieldSeparator that tells you how the file should be delimited.