Small and medium business | Business Central, N...

Copying and pasting rows from excel only pastes the 1st line

(0) Share

Report

Posted on by thegnic

Hi,

We are seeing an issue where by we are trying to copy rows from excel into a purchase invoice. The column headers are exactly as they appear in the PI however when we try to paste rows on the PI lines, only the 1st row actually pastes. If we individually copy and paste each row it works fine.

We are not copying the header row, only the data. We have removed any formatting on the excel doc too.

Anyone ever encountered this issue and resolved?

Thanks

Gary

All responses (7)

Answers (0)

Suggested answer

BM1991 5 on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Hi!

I think you have problem with excel data what you want to paste into Navision. I had a similar problem. In excel cell i've got linebreak and in this case the Navision paste only the one row from the clipboard and does not show any error messages. You should check yout excel data with pasting into notepad or notepad++. It will be show you if the excel data have any line break or invalid character and after then you corrected this issue, you can paste your data succesfully. I hope this helps.

BR.
Suggested answer

Community Member on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Gary,

Strange about the prompting and possibly this could be the issue.

Thanks,

Steve
thegnic 75 on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Hi Steve,

Thanks again for the input. That's exactly the steps that I'm following and it still on pastes the 1st line. It does actually prompt to confirm the dimensions used when pasting. I'm wondering whether this is causing the issue? As soon as I OK the dimensions it pastes the 1st line then doesn't do anything else.....weird.

Thanks

Gary
Suggested answer

Community Member on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Gary,

OK, when submitting Forum for NAV, go here: community.dynamics.com/.../microsoft-dynamics-nav-forum

To answer this, for NAV, here are steps:

Sample Purchase Order so I can get the Excel columns.

Create my Purchase Lines in Excel

Made my PI look blank

Highlighted the Columns and Rows needed

Click into Type and right-click and choose Paste Rows

Results

Hope this helps.

Thanks,

Steve
thegnic 75 on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Hi guys, thanks for the replies.

I should have mentioned (and perhaps this is in the wrong forum) that this issue is occurring on NAV2018, not BC.

I've tried all the above steps and still getting the same issue.

Cheers

Gary
Suggested answer

Community Member on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Gary,

Adding to Marco's reply... You are not the first this happens too. If the columns in your Excel spreadsheet are a mirror of the Purchase Invoice Lines highlight the rows for the columns you are copying to BC. In BC, do the following: I clicked into the Type field, then pressed CTRL-V. The lines will populate.

Hope this helps.

Thanks,

Steve
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Copying and pasting rows from excel only pastes the 1st line

Hello,

For PI, you can use Edit in Excel which is much more efficient and easy to use.

Thanks.