sdf

www.erpstuff.com Oracle Applications - EBS - Accounting Entries SR NO 1 2 3 4 5 6 7 8 9 10 11 12 PROCESS Back To Back Drop Ship SO- Work Order Inter Org ISO Procure to Pay Receipt To Cash AR Adjustments Standard Cost Update Miscellaneous Receipt Miscellaneous Payments Manual Work Order Creation & Completion LINK B2B!A1 DP!A1 SOW INTER_ORG ISO P2P O2C ADJ STD COST MISC REC Misc.Payments MOW

Please send your comments at [email protected] and keep visiting www.erpstuff.com.

Version :

1.0 12-Jan-09

BACK TO BACK SR.NO PARTICULARS I Back to Back 1 Sales Order Entry No Accounting Creation of Requisition No Accounting Creation of Purchase Order No Accounting Receipt Receiving A/c AP Accrual A/c Devlivery Raw Material Sub Inventory A/c PPV A/c Receiving A/c Reservation No Accounting Picking Staging Sub Inventory A/c Sub Inventory A/c Shipping COGS Staging Sub Inventory A/c DR CR www.erpstuff.com SPL NOTES

100

At PO Price ### At PO Price

80 20

At Standard Cost Diff between PO - Stnd ### At PO Price

80

At Standard Cost 80 At Standard Cost

80

At Standard Cost 80 At Standard Cost

BACK TO BACK www.erpstuff.com ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE

Receiving Option Setup Inventory Org Setup

ORG ORG

Sub-inventory Material A/c Setup Inventory Org Setup Receiving Option Setup

SUB-INV ORG ORG

Org Level A/c willl get defaulted

Sub-inventory Material A/c Setup Sub-inventory Material A/c Setup

SUB-INV SUB-INV

Org Level A/c willl get defaulted Org Level A/c willl get defaulted

Item Sub-inventory Material A/c Setup

SUB-INV

Org Level A/c willl get defaulted, OMTT Org Level A/c willl get defaulted

DROP SHIP SR.NO PARTICULARS I Drop Ship 1 Sales Order Entry No Accounting Creation of Requisition No Accounting Creation of Purchase Order No Accounting Receipt Receiving A/c AP Accrual A/c Devlivery Raw Material Sub Inventory A/c PPV A/c Receiving A/c Reservation No Accounting Picking Staging Sub Inventory A/c Sub Inventory A/c Shipping COGS Staging Sub Inventory A/c DR CR www.erpstuff.com SPL NOTES

100

At PO Price ### At PO Price

80 20

At Standard Cost Diff between PO - Stnd ### At PO Price

80

At Standard Cost 80 At Standard Cost

80

At Standard Cost 80 At Standard Cost

DROP SHIP www.erpstuff.com ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE

Receiving Option Setup Inventory Org Setup

ORG ORG

Sub-inventory Material A/c Setup Inventory Org Setup Receiving Option Setup

SUB-INV ORG ORG

Org Level A/c willl get defaulted

Sub-inventory Material A/c Setup Sub-inventory Material A/c Setup

SUB-INV SUB-INV

Org Level A/c willl get defaulted Org Level A/c willl get defaulted

Item Sub-inventory Material A/c Setup

SUB-INV

Org Level A/c willl get defaulted, OMTT Org Level A/c willl get defaulted

SR.NO PARTICULARS 1 At the time of material issue WIP Material A/c Subinventory material A/c 2 Resource Valuation WIP Resource valuation A/c Resource Absorption A/c 3 Overhead Cost (Material) WIP Material ovehead A/c Sub inventory material overhead A/c 4 Overhead Cost (Indirect) WIP Overhead A/c Overhead absorption A/c 5 WIP Job Completion Stagging/Completion Sub-inventory A/c WIP Material A/c WIP Resource valuation A/c WIP Material ovehead A/c WIP Ooverhead A/c WIP Material Variance A/c WIP Resource Variance A/c WIP Material Variance A/c WIP Ooverhead Variance A/c 5 Picking Staging Sub Inventory A/c Sub Inventory A/c 6 Shipping COGS Staging Sub Inventory A/c

DR

CR

SO-WORKORDER FLOW www.erpstuff.com SPL NOTES

100 100

100 100

10 10

100 100

Std Cost

Diff between Actual - STD Diff between Actual - STD Diff between Actual - STD Diff between Actual - STD

100

At Standard Cost 100 At Standard Cost

100

At Standard Cost 100 At Standard Cost

-WORKORDER FLOW www.erpstuff.com ACCOUNT IS PULLED

SPECIFIC

OPTION AVAILABLE

WIP Class Org/Subinventory

WIP Class Resource Defination Form

WIP Class Org/Subinventory

WIP Class Overheads Defination Form

Org/Subinventory WIP Class WIP Class WIP Class WIP Class WIP Class WIP Class WIP Class WIP Class

Sub-inventory Material A/c Setup Sub-inventory Material A/c Setup

SUB-INV SUB-INV

Org Level A/c willl get defaulted Org Level A/c willl get defaulted

Item Sub-inventory Material A/c Setup

SUB-INV

Org Level A/c willl get defaulted, OMTT Org Level A/c willl get defaulted

INTER ORG/INTE www SR.NO PARTICULARS DR CR FOB Point is set to Receipt without Charges & Freight - Using Transaction Type - Intransit 1 Entry at the time of ISSUE Intransit Inventory A/c ( Sending Org ) Sub Inventory A/c ( Sending Org ) Entry at the time of RECEIPT InterOrganization Receivable( Sending Org ) Intransit Inventory A/c ( Sending Org ) Sub Inventory A/c ( Receiving Org ) InterOrganization Payable ( Receiving Org ) 2

100 100

100 100 100 100

FOB Point is set to Receipt with Charges & Freight - Using Transaction Type - Intransit Entry at the time of ISSUE Intransit Inventory A/c ( Sending Org ) Sub Inventory A/c ( Sending Org ) Entry at the time of RECEIPT InterOrganization Receivable( Sending Org ) Intransit Inventory A/c ( Sending Org ) InterOrganization Receivable( Sending Org ) Freight Expense A/c ( Sending Org ) InterOrganization Receivable( Sending Org ) InterOrg. Transfer Credit ( Sending Org ) Subinventory A/C (Receiving Org) Purchase Price Variance(Receiving Org) InterOrganization Payable (Receiving Org)

100 100

100 100 15 15 10 10 100 25 125

FOB Point is set to Shipment without Charges & Freight - Using Transaction Type - Intransit Entry at the time of ISSUE

InterOrganization Receivable (Sending Org)

Sub Inventory A/c ( Sending Org ) Intransit Inventory A/c (Receiving Org) Inter - Organization Payable (Receiving Org) Entry at the time of RECEIPT Sub Inventory A/c (Receiving Org) Intransit Inventory A/c (Receiving Org)

100 100 100 100

100 100

Direct InterOrganization Transfer without FOB being Receipt and without transfer credit and freight

InterOrganization Receivable (Sending Org)

Sun Inventory A/c (Sending Org) Sub Inventory A/c (Receiving Org) Inter - Organization Payable (Receiving Org)

100 100 100 100

Direct InterOrganization Transfer with FOB being Receipt with transfer credit and freight Entry at the SOURCE

InterOrganization Receivable (Sending Org)

Sub Inventory A/c (Sending Org) InterOrg. Transfer Credit ( Sending Org ) Freight Expense A/c ( Sending Org ) Entry at the DESTINATION Sub Inventory A/c (Sending Org) Purchase Price Variance (Receiving Org) Inter - Organization Payable (Receiving Org) 6 If the Standard Cost is different in Sending & Receving Org Entry at the time of ISSUE Intransit Inventory A/c (Sending Org) Sub Inventory A/c (Sending Org) Entry at the time of RECEIPT Sub Inventory A/c (Receiving Org) Inter - Organization Payable (Receiving Org) Purchase Price Variance (Receiving Org)

120 100 10 10

100 20 120

100 100

120 100 20

INTER ORG/INTERNAL SALES ORDERS www.erpstuff.com SPL NOTES ACCOUNT IS PULLED

SPECIFIC

At Standard Cost At Standard Cost

Shipping Network Sub-inventory Material A/c Setup

ORG ORG

At Standard Cost At Standard Cost At Standard Cost At Standard Cost

Shipping Network Shipping Network Sub-inventory Material A/c Setup Shipping Network

ORG ORG ORG ORG

At Standard Cost At Standard Cost

Shipping Network Sub-inventory Material A/c Setup

ORG ORG

At Standard Cost At Standard Cost

At Standard Cost

Shipping Network Shipping Network Shipping Network At Transaction Level Shipping Network Shipping Network Sub-inventory Material A/c Setup Shipping Network Shipping Network

ORG ORG ORG ORG

ORG

At Standard Cost At Standard Cost

Shipping Network Sub-inventory Material A/c Setup Shipping Network Shipping Network

ORG ORG ORG ORG

At Standard Cost At Standard Cost

Sub-Inventory Material A/c Setup Shipping Network

ORG ORG

er credit and freight At Standard Cost At Standard Cost At Standard Cost At Standard Cost Shipping Network Sub-inventory Material A/c Setup Sub-inventory Material A/c Setup Shipping Network ORG ORG ORG ORG

At Standard Cost

Shipping Network Sub-inventory Material A/c Setup Shipping Network At transaction level

ORG ORG ORG ORG

At Standard Cost

Sub-inventory Material A/c Setup Shipping Network Shipping Network

ORG ORG ORG

At Standard Cost At Standard Cost

Shipping Network Sub-inventory Material A/c Setup

ORG ORG

At Standard Cost

Sub-inventory Material A/c Setup Shipping Network Shipping Network

ORG

OPTION AVAILABLE

PROCURE TO PAY www.erpstuff.com SR.NO PARTICULARS 1 Creation of Requisition No Accounting 2 Creation of Purchase Order No Accounting Receipt Receiving A/c AP Accrual A/c Devlivery Raw Material Sub Inventory A/c PPV A/c Receiving A/c Invoice matching with PO AP Accrual Liability A/c Invoice Price Variance A/c AP Liability A/c On making Payment Liability A/c Cash DR CR SPL NOTES

100

At PO Price 100 At PO Price

80 20

At Standard Cost Diff between PO - Stnd 100 At PO Price

100 10

At PO Price Diff between Invoice - PO 110 AT INV Price

110

At Invoice Price 110 At Invoice Price

PROCURE TO PAY www.erpstuff.com ACCOUNT IS PULLED

SPECIFIC OPTION AVAILABLE

Receiving Option Setup Inventory Org Setup

ORG ORG

Sub-inventory Material A/c Setup Inventory Org Setup Receiving Option Setup

SUB-INV ORG ORG

Org Level A/c willl get defaulted

Receiving Option Setup Inventory Org Setup Financial Options/Supplier Site

ORG ORG

Financial Options/Supplier Site Bank A/c Setup

SUMMARY!A1 SR.NO 1 PARTICULARS Sales order entry No Accounting Sales Order Pick From Sub Inventory A/c To Sub Inventory A/c 3 Sales Order Issue COGS To Sub Inventory A/c 4 Transaction level Receivable A/c Tax A/c Frieght A/c Revenue A/c Receipts 5 Receipts with no remittance method Cash Unapplied A/c Unapplied A/c Receivables A/c Cash A/c Unidentified A/c Unidentifed A/c Unapplied A/c 6 Receipts with remittance method. Confirmed receipts A/c Unapplied A/c Remitted receipts A/c Confirmed receipts A/c Cash Remitted receipts A/c 7 Receipts with discount/unearned discounts 100 100 100 100 100 100 100 100 100 100 100 100 100 100 120 10 10 100 100 100 100 100 DR CR

Order To Cash Cycle

www.erpstuff.com

Cash Discount earned A/c Receivable A/c Cash Discount unearned A/c Receivables A/c

90 10 100 90 10 100

Order To Cash Cycle

www.erpstuff.com SPL NOTES ACCOUNT IS PULLED

At Standard Cost At Standard Cost(Staging)

Sub-inventory Material A/c Setup Sub-inventory Material A/c Setup

It can be fetched from five places At Standard Cost

Master Item/Org/Order Type/Line Type/Shipping Params Sub-inventory Material A/c Setup

Transaction type Tax codes Transaction type Transaction type

Before application of the receipt

Receipt class Receipt class Receipt class Receipt class Receipt class Receipt class Receipt class Receipt class

After application of the receipt to the transaction

In case of receipt without customer or transaction when customer indentfied

At the time receipt entry

Receipt class Receipt class Receipt class Receipt class Receipt class Receipt class

On remittance to bank

On clearence of cheque

At the time earned discounts

Bank Receivable activity Transaction Type Bank Receivable activity Transaction type

At the time of unearned discount

SPECIFIC

OPTION AVAILABLE

ORG ORG

Master org/shipping parameters/order type/Inv org

sales rep/customer site Transaction type/sales reps/customer bill to site/Standard lines sales rep/customer bill to site/standard lines sales rep/customer bill to site/standard lines

Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form

Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form Bank Defination Form

Adjustments in AR
SR.NO PARTICULARS DR 1 Adjustments Adjustment A/c Receivable A/c 100 100 CR www.erpstuff.com SPL NOTES ACCOUNT IS PULLED SPECIFIC

Receivable activity Transaction type

OPTION AVAILABLE

Sales Rep/Customer Site

STANDARD COST UPDATE www.erpstuff.com SR.NO PARTICULARS 1 Inventory Std cost update Sub Inventory A/c Cost Adjustment A/c 2 Intransit material Std Cost Update Intransit Inventory A/c Cost Adjustment A/c 3 WIP Material Std Cost Update WIP Material A/c WIP Material Variance A/c 100 100 100 100 DR CR SPL NOTES

100 100

STANDARD COST UPDATE www.erpstuff.com ACCOUNT IS PULLED

SPECIFIC OPTION AVAILABLE

Sub-inventory Material A/c Setup At the Standard Cost update request level

ORG

Shipping Network At the Standard Cost update request level

ORG

WIP Accounting Class WIP Accounting Class

Miscellaneous Receipts in AR
SR.NO PARTICULARS 1 Miscellaneous Receipt at receivables Accounting Cash Misc Cash A/c 2 Miscellaneous Issue/Receipt At Inventory Issue Misc Issue A/c Sub Inventory A/c Receipt Sub Inventory A/c Misc Receipt A/c 100 100 100 100 100 100 Entered Reciept Amount DR CR www.erpstuff.com SPL NOTES

ellaneous Receipts in AR
www.erpstuff.com ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE

Bank Account Definition Receivable activity

Bank(Internal) Distribution set

At Misc Issue form level Org/Subinventory level

ORG

Org/Subinventory level At Misc receipt form level

ORG

MISC PAYMENTS www.erpstuff.com SR.NO PARTICULARS DR CR

On entering a Misc.Invoice Charge A/c Liability A/c 100 100

On making the Payment Liability A/c Cash 100 100

On making Payment (when Cash Mgmt is implemented) On Payment Liability A/c Cash Clearing A/c On Clearing Cash Clearing A/c Cash

100 100

100 100

MISC PAYMENTS www.erpstuff.com SPL NOTES A dummy Misc.Vendor is created for this purpose and the details are captured in the DFF. Distribution Set/PO charge A/c From the supplier site ACCOUNT IS PULLED SPECIFIC

From the Supplier site From the Bank A/c's Definition

From the supplier site From the Bank A/c's Definition

From the Bank A/c's Definition From the Bank A/c's Definition

OPTION AVAILABLE

Financial Options

Financial Options

Financial Options

Manual WorkOr
SR.NO 1 PARTICULARS At the time material issue WIP Material A/c Sub Inventory A/c 2 Resource Valuation WIP Resource valuation A/c Resource Absorption A/c 3 Overhead Cost (Material) WIP Material ovehead A/c Sub inventory material overhead A/c 4 Overhead Cost (Indirect) WIP Overhead A/c Overhead absorption A/c Outside Processing (In case of fixed standard cost to resource) WIP OSP A/c Variance A/c Resource A/c 100 95 5 10 10 100 100 100 100 DR CR

www.erpstuff.com

100 100

Manual WorkOrder
www.erpstuff.com SPL NOTES ACCOUNT IS PULLED SPECIFIC OPTION AVAILABLE

WIP Class At Standard Cost Sub-inventory Material A/c Setup

ORG

WIP Class Resource Definition Form

WIP Class Org/Subinventory

ORG

WIP Class Overheads Defination Form

WIP Class Resource Defination Form Resource Defination Form

Org Paramaeters Receiving Options