Skip to main content

Notifications

Announcements

No record found.

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

Issues Copying and pasting multiple lines from excel file into general journal template

Posted on by 5

Hi ,

I am trying to past an excel journal file into BC general Journal template and am having issues. It was working yesterday!

I have tried a new journal template. Made sure my excel file format is the same as the BC file.

I can paste one line at a time just not the whole lot.

The error is that it is not recognising the next row in the excel file and is pasting the information in the last cell of row 1 .  

when i paste it in i get the following message.

Validation Results

The field Costcentre Code of table Gen. Journal Line contains a value (80 31/12/2022) that cannot be found in the related table (Dimension Value).

this is what the journal in BC looks like when i paste 

pastedimage1673001031272v1.png

this is the excel I am trying to paste

pastedimage1673001229662v2.png

Any help would be appreciated 

thanks 

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Issues Copying and pasting multiple lines from excel file into general journal template

    Hello,

    Best is to raise this question to your partner and if needed they can raise it to Microsoft.

    Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans