Sage 100

Exporting A/P Vendors in VI. I export Account_Key but the data is the G/L account Number not the key. Is this a bug? This is on 4.5

Same thing in sales order, so I think it's just bad naming.

Do you really wan the account key? You can usually import into a GL Acct key field with the GL account number anyway.

I'd rather not use account key but the import doesn't give the account number as a field to import

if it old data done prior to V4.0, the account was the same and the number.

It doesn't list the account number but if you import the account number into the account key it'll work

You must have dashes in the incoming field ie ""1100-000-00

In 4.X the account key can get weird and when I do the import with the data exported from account key field into account key it says not found.

I think I had something similar happen, Is the account # that is exported formatted by segment? how long are your GL Accounts?

In exporting account key the data shows 80350-6233 When I import it says account not found

I think you're right @JimWoodhead, Last time I did this, on the import side i read the account number into temp fields by segment and then put them back together.

@ZalmiBerger read the first 5 characters into a temp field then read the last 4 into another temp field and concatenate them together in a calculation on the account key field.

I also use a trick by using a calculation field referencing the raw data instead of the replace field. . In the calculation field I will use IMP$[3] (which refer to the third column in the incoming data field.) The raw data can reference based on the column the data is in. IMP$[x] with X being the column number. The important thing is that it ignores the field length parameter that is use with the replace type.

@BrettLyder Did your suggestion, ran the test and it looks good. Thanks

Cool! Glad it worked for you.

I attended this school of hard knocks class a couple years back. After dinking with it for a day, I came realization that when importing GL accounts numbers, importing the number to a temp field, then using a calc expression referencing the temp field for the account number works everytime for me.