SD- Surya- Deepak-Prudvi- 2016-01-27 - 22066 - Spec - Commercial invoice form for EMEA (Craig by 2015-12-31) #EMEA #salesorders #invoices
SPECIFICATIONS
22066-Spec- Commercial invoice form for EMEA
Purpose
Create an output in Excel format with addition of new fields for EMEA commercial invoice
Admin Info
| Purpose |
Create an output in Excel format with addition of new fields for EMEA commercial invoice |
| Requested By |
Craig Spangler |
| Spec Created By |
Surya Basa |
| Spec Created Date |
03/03/2016 |
| Spec QA by |
Surya Basa |
| Objects |
TVARVC ZSF00010_EMEA_IB_OB ZMM_PO_PRINT_EXCEL VN_T685B V_T683_XX ZSF00010_EMEA_IB_OB ZMM_PO_PRINT_EXCEL VN_T685B VVC_TPAER_I_VJ VC_TPAR_KU VC_TPAR_LK VC_TPAR_VK |
| Document Status |
Completed |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
20 |
| 2 |
Documentation |
10 |
| 3 |
Development/ Config |
50 |
| 4 |
Unit test in DEV |
30 |
| 5 |
Unit test in QUA |
30 |
| 6 |
Other activity |
|
| TOTAL |
140 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]Documents
[Attach any document(s) received for the requirement(s)]Commercial Invoice_Prototype.xlsx
Copy of CI requirements v2 07-01.xlsx
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 |
Excel output to drop to a directory/desktop |
Craig Spangler |
||
| 2 |
Changes to fields |
|||
| 3 |
The ZECO output should be triggered with or without PGI/PGR for outbound,inbound deliveries and PO. |
Rizwan Shah |
04/28/2016 |
NA |
| 4 |
Change the file format to text for the fields in the excel file |
Rizwan Shah |
05/20/2016 |
NA |
| 5 |
Add new partner function ZJ for commercial invoice and add it in defaults at delivery and PO level |
Rizwan Shah |
06/ 20/2016 |
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]New Era ships products outside of EU. All shipments need to have attached a commercial invoice to be checked by Customs in order to go through. If wrong data is on the document or data does not exist on it, Customs can decide to block the shipment, ask for relevant info to the company that ships the products or purely send the products back to where it has been sent. If the customer can’t comply to the Customs, they can decide to red list the customer and systematically check his products before entry to the country. The missing data is the Country of Origin and Fabric Composition of the products.
In Scope:
[List the activities to be included in scope]Overall Requirements
To add extra elements on existing commercial invoices form
To generate the output in an Excel format
The process is
- If Menlo, the delivery is what will trigger the content of the commercial invoice form. The delivery should be created on PGI
- If Dropship, as soon as a PO will be shipped, this will provoke the creation of the form. Partial can exist and a PO can be attached to several SOs. This would be triggered at PGR for SNC PO’s and at GR for non-SNC. One PO can have multiple SO’s on it
- It should be emailed in .xls format
- The output will be issued manually by the user; the output should be saved to a location or as a spool
- Package Detail can be blank, Invoice date says date of generation, number is blank, COO is country of origin
Out of Scope:
[Out of scope activities]Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
| Activity |
| I. Configuration |
| - Set up output types for OB Delivery, IB Delivery, MIGO |
| - Define routines if required for specific conditions |
| II. Development |
| - Program to generate Excel |
| - Design Excel template |
| - Logic to fetch data and export to designate cells in Excel |
| - Excel alignments – Header and Item |
| - Calculate column totals |
Test Plan
[List test scenarios/cases to be executed here]| Unit Testing |
| - Outbound Delivery |
| - Inbound Delivery (SNC PO) |
| - Purchase Order (MIGO; non SNC PO) |
Scenarios - Outbound Delivery
| Test ID |
Test ScenarioTe |
Expected Result |
| SD-001 |
1. Create ZOR order 2. Create Delivery w/o PGI 3. Issue ZECO output manually |
The items shouldn't be displayed in the commercial invoice form as the PGI is not done. |
| SD-002 |
1.Create ZOR order with three items 2. Create Delivery and PGI two items 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
| SD-003 |
1.Create ZOR order and partially reject few lines 2. Create Delivery and PGI 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
| SD-004 |
1. Create ZOR order with Item category TAB 2. Create PO, Delivery and PGI 3. Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
| SD-005 |
1.Create ZPTO order 2. Create PO, Delivery and PGI 3.Issue ZECO output manually |
Only the PGI items should be displayed in the commercial invoice form. |
Scenarios - Inbound Delivery
| Test ID |
Test Scenario |
Expected Result |
| SD-001 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-002 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-003 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each IB Delivery. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-004 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-005 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
| SD-006 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
| SD-007 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each IB Delivery. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
| SD-008 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in each IB Delivery. |
Items should be displayed in the commercial invoice form as the PGR is done with correct unit price and total price. |
| Test ID |
Test Scenario |
Expected Result |
| SD-001 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
| SD-002 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manually in PO. |
All the PGR items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
| SD-003 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in each PO. |
All the PGR items should be displayed in the commercial formand PO (Po type- NB) number should not be displayed. |
| SD-004 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for partial items in the PO. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form Non PGR items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. |
| SD-005 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for partial items in PO. 3.Execute ZECO output manually in PO. |
All the PGR items should be displayed in the commercial form Non PGR items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
| SD-006 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for partial items in the PO's. 3.Execute ZECO output manullay in each PO |
All the PGR items should be displayed in the commercial form Non PGR items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. |
| SD-007 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. |
| SD-008 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manually in PO. |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
| SD-009 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in each PO |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. |
| SD-010 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
The items shouldn't be displayed as there is no receipt quantity and PO (Po type- NB) number should not be displayed. |
| SD-011 |
1.Create ZPTO SO in 2000,10,00 sales area and Reject 1st size of each item and create corresponding NB PO. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in PO. |
All the PGR items should be displayed in the commercial form with correct unit price and total price and PO (Po type- NB) number should not be displayed. |
| SD-012 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-013 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
| SD-014 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-015 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-016 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in PO. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
| SD-017 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually in PO. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. Multiple output files should be triggered for each SO. |
| SD-018 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each PO. |
The items shouldn't be displayed in the commercial invoice form as the PGR is not done. |
| SD-019 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in PO. |
Items should be displayed in the commercial invoice form as the PGR is done with correct unit price and total price. |
| SD-020 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
The items shouldn't be displayed in the commercial invoice form as the MIGO is not done. Multiple output files should be triggered for each SO. |
| SD-021 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
All the items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
| SD-022 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document with partial qty. 3. Execute ZECO output manually in PO. |
All MIGO'ed items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
Test data after removing the logic to trigger the excel with or without PGI/MIGO :
Outbound Del -
| Test ID |
Test Scenario |
Expected Result |
| SD-001 |
1. Create ZOR order 2. Create Delivery w/o PGI 3. Issue ZECO output manually |
The items should be displayed in the commercial invoice form |
| SD-002 |
1.Create ZOR order with three items 2. Create Delivery and PGI two items 3. Issue ZECO output manually |
The items should be displayed in the commercial invoice form |
| SD-003 |
1.Create ZOR order and partially reject few lines 2. Create Delivery and PGI 3. Issue ZECO output manually |
The items should be displayed in the commercial invoice form |
| SD-004 |
1. Create ZOR order with Item category TAB 2. Create PO, Delivery and PGI 3. Issue ZECO output manually |
The items should be displayed in the commercial invoice form |
| SD-005 |
1.Create ZPTO order 2. Create PO, Delivery and PGI 3.Issue ZECO output manually |
The items should be displayed in the commercial invoice form |
Inbound Del :
| Test ID |
Test Scenario |
Expected Result |
| SD-001 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-002 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-003 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each IB Delivery. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-004 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-005 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-006 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-007 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each IB Delivery. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-008 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in each IB Delivery. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| Test ID |
Test Scenario |
Expected Result |
| SD-001 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
| SD-002 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for all the items in the PO. 3.Execute ZECO output manually in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
| SD-003 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in each PO. |
All the items should be displayed in the commercial formand PO (Po type- NB) number should not be displayed. |
| SD-004 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. Create MIGO document for partial items in the PO. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form Non items shouldn't be displayed. and PO (Po type- NB) number should not be displayed. |
| SD-005 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. Create MIGO document for partial items in PO. 3.Execute ZECO output manually in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
| SD-006 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. Create MIGO document for partial items in the PO's. 3.Execute ZECO output manullay in each PO |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
| SD-007 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
| SD-008 |
1.Create two ZPTO SO's in 2000,10,00 sales area and corresponding single NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manually in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. Multiple output files should be triggered for each SO. |
| SD-009 |
1.Create ZPTO SO in 2000,10,00 sales area and multiple NB PO's. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in each PO |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
| SD-010 |
1.Create ZPTO SO in 2000,10,00 sales area and corresponding NB PO. 2. MIGO document is not created for the PO. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form and PO (Po type- NB) number should not be displayed. |
| SD-011 |
1.Create ZPTO SO in 2000,10,00 sales area and Reject 1st size of each item and create corresponding NB PO. 2. Create MIGO document for all the items in the PO's. 3.Execute ZECO output manullay in PO. |
All the items should be displayed in the commercial form with correct unit price and total price and PO (Po type- NB) number should not be displayed. |
| SD-012 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-013 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and PGR. 3.Execute ZECO output manually in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
| SD-014 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del documents and PGR. 3.Execute ZECO output manullay in each PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-015 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del for partial items and PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del's should be displayed in the commercial invoice form. |
| SD-016 |
1.Create ZU3P SO in 2000,10,00 sales area and corresponding SNC PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-017 |
1.Create two ZU3P SO's in 2000,10,00 sales area and corresponding single PO. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manually in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
| SD-018 |
1.Create ZU3P SO in 2000,10,00 sales area and multiple SNC PO's. 2. Create Inb.Del document and do not PGR. 3.Execute ZECO output manullay in each PO. |
All the items in the Inb del should be displayed in the commercial invoice form. |
| SD-019 |
1. Create ZU3P SO in 2000,10,00 sales area and reject 1st size of each size. Then create corresponding SNC PO. 2. Create inb. Del document and do the PGR. 3. Execute ZECO output manually in PO. |
Items should be displayed in the commercial invoice form as the is done with correct unit price and total price. |
| SD-020 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
All the items in the Inb del should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
| SD-021 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document 3. Execute ZECO output manually in PO. |
All the items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
| SD-022 |
1. Create multiple ZU3P SO in 2000,10,00 sales area and Then create corresponding Z3NB PO with confirmation ZNEC. 2. Create MIGO document with partial qty. 3. Execute ZECO output manually in PO. |
All MIGO'ed items in the PO should be displayed in the commercial invoice form. Multiple output files should be triggered for each SO. |
Solution Details
[Provide complete technical details for configuration or programming here]
1.New outputs for commecial invoice are created at Outbound Delivery,Inbound Delivery and Purchase orders without any access sequence as below.
a. ZECO at Shipping (outbound delivery) level :
b. ZECO at Inbound level:
c. ZECO at PO level :
2. These outputs are assigned to the respective output determination procedures.
3.The default customer is assigned as ZJ in these three outputs.
4. A new TVARVC variable is created to maintain the email addresses for which these commerial invoices should be sent as below.
5. New programs are created for Deliveries(Inbound and outbound) and PO as below.
ZSF00010_EMEA_IB_OB
ZMM_PO_PRINT_EXCEL
Issues
[List Issues / Bugs identified in configuration or development]