Rma Cogs PDF
Rma Cogs PDF
Rma Cogs PDF
VCP Webcast Calendar/Archive Doc ID 837233.1 Oracle Webcast Schedule/Archive Doc Id: 740966.1
What Cost Management advisor webcast topics do YOU want to see presented in 2013? Click here to let us know.
AGENDA
Presentation and Demo approximately 60 - 75 minutes Q&A Session maximum 15 minutes
Web attendees can ask questions via Q&A panel Phone attendees can ask questions via Q&A panel or phone
Who to ask?
3 Send
your question
Q&A panel
Teleconference Connect details: 1. Conference ID: 2. International dial in: +44 (0) 1452 562 665 3. List with national toll free numbers is available in Note 1354453.1 Note: You can view this info anytime using WebEx menu from your WebEx-Session : Select Communicate --> Join Teleconference.
Program Agenda
Introduction to Revenue COGS matching COGS Dataflow RMA Setup & Flow Various RMA Scenarios and their Accounting Entries Summary Of RMA Accounting Troubleshooting - Revenue COGS Diagnostics Not a bug Scenario Recommended Patches Q&A
10
11
OE_ORDER_LINES_ALL
MTL_MATERIAL_TRANSACTIONS
R.O.M.T
C.R.R.I G.C.R.E
CST_REVENUE_RECOGNITION_LINES
12
13
14
Oe_order_lines_all
15
Mtl_Transaction_accounts
16
17
17
18
19
20
21
Queries:
SQL> select reference_line_id "om_line_id from oe_order_lines_all where line_id=&rma_line_id; SQL> select trx_source_line_id rma_line_id from mtl_material_transactions where transaction_id=&transaction_id; /* Use RMA Receipt */
22
22
23
24
There will be a COGS transaction line in MMT for 0 Quantity. Hence there will not be any Distributions created in MTA.
25
CST_COGS_EVENTS
26
26
In Standard Costing Organization Item cost at the time of sales order issue is 10 and Item cost at
the time of RMA is 12. Debit Credit Sales Order Issue DCOGS(1 Qty) Inventory(1 Qty @ $10) COGS recognition COGS (1 Qty) DCOGS (1 Qty @$10) RMA INV(1Qty@ $12 ) DCOGS (1Qty @ $10) DCOGS(1 Qty) COGS (1Qty @ $10)
27
Mtl_Material_Transactions @ RMA
28
29
30
30
Sales order = 3Qty (spilt into 2 and 1). RMA for 1 qty.
Debit Credit DCOGS(3 qty) Inventory(3 qty) INV (1qty) DCOGS (1qty) COGS (2 qty) DCOGS (2 qty)
31
Mtl_transaction_accounts
SOI is for 3 qty, RMA for 1 Qty and COGS Recog done for 2 Qty (3-1)
32 Copyright 2013, Oracle and/or its affiliates. All rights reserved. Confidential Oracle Internal
33
34
35
COGS Recognition:
RMA:
Reversal Entries:
36
In case of Ship Only Orders, once the line is closed, it insert a line in CRRL table with Potentially_unmatched_flag as U. Once the Generate COGS rec program is run Potentially_unmatched_flag becomes NULL and COGS trx is created in MMT and CCE tables.
37
Optional Class1
Optional Class 2
Item1
Item 2
Item 3
Item 4
38
39
Note: COGS recognition and RMA transactions are created across periods.
40
Debit DCOGS
Credit Inventory
41
Debit COGS
Credit DCOGS
42
Debit INV
Credit COGS
43
Summary of Accounting Entries: Transaction Type Debit Sales Order Issue(period 1) DCOGS COGS recognition(period 1) COGS RMA (period 2) INV Note: The accounting entries are created in the same way irrespective of the item type.
1 2 3 6
44
Setups to perform 50% rev recognition: Account Receivables(N)-> Setup-> Transactions-> Accounting Rules Define accounting rule for 50% deferral.
45
accounting rule
46
47
Oe_Order_lines_all
48
Note:1.Sales order issue for 3 Quantities created on 31-Dec-2012 . 2.Ran Revenue Recognition on 31-Dec-2012. 3.RMA Receipt for 1 Quantity created on 02-Jan-2013. 4.Ran Collect Revenue recognition and Generate cogs on 03-Jan-2013.
49
Cst_Revenue_Recognition_lines
50
Reference:ER 12548020
51
52
Debit
DCOGS COGS INV DCOGS
Credit
INV DCOGS DCOGS COGS
Debit
DCOGS COGS INV
Credit
INV DCOGS COGS
Case 2: Unreferenced RMA (SOI-> Rev Rec-> COGS rec->Un Ref RMA) Case 3: SOI and RMA quantity are same. (SOI-> Rev Rec->Ref RMA-> COGS Rec)
Transaction Type
SO ISSUE COGS Rec RMA
Debit
DCOGS COGS INV
Credit
INV DCOGS COGS
Transaction Type
SO ISSUE RMA COGS Rec
Debit
DCOGS INV No Accounting
Credit
INV DCOGS No Accounting
53
Credit
INV (1 Qty @ $10) DCOGS(1 Qty @ $10)
DCOGS(1 Qty @ $10) COGS(1 Qty @ $10)
Credit
INV(3 Qty) DCOGS(1 Qty) DCOGS(2 Qty)
Credit
INV DCOGS DCOGS COGS
Credit
INV DCOGS COGS
54
Debit
DCOGS COGS(50%) INV
Credit
INV DCOGS DCOGS(50%) COGS(50%)
Case 9: SOI and RMA across periods (SOI -> Rev Rec->Ref RMA-> COGS Rec SOI for 3 quantity RMA for 1 quantity SOI in Period 1 and RMA & COGS in Period 2
Transaction Type
SO ISSUE RMA COGS Rec
Debit
DOCGS(3 Qty) INV(1 Qty) COGS( 3 Qty)
Credit
INV(3 Qty) DCOGS(1 Qty) DCOGS(3 Qty)
DCOGS(3 Qty)
COGS(3 Qty)
55
56
Prior_cogs_percentage 0 0 0 0 1
SO Issue RMA
Full COGS Recognition
0 0 0 1 1
0 0 0.25 .50
57
58
Reference:Bug 13576673 - COGS RECOGNITION LINES NOT GENERATED AND DEFERRED COGS BALANCE IN GL INCREASES
59
Meaning
1 2 3 4 5 6
Sales Order Issue RMA COGS Recognition COGS Recognition % Adj COGS Recognition Qty Adj RMA Place Holder
60
61
62
Not a Bug
1.Distribution does not get created for Cogs Recognition:
a. When the SO ISSUE qty and RMA Qty are equal and are in same or different period. [SO ISSUE > RMA > Cogs ] b. When the Item costs is "ZERO" In CRCML table, check the new_cost. It will be "Null". c. when both the cogs % and Prior Cogs % are same(0 or any value) in cst_cogs_events Table.
63
Not a Bug
2.Manual AR invoices linked to SO are not considered for COGS recog:
Only invoices created through Auto invoice program are getting considered for COGS recognition.
This is not a bug, the matching between AR invoice and Sales Order
shipment is controlled by OM, if the AR invoice is not from OM, the link between AR and INV is not maintained. Reference :Bug 14823225 - MANUAL AR INVOICES LINKED TO SALES ORDER ARE NOT CONSIDERED FOR COGS RECOGNITION
64
Recommended Patches:
Recommended to Apply the following Patches: R 12.0: CSTRCMVB.pls 120.37.12000000.51 - Patch 12779598:R12.BOM.A R 12.1.X: 14180892:R12.BOM.C - CSTRCMVB.pls 120.45.12010000.48 14656876:R12.BOM.C - CSTRCMVB.pls 120.45.12010000.64* Note:-
65
References
Oracle Cost Management User's Guide Release 12.1 DOC ID1528307.1, COGS Accounting From RMA Perspective
66
To ask a question on the phone line, select *1 on your phone. To ask a question online, use the Q&A area at the top.
Your question will be read aloud in the order received. Question can also be asked on the My Oracle Support Communities
67
Visit the My Oracle Support Community now!! 1. 2. 3. 4. Log into My Oracle Support. Select the Community tab. Select the Enter Here button. Select the Community Name link under the E-Business Suite section of the My Communities Menu on the left side of the window.
68
69
Session
12975 12978
Session Details
Oracle E-Business: Take Control of Workflow with Workflow Analyzer! EBS Upgrades: Save time and money on your upgrade from 11.5.10 to 12.1.3 Get Proactive: Best Practices for a Faster, Smoother Oracle EBusiness Suite Period Close EBS Meet the Experts: Bring your questions, we will have experts, answers and resources to help you. EVERYTHING EBS PATCHING! Oracle E-Business: Oracle Payables: Have a smoother accounting period close 432.1 Get Proactive: Finding answers faster through MOS and communities.
Track
Financial Modules Application Strategy and Services Financial Modules
12969
Financial Modules Application Strategy and Services Oracle E-Business Suite Financial Modules
THANK YOU
71
Avoid the unexpected Dont leave value on the table Lower overall organizational costs through preventative maintenance Reduce risks and maximize uptime Achieve resolution faster Streamline and simplify your daily operations Get even more through connection
72