INTERFACE DOCUMENT
Oracle Apps Implementation
Accounting Document
Author:
Creation Date: February 16, 2018
Last Updated: March 7, 2018
Version: Version 1.1
Document Control
Change Record6
Date Author Version Change Reference
16-Feb-18 Santosh Krishna 1.0
7-Mar-18` Santosh Krishna 1.1
Reviewers
Name Position
Ashok Dash Director
Distribution
Copy No. Name Location
1
2
3
4
Approval
Copy No. Name Signature
1 Ashok Dash Director
2
3
Note to Holders:
If you receive an electronic copy of this document and print it out, please write your name on the
equivalent of the cover page, for document control purposes.
If you receive a hard copy of this document, please write your name on the front cover, for
document control purposes.
ICT Health - Confidential
2
Contents
Document Control ...................................................................................................................2
Interface Accounting Document ...........................................................................................4
Process Flow .....................................................................................................................4
IP Cash Sale .......................................................................................................................5
IP Credit Sale ....................................................................................................................5
ICT Health - Confidential
3
Interface Accounting Document
Process Flow
ICT Health - Confidential
4
IP Cash Sale
The Invoice Flow from HINAI to Oracle after approved the Invoice in HINAI.
Accounting Entry:
Particular Debit Credit
Trade Account Receivables / IP Cash XXXX
[Link] Cash Sales XXXX
[Link] Cash Sales XXXX
Round Off XX
IP Credit Sale
The Invoice Flow from HINAI to Oracle after approved the Invoice in HINAI. System will
generate the Separate invoice for Customer like TPA/Insurance/Corporate
ICT Health - Confidential
5
Accounting Entry:
Particular Debit Credit
Trade Account Receivables / (TPA/Insurance/Corporate) XXXX
[Link] Credit Sales XXXX
[Link] Credit Sales XXXX
Round Off XX
OP Cash Sale
The Invoice Flow from HINAI to Oracle after approved the Invoice in HINAI.
ICT Health - Confidential
6
Accounting Entry:
Particular Debit Credit
Trade Account Receivables / (OP Cash) XXXX
DEPT1. OP Cash Sales XXXX
DEPT2. OP Cash Sales XXXX
Round Off XX
OP Credit Sale
The Invoice Flow from HINAI to Oracle after approved the Invoice in HINAI. System will
generate the Separate invoice for Customer like TPA/Insurance/Corporate
ICT Health - Confidential
7
Accounting Entry:
Particular Debit Credit
Trade Account Receivables / (OP Cash) XXXX
DEPT1. OP Cash Sales XXXX
DEPT2. OP Cash Sales XXXX
Round Off XX
TPA/Corporate Settlement with TDS and Write-Off
TPA / corporate Adjustment will done by the user in Oracle and the same data will flow to
HINAI.
Accounting Entry:
TDS Entry :
Particular Debit Credit
Trade Account Receivables / (TPA/Corporate/Insurance) XXXX
TDS Receivables XXXX
Receipt Entry:
Particular Debit Credit
Confirmed Cash XXXX
Unapplied Cash / (TPA/Corporate/Insurance) XXXX
Write Off:
Particular Debit Credit
Write Off XXXX
Trade Account Receivables / (TPA/Corporate/Insurance) XXXX
TDS Accounting Entry :
ICT Health - Confidential
8
Receipt Entry:
Write Off:
Invoice Cancellation:
The Transaction will be initiated in HINAI against Invoice at the same time the system will create the
Credit Memo against the Invoice.
Accounting Entry:
Credit Memo Entry:
ICT Health - Confidential
9
Particular Debit Credit
Trade Account Receivables / (TPA/Corporate/Insurance) XXXX
Revenue Account XXXX
Accounting Entry Flow:
Receipt Cancellation:
The Transaction will be initiated in HINAI against Receipt Number at the same time the system will
Reverse the Receipt in Oracle.
Receipt Cancellation Entry:
Particular Debit Credit
Unapplied Cash XXXX
Confirmed Cash XXXX
ICT Health - Confidential
10
Cash / Credit Refund:
The Transaction will initiate in HINAI and after approval of the Refund against the refund request.
Refund Entry initiation in AR :
Particular Debit Credit
Unapplied Cash XXXX
Patient Refund Control Account XXXX
AP Invoice Accounting Entry:
Particular Debit Credit
Patient Refund Control Account XXXX
Trade Payables Control Account XXXX
ICT Health - Confidential
11
AP Invoice Payment Accounting Entry:
Particular Debit Credit
Trade Payables Control Account XXXX
Cash / Bank Account XXXX
Credit Memo Refund:
This Transaction will initiate in HINAI and after approval of the Refund Request the refund will be made
in HINAI.
ICT Health - Confidential
12
Credit Memo refund Account entry.:
Particular Debit Credit
Trade Receivables XXXX
Patient Refund Control Account XXXX
AP Invoice Accounting Entry:
Particular Debit Credit
Patient Refund Control Account XXXX
Trade Payables Control Account XXXX
AP Invoice Payment Accounting Entry:
Particular Debit Credit
ICT Health - Confidential
13
Trade Payables Control Account XXXX
Cash / Bank Account XXXX
On- Account Receipts:
The Transaction will be initialized in Oracle.
Receipt Accounting Entry:
Particular Debit Credit
Cash / Bank Account XXXX
Deposit from Patient (On-account Cash) XXXX
Revenue Reco.:
Service Group Wise Revenue Reconciliation.
ICT Health - Confidential
14
ICT Health - Confidential
15
Interface between SCM & Finance Module Accounting Entries.
GRN Creation:
While Creating the GRN in the SCM the system will automatically pass the below Accounting entry.
Particular Debit Credit
Material Account XXXX
Inventory AP Accrual Account XXXX
Supplier Return:
While doing the Supplier Return the SCM will pass the below accounting entry.
Particular Debit Credit
ICT Health - Confidential
16
Material Account XXXX
Inventory AP Accrual Account XXXX
Invoice Validation:
While Validating the invoice the below accounting entry will generate in the Finance Module.
Particular Debit Credit
Inventory AP Accrual Account XXXX
Trade Payables Account XXXX
Debit Memo Validation:
Particular Debit Credit
Inventory AP Accrual Account XXXX
Trade Payables Account XXXX
Invoice Accounting Screen Shot.
ICT Health - Confidential
17
Debit Memo Screen Shot.
Invoice Payment:
While doing the payment for invoice after validation the below accounting entry.
Particular Debit Credit
Trade Payables Account XXXX
Cash / Bank Clearing Account XXXX
ICT Health - Confidential
18
ICT Health - Confidential
19