Sage 100

Importing into AP Invoice Data Entry: GL Account Key - isn't there a way to import the GL Account number instead of the key?

Yes, it pretty much just works. On the GL Account Key field just point to a column in the source file that has the actual GL number in it and it will import. How long are you GL numbers.

Oh, I didn't know it would work. The account number is 8 characters.

Yep. Give it a try it usually works real well.

Make sure you use the dashes to separate the segments. If the number is longer that 9 digits, there is a check box on the VI header to not truncate source data.

And if it doesn't you can import into a temp and set the GL Account as a calculation.

Or you can set the field to a calculation type (string) and use the variable imp$[x] where x is equal to the column that your data is in import file.

@JimWoodhead that's a good trick. I haven't seen that one yet, thanks.

All imports that I do involving the gl account involve a temp field and then calc the gl account from the temp field.

you don't need a temp field. if it is more than 9 characters you can increase the MAX number of characters in the substring box to match the string size of the account number including dashses. That way your raw data can match the full account number as displayed. if it is less than 9 characters it should work as is.