...
1.1 Current State of Accounting Integration
- Mifos can generate XML output (Vouchers) on daily basis which can be exported to an Accounting Software.
- Mifos can show the Vouchers in Mifos UI for verification before generating XML output for a date range.
- Mifos Chart of Account has to be mapped using alias in an Accounting Software to be able to export XML output
1.2 Next State of Accounting Integration
- Mifos can export the Vouchers in Accounting Software automatically.
- Mifos can detect what data have been exported into the Accounting Software
- Mifos can provide more details of the Voucher at drill down from UI
- Avoid Duplicates and better error handling.
1.3 Purpose
Define "Accounting software interface for Mifos accounting Integration"(AMI) in order to achieve integration between accounting software and Mifos.
...
Mifos Accounting Integration: Integration of an Accounting Software with Mifos.
Common Integration Layer (CIL): Mifos Accounting Integration interacts with AMI using XML messaging which is called CIL. Mifos only understand/expect the CIL messaging from AMI.
Accounting software interface for Mifos accounting Integration (AMI): Implementation specific to an Accounting Software deployed on the Accounting Software side(ex. Tally ERP, MS Dynamics e.t.c.). In other words, a module developed in Accounting Software to support the "Common Integration Layer". AMI provides a Common Integration Layer which is controlled by Mifos.
Vouchers ("Consolidated Transactions" or "Accounting Data") : Transactions in Mifos are grouped by Branch/Office, Date and combination of "Financial Action" to "Account Action" which are called Mifos Vouchers, i.e. an Accounting software understandable formate of Mifos transactions.
There are 3 types of Vouchers in Mifos
- PAYMENT
- RECEIPT
- JOURNAL
2. AMI requirements
2.1 Base requirements
- Running as a service on a known port at localhost which will take an XML request and provide XML response.
- Additional response header "Access-Control-Allow-Origin: http://*.mifos.org" , Stored as KEY=VALUE pair
- Does mapping of Mifos "Chart of Account"(One Level GL) to Accounting software "Chart of Account" (Multi level GL)
- Read/Write access for KEY=VALUE pair at AMI storage.
- Maintains mapping of Mifos Voucher ID and Accounting Software specific ID to detect duplicates.
- Returns error code and message for voucher export failure, or return master id with success message
- Query status of export in case a process is taking more than 10 secs, return how much vouchers have been exported. (RUNNING, NUMBER OF VOUCHERS REMAINING)
- There will be two request parameters which AMI will understand.
1. COMMAND - One word instruction send to the AMI, based on which AMI knows what to do with the DATA
2. DATA - used by AMI to process some instruction
2.2 Request <-> Response protocol for CIL implemented by AMI
...