Sage 300

Customer has an AP import that has been running without incident for years. today it give the following on 1 csv file: Description: Type mismatch, CNTBTCH field should be number. Code: 1042.0.504.1260 Source: 19:45:49 - The batch number isn't in the file, nor is it in any of the other files that work - you create a batch, then import into it. Any ideas?

Phil, even though you create the batch first before you import the file, did the user set the batch number as a value in the import process. We have found it's much easier to require the batch number column and value is required to be in the import file. It can always be 1, but in order to import successfully all fields which have a STAR next to them are required when importing, either in the import file OR you set the value in the import script.

I tried setting the CNTBTCH value in the file, and then I get this: Description: Invalid input. Optional field cannot be blank. Source: 20:30:51 But none of them are! So something else is wrong.

Did you edit the file to be imported? Look at the field it was trying to import? There's probably something out of alignment - an extra field, etc....

I do LOTS of importing like this, so I've hit every possible glitch.

I assumed this is in Sage 300, right? If you want me to take a look at the file, let me know.

Figured it out - I really hate inaccurate error messages. The problem was there was an item optional field line (5) BEFORE the actual item line(2).