When setting up this control information, work from the top down. Start with the Major entries, then the Minor entries, then the Detail entries and finally the Financial entries.
When you’re setting this up you can print or preview it to see the complete layout.
Valid Entries
The following rules determine valid Balance Sheet entries...
| • | a FinancialID occurs only once |
| • | only those FinancialIDs whose Class is Asset, Liability or Equity are present on the Balance Sheet report |
| • | all FinancialIDs whose Class is Asset, Liability or Equity must be specified for the Balance Sheet report |
When you’re filling in the FinancialIDs the system helps you follow these rules by displaying a Count of available (unused) FinancialIDs and presenting only the available FinancialIDs in the drop-down list.
For example, when you’re working on the Balance Sheet then only those FinancialIDs whose Class is Asset, Liability or Equity and that are not already in use are in that list. That drop-down list will be empty once all the FinancialIDs have been set up for that Balance Sheet.
The Balance Sheet definition must have an entry whose DetailID is 999 as its last Detail entry (e.g. it must have the highest MajorID and MinorID and DetailID of all Balance Sheet report Detail entries). This entry represents "Net Income (Loss) Year-to-Date" and it may not have any FinancialIDs specified for it. This is illustrated in the sample database.