Sage 100

Attempting an import into AP Invoice Entry. Client is on 2013 Prem. Account number is 10 char including dashes. I have the Skip Truncation check box checked but testing and live import both say account is not on file and display 9 characters when saying so, even though it is reading the whole 10. I've tried Calc, Assign, Replace. I am using the AP account because these are from a merger and we do not want to affect GL. WTH? Starting to think it's a Prem thing.

Hi, Beth. Check the Import field properties on the account key that they aren't set to 9, as 9 is the default, at least in the non-premium versions, but I don't think this would be different for the premium version. Perhaps changing it there will help.

It doesn't let you make it bigger than 9

In the non premium version at least (I don't have a premium version at hand), check the Source substring box, change the Max number first, then change the length field.

Hi Beth, I had a similar problem and what I ended up doing is exporting all the GL Account Numbers and GL Account Keys and lining up the Account Keys next to the Account Numbers on my source file. Then I ran the import using the Account Keys instead of the numbers.

I believe a work around I had from back in the day was to import the account # as a temp field and then calculate the account number field from that. I have also changed the field size...

I'll try all of this stuff today. Thanks, everyone!

use of the substring approach has worked for me in the past. Although I have had it lose its setting when editing the import job. Have had to go back in to re-expand the size.

Ditto @Alan. Trick is to change the ""Max"" field first and then the ""Length"".