Sage 100

VI job into Budget Revision Entry - getting off the wall results. GL is 9 digits, 3 segments. Some data importing fine, some not at all, some into a GL account with the right main account and segment 2 value, but not the right segment 3 value (000 instead of something else). Accounts exist and are active (FWIW). Using CSV file. Rebuilt GL_Account keys. I can't find a pattern. Next step is an onsite visit to try different file types. I'll also try Exchange, but am confounded by my results. Any one have any experiences to share about using VI for this task?

What version????? I had that problem with v4.4. I imported the account number into a temp than calc'd the field into the account number field. Didn't need to do that in v2013...... I think what is happening is the accounts that are importing existed prior to v4.0 and have the same key value as the account number.. Accounts added afterwards have a key value that is different than the number and that is where the sporadic results are coming into play.

Make sure you check the box on the main panel on the VI screen to skip truncation of source data. That tells VI to read the entire number and not truncate the incoming data fields.

Yes, the skip truncation did it for me. I had accounts that if you just took the first 9 characters they were equal to the account KEY in MAS instead of the ACCOUNT, and apparently it looks for a match that way first.

Oops, version 4.5. Thanks all - I'll try the skip truncation and see how that goes.

YES! Skip truncation worked. Thanks!!!