I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years.

I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices into AP, from a csv file.  The first import brings in the Vendors and the second import brings in the invoices.

I have created two temporary fields, 001 (2 alpha) and 002 (five numeric), which populated by two fields from the source file to create the Vendor Number.    A third temporary field, 003, is used to append these two fields together.   The Division number was assigned to 00 and the Vendor Number field was assigned to the Temp003 field.

My initial test resulted in a job.distribution error.  I created a 4th Temp field and also did a Calculation to bring in the Temp003 field.  I then added the Temp004 field and I still get the error.

What am I missing?

Please note:  When I assigned the Vendor Field to a static number, 1234567, to allow me to confirm the remainder of the imports, and I changed it back to the Temp004 field calculation (forgetting to delete the default value), it would assign the first line to the static number and then each consecutive line had the result of the concatenated formula for the previous line.