VI Import Not Recognizing All GL Account Numbers

Question

Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine. 
 Our accounts format is XXXXX-XX-XX 
 I can't tell why some GL accounts are being after the second dash, while others are not. 
 
 Thoughts?

btmlinesoft · Accepted Answer

Insert a temp field before the GL account key field. Set ihe data type to " string ", Set the Assign temp on to " Key Assigns Only " and select " clear on each record ". Change the import column to your GL account column of your budget import 
 
 Change the Account key operation to " calculated ", For the calculation field below, click on the tool icon to the right and select the t emp field from the current job fields column. I should appear as Temp00x$, the "X" being the temp number.

Sage 100

VI Import Not Recognizing All GL Account Numbers

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING