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

https://factech.co.in/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 CodeUnique 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//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

Related posts

Latest posts

Leave a Comment

Leave a Reply