Skip to main content

Notifications

Business Central forum
Answered

How do you paste in more than one row in General Journals or Account Schedules?

Posted on by Microsoft Employee

I see instructions for copy/paste into General Journals and Account Schedules, however this doesn't work for me. 

I am using Business Central. 

For the General Journals, I can "edit in excel" so there is a workaround there (although copy/paste would be much preferred), but there is no such "edit in excel" option in Account Schedules when I create/edit the row formats - and copy/paste to/from excel would make building custom reports so much easier.

I am selecting all of the rows and then CTRL-V (after copying from an excel workbook) and nothing happens.  If I put the cursor in the first field "row no." and choose CTRL-V, I can only paste one row at a time.  If I select all the rows (as the instructions say), and then select the first row, the row selections are removed.  Either way, I get the message "You cannot paste 48 rows in the selected 1 row".  Same problem whether I'm creating a general journal entry or working in account schedules.

Frustrating! I'm sure there is a simple trick I'm missing, it cannot be this hard.  Any ideas?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    That is strange 

    If you have a partner asked them to open ticket with Microsoft. I had one strange issue long time ago (in similar concept) and Microsoft ended up to find and solve it (it was issue with new company as well and it was related to how company created by system). 

  • EricBC2022 Profile Picture
    EricBC2022 15 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    I have tried selecting the first row, the first cell... etc.  What is odd is that a direct copy of this company that was also created today, I can copy and paste multiple rows.  

    So I figured, copy and paste that one and maybe this will work for us.  Still the same issue.  

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Then it should work the same. Do you select the fist cell when you copy?

  • EricBC2022 Profile Picture
    EricBC2022 15 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Layout is the same and security is the same

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Hi

    I do not think special permission required here. But check your permission in other company and compare. 

    Also, does your column layout (sequence) match your other company?

    Thanks 

  • EricBC2022 Profile Picture
    EricBC2022 15 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    I just set up a new company code and Business Central is not letting me post more than 1 row at a time.  I do not get any errors, I only get the first row of my subset to paste.  

    I have had no issues with my existing company code and set up.  Is there a feature that needs to be turned on?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Brilliant!  Thank you!

  • Verified answer
    AD-22040756-1 Profile Picture
    AD-22040756-1 622 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Hello,

    Please select the entire 1st row and delete it, and then try pasting. If any field in the row contains a value you will get the error message about not being allowed to paste more than n rows in the selected 1 row. To fix delete the entire row. Sometimes its not clear that the row has existing date. If a row contains data you can paste to replace the same number of rows that you have highlighted which is why it works as you have mentioned.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Hi

    This is the exact version I used. I wonder why is working on my environment and not yours. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How do you paste in more than one row in General Journals or Account Schedules?

    Hi - the version is US Business Central 19.4 and it is SAAS.

    Thanks,

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans