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

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Cheryl Waswick Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No