Looking for a VB/SQL Server expert to build a Client Server Accounting Application to provide automation and accuracy in carrying out the necessary Accounting tasks.
The Accounting system must be able to handle all accounting functionality related to sales and shipping activities and must be automatically be able to provide comprehensive, user-friendly functionality that manages the Accounts Payable, Accounts Receivable, credit card processing, as well as providing powerful reporting capabilities. We have SQL Server7 Database which gets fed from a Web application.
A C C O U N T S P A Y A B L E
The system should be able to automatically or on-demand, generate payables of all transactions. With Keyboard or point-and-click functionality, the completed transactions must be accurately added to Payable Batches
Credit and Debit operations must update transactions and later must be added to Payable Batches
A C C O U N T S R E C E I V A B L E
The Accounts Receivable must automatically inform the system user when it is time to send out invoices
System users can be able to quickly and accurately create "Sales Invoices" on individual as well as group of corporations belonging to a certain category, with each invoice representing an particular corporation based on the business done for that billing period.
Invoices must be built "manually" by passing data from VB form as well as "automatically" getting the data from the Database
Completed Sales Invoices must be printed automatically or on demand and "posted" accordingly
Upon receiving the monies to settle an invoice, you have to consider cases where if a partial payment is made against an invoice in that case you nedd to automatically as well as manually CREDIT/DEBIT and show a balance left.
A report querying the corporations which has an open balance of (parameter $$$) to be printed. You can design the report either in Crystal Report designer or Data Reports in VB6
C R E D I T C A R D P R O C E S S I N G
System must be capable of handling real-time credit card transactions as well as getting authorization for a given amount from all major credit card companies like Master card, Visa, Discover, Diner’s Club , American Express.
M A N A G E M E N T R E P O R T S
Based on actual up-to-the-minute data the system must produce management reports. Data in these reports are initially calculated on the basis of st
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
Windows NT/2000 with ASP, IIS, VB6 and MSSQL Server7.0
## Deadline information
The Accounting Application can be further categorized in to four smaller groups of functionality
* Accounts Recievable
* Accounts Payable
* Credit Card Procesing
Proper documentation describing the functionality is not an absolute necessity but is desired
You must be able to complete each group in 2-3 weeks and payment will be made in part after completion of each group