web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • AD-22040756-1 Profile Picture
    640 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    you can use copy paste - copy the account schedules rows to excel, make your changes in excel, and then paste back into the account schedules page in Business Central

  • Suggested answer
    Dallefeld Profile Picture
    193 User Group Leader on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    1. why so many chart of accounts?

    2. are you printing each and every account on your account schedule?

  • Suggested answer
    Amit Profile Picture
    2,557 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    Hi,

    Create data in excel as per the requirement. But one think remember, the sequence of col. must be same as in Account Schedule.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • ERPlatanos Profile Picture
    73 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

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

  • ERPlatanos Profile Picture
    73 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    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.

  • AD-22040756-1 Profile Picture
    640 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    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
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    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

  • Suggested answer
    Dallefeld Profile Picture
    193 User Group Leader on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

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

  • AD-22040756-1 Profile Picture
    640 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    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

  • ERPlatanos Profile Picture
    73 on at
    RE: How to create Custom Account Schedules with G/L accounts out of order?

    My client is requesting this report with the accounts

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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 2,828

#2
Sumit Singh Profile Picture

Sumit Singh 2,617

#3
YUN ZHU Profile Picture

YUN ZHU 1,861 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans