Question

Add multiple vendors to a stock item and skip when excel is empty

  • 18 April 2024
  • 9 replies
  • 79 views
E

Hello everyone,

I have the problem that I want to add several suppliers to a stock item. This works so far, but I need a way to skip empty rows in Excel.

For example:

I have three possible suppliers in my Excel list.

Two are imported.

For the third one, it throws an error because there is none, for example.

 

 

Does anyone have any idea how I can work around this?

Kind regards

9 replies

manikantad18
Rank
Userlevel 7
Badge +12

Hi @ernst97 

Have you tried by disabling the below Mapping 

 

Acumatica Functional Consultant
E

Hi @ernst97 

Have you tried by disabling the below Mapping 

 

Hi @manikantad18 ,

I have now tried it but the same error occurs. Vendor ID must not be empty.

manikantad18
Rank
Userlevel 7
Badge +12

Hi @ernst97 Please share Import scenario XML File.

Acumatica Functional Consultant
E

Here it is.

1 Attachment
Laura02
Rank
Badge +18

Hello,

Did you try selecting ON “Ignore Error” option in the Import Scenario screen?

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
E

Hello,

Did you try selecting ON “Ignore Error” option in the Import Scenario screen?

 

Yes, unfortunately I've already tried that too

E

@Laura02 @manikantad18 

Is there a kind of zero or skip command?
Then I think it would be possible via an IIF query.

for example IIF([VENDORID] = null, 0 / skip, [VENDORID])

manikantad18
Rank
Userlevel 7
Badge +12

Hi @ernst97 

Please find the attached Import scenairo 

can you update your data provider as below ( Attached for reference). If the data is missing and it is null then the record will shows as failed, In this way we can upload the vendor which are available.

SKU Vendor ID Vendor Name Location Warehouse Purchase Unit
AACOMPUT01 ELEEASTCOM East COM Electronic Supplies MAIN   EA
AACOMPUT01 ELEEMPEROR Emperor Office Equipment MAIN   EA
1 Attachment
Acumatica Functional Consultant
D
Rank
Userlevel 7
Badge +5

@Laura02 @manikantad18 

Is there a kind of zero or skip command?
Then I think it would be possible via an IIF query.

for example IIF([VENDORID] = null, 0 / skip, [VENDORID])

I think you’re looking for putting something in the Source Restrictions tab which will allow you to filter out the records from the source file before they are processed by the import scenario.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved