![Page 1: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/1.jpg)
sdf
Oracle Applications - EBS - Accounting Entries
SR NO PROCESS LINK1 Back To Back2 Drop Ship3 SO- Work Order4 Inter Org5 ISO6 Procure to Pay7 Receipt To Cash8 AR Adjustments9 Standard Cost Update
10 Miscellaneous Receipt11 Miscellaneous Payments12 Manual Work Order Creation & Completion
Please send your comments at [email protected] and keep visiting www.erpstuff.com.
www.erpstuff.com
B2B!A1DP!A1SOW
INTER_ORGISOP2PO2CADJ
STD COSTMISC REC
Misc.PaymentsMOW
![Page 2: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/2.jpg)
Version : 1.012-Jan-09
Please send your comments at [email protected] and keep visiting www.erpstuff.com.
![Page 3: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/3.jpg)
BACK TO BACK
SR.NO PARTICULARS DR CR SPL NOTESI Back to Back
1 Sales Order EntryNo Accounting
2 Creation of RequisitionNo Accounting
3 Creation of Purchase OrderNo Accounting
4 ReceiptReceiving A/c 100 At PO PriceAP Accrual A/c 100 At PO Price
5 DevliveryRaw Material Sub Inventory A/c 80 At Standard CostPPV A/c 20 Diff between PO - Stnd Receiving A/c 100 At PO Price
6 ReservationNo Accounting
7 PickingStaging Sub Inventory A/c 80 At Standard CostSub Inventory A/c 80 At Standard Cost
8 ShippingCOGS 80 At Standard CostStaging Sub Inventory A/c 80 At Standard Cost
www.erpstuff.com
![Page 4: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/4.jpg)
BACK TO BACK
ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
Receiving Option Setup ORGInventory Org Setup ORG
Sub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaultedInventory Org Setup ORGReceiving Option Setup ORG
Sub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaultedSub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaulted
Item Org Level A/c willl get defaulted, OMTTSub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaulted
www.erpstuff.com
![Page 5: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/5.jpg)
DROP SHIP
SR.NO PARTICULARS DR CR SPL NOTESI Drop Ship
1 Sales Order EntryNo Accounting
2 Creation of RequisitionNo Accounting
3 Creation of Purchase OrderNo Accounting
4 ReceiptReceiving A/c 100 At PO PriceAP Accrual A/c 100 At PO Price
5 DevliveryRaw Material Sub Inventory A/c 80 At Standard CostPPV A/c 20 Diff between PO - Stnd Receiving A/c 100 At PO Price
6 ReservationNo Accounting
7 PickingStaging Sub Inventory A/c 80 At Standard CostSub Inventory A/c 80 At Standard Cost
8 ShippingCOGS 80 At Standard CostStaging Sub Inventory A/c 80 At Standard Cost
www.erpstuff.com
![Page 6: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/6.jpg)
DROP SHIP
ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
Receiving Option Setup ORGInventory Org Setup ORG
Sub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaultedInventory Org Setup ORGReceiving Option Setup ORG
Sub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaultedSub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaulted
Item Org Level A/c willl get defaulted, OMTTSub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaulted
www.erpstuff.com
![Page 7: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/7.jpg)
SO-WORKORDER FLOW
SR.NO PARTICULARS DR CR SPL NOTES1 At the time of material issue
WIP Material A/c 100Subinventory material A/c 100
2 Resource Valuation
WIP Resource valuation A/c 100Resource Absorption A/c 100
3 Overhead Cost (Material)
WIP Material ovehead A/c 10Sub inventory material overhead A/c 10
4 Overhead Cost (Indirect)WIP Overhead A/c 100 Overhead absorption A/c 100
5 WIP Job Completion
Stagging/Completion Sub-inventory A/c Std CostWIP Material A/cWIP Resource valuation A/cWIP Material ovehead A/c WIP Ooverhead A/cWIP Material Variance A/c Diff between Actual - STDWIP Resource Variance A/c Diff between Actual - STDWIP Material Variance A/c Diff between Actual - STDWIP Ooverhead Variance A/c Diff between Actual - STD
5 PickingStaging Sub Inventory A/c 100 At Standard CostSub Inventory A/c 100 At Standard Cost
6 ShippingCOGS 100 At Standard CostStaging Sub Inventory A/c 100 At Standard Cost
www.erpstuff.com
![Page 8: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/8.jpg)
SO-WORKORDER FLOW
ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
WIP ClassOrg/Subinventory
WIP ClassResource Defination Form
WIP ClassOrg/Subinventory
WIP ClassOverheads Defination Form
Org/SubinventoryWIP ClassWIP ClassWIP ClassWIP ClassWIP ClassWIP ClassWIP ClassWIP Class
Sub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaultedSub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaulted
Item Org Level A/c willl get defaulted, OMTTSub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaulted
www.erpstuff.com
![Page 9: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/9.jpg)
INTER ORG/INTERNAL SALES ORDERS
SR.NO PARTICULARS DR CR 1
Intransit Inventory A/c ( Sending Org ) 100Sub Inventory A/c ( Sending Org ) 100
Inter–Organization Receivable( Sending Org ) 100Intransit Inventory A/c ( Sending Org ) 100Sub Inventory A/c ( Receiving Org ) 100Inter–Organization Payable ( Receiving Org ) 100
2
Intransit Inventory A/c ( Sending Org ) 100Sub Inventory A/c ( Sending Org ) 100
Inter–Organization Receivable( Sending Org ) 100Intransit Inventory A/c ( Sending Org ) 100Inter–Organization Receivable( Sending Org ) 15Freight Expense A/c ( Sending Org ) 15Inter–Organization Receivable( Sending Org ) 10Inter–Org. Transfer Credit ( Sending Org ) 10Subinventory A/C (Receiving Org) 100Purchase Price Variance(Receiving Org) 25Inter–Organization Payable (Receiving Org) 125
3
Inter–Organization Receivable (Sending Org) 100Sub Inventory A/c ( Sending Org ) 100Intransit Inventory A/c (Receiving Org) 100Inter - Organization Payable (Receiving Org) 100
Sub Inventory A/c (Receiving Org) 100Intransit Inventory A/c (Receiving Org) 100
4
Inter–Organization Receivable (Sending Org) 100Sun Inventory A/c (Sending Org) 100Sub Inventory A/c (Receiving Org) 100
FOB Point is set to Receipt without Charges & Freight - Using Transaction Type - Intransit
Entry at the time of ISSUE
Entry at the time of RECEIPT
FOB Point is set to Receipt with Charges & Freight - Using Transaction Type - Intransit
Entry at the time of ISSUE
Entry at the time of RECEIPT
FOB Point is set to Shipment without Charges & Freight - Using Transaction Type - Intransit
Entry at the time of ISSUE
Entry at the time of RECEIPT
Direct Inter–Organization Transfer without FOB being Receipt and without transfer credit and freight
![Page 10: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/10.jpg)
Inter - Organization Payable (Receiving Org) 100
5
Inter–Organization Receivable (Sending Org) 120Sub Inventory A/c (Sending Org) 100Inter–Org. Transfer Credit ( Sending Org ) 10Freight Expense A/c ( Sending Org ) 10
Sub Inventory A/c (Sending Org) 100Purchase Price Variance (Receiving Org) 20Inter - Organization Payable (Receiving Org) 120
6 If the Standard Cost is different in Sending & Receving Org
Intransit Inventory A/c (Sending Org) 100Sub Inventory A/c (Sending Org) 100
Sub Inventory A/c (Receiving Org) 120Inter - Organization Payable (Receiving Org) 100Purchase Price Variance (Receiving Org) 20
Direct Inter–Organization Transfer with FOB being Receipt with transfer credit and freight
Entry at the SOURCE
Entry at the DESTINATION
Entry at the time of ISSUE
Entry at the time of RECEIPT
![Page 11: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/11.jpg)
INTER ORG/INTERNAL SALES ORDERS
SPL NOTES ACCOUNT IS PULLED SPECIFIC
At Standard Cost Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORG
At Standard Cost Shipping Network ORGAt Standard Cost Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORGAt Standard Cost Shipping Network ORG
At Standard Cost Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORG
At Standard Cost Shipping Network ORGAt Standard Cost Shipping Network ORG
Shipping Network ORGAt Transaction LevelShipping Network ORGShipping Network
At Standard Cost Sub-inventory Material A/c SetupShipping NetworkShipping Network ORG
At Standard Cost Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORG
Shipping Network ORGShipping Network ORG
At Standard Cost Sub-Inventory Material A/c Setup ORGAt Standard Cost Shipping Network ORG
At Standard Cost Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORGAt Standard Cost Sub-inventory Material A/c Setup ORG
www.erpstuff.com
transfer credit and freight
![Page 12: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/12.jpg)
At Standard Cost Shipping Network ORG
Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORG
Shipping Network ORGAt transaction level ORG
At Standard Cost Sub-inventory Material A/c Setup ORGShipping Network ORGShipping Network ORG
At Standard Cost Shipping Network ORGAt Standard Cost Sub-inventory Material A/c Setup ORG
At Standard Cost Sub-inventory Material A/c Setup ORGShipping NetworkShipping Network
![Page 13: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/13.jpg)
OPTION AVAILABLE
![Page 14: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/14.jpg)
PROCURE TO PAY
SR.NO PARTICULARS DR CR SPL NOTES1 Creation of Requisition
No Accounting
2 Creation of Purchase OrderNo Accounting
3 ReceiptReceiving A/c 100 At PO PriceAP Accrual A/c 100 At PO Price
4 DevliveryRaw Material Sub Inventory A/c 80 At Standard CostPPV A/c 20 Diff between PO - Stnd Receiving A/c 100 At PO Price
5 Invoice matching with POAP Accrual Liability A/c 100 At PO PriceInvoice Price Variance A/c 10 Diff between Invoice - POAP Liability A/c 110 AT INV Price
6 On making PaymentLiability A/c 110 At Invoice PriceCash 110 At Invoice Price
www.erpstuff.com
![Page 15: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/15.jpg)
PROCURE TO PAY
ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
Receiving Option Setup ORGInventory Org Setup ORG
Sub-inventory Material A/c Setup SUB-INV Org Level A/c willl get defaultedInventory Org Setup ORGReceiving Option Setup ORG
Receiving Option Setup ORGInventory Org Setup ORGFinancial Options/Supplier Site
Financial Options/Supplier SiteBank A/c Setup
www.erpstuff.com
![Page 16: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/16.jpg)
Order To Cash Cycle
SR.NO PARTICULARS DR CR 1 Sales order entry
No Accounting
2 Sales Order Pick
From Sub Inventory A/c 100To Sub Inventory A/c 100
3 Sales Order Issue
COGS 100To Sub Inventory A/c 100
4 Transaction level
Receivable A/c 120Tax A/c 10Frieght A/c 10Revenue A/c 100
Receipts
5 Receipts with no remittance method
Cash 100Unapplied A/c 100
Unapplied A/c 100Receivables A/c 100
Cash A/c 100Unidentified A/c 100
Unidentifed A/c 100Unapplied A/c 100
6 Receipts with remittance method.
Confirmed receipts A/c 100Unapplied A/c 100
Remitted receipts A/c 100Confirmed receipts A/c 100
Cash 100Remitted receipts A/c 100
7 Receipts with discount/unearned discounts
Cash 90Discount earned A/c 10
SUMMARY!A1
www.erpstuff.com
![Page 17: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/17.jpg)
Receivable A/c 100
Cash 90Discount unearned A/c 10Receivables A/c 100
![Page 18: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/18.jpg)
Order To Cash Cycle
SPL NOTES
At Standard CostAt Standard Cost(Staging)
It can be fetched from five placesAt Standard Cost
Before application of the receipt
After application of the receipt to the transaction
In case of receipt without customer or transaction
when customer indentfied
At the time receipt entry
On remittance to bank
On clearence of cheque
At the time earned discounts
www.erpstuff.com
![Page 19: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/19.jpg)
At the time of unearned discount
![Page 20: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/20.jpg)
ACCOUNT IS PULLED SPECIFIC
Sub-inventory Material A/c SetupSub-inventory Material A/c Setup
Master Item/Org/Order Type/Line Type/Shipping ParamsSub-inventory Material A/c Setup
Transaction typeTax codesTransaction typeTransaction type
Receipt classReceipt class
Receipt classReceipt class
Receipt classReceipt class
Receipt classReceipt class
Receipt classReceipt class
Receipt classReceipt class
Receipt classReceipt class
BankReceivable activity
![Page 21: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/21.jpg)
Transaction Type
BankReceivable activityTransaction type
![Page 22: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/22.jpg)
OPTION AVAILABLE
ORGORG
Master org/shipping parameters/order type/Inv org
sales rep/customer siteTransaction type/sales reps/customer bill to site/Standard linessales rep/customer bill to site/standard linessales rep/customer bill to site/standard lines
Bank Defination FormBank Defination Form
Bank Defination FormBank Defination Form
Bank Defination FormBank Defination Form
Bank Defination FormBank Defination Form
Bank Defination FormBank Defination Form
Bank Defination FormBank Defination Form
Bank Defination FormBank Defination Form
![Page 23: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/23.jpg)
Adjustments in AR
SR.NO PARTICULARS DR CR SPL NOTES ACCOUNT IS PULLED SPECIFIC1 Adjustments
Adjustment A/c 100 Receivable activityReceivable A/c 100 Transaction type
www.erpstuff.com
![Page 24: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/24.jpg)
OPTION AVAILABLE
Sales Rep/Customer Site
![Page 25: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/25.jpg)
STANDARD COST UPDATE
SR.NO PARTICULARS DR CR SPL NOTES1 Inventory Std cost update
Sub Inventory A/c 100Cost Adjustment A/c 100
2 Intransit material Std Cost Update
Intransit Inventory A/c 100Cost Adjustment A/c 100
3 WIP Material Std Cost Update
WIP Material A/c 100WIP Material Variance A/c 100
![Page 26: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/26.jpg)
STANDARD COST UPDATE
ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
Sub-inventory Material A/c Setup ORG
At the Standard Cost update request level
Shipping Network ORG
At the Standard Cost update request level
WIP Accounting ClassWIP Accounting Class
www.erpstuff.com
![Page 27: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/27.jpg)
Miscellaneous Receipts in AR
SR.NO PARTICULARS DR CR SPL NOTES1 Miscellaneous Receipt at receivables
Accounting
Cash 100 Entered Reciept AmountMisc Cash A/c 100
2 Miscellaneous Issue/Receipt At Inventory
Issue
Misc Issue A/c 100Sub Inventory A/c 100
Receipt
Sub Inventory A/c 100Misc Receipt A/c 100
www.erpstuff.com
![Page 28: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/28.jpg)
Miscellaneous Receipts in AR
ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
Bank Account Definition Bank(Internal)Receivable activity Distribution set
At Misc Issue form level Org/Subinventory level ORG
Org/Subinventory level ORGAt Misc receipt form level
www.erpstuff.com
![Page 29: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/29.jpg)
MISC PAYMENTS
SR.NO PARTICULARS DR CR
1 On entering a Misc.Invoice
Charge A/c 100Liability A/c 100
2 On making the Payment
Liability A/c 100Cash 100
3
On PaymentLiability A/c 100Cash Clearing A/c 100
On ClearingCash Clearing A/c 100Cash 100
On making Payment (when Cash Mgmt is implemented)
![Page 30: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/30.jpg)
MISC PAYMENTS
SPL NOTES ACCOUNT IS PULLED SPECIFIC
Distribution Set/PO charge A/cFrom the supplier site
From the Supplier siteFrom the Bank A/c's Definition
From the supplier siteFrom the Bank A/c's Definition
From the Bank A/c's DefinitionFrom the Bank A/c's Definition
www.erpstuff.com
A dummy Misc.Vendor is created for this purpose and the details are captured in the DFF.
![Page 31: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/31.jpg)
OPTION AVAILABLE
Financial Options
Financial Options
Financial Options
![Page 32: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/32.jpg)
Manual WorkOrder
SR.NO PARTICULARS DR CR 1 At the time material issue
WIP Material A/c 100Sub Inventory A/c 100
2 Resource Valuation
WIP Resource valuation A/c 100Resource Absorption A/c 100
3 Overhead Cost (Material)
WIP Material ovehead A/c 10Sub inventory material overhead A/c 10
4 Overhead Cost (Indirect)WIP Overhead A/c 100 Overhead absorption A/c 100
5 Outside Processing (In case of fixed standard cost to resource)
WIP OSP A/c 100Variance A/c 95Resource A/c 5
www.erpstuff.com
![Page 33: Oracle Applications EBS - Accounting Entries - V1[1].0](https://reader030.vdocuments.us/reader030/viewer/2022032612/55cf9ad8550346d033a3b1c7/html5/thumbnails/33.jpg)
Manual WorkOrder
SPL NOTES ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE
WIP ClassAt Standard Cost Sub-inventory Material A/c Setup ORG
WIP ClassResource Definition Form
WIP ClassOrg/Subinventory ORG
WIP ClassOverheads Defination Form
WIP ClassResource Defination Form Org ParamaetersResource Defination Form Receiving Options
www.erpstuff.com