Skip to main content

Notifications

Announcements

No record found.

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 185

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. 

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

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

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

    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
    ERPlatanos 185 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

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 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

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 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?

  • ERPlatanos Profile Picture
    ERPlatanos 185 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

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 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
    ERPlatanos 185 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.

  • ERPlatanos Profile Picture
    ERPlatanos 185 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

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans