Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Business Central forum

Reporting Questions

(0) ShareShare
ReportReport
Posted on by

Hello,

I would like to confirm a couple of GL and reporting questions in out of the box Business Central:

-Can you import data directly into posted tables? Can you delete data from posted tables?

-Can you run account schedules against provisional data (general journals which are not yet posted, but tagged to GL accounts)?

-Is there a way to have more that one description column for account schedules in Business Central in order to have one column for account numbers and one column for account descriptions?

Thank you,

Tim 

  • Francisco Bedolla Profile Picture
    1,119 on at
    RE: Reporting Questions

    -Can you import data directly into posted tables? Can you delete data from posted tables?

    No, you cannot do this in an out of the box BC (needs development for insert, modification or delete are not recommended)

    -Can you run account schedules against provisional data (general journals which are not yet posted, but tagged to G/L accounts)?

    No, the accounts schedules pulls information from table 17 G/L Entry and this table has only posted entries. maybe you can use queries to mix posted and unposted ledger entries in the same query

    -Is there a way to have more that one description column for account schedules in Business Central in order to have one column for account numbers and one column for account descriptions?

    Yes, with development you can add or modify columns or titles in the account schedule but, is the same table for all account schedules (ID 85)

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans