Oracle Applications Accounting Overview
Oracle Applications Accounting Overview
Introduction............................................................................................................. 4
Purpose............................................................................................................. 4
Scope................................................................................................................ 4
Structure........................................................................................................... 5
Related documents........................................................................................... 5
Oracle Payables....................................................................................................... 6
Assumptions..................................................................................................... 6
Events............................................................................................................... 6
Accounts........................................................................................................... 7
Accountin entries............................................................................................ !
"otes............................................................................................................... #$
Oracle Receivables................................................................................................ ##
Assumptions................................................................................................... ##
Events............................................................................................................. ##
Accounts......................................................................................................... #%
Accountin entries.......................................................................................... #4
"otes............................................................................................................... #&
Oracle Purc'asin and Inventory...........................................................................%$
Assumptions................................................................................................... %$
Events............................................................................................................. %$
Accounts......................................................................................................... %$
Accountin entries.......................................................................................... %$
"otes............................................................................................................... %$
Oracle (i)ed Assets............................................................................................... %$
Assumptions................................................................................................... %$
Events............................................................................................................. %$
Accounts......................................................................................................... %$
Accountin Entries.......................................................................................... %$
"otes............................................................................................................... %$
Encumbrance Accountin...................................................................................... %$
Assumptions................................................................................................... %$
Events............................................................................................................. %$
Accounts......................................................................................................... %$
Accountin entries.......................................................................................... %$
"otes............................................................................................................... %$
Open en closed...................................................................................................... %$
Open............................................................................................................... %$
Closed................................................................................................. %$
Introduction
*'ile implementin Oracle Applications t'ere is o+ten a need +or an
interated +unctional overvie, on -ournal entries. .'is need is especially
+elt ,'en setup discussions are on ,it' t'e customer and decisions 'ave
to be made. .'e customer enters t'e discussions +rom a +unctional point
o+ vie,.
.'e available Oracle in+ormation and documentation is +ramented and
detailed. (or eac' module or application separate manuals e)ist. .'ese
manuals are +ocused on descriptions o+ ,indo,s and speci/c +unctions.
As part o+ t'e Practice 0evelopment pro-ect o+ Oracle .'e "et'erlands a
document is created t'at covers t'e accountin issues in Oracle
Applications in an interated ,ay. .'is is t'e result.
Purpose
.'e purpose o+ t'is document is to create an overvie, o+ t'e accountin
entries in Oracle Applications in a suc' a ,ay t'at1
#. t'e determination o+ t'e system accounts ta2es place in a structured
,ay. In practice3 as part o+ t'e implementation3 t'e customer ,ill
determine t'e c'art o+ accounts. O+ten system accounts are not ta2en
into account.
%. t'e document can be used as pro-ect documentation and in+ormation
to e)plain setup decisions. .'is is also t'e case +or (ast(or,ard
implementations +or ,'ic' all decsions already 'ave been made.
Scope
.'is document covers t'e +ollo,in applications1 4eneral 5eder3
Receivables3 Payables3 Cas' 6anaement3 (i)ed Assets3 Pro-ect
Accountin3 Purc'asin3 Order Entry en Inventory. Ot'er E78usiness
applications are not in t'e scope o+ t'is document. Cas' 6anaement is
covered as part o+ Payables and Receivables. Purc'asin3 Order Entry and
Inventory are 'andled in one c'apter.
(or eac' Application assumptions are made concernin t'e setup. .'ese
are made on base o+ best practices in .'e "et'erlands.
.'is document is +ocused on setup related options t'at a9ect t'e content
and structure o+ -ournal entries.
Ot'er topics t'at are not in t'e scope o+ t'is document1
#. "e, developments in +uture releases are not ta2en into account. .'is
document is solely based on Release ##.5: ##i.
%. .'e setup o+ t'e accountin ;e)/eld.
<. Reportin issues and tools li2e (S4 and Oracle discoverer.
ii
4. Speci/c intercompany and consolidation issues.
5. .ec'nical speci/cations o+ tables and prorams t'at support t'e
accountin process in Oracle Applications.
Structure
(or eac' application you ,ill /nd a separate c'apter. Eac' c'apter 'as t'e
+ollo,in content1
#. Eac' c'apter starts ,it' assumptions t'at 'ave been made. 6ost
assumptions are made on base o+ best practice in .'e "et'erlands.
%. In t'e second part t'e events o+ t'e application are described. An
event is a trier t'at causes a -ournal entry in 4eneral 5eder. .'e
events ,ill be used to cateori=e t'e accounts and -ournals t'at are
described in t'e ne)t parts.
<. .'e t'ird part ives an overvie, o+ t'e accounts t'at are part o+ t'e
setup o+ t'e application. (or eac' account a relation is made to one or
more events. A second table3 ,it' t'e same accounts3 ives an
overvie, in ,'ic' +orms t'e setup o+ t'at account 'as to ta2e place.
4. .'e +ourt' part s'o,s +or eac' event t'e structure and content o+ t'e
-ournal. .'is in+ormation is presented in a table.
5. (inally eac' c'apter ends ,it' notes.
A separate c'apter is introduced to cover encumbrance accountin.
Encumbrance accountin is related to Purc'asin3 Oracle Payables and
4eneral 5eder.
Related documents
#. (ast (or,ard documents
%. Accountin;o, in Oracle R##I voor Canon Consumer Imain
4roup by 5uu2 de >o2. ?ersion #3 dated %# auustus %$$#.
<. Oracle Payables @ser 4uide3 Release ##i3 -anuary %$$$.
4. @nloc2in t'e 6ystery o+ Encumbrance Accountin by ?ictoria
5eavy.
iii
Oracle Payables
In t'is c'apter accountin issues are described +or t'e application Oracle
Payables. .'is application covers t'e purc'ase invoice and payment
processes. .o be able to reconcile t'e payments it is best practice to
implement Cas' 6anaement as ,ell. .'e accountin entries t'at are a
result o+ reconciliation are processed by Oracle Payables.
(or encumbrance related issues see c'apter Encumbrance Accountin.
Assumptions
#. .'e Account +or Payment option is set to 8ot'. .'is means accountin
entries ,ill be created at t'e time o+ payment AcreationB and at t'e
time o+ payment reconciliation by usin Cas' 6anaement. In previous
releases o+ Oracle Applications t'is +eature ,as 'andled by t'e Allo,
Reconciliation Accountin option.
%. .'e Account +or 4ain:5oss option is set to 8ot' as ,ell. .'is means t'at
+orein currency losses and ains are recorded at t'e moment o+ t'e
payment issue and at t'e moment o+ t'e payment clearin.
<. Automatic *it''oldin .a) Payables is not used.
4. .'e accountin met'od is set to Accrual 8asis Accountin. .'is means
you create accountin entries +or invoices and payments by usin t'e
liability account. ACas' 8asis Accountin only creates accountin
entries +or t'e paymentB
5. .'e Automatic O9set 6et'od is set to 8alancin. .'is means t'e
liability accounts ,ill 'ave t'e same balancin sement value as t'e
accounts t'at are entered in t'e invoice distributions.
6. .'e pooled ban2 account option is set on yes. .'is means t'e ban2
account is s'ared by multiple balancin sement values.
7. Interest Invoicin ma2es it possible to create an interest invoice +or an
overdue invoice at t'e time o+ payment. Separate accounts are used to
record t'e accountin entries. .'is +eature is not commonly used in t'e
"et'erlands and t'ere+ore not recorded as an event in t'is c'apter.
!. .a) and +rei't are included.
Events
AP
Even
t nr.
Event name GL Source GL Category Notes
# Invoice Payables Purc'ase Invoice *'en ad-ustin or cancellin an
invoice t'e same accounts are
used. Only debit : credit ,ill be
reversed.
iv
AP
Even
t nr.
Event name GL Source GL Category Notes
% Prepayment Payables Purc'ase Invoice *'en ad-ustin or cancellin a
prepayment t'e same accounts
are used. Only debit : credit ,ill be
reversed.
< Prepayment application Payables Purc'ase Invoice *'en unapplyin a prepayment
t'e same accounts are used. Only
debit: credit ,ill be reversed.
4 Payment Payables Payment *'en ad-ustin or voidin a
payment t'e same accounts are
used. Only debit: credit ,ill be
reversed.
5 Payment maturity Payables Payment .'is event ta2es only place ,'en
t'e Account +or Payment *'en
Payment is Issued option is
enabled.
6 Reconciliation Payables Reconciled
Payment
*'en unreconcilin a payment
t'e same accounts are used. Only
debit: credit ,ill be reversed.
Accounts
ype ! " # $ % &
5iability 5iability ' ' ' '
E)pense E)pense '
Prepayment Asset ' '
(uture dated payment Asset '
PO rate variance ain Revenue '
PO rate variance loss E)pense '
0iscount E)pense '
Reali=ed ain Revenue '
Reali=ed loss E)pense '
Roundin E)pense
(rei't E)pense '
Interest invoice
e)pense
E)pense
Interest invoice
liability
5iability
Cas' clearin Asset ' ' '
Cas' Asset '
8an2 c'ares E)pense '
8an2 errors E)pense '
.a) Asset '
(inancia
ls
options
Payable
options
Supplie
r )Site
*an+
accou
nt
Payables
document
s
a, Invoice
5iability C ' ' '
E)penseCC '
Prepayment ' '
(uture dated payment
C
' ' ' '
PO Rate variance ain '
PO Rate variance loss '
0iscount C '
Reali=ed ain C ' '
Reali=ed loss C ' '
v
(inancia
ls
options
Payable
options
Supplie
r )Site
*an+
accou
nt
Payables
document
s
a, Invoice
Roundin C:CCC '
(rei't ' '
Interest invoice
e)pense
'
Interest invoice
liability
'
Cas' clearin C ' '
Cas' C '
8an2 c'ares C ' '
8an2 errors C ' '
.a) ' '
C.'ese are t'e accounts +or ,'ic' automatic o9sets are created.
CC.'is account is enerated by Account 4enerator ,'en t'e invoice is
related to a pro-ect.
CCC.'e roundin account ,ill be used ,'en1
#. Dou use multiple currencies and t'e payment currency does not
round ,it'in t'e payment currency precision.
%. .'e +unctional currency amounts o+ payments do not eEual t'e
amount recorded as t'e liability.
<. Dou 'ave enabled automatic o9sets and t'e cas' account is
pooled3 and you 'ave roundin errors.
*'et'er t'e +uture dated payment account is used +rom t'e supplier site
or t'e payables document is de/ned by t'e Payables Option F@se (uture
0ated PaymentG.
#7
Accounting entries
AP-! Invoice
Accounting entry .ebit Credit
E)pense Aor AP AccrualBC '
.a) '
(rei't '
5iability '
PO rate variance ain: lossCC /'0 /'0
Invoice Price varianceC /'0 /'0
C .'is ,ill be t'e AP Accrual account in case t'e AP invoice is matc'ed to
a Purc'ase Order and t'e item used on t'e Purc'ase order is an inventory
item. .'e AP Accrual account is an orani=ation parameter and is can be
+ound in t'e Oracle Purc'asin and Inventory C'apter.
CC .'ese accountin entries can only be created ,'en an invoice is
matc'ed to a purc'ase order.
vi
AP-" Prepayment
Accounting entry .ebit Credit
Prepayment '
5iability '
AP-# Prepayment Application
Accounting entry .ebit Credit
Prepayment '
5iability '
*'en applyin an invoice to a prepayment3 t'e prepayment 'as to be
paid. Only t'en t'e prepayment is available.
AP-$ Payment
Accounting entry .ebit Credit
5iability '
Cas' clearin '
0iscount '
Reali=ed ain: loss /'0 /'0
In case o+ a +uture dated payment t'e +uture dated payment account is
used instaead o+ t'e cas' clearin account. At time o+ maturity t'e +uture
dated payment is credited. 0iscount and reali=ed ain: loss is recorded at
t'e time o+ maturity.
PA-% Payment maturity
Accounting entry .ebit Credit
(uture dated Payment '
Cas' clearin '
0iscount '
Reali=ed ain: loss /'0 /'0
PA-& Reconciliation
Accounting entry .ebit Credit
Cas' '
Cas' clearin '
Reali=ed ain: loss /'0 /'0
8an2 c'ares '
8an2 errors '
vii
Notes
#. Automatic o9set only e+ects t'e accounts t'at are mar2ed ,it' C. Ot'er
accounts can only be balanced by manual entries in Oracle 4eneral
leder.
%. Automatic o9set is only relevant ,'en more t'an one balancin
sement value is used in an Operatin @nit.
<. Automatic o9set does not support Interest invoicin. Ho,ever Interest
invoicin is not common practice in .'e "et'erlands.
4. .'e pooled ban2 account option is only relevant ,'en more t'an one
balancin sement value is used in an Operatin @nit.
5. (uture dated payments are not common practice in .'e "et'erlands.
.'is +unctionality ma2es a di9erence bet,een issuin o+ a payment
and t'e moment a payment is mature. Only ,'en a payment is mature
Astatus o+ t'e payment is "eotiableB it is possible to clear t'e payment
by usin Cas' 6anaement. .o use t'is +eature t'e option @se (uture
0ated Payment Account 'as to be set to Payment 0ocument or Supplier
Site.
6. "ever c'ane accountin options in t'e payment Accoutin Payables
Options +orm. .'is could create inconsistent accountin entries in t'e
system.
7. .'e PO Rate ?ariance 4ain and 5oss accounts are only used in case you
matc' an invoice ,it' a purc'ase order t'at involves inventory items.
!. .'e e)pense clearin account in previous releases o+ Oracle
Applications does not e)ist anymore in Release ##i.
viii
Oracle Receivables
In t'is c'apter accountin issues are described +or t'e application Oracle
Receivables. .'is application covers t'e sales invoice and collection
processes. .o be able to reconcile t'e receipts it is best practice to
implement Cas' 6anaement as ,ell. .'e accountin entries t'at are a
result o+ reconciliation are processed by Oracle Receivables.
.,o main types o+ receipts can be distinuis'ed1
#. Cas' receipt. .'is is a receipt t'at potentially is lin2ed to an
outstandin item. *'en t'e outstandin item Aand t'e related liability
accountB can not be +ound a de+ault liability account ,ill be used.
%. 6iscellaneous receipt. .'is is a receipt t'at is not related to an
outstandin item. Instead o+ usin a liablity account3 any type o+
account can be used. .'ese account are related to receivable activities.
Assumptions
#. Clearance met'od I 8y 6atc'in
%. .'e accountin met'od is set to Accrual 8asis Accountin. .'is means
you create accountin entries +or transactions and receipts by usin
t'e liability account. ACas' 8asis Accountin only creates accountin
entries +or t'e receiptB
<. "o unallocated receipts are recorded.
4. Receipt remittance by usin t'e (actorin met'od is not in t'e scope.
Events
AR
Even
t nr.
Event name GL Source GL Category Remar+s
# Invoice AreularB Receivables Sales Invoices
% 8ill in arrears invoice Receivables Sales Invoices 0etermined by t'e invoicin rule
t'at is used in t'e more tab o+ t'e
transactions ,indo,. .'e revenue
reconition proram creates t'e
accountin entries.
< 8ill in advance Invoice Receivables Sales Invoices 0etermined by t'e invoicin rule
t'at is used in t'e more tab o+ t'e
transactions ,indo,. .'e revenue
reconition proram creates t'e
accountin entries.
4 0ebit memo Receivables 0ebit 6emos
i)
AR
Even
t nr.
Event name GL Source GL Category Remar+s
5 Credit memo Receivables Credit 6emos .'is event ta2es place by usin
t'e Credit transactions ,indo,s.
6 Apply credit memo to
invoice
Receivables Credit 6emo
Applications
7 On7account credit Receivables Credit 6emos On account credits are credits t'at
are not applied to a speci/c
transaction. .'is event ta2es place
by usin t'e Credit transactions
,indo,s or by applyin a receipt.
! Ad-ustment Receivables .'is event ta2es place ,'en usin
a separate ,indo,. It can be
positive or a neative ad-ustment.
& 0eposit Receivables A deposit is bein created by
usin t'e .ransactions ,indo,.
#$ Invoice applied to deposit Receivables Sales Invoices Application ta2es place by /llin
out t'e /eld Commitment in t'e
.ransactions ,indo,.
## 4uarantee Receivables A uarantee is bein created by
usin t'e .ransactions ,indo,.
#% Invoice applied to
uarantee
Receivables Sales Invoices Application ta2es place by /llin
out t'e /eld Commitment in t'e
.ransactions ,indo,.
#< Applied receipt Receivables .rade Receipts .'is is event includes a discount.
Also valid +or receipts on a deposit
and uarantee.
#4 @napplied receipt Receivables .rade Receipts
#5 @nidenti/ed receipt Receivables .rade Receipts .'is is t'e case ,'en a Acas'B
receipt 'as no customer. .'ese
can not be applied.
#6 C'ane +rom unidenti/ed
to unapplied
Receivables .rade Receipts
#7 C'ane +rom on account
to applied
Receivables .rade Receipts
#! On account receipt Receivables .rade Receipts .'is is t'e case ,'en a Acas'B
receipt 'as a customer but cannot
be related to a speci/c
transaction.
#& 6iscellaneous receipt Receivables 6isc Receipts .'is receipt is not matc'ed to an
invoice. .'e revenue account is
derived +rom t'e receivable
activity.
%$ Receipt ,it' discount Receivables .rade Receipts
%# Receipt Ato be remittedB Receivables .rade Receipts Create a receipt t'at needs to be
remitted by t'e ban2 AFincasso
tapeGB
%% Remittance o+ t'e receipt Receivables Remittance
%< Reconciliation o+ t'e
remitted receipts
Receivables @sin Cas' 6anaement
Accounts
ype ! " # $ % & 1 2 3 !4 !! !" !# !$
Reali=ed ain Revenue '
Reali=ed loss E)pense '
@nallocated Revenue Revenue
Cross currency
roundin
E)pense
Header roundin E)pense
Cas' Asset ' '
8an2 c'are E)pense ' '
Receipt con/rmation Asset
Remitted receipt Asset
)
ype ! " # $ % & 1 2 3 !4 !! !" !# !$
(actored receipt Asset
S'ort term debt
@napplied receipt Asset ' '
@nidenti/ed receipt Asset
On account receipt Asset
Receivable Asset ' ' ' ' ' ' ' ' ' ' ' '
Revenue Revenue ' ' ' ' ' ' ' '
Clearin Asset
@nbilled receivable Revenue ' ' '
@nearned revenue Revenue ' ' ' ' '
.a) 5iability ' ' ' ' ' ' '
(rei't Revenue ' ' ' ' ' ' '
Earned discount Revenue
@nearned discount Revenue
Ad-ustment A,rite7o9B E)pense '
8an2 Error E)pense ' '
(inance C'are Revenue '
6isc. Cas' Revenue
ype !
%
!& !1 !2 !3 "4 "! "" "#
Reali=ed ain Revenue
Reali=ed loss E)pense
@nallocated Revenue Revenue
Cross currency
roundin
E)pense
Header roundin E)pense
Cas' Asset ' ' ' ' '
8an2 c'ares E)pense ' '
Receipt con/rmation Asset ' '
Remitted receipt Asset ' '
(actored receipt Asset
S'ort term debt
@napplied receipt Asset ' ' ' '
@nidenti/ed receipt Asset ' '
On account receipt Asset '
Receivable Asset ' ' '
Revenue Revenue '
Clearin Asset
@nbilled receivable Revenue
@nearned revenue Revenue
.a) 5iability
(rei't Revenue
Earned discount Revenue '
@nearned discount Revenue '
Ad-ustment A,rite7o9B E)pense
8an2 error E)pense ' '
(inance C'are Revenue
6isc. cas' Revenue '
System
options
*an+
accounts
rans.
ypes
Custo
mer
Site
Sales Rep a, Receivable
activity
Reali=ed 4ain '
Reali=ed 5osses '
@nallocated Revenue '
Cross currency
roundin
'
Header roundin '
Cas' '
8an2 c'ares '
)i
System
options
*an+
accounts
rans.
ypes
Custo
mer
Site
Sales Rep a, Receivable
activity
Con/rmed receipts '
Remitted receipts '
(actored receipts '
S'ort term debt '
@napplied receipts '
@nidenti/ed receipts '
On account receipts '
Receivable C ' ' '
Revenue C ' ' '
Clearin C ' '
@nbilled receivableC ' '
@nearned revenueC ' '
.a) C ' ' ' '
(rei't C ' ' '
Earned discount '
@nearned discount '
Ad-ustment A,rite7o9B '
8an2 Error '
(inance C'are '
6isc. Cas' '
C .'ese are accounts t'at can be manaed by Auto Accountin.
#7
Accounting entries
AR-! Invoice regular
Accounting entry .ebit Credit
Receivable '
Revenue '
.a) '
(rei't '
AR-" *ill in arrears invoice
Accounting entry .ebit Credit
@nbilled Receivable '
Revenue '
.a) '
(rei't '
0ependin on t'e 8ill in arrears rule t'e revenue ,ill be ta2en in di9erent
periods and t'e -ournal entry above ,ill be enerated eac' time.
Accounting entry .ebit Credit
@nbilled Receivable '
Revenue '
.a) '
(rei't '
@nbilled Receivable '
)ii
Accounting entry .ebit Credit
Receivable '
At t'e /nal period t'e unbilled Receivable is trans+erred to Receivable. At
t'at time t'e sales invoice ,ill be enerated and send to t'e customer.
.'e amount o+ t'e Receivable entry is t'e total o+ all t'e @nbilled
receivable entries t'at 'ave been recorded in t'e previous periods.
AR-# *ill in advance invoice
Accounting entry .ebit Credit
Receivable '
@nearned revenue '
.a) '
(rei't '
@nearned revenue '
Revenue '
At t'e /rst period t'e total receivable amount is recorded and an invoice
is sent to t'e customer. .'e revenue ,ill be recorded in t'e comin
periods as it is de/ned in t'e 8ill in advance invoicin rule.
Accounting entry .ebit Credit
@nearned revenue '
Revenue '
AR-$ .ebit memo
Accounting entry .ebit Credit
Receivable '
Revenue '
.a) '
(rei't '
Receivable '
(inance c'are '
AR-% Credit memo
Accounting entry .ebit Credit
Receivable '
Revenue '
.a) '
(rei't '
)iii
AR-& Apply credit memo to invoice
Accounting entry .ebit Credit
Receivable '
Receivable '
AR-1 On-account credit
Accounting entry .ebit Credit
Receivable '
Revenue '
An on7account credit can be a credit on Revenue3 .a) or (rei't. .'e
-ournal entry above is a credit on Revenue.
AR-2 Ad5ustment
Accounting entry .ebit Credit
Receivable '
Ad-ustment '
.'e entry above is a postive ad-ustment. Ad-ustment must be seen as a
,rite7o9. Ad-ustment entries can be made in combination ,it' receipts.
AR-3 .eposit
Accounting entry .ebit Credit
Receivable '
@nearned revenue '
AR-!4 Invoice applied to deposit
Accounting entry .ebit Credit
Receivable '
Revenue '
.a) '
(rei't '
@nearned revenue '
Receivable '
AR-!! Guarantee
Accounting entry .ebit Credit
@nbilled receivable '
)iv
Accounting entry .ebit Credit
@nearned revenue '
AR-!" Invoice applied to guarantee
Accounting entry .ebit Credit
Receivable '
Revenue '
.a) '
(rei't '
@nearned revenue '
@nbilled receivable '
AR-!# Applied receipt
Accounting entry .ebit Credit
Cas' '
8an2 c'are '
8an2 error '
Reali=ed ain: loss /'0 /'0
Receivable '
@napplied receipt '
@napplied receipt '
.'e moment o+ creatin t'is -ournal entry is dependent on t'e settin
Clearance 6et'od in Receipt classes. *'en t'e met'od is set to 0irectly
t'e entry is created at t'e time o+ processin t'e receipt. I+ t'e met'od is
set to 8y 6atc'in t'e entry is created at t'e time o+ clearin t'e receipt
by Oracle Cas' 6anaement.
AR-!$ 6napplied receipt
Accounting entry .ebit Credit
Cas' '
8an2 c'are '
8an2 error '
@napplied receipt '
AR-!% 6nidenti7ed receipt
Accounting entry .ebit Credit
Cas' '
8an2 c'are '
8an2 error '
@nidenti/ed receipt '
AR-!& C8ange 9rom unidenti7ed to unapplied
)v
Accounting entry .ebit Credit
@nidenti/ed receipt '
@napplied receipt '
AR-!1 C8ange 9rom unidenti7ed to unapplied
Accounting entry .ebit Credit
Receivable '
@napplied receipt '
AR-!2 On account receipt
Accounting entry .ebit Credit
Cas' '
8an2 c'are '
8an2 error '
On account '
@napplied receipt '
@napplied receipt '
AR-!3 :iscelleneous receipt
Accounting entry .ebit Credit
Cas' '
6isc. cas' '
A miscelleneous receipt is a receipt t'at is not related to an outstandin
item.
AR-"4 Receipt ;it8 discount
Accounting entry .ebit Credit
Cas' '
Receivable '
Receivable '
Revenue '
Receivable '
0iscount Aearned: unearnedB '
AR-"! Receipt /to be remitted0
Accounting entry .ebit Credit
Receipt con/rmation '
@napplied receipt '
)vi
Accounting entry .ebit Credit
@napplied receipt '
Receivable '
AR-"" Remittance o9 t8e receipt
Accounting entry .ebit Credit
Remitted receipt '
Receipt con/rmation '
AR-"# Reconciliation o9 t8e remitted receipts
Accounting entry .ebit Credit
Cas' '
Remitted receipt '
Notes
#. .'e pro/le option AR1 @se Invoice Accountin +or Credit 6emos
determines t'e ,ay accountin entries +or credit memos are
enerated. I+ t'is option is set to Des t'en Receivables credits t'e
oriinal transaction. *'en t'e option is set to "o3 Receivables uses
AutoAccountin to determine t'e accounts.
%. *'en enterin a credit memo you 'ave to c'oose a Rulin 6et'od and
a Split .erm 6et'od. .'e options +or bot' are (I(O3 5I(O and prorate.
.'ese rules do not e9ect t'e -ournal entries t'emselves. .'e met'ods
determine ,'at element o+ t'e invoice 'as to be credited.
<. .'e accounts (actored receipt and S'ort term debt are only used +or
remittances ,'en usin t'e +actorin met'od.
4. .'e -ournals AR7%$3 AR7%# and AR7%% are related to t'e JIncassoK
+unctionality. .'is is common practice in t'e "et'erlands.
)vii
Oracle Inventory< Purc8asing and Order Entry
In t'is c'apter accountin issues are described +or Oracle Purc'asin and
Inventory. Only actual -ournal entries are included in t'is c'apter.
Encumbrances are 'andled in a separate c'apter.
Assumptions
#. Inventory is not used in a manu+acturin environment. 4oods are
received3 moved bet,een orani=ations and sold.
%. Receivin o+ oods is done in t,o steps. .'e /rst step is receivin
t'e oods +or inspection. .'e second step is to deliver t'e oods to
t'e inventory or ot'er department .
Events
IN=
Even
t nr.
Event name GL Source GL Category Remar+s
# Receipt o+
inventory item
Purc'asin Accrual: Receivin .'e cateory depends on t'e ,ay
receipt accountin is 'andled. .'e
cateory accrual is used ,'en t'e
met'od is period end. Receivin is used
,'en t'e receipt -ournal is enerated
directly.
% Receipt o+ e)pense
item
Purc'asin Accrual: Receivin .'e same.
< 0eliver Purc'asin Accrual: Receivin .'e same.
4 Return to vendor
Aoods not in
stoc2B
Purc'asin Accrual: Receivin .'e same.
5 Return to vendor
Aoods in stoc2B
Purc'asin Accrual: Receivin .'e same.
6 Sales order
s'ipment
Inventory Inventory
7 Cycle count
ad-ustment
Inventory Inventory
! 6iscelleneous
.rans+er
Inventory Inventory
& Interor. .rans+er Inventory 6.5
#$ Subinventory
.rans+er
Inventory 6.5
)viii
Accounts
ype ! " # $ % & 1 2 3 !4
Receivin Inspection Asset ' ' ' '
Purc'ase Price
?ariance
E)pense ' '
Receivable Asset '
Payable 5iability '
Intrasit Inventory Asset '
6aterial Asset ' ' ' ' ' ' '
Outside Processin Asset
6aterial Over'ead Asset
Over'ead Asset
Resource Asset
E)pense E)pense '
Invoice Price ?ariance E)pense
Inventory AP Accrual 5iability ' ' ' '
Sales Revenue
Cost o+ 4oods Sold
ACO4SB
E)pense '
Cost ?ariance Account E)pense
Cycle count
ad-ustment
E)pense '
Scrap E)pense '
Ot8er Organi>atio
n
Subinvento
ry
Receivin Inspection '
Purc'ase Price
?ariance
' '
Receivable ' '
Payable ' '
Intrasit Inventory '
6aterial ' '
Outside Processin ' '
6aterial Over'ead ' '
Over'ead ' '
Resource ' '
E)pense ' ' '
Invoice Price ?ariance '
Inventory AP Accrual '
Sales '
Cost o+ 4oods Sold '
Cost ?ariance Account '
Cycle count
ad-ustment
'
Scrap '
Accounting entries
IN=-! Receive to Inspect
Accounting entry .ebit Credit
Receivin inspection '
Inventory AP AccrualC '
)i)
C .'is account ,ill be posted 0ebit ,'en matc'in an AP Invoice to t'e related Purc'ase order.
IN=-" .eliver to Inventory
Accounting entry .ebit Credit
6aterialC '
Receivin inspection '
Purc'ase Price ?ariance /'0 /'0
? In case o+ t'e use o+ an e)pense item on t'e related Purc'ase order3 t'is account ,ill be an
e)pense item.
IN=-# Return to =endor /Goods not in stoc+0
Accounting entry .ebit Credit
Inventory AP Accrual '
Receivin inspection '
IN=-$ Return to =endor /Goods in stoc+0
Accounting entry .ebit Credit
Inventory AP Accrual '
Receivin inspection '
Accounting entry .ebit Credit
Receivin inspection '
6aterial '
Purc'ase Price ?ariance /'0 /'0
IN=-% Receive an E,pense Item
Accounting entry .ebit Credit
E)pense account '
Inventory AP Accrual '
IN=-& Sales Order S8ipment
Accounting entry .ebit Credit
CO4S '
6aterial '
))
IN=-1 Cycle count ad5ustments
Accounting entry .ebit Credit
Cycle count ad-ustment /'0 /'0
6aterial /'0 /'0
IN=-2 :isc. trans9er
Accounting entry .ebit Credit
Scrap '
6aterial '
IN=-3 Interorg trans9er
Accounting entry .ebit Credit
6aterial AOrani=ation AB '
6aterial AOrani=ation 8B '
Accounting entry .ebit Credit
Receivable AOrani=ation 8B '
.rans+er Cost '
Accounting entry .ebit Credit
Intrasit '
Payables AOrani=ation AB '
IN=-!4 Subinventory trans9ers
Accounting entry .ebit Credit
6aterial AAB '
6aterialA8B '
Notes
))i
Oracle (i,ed Assets
8e+ore ,e o into t'e details o+ Events3 Assumptions3 Accounts en
Accountin Entries3 t'is c'apter ives a lobal introduction o+ t'e
terminoloy used ,it'in assets concernin +unctionality t'at in;uences
t'e construction o+ -ournal transactions.
CIP versus Capitali>ed transactions.
Assets supports t'ree types o+ Assets3 JCapitali=edK3 JCIPK and
JE)pensedKL every Assets 'as a correspondin status.
#. JE)pensedK 'as no Asset -ournals as a resultL t'e cost o+ assets
'as been ta2en Aas e)penses in t'e PM5B in t'e period t'e purc'ase
invoice ,as distributed in eneral 5eder.
%. JCIPK Assets are not Det depreciatedL
<. And JCapitali=edK
Assets support t'e +ollo,in Events1 +or3 JCapitali=edK and JCIPK
transactionsL
Additions L
0epreciation L
Ad-ustments L
.rans+ers L
Reclassi/cations L
RevaluationGs L
Retirements and L
.a) accountin.
0ependin on t'e type o+ an Asset3 t'e transaction ,ill be a CIP
transaction or a Capitali=ed transaction.
In t'e t'ird part o+ t'is c'apter ,'ere ,e ,ill describe t'e -ournal
transactions. (or JAdditionsK t'e -ournals +or JCIPK and JCapitali=edK ,ill
be discussed separately 3 +or all ot'er events Capitali=ed type ,ill be
described. .'e bi di9erence ,it' CIP is t'at CIP assets ,ill not
depreciate3 and 'as no Jaccumulated deprecationK to account +or in all
ot'er events.
Asset @CorporateA< @a,A and @*udgetA boo+s types
Dou cannot allo, eneral leder postin +or your budet boo2s.
Asset boo2s o+ t'e .ype J.a)K and JCorporateK produce -ournal lines i+ you
allo, 4:5 Postin +or t'is Asset 8oo2.
))ii
E,pensed versus Amorti>ed Ad5ustmentsB
An ad-ustment mi't in;uence t'e 'istorical depreciation calculation in
retrospect. .'e correction can be ta2en Ae)pensedB in t'e current asset
period3 or can be spread over t'e remainder o+ an asset li+e Aamorti=edB.
8ot' Ad-ustments types are part o+ t'e 0utc'Gs best practice. .'e
di9erence is not really t'e -ournal A,itc' accounts are 'itB3 but t'e
di9erence is t'e ,ay t'e amounts are calculated.
.'e only di9erence in t'e accounts t'at are 'it is t'e depreciation -ournal.
0epreciation -ournals +or E)pensed ad-ustments 'ave one e)tra -ournal
lineL .'e depreciation e)pense Aad-ustmentB line ,'ic' represents t'e
part o+ t'e depreciation e)pense t'at is a result o+ t'e ad-ustment. It is
t'e depreciation e)pense +or t'e current period as a result o+ t'e
ad-ustment on top o+ t'e normal periodic depreciation.
Prior period transactions versus Current Period transactionsB
Any transaction can be relevant +or depreciation as o+ t'e period t'e
transaction ,as made in. 8ut it can also in;uence t'e depreciation o+ any
number o+ prior periods in t'e same /scal year. I+ a transactions is sub-ect
to prior period e9ect. It does not in;uence t'e -ournal +rom t'e prior
period addition 3 ad-ustment3 trans+er3 reclassi/cation or retirement itsel+3
but t'e depreciation transaction as a result o+ a prior period transaction is
di9erent as a depreciation transaction as a result o+ current period
transaction
))iii
Assumptions
"ot all +unctionality o+ Oracle (i)ed Assets is ,ill be discussed in t'e
remainder o+ t'is c'apter. (or t'e 0utc' best practice t'e +ollo,in
assumptions are made1
0epreciation 6et'od Set up1
depreciate an asset in t'e year it is retired is set to Des
0epreciation 8oo2s N Calendar Set up1
depreciate assets in t'eir /rst year o+ li+e is set to "o
0epreciation 8oo2s N Accountin rules Set up1
Allo, Amorti=e c'anes is set to Des
Allo, Revaluation is set to Des
Revalue accumulated 0epreciation I Des 3 because t'e J"oK7
option ,ill trans+er t'e accumulated depreciation to t'e
revaluation reserve on every revaluation. Amorti=ation o+
Revaluation Reserve or Retire Revaluation reserve I Des3 t'ere
are not bot' no.
revaluation o+ +ully reserved asset is not limitedL AemptyB
0epreciation 8oo2s N "atural Accounts Set up1
Every account /eld3 'as a separate valueL
only e)ception is t'e ain and loss account +or COR I ACost o+
removalB it can be # value. .'e same oes +or POS APro/t o+
SaleB and "8? A"et 8oo2 ?alueB retired.
Intercompany Receivables and Payables clearin account
numbers are speci/c accounts +or Assets3 t'ey can 'ave t'e
same value.
.'e de+ault Account enerator Account is a balance s'eet
account ,it' al ot'er sement set to =ero value Anot
applicableBL
.a)7boo2 setup
t'ere are no .a) boo2s de/nedL
Investment .a) Credits are not usedL
li+e e)tension +actor I A#3$B L and no li+e e)tension ceilin L
"o Asset cost3 0epreciation3 Revaluation and E)pense Ceilins
are used
0e+erred Income .a) 5iabilityL is not used
no Ad-ustment Current Earnins depreciation rules and 8oo2s
are used.
))iv
Events
.'e Asset accounts +or 4eneral 5eder transactions are a result o+ t'e
reconi=ed Events3 Assumptions made in previous pararap's3 and t'e
Account enerator set up.
Per Event (A7#3 (A7% e)t3 t'e most common variations o+ t'e relevant
accountin entries a mentioned in t'e Remar2 section o+ t'e table belo,.
Event
number
Pre7,C(A
Event name GL Category Remar+
# Payables3 Pro-ect
and t'ird party
create 6ass
Additions.
Purc'ase
Invoice
Pro-ects
@ser de/ned
0i9erent oriinate +rom
PayablesL Create 6ass Additions
Pro-ectsL Create 6ass Additions OOO
SP57loader
% Asset 6ass Addition
5ine 0eletions
":a PS .'is event is mentioned because it
speci/cally 'as no 45 transaction as a result.
.'e transaction s'ould be made manually or
be avoided by only deletin 6ass addition
lines i+ you also delete a correspondin 6ass
addition credit line.
< Additions Addition
CIP Addition
0i9erent Qournals +or Additions because o+1
A<aB Capitali=ed and A<bB CIP Additions
Current and Prior period additionsL
A<cB Sinle and mered Additions
A<dB is t'e prior period e9ect o+ t'is
transaction
4 Capitali=ation o+ CIP
Assets
CIP Addition 0i9erent Qournals +or capitali=ation because o+1
Capitali=ationGs A4aB in t'e period and A4bB
A+ter t'e period t'e asset ,as added.
C'ane Asset type to CIP A4cB 0e7
capitali=ationL PS AIt can only be don as a
current period transactionB
5 Periodic
0epreciation
Depreciation 0i9erent Qournals +or 0epreciation because o+1
A5aB 0epreciation +or Assets ,it'out
ad-ustments and amorti=ed ad-ustments3 or
A5bB ,it' E)pensed ad-ustmentsL
A5cBL 0epreciations +or Revaluated Assets and
Parameter1 Amorti=e Revaluation Reserve I
Des
6 Ad-ustments Ad-ustments
CIP Ad-ustment
0i9erent Qournals +or Additions because o+1
6aB E)pensed ad-ustment o+ recoverable
cost L
6bB Amorti=ed ad-ustment o+ recoverable cost
L
6cB .rans+er o+ Source lines +rom assets added
in a prior period ,itc' result in trans+er o+
cost3 trans+er o+ depreciation3 and trans+er o+
e)pense.
A6dB .rans+er o+ Source lines +rom assets
added in t'e current periods or
A6eB Addin mass addition lines to an e)istin
Asset.
Ps. 0epreciation 6et'od3 5i+e Ad-ustments3 Rate
Ad-ustments and capacity Ad-ustments do not
directly result in -ournal transactions. 0ependin
on t'e e9ect t'ey 'ave on t'e depreciation t'e
,ill in;uence t'e amounts o+ t'e depreciation
transaction Aamorti=ed or E)pensedB
7 .rans+er
As a
assinment
trans+er
Or as number
o+ unit
.rans+er
CIP trans+er
0i9erent Qournals +or Additions because o+1
A7aB .'e trans+er bet,een cost centers results
in trans+er o+ cost and depreciation +or
current period trans+ersL
A7bB +or t'e prior period e)pense part in a
prior period trans+er.
))v
Event
number
Pre7,C(A
Event name GL Category Remar+
ad-ustment A7cB.'e trans+ers bet,een balancin
sements
! Reclassi/cation Reclass M
CIP Reclassi/cation
0i9erent Qournals +or Reclassi/cation because o+1
A!aB Current Reclassi/cation3 and
A!bB Prior period Reclassi/cationGsL
Purc'ases Commitment
< Purc'ase order Purc'asin
Purc'ases Obliation:
Commitment
*'en reservin or approvin
a Purc'ase Order.
4 Cancel Purc'ase order Purc'asin
Purc'ases Obliation
5 Invoice Aunmatc'edB Payables Purc'ase
Invoice
Invoice *'en approvin t'e invoice.
6 Invoice Amatc'edB Payables Purc'ase
Invoice
Invoice:
Obliation
*'en postin t'e -ournals
+rom AP to 45.
7 Receipt Purc'asin