Import Scenario Error When Updating Vendor Payment Instructions

Hi @TitileGama 

Please find the attached import scenario for reference.

All see suggestions and options in the below article https://community.acumatica.com/import-and-export-scenarios-117/issue-with-vendor-eft-data-importation-15754

Thank you @manikantad18  i have attempted to use your Import scenario , however i still get the same error 

Hello,

I have not loaded Manikanta’s version, but I have one idea about your original version.

The error mentions BAccount and that represents Vendor ID.

On Vendor ID in the Summary, the first field in your import, I think COMMIT column should be checked ON.  Did you already try the import with Commit checked on for Vendor ID?

Do all Vendor ID’s showing in Vendor column of your data exist in Acumatica?

What happens when you manually type the same lines into the Vendor screen?  Are there any errors when manually typing?  Manually typing is a first step to solving errors, because we can only import data that can be successfully typed in.

Hope this helps.

Laura

@TitileGama

I have the solution that might help you.

Please change the Payment method to Check/Chk for all the vendors that you are trying to import.

Later import the above data with the EFT (or the payment method which have remittance with Bank information) payment method.

Usually you get the above error when you trying to import a same payment method that already Vendor have in Vendor master.

Make sure that the <Line Number> is in active.

The below worked for me. After changing all Vendors payment method to Check.

Regards

Ram

Thank you for sharing you solution with the community @TitileGama !