2016-07-14 - 24193 - Spec - Best practice for Global free promotional orders #FISD #FIMM #US #EMEA #Mexico #FIOutgoingInvoices #CCA
SPECIFICATIONS
18280-Spec- Best practice for free promotional order
Purpose
Free of charge orders should reverse the COGS A/c and hit the Promotional expense Account.
Admin Info
| Purpose |
Best practice for free promotional order |
| Requested By |
Jingsha/Babu |
| Spec Created By |
Raghav/Deepak |
| Spec Created Date |
04/01/2015 |
| Spec QA by |
Raghav/Deepak |
| Objects |
V_T683 V_T687 RV61B904 V_TVAK ZRGGBS000 V_T80D VWTYGB01 GGB1 GB01C GB02C V_KKAZ V_T001Q C520 C003 C001 V_TVAUK V_TVKT |
| Document Status |
Completed |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
60 |
| 2 |
Documentation |
20 |
| 3 |
Development/ Config |
50 |
| 4 |
Unit test in DEV |
100 |
| 5 |
Unit test in QUA |
50 |
| 6 |
Other activity |
20 |
| TOTAL |
300 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]1) 18280 - Best practice for free promotional order
2) 23648 - Gl account determination settings
Documents
[Attach any document(s) received for the requirement(s)]Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
Change 904 output routine for auto picking of ZJRF deliveries |
Babu Vanamali |
07/20/2015 |
|
| 2 |
Global FOC orders set up |
Babu Vanamali |
07/27/2015 |
New ticket 18280:500 is assigned. |
| 3 |
New Item category creation ,account assignment cat for TAB order process for FOC |
Babu Vanamali |
08/10/2015 |
|
| 4 |
Copy control change for LF/F2 for ZTFC item category for Foreign trade issues. |
Babu Vanamali |
08/15/2015 |
|
| 5 |
Accounting to hit the promotion expense at PGI and invoice |
Babu Vanamali |
08/15/2015 |
|
| 6 |
Removal of other item category assignments to ZFOC doc except ZANN,ZTFC and ZTSN. |
Babu Vanamali |
08/21/2015 |
|
| 7 |
Creation of new PP ZNEFOC by copying ZNECGR and assign it to ZFOC and ZFCR customers. |
Babu Vanamali |
08/25/2015 |
|
| 8 |
MTO process to hit GL Acct 518100 at the time settlement and delivery. |
Babu Vanmali |
09/01/2015 |
Requirements has been stopped for ZKE orders |
| 9 |
Japan category account offset discount and cost center assignment to order reson for ZFOC & ZFCR |
Babu Vanmali |
10/26/2015 |
|
| 10 |
New Customer account assignment groups and Global account determination. |
Babu Vanmali |
12/11/2015 |
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]FOC orders are posting to COGS A/C and later on the the user doing manual adjustment to Promotion expense A/c. To avoid this manual posting system should automatically reverse the COGS A/c and post it to Promotion expense A/c. For all following process.
1) Japan FOC Rush orders and Returns
Global
2) MTS orders - TAN/ZANN
3) PTO orders - TAB/ZTFC
4) Dropship Orders - TAS/ZTSN
5) MTO with Requirement Type KE
Japan category account offset discount and cost center assignment to order reson for ZFOC & ZFCR
Create new category account for Japan FOC Offset account 650293, 651127 and for condition type R100 same as cost of sales ie GL account 410000 sales.
In Scope:
[List the activities to be included in scope]Out of Scope:
[Out of scope activities]Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
The cost center and Expense account category is mandatory for these new FOC order types. FOC orders should create with account assignment cost centers can manually enter at sales order and Expense category will be configured from the customer Account assignment group. So that at the time of invoice COGS-FOC-518100 will get reverse and post to required Promotion Expense A/c.
JAPAN
1. A new document type ZJRF should be created for the Japan FOC rush orders and necessary item category determination should be done.
2. ZJRR FOC return order should be created and the specific order reason should assign to cost center on t. code OVF3
3. New GL Account 518100 COGS-FOC have to create with cost element and assign at PGI in OBYC
4. Account determination of account posting have to be done with the order type ZJRF and ZJRR
GLOBAL
1. MTS: New order types ZFOC and ZFCR for returns have to be created for FOC orders , account determination VKOA settings to reverse the COGS and post to promotion expense
2. For PTO's (TAB) to hit GL A/c 518100 COGS-FOC at PGI we have to define new Item category, Schedule line, Account Assignment Category, Requirement type and Requirement Class
3. As there was a difference in Price at invoice for dropship orders, we have to create the new pricing procedure ZNEFOC to correct the difference price and also should manually update GL Account 518100 in PO.
4. MTO: As GL account 518100 will not update at the time of settlement we have to use substitute rule to change the GL Account 510000 to 518100 with conditions order type ZFOC and requirement type KE and also as GL Acct 518100 is is cost element it should have a cost object so that we have default the sales order header 'cost center' at the time of settlement. We have to assign the all promotion expense GL accounts to line primary cost line ID.
Prerequisites for Free of charge order Process:
1) MTS and PTO : Item category ZANN and ZTFC and common for all process
-It is mandate to maintain customer pricing procedure 'Y' in customer master data to pick the 'ZNEFOC' pricing procedure in sales order.
-Maintain AA grp in Customer master data or Sales order>Goto>Header>Financial Accounting and also maintain relevant Cost center at Sales order>Goto>Header>Account Assignment
2)Dropship orders: Item Category ZTSN
-At the time of PO GL account should be changed from '510000' to '518100'
Auto picking of ZJRF deliveries:
1. The RV61B904 routine should be changed to include ZJRF document type for auto picking.
New Item category ,account assignment cat for FOC TAB order process:
1.New item category.schedule line,requirement type,requirement class and account assignment category should be created for FOC TAB order process.
Japan category account offset discount and cost center assignment to order reson for ZFOC & ZFCR
-New customer Account Assignment Group ZD, ZS and related GL account determination 650293, 651127.
-New order reasons C61, C62 and assigned to ZFCR return order type for sales org 3200.
-Assignment of order reason C61, C62 to cost center 60000DESIG, 60000ECOMM for sales org 3200.
-In Pricing procedure ZNECGR and ZNEFOC for condition type R100 the account key is changed to ERL
Test Plan
[List test scenarios/cases to be executed here]Accounting entries posting at the time of Delivery and Invoice:
| Test ID |
Test Scenario |
Expected Results |
| FI-001 |
Create Japan ZJRF Sales order with account assignment cost center and AAGrp ZA |
GL Acct 518100 COGS-FOC should hit at the time of delivery and reversed at the time of invoice and post to 650193 promotion expense a/c |
| FI-002 |
Create Japan ZJRR sales return order with account assignment cost center and AAGrp ZA |
GL Acct 518100 COGS-FOC should hit at the time of delivery and reversed at the time of invoice and post to 650193 promotion expense a/c |
| Test ID |
Test Scenario |
Expected Results |
| SD-001 |
Create Rush order via IDOC with order type ZJRF & PO type WEB SA - 3200/10/00 ; Plant - 0620 |
SO should be created with immediate delivery. Output ZEK0 should be triggered and picking should be done. |
| SD-002 |
Create Rush order via IDOC with order type ZJRF & PO type POS . SA - 3200/10/00 ; Plant - 0620 |
SO should be created with immediate delivery. Output ZEK0 should be triggered and picking should be done. |
| SD-003 |
Create Rush order via IDOC with order type ZJRF & PO type EDI SA - 3200/10/00 ; Plant - 0620 |
SO should be created with immediate delivery. Output ZEK0 shouldn't be triggered and picking shouldn't be done. |
| Test ID |
Test Scenario |
Expected Results |
| FI-001 |
Create FOC-ZANN Sales order for Sales org 1200 |
Billing invoice should post to GL account specified as in Account determination and sales order |
| FI-002 |
Create FOC-ZTSN Sales order for sales org 4000 |
Billing invoice should post to GL account specified as in Account determination and sales order |
| FI-003 |
Create FOC-ZTFC Sales order for sales org 1500 |
Billing invoice should post to GL account specified as in Account determination and sales order |
| Test ID |
Test Scenario |
Expected Results |
| FI-001 |
Create FOC MTO Sales order with requirement type KE |
GL Account should change from '510000' to '518100' at the time of settlement and Cost center should be same as in sales order |
| FI-002 |
Create ZOR MTO Sales order with requirement type KE |
Gl account should not change and no cost center should update at the time of settlement |
| Test ID |
Test Scenario |
Expected Results |
| FI-001 |
Create EMEA Sales order |
GL Account should change from '510000' to '518100' at the time of delivery and post to promotion expense account at Invoice |
| FI-002 |
Create EMEA Sales order returns |
Cost center should update automatically with the order reason and GL Account posting should done accordingly |
| Test ID |
Test Scenario |
Expected Results |
| FI-001 |
MTS process for FOC Japan with ZFOC and ZFCR orders |
1) Customer AAGrp ZD/ZS should post to GL Account 650293/651127 at the time of invoice 2) For return order cost center 60000DESIG/60000ECOMM at header should determine through order reason C61/C62 3) In pricing condition R100 should post GL 410000 sales instead 421000 sales discount in accounting |
| FI-002 |
Dropship process for FOC Japan with ZFOC and ZFCR orders |
1) Customer AAGrp ZD/ZS should post to GL Account 650293/651127 at the time of invoice 2) For return order cost center 60000DESIG/60000ECOMM at header should determine through order reason C61/C62 3) In pricing condition R100 should post GL 410000 sales instead 421000 sales discount in accounting |
| FI-003 |
PTO process for FOC Japan with ZFOC and ZFCR orders |
1) Customer AAGrp ZD/ZS should post to GL Account 650293/651127 at the time of invoice 2) For return order cost center 60000DESIG/60000ECOMM at header should determine through order reason C61/C62 3) In pricing condition R100 should post GL 410000 sales instead 421000 sales discount in accounting |
Solution Details
[Provide complete technical details for configuration or programming here]
1. Item category ZENN is assigned to ZJRR document at sales order level.
2. The ZENN is assigned to LR at delivery level.
3. The order reasons are assigned to ZJRR document.
Auto picking of ZJRF deliveries:
The routine RV61B904 is changed by adding a new document type ZJRF with PO types WEB/POS as below.The output ZEK0 is triggered by containing the condition record for ZJRF document for auto picking of the deliveries.
FI configuration
1. Create new Account Key in OV34
2. Assign Account key to Japan pricing procedure ZNECJP for condition type ZEXX
3. Account assignment for sales order with account assignment in OBYC - GBB
4. Account determination VKOA in table 520
Global Account determination.
VKOA- Account Determination.xlsx
For MTO requirement type KE orders we have to assign the all promotion expense GL accounts to Line IDs NMA(Primary costs) in T.Code OKG5
FI Substitution rule for the GL account 518100 with default cost center at the time of settlement VA88
Deactivate the GL account(HKONT) and Cost Center(KOSTL) in SM30-VWTYGB01
Create substitute rule in T.code GGB1 under Financial Accounting-Line Item
Create Step under substitution rule with fields GL Account and Cost Center with help of Exits
Assign substitute rule for the company code 0010 in T.code OBBH
New Item category ,account assignment cat for FOC TAB/ZTFC order process:
Configuration document for ZFOC Sales process.doc
Copy control change for LF/F2 for ZTFC item category for Foreign trade issues:
Japan category account offset discount and cost center assignment to order reson for ZFOC & ZFCR
1) Create order reasons: SPRO-Sales and Distribution-sales-Sales Document Header-Define order reasons
2) Assign order reasons to sales org 3200 for order type ZFCR: SPRO-Sales and Distribution-sales-Sales Document Header-Assign order reasons (AFS)
3) Assign cost center to order reasons for sales org 3200 Tcode OVF3
4) Create Customer account assignment group: Tcode OVK8
5) GL account determination: VKOA
6) Change Account key to ERL for condition type R100 in Pricing procedure ZNEFOC and ZNECGR
Issues
[List Issues / Bugs identified in configuration or development]
1) Account Determination Error in PRD-Japan on 07/27/2015