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
-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)