SAP ERP Integration with iBill
What is SAP ERP
SAP ERP is enterprise resource planning software developed by SAP.
Mainly Used
- To manage the business and automate many back-office functions related to technology, services, and human resources.
- By Backend Team with minimal interfaces available for Front End Team and Customers
What is iBill
iBill is a Recurring Billing Solution for Real Estate developed by Factech.
Mainly Used
- To manage billing & collection-related operations after Units handover to Customer.
By Front End Team and Customers with integrations with Backend System
Why iBill & SAP Integration
- Increase transparency for Customer/ Facility & Finance Team
- Real-time update & Notification to Customer of Payments/ Bills.
- Delegation & Control to Facility Team with real-time data availability.
- Increase effectiveness in System as SOA/ Ledger etc. available to Facility & Customer on their Mobile App
- Less Error-Prone – Backend updated automatically without any human intervention.
SAP Integration-Strategy
Below Fields of SAP mapped in iBill so that both System can synch:
-
- SAP / Customer Code –Against the Unit in iBill.
- Charge Head (like – CAM, ELE) and their respective GL Codes –Against the Charges in ISM
- Tax Code and their respective GL Codes – Against the Tax at Charge Level in ISM
- Bill Plan– Against the Bill Type in iBill – like Electricity, Maintenance etc.
- Site Id – Against the Society in ISM
- Company Code – Unique Entity Code in SAP
REST Webservices with Security Key decided as Communication Protocol between two Systems with request/response in JSON format.
SAP Integration Approach
So far 2 Approaches:
- Complete Control at iBill( iBill) i.e. Invoice generation and Payment entries in iBill & SAP consuming (Pulling) the payments, debit & credit notes/ bills generated in iBill. – This is most preferred one
- Invoice generated in SAP & pulled by iBill. Payment Transaction ( Debit & Credit Notes) generated in iBill and consumed by SAP.
In both cases Unit Master Data is imported from SAP in xls and updated in iBill . No update moves back to SAP in Unit Details automatically.
Bill Webservices to be Consumed by SAP
API URL: https://api.isocietymanager.com/v1/site//bill?criteria=&billing_month=
Field | Parameter Name | Parameter Type | M/O | Detail |
Sap Code | sapcode | String | C* | Unit Sap Code |
Search Criteria | criteria | String | C* | Cluster/Tower/Unit |
Billing Month | billing_month | String | M | Billing Month |
Bill Plan | bill_plan | String | O | CAM/ Electricity etc. |
Sample Response (JSON Format): which is consumed by SAP
{“status”:”success”,
“data”:[{“company_code”:”5001”,”sap_code”:”VV-D08-01-01″,“unit_no”:”D08-01-01″,”tower”:”D08″, “billing_month”:”201901″, “billing_date”:”2019-01-03″, “urn”:”000027971562328″,”invoice_no”:“INV 18-19\/ 715”,“bill_plan”:”CAM”,
“bill“:[
{“Late payment charges”:”001058.50″, “charge_code”:“LPC101“, “hsn_code”:”9553”},
{“Cheque bounce”:”000000.00″, “charge_code”:“CHQB001″, “hsn_code”:”9554”},
{“CAM Collection”:”005061.20″, “charge_code”:“CAM001″, “hsn_code”:”9555”, “tax_code”:“0”}]}
Note:- bold are sap fields, urn is unique id for traceability
Payment Webservices to be Consumed by SAP
API URL: https://api.isocietymanager.com/v1/site///transactions ?
Field | Parameter Name | Parameter Type | M/O | Detail |
Sap Code | sapcode | String | C* | Unit Sap Code |
Search Criteria | criteria | String | C* | Cluster/Tower/Unit |
From Date | from_date | String | O | From Date |
To Date | to_date | String | O | To Date |
Sample Response (JSON Format): which is consumed by SAP
{“status”:”success”,”data”:[{“sapcode”:”VV-A-18-03″,“flat_no”:”A-18-03″,
“transaction”:{“amount”:”6000″,”date”:”2019-01-10 19:45:38″,”type”:”PAYMENT”,”transaction_mode”:”ONLINE”,“transaction_no”:”20190110111212800110168700952224251″,”chque_date”:”2019-01-10 19:45:38″,”bank”:”PAYTM”,”urn”:”000000000000000000175289P00940″, “remarks”:”VV-A-18-03 paying for amount Rs. 6000″, “tds”:”0″, “bills”:[{“invoce_no”:”INV-18-19\/709″}], “bill_plan”:”CAM“ }}
Note:- bold are sap fields, urn is unique id for traceability
Postman Collection
https://www.getpostman.com/collections/3a7d0fdc668619ed0caf
Related links
https://factech.co.in/blog/ufaqs/what-details-required-to-tally-integration-with-isocietymanager/
Leave a Reply
You must be logged in to post a comment.