Vendor Number does not import when importing new vendors

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.

  • Can you be a little more specific on your error?

    Do you have the job cost module by any chance? I note there is a file called AP_JobDistributionDetail that I assume is related to job cost. And there is a field in Invoice History Header for job number. Possibly related?
  • in reply to TomTarget
    This customer does not own Job Cost. When I try to import the Vendors into the Vendor Masterfile, I get the following error: Error 84 at AP_JobDistributionDetail_BUS.PVC at line 116.
  • in reply to FinanceAssist
    In AP Options, does it show Integrate with Job Cost is enabled? May be able to use DFDM to correct it
  • When creating the temp variables temp001 and temp 002 did you select 'Key Assigns Only' on the 'Assign Temp On' drop box? Is VendorNo Calculation is Temp001$+STR(Temp002). I was able to successfully import vendors using this.
  • in reply to daburke
    This is why, even after years of experience, many brains is better than one, slightly older brain! I failed to change the 'Key Assigns Only' for the Temp field. In most cases, the vendor numbers are specified exactly on the source file for both implementations and other imports and it doesn't usually cause an issue. However, I should have known better. Thanks for saving me and my customer time and dollars of trial and error!