When your new business is going well. Branches open in New Zealand, Australia and Hong Kong. New branches sites secured in China (2) London and Paris. Your own Software development group is supporting the trading desks with new high feature releases but the back office, support is almost entirely manual. Reuters exchange rate feeds, location of deposits across a dozen currencies and 20 bank accounts and the daily reconciliation of trades, deposits, add-on costs and trade by trade profit is entirely managed by hand. With daily exposure, risk and profit reporting to the Board plus the plans this group has for expansion never mind the Reserve Bank reporting regime somethings gotta give…..

International Foreign Exchange Bank with offices in Hong Kong, Australia, England, China, France and New Zealand and Web based trading

Using existing simple Accounting package Exchequer to manuallyconsolidate trades but wanted to formulate integration between their trading desk software and an ERP package. At the same time the businesswanted to automate some parts of the business; in particular theupdating of the exchange rates and location of direct bank deposits tomatch the buy/sell amounts of the trades.

Much of the development was experimental – it was a first in theexperience of the bank to automate these trading features. They were notan Open Source development shop and so required that all modificationsoutside ADempiere were done in the .Net framework. All of thisdevelopment was done during a time of sustained growth so it put specialdemands on the people who operate the system and still maintain thebusiness.

Training was to be done by “seeing and doing” live with theimplementation. Their own development house collaborated with the Hong Kong Head Office remote from the development site.
Eventually it was designed so that the pilot project would be adopted by all the branches in the network of offices.

Reduce license Costs for ERP software while expanding the use ofthe system world wide Integrate all functions for trading and profitreporting. Provide fresh functionality outside the ADempiere package to update live exchanger rate quotes and assist in locating deposits that match the trading transactions recorded through the trading desk.

Integrated transactions through to profit reporting. Many scenarios and trading rules to mimic within the ADempiere processing environment so that individual ticket trades had their profits recognised correctly.
Extensions to the Bank Reconciliation process – separate from ADempiere Complies with Reserve Bank reporting regulations

McBoss migrated the bank from their existing system to ADempiereover Oracle 10g Database. The solution has been in service from 2005(initially in Compiere) and is now entirely supported by their own software development services. The solution is in use at their headoffice and through out the world wide branches.

• ADempiere ERP /CRM
• Oracle 10g
• .Net Tools
• Java J2EE

• Lower transaction costs
• More transactions handled by fewer back room staff
• Compliance with Reserve Bank reporting requirements
• Improved Reporting
• Simpler Bank reconciliation
• Fewer Orphaned deposits and incomplete transactions because ofmatches to Deposits
• Better isolation of profitability due to exchange trade feesrather than relying on on cost items.

• Data Mapping
• Data Migration
• Modification to the Adempiere User interface
• Modification to the import process into ADempiere
• Development of Custom “Parent Child” Screens for single glimpse view of trades
• Assistance with design of Trade transaction to best use ADempiere features
• Integration to Reuters real time currency updates.
• Development of Custom Reports
• Java programming
• .Net programming
• Accounting Assistance
• Project Management
• Implementation and End User training
• Documentation