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 are handovered to Customers.

https://factech.ai/ibill 

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:

1.  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
2. 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/<site-id>/bill?criteria=&billing_month=

Sample Response (JSON Format): 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/<site-id>//transactions ? 

Sample Response (JSON Format): 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.ai/blog/ufaqs/what-details-required-to-tally-integration-with-isocietymanager/