Select an item and view the sales and profit graph in Microsoft Access.

 

You'll have unlimited access to your OSAS data with the following ODBC-compliant software packages:	Microsoft Access Microsoft Excel Microsoft Word Lotus 1-2-3 WordPerfect	Crystal Reports dBase IV FoxPro Database many more

Report Applets are available with a Microsoft Excel PivotTable for each of the major files in each application. For example, in the Accounts Receivable applet, you will find tables for customers, open invoices, transactions, detail history, summary history, and more. The number of spreadsheets varies by application. You'll be amazed at how easy it is to use these tables; you'll never look at your accounting data the same way again!

This PivotTable displays transaction history from the Payroll Transaction History file. From here you can sort on Employee ID or Transaction Date.

ODBC Kit applet reposts included:

 

Accounts Receivable Aging History Sales Analysis Cash Receipts Customer Sales Analysis Customer Sales History Detail Sales History Payment History Item History Methods of Payment Open Invoices Sales Journal Tax Report Sales History Kit History Recurring Journal Sales Journal Tax Report Accounts Payable Analysis Checks Check History Check Detail Detail History Payment History Tax History Summary Invoice History Item History Vendor History Vendor Analysis Tax Report Purchase Order Order Detail Invoice Detail Invoice Totals Purchase Requisitions Receipt of Goods Transaction Summary

Inventory Bin Analysis COGS Adjustments History Detail Location Detail Location Pricing Lot Detail Lot History Physical Counts Price Structures Quantity Detail Quantity Totals Requisitions Serialized History Serial Numbers Summary History Transactions Unit Pricing Vendor Information General Ledger Budget Detail Comparative Analysis Forecast Detail Journal Payroll Checks Check Deductions Check Earnings Check History Check Withholdings Department Analysis Employee History Employee Deduction History Employee Earnings History Employee Withholding History Leave History Recurring Deductions Recurring Time Tickets Miscellaneous Deduction History Time Ticket History

Bill of Materials/Kitting Bill of Materials Detail History Journal Master Header Transactions Job Cost Job Cost Code Detail History Sales and Purchases History Payroll Job Cost Jobs Analysis Fixed Assets Asset Books Asset Master Retired Asset Books Retired Asset Master Bank Reconciliation Bank Account List Journal Recurring Adjustments Transactions Direct Deposit Current Vouchers Master List Voucher History