Skip to main content
Answer

While doing Import scenario for vendor i’m getting the below error

  • July 6, 2023
  • 3 replies
  • 175 views

 

Best answer by Laura03

Hello,

It seems like the import file does not contain any vendor id.  Vendor ID column is required when importing new vendors or changes to vendors, even if automatic numbering is turned ON.

The minimum you can have is a Vendor ID column that is numbered sequentially:

1

2

3

4

5

6

Point the import scenario to the above Vendor ID column. If Vendor ID is automatically numbered, Acumatica will assign the next number from Numbering Sequences screen.

If this doesn’t answer your question, can you show us the import scenario you are using along with a few lines of what your data looks like?

Thank you.

Laura

3 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @debas56 

Please share the Excel file you are importing, there are some issues in the data file. Also, share an XML file. of Import scenario and data sheet. 

Thanks

 


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • July 6, 2023

Hello,

It seems like the import file does not contain any vendor id.  Vendor ID column is required when importing new vendors or changes to vendors, even if automatic numbering is turned ON.

The minimum you can have is a Vendor ID column that is numbered sequentially:

1

2

3

4

5

6

Point the import scenario to the above Vendor ID column. If Vendor ID is automatically numbered, Acumatica will assign the next number from Numbering Sequences screen.

If this doesn’t answer your question, can you show us the import scenario you are using along with a few lines of what your data looks like?

Thank you.

Laura


  • Author
  • Freshman I
  • July 6, 2023

@Laura02 Thanks.