BilTAY Teknoloji SCIENTA Report System
Report Guide
Overview
BilTAY Teknoloji SCIENTA includes four types of reports:
Pre-Defined GAAP Financial Statements
There are many financial reports that are available in by clicking the "GAAP Financial Statements" link from the reports tab in the main application. Since there are so many different financial reports available (over 100 Different variations), we provide the financial statement selection screen in table format. Selecting the options that you want and clicking on the printer execute the financial report.
When a financial report is selected for execution, the system is running an ASPX Formatted Report Page against a pre-defined stored procedure to option the result. Both the ASPX Report Page and the stored procedure that drive the reports are completely customizable to meet your needs.
Pre-Defined IFRS Financial Statements
There are many financial reports that are available in by clicking the "IFRS Financial Statements" link from the reports tab in the main application. Since there are so many different financial reports available (over 100 Different variations), we provide the financial statement selection screen in table format. Selecting the options that you want and clicking on the printer execute the financial report.
When a financial report is selected for execution, the system is running an ASPX Formatted Report Page against a pre-defined stored procedure to option the result. Both the ASPX Report Page and the stored procedure that drive the reports are completely customizable to meet your needs.
Documents
Documents in the system refer to reports that usually print a single page of specific information, like an Order, and Invoice, a Purchase Order, etc. These are usually run by clicking a printer icon somewhere on a particular page. A document is typically implemented as a stand-alone ASPX program, that takes as input a document number, and outputs a formatted page for that document number. For example, to print an order, you would call the "DocOrder.aspx" page, pass it the order number, and it will display the order as a formatted aspx page that can then be printed, faxed, emailed, etc.
These are easily customizable, you can simple make a copy of the entire ASPX Page and change whatever you like very easily.
ASPX Report Engine
BilTAY Teknoloji SCIENTA also includes a dynamic report generator that we call the ASPX Report Engine. This reports engine builds a report dynamically based upon a pre-defined stored procedure in the database back-end. This works as follows:
1) The user selects a report stored procedure from the reports engine drop-down list, and presses "Select"
2) If the report has parameters, the parameter table will be populated and the user can enter the information that the report needs to run.
3) The user can now select one of the three displaying options at the bottom of the window:
A) Screen - This will display the report on the screen in a browse-able data grid that supports sorting on any of the fields and paging through large amounts of data.
B) Printer - This will display the report in a format suitable for printing.
C) Excel - This will export the contents of the report directly into excel and load excel so you can work with the results immediately. Once in Excel, you can emancipate the data, export it to various formats, make charts and graphs, and save it separately. You need to have Microsoft Office 2000 or greater for this function to properly work.
The BilTAY Teknoloji SCIENTA system already includes over a hundred standard reports in ASPX Reports Engine format ready to run out of the box. Anyone that can understand simple stored procedures can customize and / or build new stored procedure report formats for use with the reports engine.
Report Design
If you need to create a new report in the system, the simplest thing to do would be to find a report in the system that is already close to want you want (This should be an easy task since there are hundreds of reports in the system), make a copy of it, make the modifications that you want, and display the result using the ASPX Report Engine. New reports in the BilTAY Teknoloji SCIENTA system are this easy.
GAAP Financial Statements
There are many financial reports that are available in by clicking the "GAAP Financial Statements" link from the reports tab in the main application. Since there are so many different financial reports available (over 100 Different variations), we provide the financial statement selection screen in table format. Selecting the options that you want and clicking on the printer execute the financial report.
When a financial report is selected for execution, the system is running an ASPX Formatted Report Page against a pre-defined stored procedure to option the result. Both the ASPX Report Page and the stored procedure that drive the reports are completely customizable to meet your needs.
IFRS Financial Statements
There are many financial reports that are available in by clicking the "IFRS Financial Statements" link from the reports tab in the main application. Since there are so many different financial reports available (over 100 Different variations), we provide the financial statement selection screen in table format. Selecting the options that you want and clicking on the printer execute the financial report.
When a financial report is selected for execution, the system is running an ASPX Formatted Report Page against a pre-defined stored procedure to option the result. Both the ASPX Report Page and the stored procedure that drive the reports are completely customizable to meet your needs.
ASPX Report Engine
BilTAY Teknoloji SCIENTA also includes a dynamic report generator that we call the ASPX Report Engine. This reports engine builds a report dynamically based upon a pre-defined stored procedure in the database back-end. This works as follows:
1) The user selects a report stored procedure from the reports engine drop-down list, and presses "Select"
2) If the report has parameters, the parameter table will be populated and the user can enter the information that the report needs to run.
3) The user can now select one of the three displaying options at the bottom of the window:
A) Screen - This will display the report on the screen in a browse-able data grid that supports sorting on any of the fields and paging through large amounts of data.
B) Printer - This will display the report in a format suitable for printing.
C) Excel - This will export the contents of the report directly into excel and load excel so you can work with the results immediately. Once in Excel, you can emancipate the data, export it to various formats, make charts and graphs, and save it separately. You need to have Microsoft Office 2000 or greater for this function to properly work.
The BilTAY Teknoloji SCIENTA system already includes over a hundred standard reports in ASPX Reports Engine format ready to run out of the box. Anyone that can understand simple stored procedures can customize and / or build new stored procedure report formats for use with the reports engine.
Complete Reports List for BilTAY Teknoloji SCIENTA
This list is current as of the 11/17/2004 release.
GAAP Financial Statements
--------------------------------------------------------------------------------
Current Year Standard Balance Sheet
Current Year Standard Balance Sheet By Period
Current Year Standard Balance Sheet By Division
Current Year Standard Balance Sheet By Division By Period
Current Year Standard Balance Sheet By Company
Current Year Standard Balance Sheet By Company By Period
Current Year YTD Balance Sheet
Current Year YTD Balance Sheet By Period
Current Year YTD Balance Sheet By Division
Current Year YTD Balance Sheet By Division By Period
Current Year YTD Balance Sheet By Company
Current Year YTD Balance Sheet By Company By Period
Current Year Comparative Balance Sheet
Current Year Comparative Balance Sheet By Period
Current Year Comparative Balance Sheet By Division
Current Year Comparative Balance Sheet By Division By Period
Current Year Comparative Balance Sheet By Company
Current Year Comparative Balance Sheet By Company By Period
Prior Year Standard Balance Sheet
Prior Year Standard Balance Sheet By Period
Prior Year Standard Balance Sheet By Division
Prior Year Standard Balance Sheet By Division By Period
Prior Year Standard Balance Sheet By Company
Prior Year Standard Balance Sheet By Company By Period
Current Year Standard Income Statement
Current Year Standard Income Statement By Period
Current Year Standard Income Statement By Division
Current Year Standard Income Statement By Division By Period
Current Year Standard Income Statement By Company
Current Year Standard Income Statement By Company By Period
Current Year YTD Income Statement
Current Year YTD Income Statement By Period
Current Year YTD Income Statement By Division
Current Year YTD Income Statement By Division By Period
Current Year YTD Income Statement By Company
Current Year YTD Income Statement By Company By Period
Current Year Comparative Income Statement
Current Year Comparative Income Statement By Period
Current Year Comparative Income Statement By Division
Current Year Comparative Income Statement By Division By Period
Current Year Comparative Income Statement By Company
Current Year Comparative Income Statement By Company By Period
Prior Year Standard Income Statement
Prior Year Standard Income Statement By Period
Prior Year Standard Income Statement By Division
Prior Year Standard Income Statement By Division By Period
Prior Year Standard Income Statement By Company
Prior Year Standard Income Statement By Company By Period
Current Year Standard Direct Cash Flow
Current Year Standard Direct Cash Flow By Period
Current Year Standard Direct Cash Flow By Division
Current Year Standard Direct Cash Flow By Division By Period
Current Year Standard Direct Cash Flow By Company
Current Year Standard Direct Cash Flow By Company By Period
Current Year YTD Direct Cash Flow
Current Year YTD Direct Cash Flow By Period
Current Year YTD Direct Cash Flow By Division
Current Year YTD Direct Cash Flow By Division By Period
Current Year YTD Direct Cash Flow By Company
Current Year YTD Direct Cash Flow By Company By Period
Current Year Comparative Direct Cash Flow
Current Year Comparative Direct Cash Flow By Period
Current Year Comparative Direct Cash Flow By Division
Current Year Comparative Direct Cash Flow By Division By Period
Current Year Comparative Direct Cash Flow By Company
Current Year Comparative Direct Cash Flow By Company By Period
Prior Year Standard Direct Cash Flow
Prior Year Standard Direct Cash Flow By Period
Prior Year Standard Direct Cash Flow By Division
Prior Year Standard Direct Cash Flow By Division By Period
Prior Year Standard Direct Cash Flow By Company
Prior Year Standard Direct Cash Flow By Company By Period
Current Year Standard Trial Balance
Current Year Standard Trial Balance By Period
Current Year Standard Trial Balance By Division
Current Year Standard Trial Balance By Company
Current Year YTD Trial Balance
Current Year YTD Trial Balance By Period
Current Year YTD Trial Balance By Division
Current Year YTD Trial Balance By Company
Current Year Comparative Trial Balance
Current Year Comparative Trial Balance By Period
Current Year Comparative Trial Balance By Division
Current Year Comparative Trial Balance By Company
Prior Year Standard Trial Balance
Prior Year Standard Trial Balance By Period
Prior Year Standard Trial Balance By Division
Prior Year Standard Trial Balance By Company
IFRS Financial Statements
--------------------------------------------------------------------------------
Current Year Standard Balance Sheet
Current Year Standard Balance Sheet By Period
Current Year Standard Balance Sheet By Division
Current Year Standard Balance Sheet By Division By Period
Current Year Standard Balance Sheet By Company
Current Year Standard Balance Sheet By Company By Period
Current Year YTD Balance Sheet
Current Year YTD Balance Sheet By Period
Current Year YTD Balance Sheet By Division
Current Year YTD Balance Sheet By Division By Period
Current Year YTD Balance Sheet By Company
Current Year YTD Balance Sheet By Company By Period
Prior Year Standard Balance Sheet
Prior Year Standard Balance Sheet By Period
Prior Year Standard Balance Sheet By Division
Prior Year Standard Balance Sheet By Division By Period
Prior Year Standard Balance Sheet By Company
Prior Year Standard Balance Sheet By Company By Period
Current Year Standard Income Statement
Current Year Standard Income Statement By Period
Current Year Standard Income Statement By Division
Current Year Standard Income Statement By Division By Period
Current Year Standard Income Statement By Company
Current Year Standard Income Statement By Company By Period
Current Year YTD Income Statement
Current Year YTD Income Statement By Period
Current Year YTD Income Statement By Division
Current Year YTD Income Statement By Division By Period
Current Year YTD Income Statement By Company
Current Year YTD Income Statement By Company By Period
Prior Year Standard Income Statement
Prior Year Standard Income Statement By Period
Prior Year Standard Income Statement By Division
Prior Year Standard Income Statement By Division By Period
Prior Year Standard Income Statement By Company
Prior Year Standard Income Statement By Company By Period
Current Year Standard Direct Cash Flow
Current Year Standard Direct Cash Flow By Period
Current Year Standard Direct Cash Flow By Division
Current Year Standard Direct Cash Flow By Division By Period
Current Year Standard Direct Cash Flow By Company
Current Year Standard Direct Cash Flow By Company By Period
Current Year YTD Direct Cash Flow
Current Year YTD Direct Cash Flow By Period
Current Year YTD Direct Cash Flow By Division
Current Year YTD Direct Cash Flow By Division By Period
Current Year YTD Direct Cash Flow By Company
Current Year YTD Direct Cash Flow By Company By Period
Prior Year Standard Direct Cash Flow
Prior Year Standard Direct Cash Flow By Period
Prior Year Standard Direct Cash Flow By Division
Prior Year Standard Direct Cash Flow By Division By Period
Prior Year Standard Direct Cash Flow By Company
Prior Year Standard Direct Cash Flow By Company By Period
Current Year Standard Trial Balance
Current Year Standard Trial Balance By Period
Current Year Standard Trial Balance By Division
Current Year Standard Trial Balance By Company
Current Year YTD Trial Balance
Current Year YTD Trial Balance By Period
Current Year YTD Trial Balance By Division
Current Year YTD Trial Balance By Company
Prior Year Standard Trial Balance
Prior Year Standard Trial Balance By Period
Prior Year Standard Trial Balance By Division
Prior Year Standard Trial Balance By Company
Other Financial Reports
--------------------------------------------------------------------------------
AR Aging Report
AP Aging Report
10 Column Accounting Worksheets in Excel
Accounts Receivable
--------------------------------------------------------------------------------
Orders & Invoices
AR Transaction Types
Contract Headers
Contract Detail Items
Contract Types
Contract Email List
Order Headers
Order Detail Items
Order Types
Invoice Headers
Invoice Detail Items
Receipts Headers
Receipt Detail Items
Receipt Classes
Receipt Types
Sales & Profit
Customer Sales Detail
Customer Sales Summary
Profitability By Customer
Profitability By Invoice
Customers
Customer Information
Customer Credit References
Customer Ship For Locations
Customer Ship To Locations
Customer Item Cross Reference
Customer Price Cross Reference
Customer Types
Customer Account Statuses
Customer Comments
Customer Contact Log
Customer Contacts
Accounts Payable
--------------------------------------------------------------------------------
Purchases
AP Transaction Types
Purchase Headers
Purchase Detail Items
Payments
Payments Headers
Payment Detail Items
Payment Types
Payment Classes
Payment Methods
Vendors
Vendor Information
Vendor Item Cross Reference
Vendor Price Cross Reference
Vendor Types
Vendor Account Statuses
Vendor Comments
Vendor Contacts
General Ledger
--------------------------------------------------------------------------------
Ledger
Account Statuses
Chart of Accounts
Ledger Transactions
Ledger Transaction Details
Ledger Transaction Types
Ledger Account Types
Ledger Balance Types
Currencies
Currency Types
Invoices By Currency
Orders By Currency
Payments By Currency
Purchases By Currency
Receipts By Currency
Currency Requirements
Currency Positions
Unrealized Gains & Losses
Unrealized Gain & Loss Total
Banking
Bank Accounts
Bank Transactions
Bank Transaction Types
Bank Reconciliation
Bank Reconciliation Summary
Bank Reconciliation Detail
Bank Reconciliation Credits
Bank Reconciliation Debits
Fixed Assets
Fixed Assets
Asset Status
Asset Types
Depreciation Methods
Inventory
--------------------------------------------------------------------------------
Items & Stock
Inventory By Warehouse
Inventory Low Stock Alert
Items
Item Categories
Item Families
Item Types
Item Pricing Codes
Item Pricing Methods
Item Serial Numbers
Sales, Profit & Value
Item Sales Detail
Item Sales Summary
Item Sales History Detail
Item Sales History Summary
Profitability By Item
Top 10 Items By Sales
Top 10 Items By Profit
Inventory Valuation Report
Inventory Valuation Report Average
Inventory Valuation Report FIFO
Inventory Valuation Report LIFO
Inventory Adjustments
Inventory Adjustments Detail
Inventory Adjustment Types
Inventory Assemblies
CRM & Leads
--------------------------------------------------------------------------------
CRM & Leads
Lead Information
Lead Comments
Lead Contacts
Lead Types
All Lead Emails
Weekly Lead Emails
Payroll
--------------------------------------------------------------------------------
Employees
Employees
Employee Details
Employee Types
Sales Commissions
Payroll Processing
Payroll Setup
Payroll Register
Payroll Register Detail
Payroll Items
Payroll Item Types
Payroll Checks
Payroll Check Stubs
Payroll Check Summary
Payroll Check Type
W2 Report
W3 Report
Setup
--------------------------------------------------------------------------------
System Reports
Companies
Divisions
Departments
Audit Trail
Access Permissions
Error Log
Setup Reports
Credit Card Types
Terms
Comment Types
Warehouses
Shipment Methods
Contact Industry
Contact Regions
Contact Source
Contact Type
Taxes
Tax Groups
Tax Groups Detail
EDI Setup
EDI Directions
EDI Document Types
EDI Exceptions
EDI Exception Types
Projects
Project Types |
