Business News
Syndicate
Home arrow Sun Documentation arrow System Administration arrow Optional Ledger Tables Create
Optional Ledger Tables Create PDF Print E-mail
User Rating: / 0
PoorBest 
Sun Documentation - System Administration
The database for a Financials business unit comprises a number of tables. When you define a new business unit, the mandatory database tables are initialized.
Optional Ledger Tables (OLT) is used to initialize the following optional files that may be required to hold additional financial information for a business unit:
  • ledger balance file
  • journals on hold file
  • budget ledger files. 
Discuss in forum
To Create Optional Tables identify the tables you want to create in Optional Ledger Tables (OLT).
Click here to see the screenshot.
Select Action >> Create or click Create to initiate the process.
Business Unit Code
The code identifying an existing business unit for which you want to create new tables.
Ledger Balance
This is used to create a balance table for a selected ledger, for the business unit. Choose A to create a balance table for the actuals ledger. Choose B to K to create a balance table for the associated budget ledger.
You cannot create a balance table for a ledger that doesn't exist. For example, you can not create a balance table for a budget ledger if you have not first created the budget ledger itself.
The balance table remains empty until you create the balances and update the table using Ledger Balances Update or Ledger Balances Rebuild.
Journal Hold
Select Yes to create a journal hold table for the business unit. This is used to store unposted journals. See What are Held Journals?.
Budget
A budget table must be created to contain the budget ledger values. You must select the budget ledger you want to create which is identified by the ledger code B to K. A description should be created in Budget Labels (BUL).
Balance Table Analysis Code Consolidation
If you choose to create a balance table for an existing database, with analysis dimensions and codes defined, the Balance Table Analysis Code Consolidation form appears. This lists each of the analysis dimensions defined for the ledger and allows you to specify the ledger analysis dimension consolidation you require. 
Click the Consolidate box alongside the dimensions you want to be consolidated, if any. Consolidated codes are not held on the balance table so cannot be used for reporting using balances.
Discuss in forum

Comments

Only registered users can write comments.
Please login or register.

Latest Articles
 
 
Popular Articles
New Forum Topics
Poll
Apart from Sun do you use other Infor products?
Yes, we use these Infor products:
Place your ads here: