Vendor Combiner not allowing Import

(0) Share

Report

Posted on by Bill Campbell

After creating the list of vendor ID's we need to combine - two columns of data in excel saved as CSV - we click on the VALIDATE and the pop up shows it passes validation. Then when we click the PROCESS button, we get a pop up that says there is nothing to import.

Any suggestions on what we are doing wrong?

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (1)

Bill Campbell on at

Like (0)

Report

RE: Vendor Combiner not allowing Import

Cheryl, thanks for the pointer - I opened the file and there was a single blank line at the end of the file. Once removed the Validation and Import then worked correctly.

Thanks for the assistance.
Verified answer

Cheryl Waswick on at

Like (0)

Report

RE: Vendor Combiner not allowing Import

Hello Bill,

I would recommend to open the file with Notepad and press CONTROL - END, and see where the cursor takes you. If there are blank lines at the end of the file, hit the BACKSPACE key to remove them (and put the cursor at the end of the last line of data) and resave the file and try again.

Cheryl

Microsoft Dynamics GP
Bill Campbell on at

Like (0)

Report

RE: Vendor Combiner not allowing Import

I should add that I am running this as 'sa' and there are no other users in the company database I am working on.

My expectation was that after running a successful validation that the list of the FROM and TO vendor IDs would appear in the rows below. But nothing happens.