web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to create Custom Account Schedules with G/L accounts out of order?

(0) ShareShare
ReportReport
Posted on by 73

I have a client with some reporting needs that requires all G/L accounts, but in a specific order requested by the customer. Instead of in order like 1001, 1002, 1003, 1004, etc., the list will be, 1001,1004,1005,1003,1007,1006, etc. Account schedules doesn't seem to have an "Edit in Excel" option to make this easy. I could simply edit the account schedule, but that requires me to manually enter every single account. There are 18,000 that I don't plan to go through. I figured I could create a configuration package, but I haven't worked with them before. I'm not seeing much info online using these with Account Schedules. 

I have the same question (0)
  • ERPlatanos Profile Picture
    73 on at

    andy4029 thanks!

    I was trying to copy each column individually (Account number, then account description), as I assumed copying and pasting both columns wouldn't work in Dynamics. I was able to delete all rows, then copy both columns, pasting to a blank row. I am still new to BC, and have been trying to find an efficient way to do this for a few days.

  • Verified answer
    AD-22040756-1 Profile Picture
    642 on at

    got it...to fix the you cannot paste 18809 rows in the selected 1 rows please paste into an empty row. You will get that error message if you paste into a row with data. If its me i would just create a new account schedule rather than paste into the existing one

  • ERPlatanos Profile Picture
    73 on at

    I was responding to Amit about Edit in Excel.

    For copying, I have tried this with no luck.

    pastedimage1664989579867v2.png

    I have also tried to select all rows, but this will only allow pasting to the viewable rows on screen. 

  • ERPlatanos Profile Picture
    73 on at

    My client is requesting this report with the accounts

  • AD-22040756-1 Profile Picture
    642 on at

    I am not referring to using "Edit in Excel," please re-read my post as it doesnt mention it. To restate:

    1. open your account schedule rows in Business Central

    2. select a row, or select all rows

    3. on your keyboard select CTRL+C to copy the rows

    4. Open Excel in your computer (I am not talking about using the Edit in Excel functionality in Business Central).

    5. on your keyboard select CTRL+V to paste the copied rows

    6. in excel you now have the correct format of the required rows

    7. make the changes you would like in excel and copy the excel rows

    8. go back to Business Central. Open your account schedule rows

    9. go to an an empty row, select the first field, on your keyboard select CTRL+V

  • Suggested answer
    Dallefeld Profile Picture
    211 User Group Leader on at

    Jake, you know that you do not need different account to do year over year comparisons, right?

  • ERPlatanos Profile Picture
    73 on at

    As stated in the original post, "Edit in Excel" is not available on Account Schedules. I can only "Open in Excel" which doesn't allow for publishing. I've tried to add the table, adding the page to webservices, but no entity data source shows up on the Data Connector for Excel

  • AD-22040756-1 Profile Picture
    642 on at

    it will work with the description as well, it works with all fields. Are you pasting into excel first? This step ensures your fields are in the correct order.

  • ERPlatanos Profile Picture
    73 on at

    1. There are about 18000 records. The same account may have multiple records. This is going to be used for year-over-year Profit Loss report.

    2. Not every account will be used.

  • ERPlatanos Profile Picture
    73 on at

    This will only work with the row number for the Account. I am unable to paste all the account descriptions with them

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,513

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 706 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans