Skip to main content
Question

Vendor Import error

  • Nov 19, 2026 1:48 AM UTC
  • 5 replies
  • 29 views
  • Translate All

Hello,

Acumatica newbie here but I have used integration tools quite a bit, particularly with Dynamics GP.

I am working on building a set of imports for migration from Dynamics GP. I imported the chart of accounts and Customers and Locations.

I am not able to import vendors.  Can you help me figure ths out, please?

Sceenshots attached here.

-------------------------------------

I am getting this error:  “Value cannot be null.  Parameter name: key”

Import By Scenario

 

here is the Import Scenario.  it might be worth mentioning that I could not find a mapping for Vendor Name, so I used Legal Name instead.

Import Scenario
Data Provider

 

5 replies

mohammadnawaz51
Varsity I
Forum|alt.badge.img+8

​@hsalim 

Please review this mapping once

 

Here is a Vendor sample Acumatica Import Scenario with Installation Instructions.

 

Sample Acumatica Import Scenario (Vendors)

Click here for a listing of other Sample Acumatica Import Scenarios

Screen: FINANCE -> Accounts Payable -> Work Area -> MANAGE -> Vendors (AP303000)

Fields Imported

  1. Vendor ID
  2. Vendor Name
  3. General Info -> FINANCIAL SETTINGS -> Vendor Class
  4. General Info -> MAIN CONTACT -> Company Name
  5. General Info -> MAIN CONTACT -> Attention
  6. General Info -> MAIN CONTACT -> Email
  7. General Info -> MAIN CONTACT -> Web
  8. General Info -> MAIN CONTACT -> Phone 1
  9. General Info -> MAIN CONTACT -> Phone 2
  10. General Info -> MAIN CONTACT -> Fax
  11. General Info -> MAIN CONTACT -> Account Ref. #
  12. General Info -> MAIN CONTACT -> Parent Account
  13. General Info -> MAIN ADDRESS -> Address Line 1
  14. General Info -> MAIN ADDRESS -> Address Line 2
  15. General Info -> MAIN ADDRESS -> City
  16. General Info -> MAIN ADDRESS -> Country
  17. General Info -> MAIN ADDRESS -> State
  18. General Info -> MAIN ADDRESS -> Postal Code
  19. Payment Settings -> DEFAULT PAYMENT SETTINGS -> Payment Method
  20. GL Accounts -> AP Account
  21. GL Accounts -> AP Sub
  22. GL Accounts -> Expense Account
  23. GL Accounts -> Expense Sub
  24. GL Accounts -> Cash Discount Account
  25. GL Accounts -> Cash Discount Sub
Translate

KrunalDoshi
Pro II
Forum|alt.badge.img+9

Hi ​@hsalim,

Remove duplicate VendorID and Action Cancel.

 

Move Vendor Class above Address Line 1. Make sure all the mandatory fields are set.This should resolve your issue.

You can also review out-of-box Vendor import scenario “ACU Import Vendors” for reference. 

Hope this is helpful!

Translate

Steve Milner
Varsity III
Forum|alt.badge.img+8

My replies are created in part with the help of proprietary AI, built with my AI skills, curated and maintained myself. Most replies are tested on local instances before they go up, and all are reviewed before posted.

@hsalim, Vendor Name is there. It lives on Vendor Account Info, the same object as your Legal Name row. Change row 4’s Field or Action from Legal Name to Vendor Name and put VENDNAME in Source Field or Value. The Internal Name column will show AcctName.

Vendor Name is a required field, and nothing in your mapping fills it right now. The Legal Name row has an empty Source Field or Value, so VENDNAME never reaches Acumatica. Krunal’s point about mandatory fields applies here, and Vendor Name is item 2 in Mohammad’s sample.

Krunal is right about rows 5 and 6 too. The second Cancel and the second Vendor ID with no source aren’t in ACU Import Vendors, so delete both. Rows 1 to 3 (Key, Cancel, Vendor ID with VENDORID) are the pattern to keep.

Translate

  • Author
  • Freshman I
  • Nov 20, 2026 7:03 PM UTC

Thank you ​@mohammadnawaz51 , ​@KrunalDoshi  and ​@Steve Milner 

I was able to import the vendor list.  a few observations:

I had watched a few videos and learned that I could copy the mapping from an existing import scenario and I did import it from ACU Import Vendors.  (I must have imported it twice)

I could not delete lines 5 & 6 - Error: System rows cannot be deleted. so just deleted the import scenario and rebuilt it.

Vendor Name is not in the mapping.  I found it in Vendor Account Info, as Account Name.  Thanks to ​@Steve Milner, when i saw the internal name showed AcctName,  I knew I had it right.  

The other Gotcha was Cash Account.  I had imported the chart but had not set up the cash account as a “cash account”. that took a few minutes to figure out.

 

edited to add: 

The Cash Account maps to the named “Cash Account”, not to a GL Account number.  

however, Expense account maps to a GL account number.

Translate

KrunalDoshi
Pro II
Forum|alt.badge.img+9

Glad you figure it out and able to import from “ACU Import Vendors”

Translate