The Online Module provides the ability to enter real-time updates to the Fixed Asset Accounting System Master Files and to inquire against them. The Online Module includes:
- Real-time update of Control, Asset, Book and Detail Master Files.
- A large number of predefined screens for both entry and inquiry.
- Screens can be modified or new screens created by the accounting user. No programming is required to change or add screens. The system automatically produces documentation reflecting the changes.
- Both entry and inquiry can be performed on the same screen.
- Previously entered transactions with errors can be called up and corrected online.
- Security features protect against unauthorized access or inquiry.
- Multiple lines can be entered on a single screen.
- The user can access multiple Data Design Systems all from the same program.
- VIEW is like a real-time interactive report writer. This includes the ability to define a Query, run a Query, review and save the Query Answer, and save the Query Definition.
General Report Writer
A company’s computerized Fixed Asset Accounting System records can be a valuable resource to assist management. The General Report Writer is a tool that an accountant can utilize to design and produce special reports from this data base, without programming assistance.
The General Report Writer is exceptionally simple to use, yet extremely powerful. It can generate a wide range of reports from simple “list and total” type displays to very complex reports requiring extensive calculations, logical tests, and multiple detail print lines. Features include:
- Up to fifteen reports with a single pass of the Master Files
- Both printed and machine-readable output
- Complete detail print line format flexibility
- User-defined page and column headings
- Extensive logical test and calculation capabilities
- Ability to access user-defined tables
- Unlimited report sequencing and totaling flexibility
- Detail or summary reporting
- Percentages may be computed and printed based on accumulated totals
- Detail lines may contain variables, constants, and calculated amounts
- Records may be selected using extensive selection criteria
The General Report Writer has been designed to run efficiently so that it can be used to produce regular accounting reports in addition to one-time special reports. It is particularly useful for creating additional accounting and control reports designed to meet the exact needs of a company.
The module also gives the user the ability to define other files that can be used with the Report Writer. Any sequential file with fixed-length records can be accessed and used to produce reports.
The Fixed Asset Accounting System can be completely integrated with all of a customer’s existing systems without the need to write interface programs or modify existing systems. This is accomplished with AIM, Data Design’s Automatic Interface Module. AIM is a powerful tool that accepts the records from any system and restructures them into Data Design format. AIM capabilities include:
- Reformatting records.
- Translation of codes and other data.
- Accepting groups of records and creating consolidated or allocated records.
- Comprehensive sign manipulation capabilities.
Personal Computer Interface
Data Design’s LINK joins powerful mainframe data base retrieval of VIEW with the ease, convenience and flexibility of personal computing. Real-time query menus can be used to find, calculate, or summarize information from Data Design’s Fixed Asset Accounting System. The user is working with a familiar framework of information, using the same terms and formats that have already been set up for the mainframe application data.
Lease Accounting (FAS-13)
The Lease Accounting Module provides comprehensive coverage of all accounting and reporting requirements placed on the lessee by FASB Statement 13. Features include:
- All leases are automatically analyzed and established as either capital leases or operating leases.
- For capital leases, the Module computes the interest rate implicit in the lease.
- The Module computes the present value of the minimum lease payments, using either the lessee’s borrowing rate or the lessor’s implicit rate, according to the criteria provided by the Statement.
- The Module computes amortization over the period of the lease, allowing a user-specified portion of the lease value to be considered non-depreciable. The amortization period is automatically selected by the Module as either a user-specified depreciation life or the term of the lease, using the criteria defined by the Statement.
- The Module allows the payment schedule to be entered in up to nine series of payments (or stair steps). From series to series, the frequency, number and amount of individual payments may vary.
- In addition to the normal payment amount, the Module also carries executory cost. The executory cost may be specified either as a dollar amount associated with each payment or a percentage of the payment, with the actual dollar amount to be calculated by the Module.
- Anytime the terms of the lease are altered, the Module will generate a new payment schedule. In this way, the accounting user can analyze various lease options. The necessity for making retroactive lease adjustments is also eliminated.
- The standard reporting options available for reports produced by the basic Fixed Asset System are also available in the Lease Accounting Module.
- The extensive report selection criteria capability of the Fixed Asset System is also available in the Lease Accounting Module. This capability allows the user to precisely control the content of each version of each report.
Inflation Accounting (FAS-33)
The Inflation Accounting Module provides users of the Data Design Fixed Asset Accounting System with a tool for preparing those asset-related disclosures required by Statement 33 of the Financial Accounting Standards Board, “Financial Accounting and Changing Prices.” Features include:
- Historical costs and related values (such as depreciation) are indexed to constant dollar values using the Consumer Price Index for all Urban Consumers (CPI-U). Historical cost/constant dollar values may be indexed to either 1967 dollars or current year dollars, at user option.
- The following techniques are provided for determining current cost:
- Indexing (life-to-date)
- Direct Pricing by asset, unit or productive unit
- Recoverable Amount (for assets retired in the current year)
- Each company may specify a Master File field to be used as a default class code for looking up current cost indexes.
- The standard report options and selection criteria available for reports produced by the basic Fixed Asset System are also available in the Inflation Accounting Module. They may be different for each version of a report.
- Leased assets present on the Asset Master File are examined to determine whether they are to be accounted for as capital or operating leases under FASB Statement 13. Capital leases are included in FAS-33 reports, while operating leases are not.
- Companies using the currency conversion feature of the Fixed Asset System maintain historical cost and related amounts in foreign currency. Where this feature is used, the FAS-33 module converts to U.S. dollars.