I need an online application which will have Currency exchange (sales, purchase, Sales and Purchase return, remittance) General Ledger, Administration.
The system is a Multi Company, Multi Location and Multi Currency application. The application has comprehensive system setup routine where the Company, Locations, Currencies, Account setup, User Security and Financial Year setup is defined.
The User security, in a Multi Company, Multi Location environment plays and important role. The amount of access to be provided to the users is to be clearly defined based on the company's policies of accountability and responsibility.
The Maintenance module is only accessible to the highest authority of the company and / or to the System Supervisor as the core function of the application setup is effected here (The supervisor account which will be created after the creation of table schema).
The setup of the various functions in this module must be carried out under the supervision of a qualified Database Supervisor. The access to this module should also be limited to the key people of the Company.
The Currency Exchange module, as the name suggests, revolves around the transactions related to the Remittance, Purchase and Sales of Currencies by the company. The customers and the Agents / Banks of the company along with their profiles are defined in this module. All the transactions related to Remittance, Purchase and Sales of the currencies either in cash or on credit are passed here. The module supports comprehensive reporting function in terms of transactions edit list, etc. (write more details of the reports).
This module is tightly inter-linked to the General Ledger module. The transactions of the Customer and Agent are posted in the form of Journal Vouchers to the control accounts in the General Ledger module through posting routines. The receivables and the payables of the company are updated on an on line basis. However, the postings are to be effected on a daily basis to get the on-line balances.
The primary function of this module is to maintain the information in terms of the Inward and Outward Remittances of currencies, total currency Purchases / Sales of the company and generate invoices, both cash and credit. The details of daily Remittances, cash Purchases / Sales transactions and credit Purchases / Sales along with Credit / Debit card Purchase / Sales and Sales Returns are also maintained here. The Report function provides comprehensive reports to help management plan their sales strategy and maximize returns.
This will be the Welcome screen of eDealer, or could be anything neat if creating menu is less time consuming then its okay to have icon on this screen to call the others. The icon image file should be parameterize we could be set in Main core administration module.
This module is the core of the accounting process carried out in the company and maintains all the account heads for the main accounts along with their balances. The Voucher entry option of this module allows the entries for Receipts and Payments for cash and bank transactions and adjustment entries through the Journal Voucher entry option. The transactions can be passed manually and by locations', whereas the sub-ledger transactions from various modules are posted here in the form of system journal vouchers.
All the reports relating to the final accounts of the company such as the transactions edit list, statement of accounts, trial balance, profit and loss account and the balance sheet are available in this module. The other modules of DEALER integrate with this module through posting procedure and the figures of the sub ledgers are posted to the control accounts in the General Ledger.
This is a general system specifications and I will provide FSD level II, once I have shortlisted atleast 5 companies to work on this kind of project. System should work on mySql and Oracle both databases and will have PHP as front end based on Ajax to increase response performance.