The given value of type String from the data source cannot be converted to type decimal of the specified target column.

  • 1
  • Question
  • Updated 2 months ago
Having troubles importing my item list. The above message keeps on coming up. I have reformatted  the  cost items with lo luck. Getting  very frustrated with this and the lack of support for the issue.   Im trying to upload to Reckon Cloud POS
Photo of Malcolm

Malcolm

  • 232 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 20,516 Points 20k badge 2x thumb
Hi Malcolm - I am no expert in Cloud POS - have not tried to import items before - but have you checked out the help files?     https://help.reckon.com/article/pp50ue79ff-other

String types mean text... decimal types are numbers... so the error sounds like you are trying to import text characters into a field that is expecting numbers only?

Did you download the template provided by Cloud POS first and then enter data... any pricing etc - should not have $ signs - should just be numbers?

if you want to email me the list you are trying to import - I am happy to have a quick look?  Send to linda@abcomputing.com.au 
Photo of Malcolm

Malcolm

  • 232 Points 100 badge 2x thumb
Linda your a star if I had only seen that help file from the outset this would have been done weeks ago. Thank you very much