Error when copying and pasting into a journal template

(0) Share

Report

Posted on by AleAlonso

323

Hello,

I'm trying to copy from Excel and copy the records in Business Central, see example below:

the problem is that it doesn't see to recognise line breaks and I'm getting the error below:

The field Bal. Account No. of table Gen. Journal Line contains a value (CABE001 28/02/2022) that cannot be found in the related table (Vendor).

Has anybody seen this type of error before?

Thanks

Alejandra

All responses (8)

Answers (0)

AleAlonso 323 on at

Like (1)

Report

RE: Error when copying and pasting into a journal template

Morning Zhu,

Vendor name is correct. My file has got over 300 JNLs and the error keeps happening randomly with different vendors. I had to copy and paste in small batches.

Thanks

Alejandra
AleAlonso 323 on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

Hi Kim,

No, one row doesn't work either. I need to manually update the Vendor Name in BC.

It is not this specific vendor, I'm working with a Sheet of 320 JNLs, the first time I tried to copy and past all records I got this error. So I had to do it in small batches, the error keeps happening randomly and not always with the same vendors.

Thanks

Alejandra
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

Hi, I tested it and it doesn't seem to be a problem, please confirm whether the Vendor number is the problem.

[View:/cfs-file/__key/communityserver-discussions-components-files/758/Test0712.mp4:1110:833]

Hope this helps.

Thanks.

ZHU
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

Unsual! try copying one row, does that work?
AleAlonso 323 on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

Hi Kim,

I'm only copying and pasting columns Posting Date to Bal. Account No. and still getting the error.

Thanks

Alejandra
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

don't highlight the entire row, highlight the cells and then copy/paste.
AleAlonso 323 on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

Hello Kim,

Screenshot is from Excel.

Yes, same columns layout in Excel and BC.

Thanks

Alejandra
Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Error when copying and pasting into a journal template

Is the above screenshot from Excel?

Do you have the columns layed out the same in Excel as they are in BC?