2016-08-05 - 26998 - Spec - PO Delivery date change CH Robinson #chr
SPECIFICATIONS
26998 - Spec - PO Delivery date change CH Robinson
Purpose
Create a program which can change the delivery dates in PO
Admin Info
Purpose
|
PO Delivery date change CH Robinson
|
Requested By
|
Jingsha
|
Spec Created By
|
Adithya
|
Spec Created Date
|
08/05/2016
|
Spec QA by
|
Adithya
|
Objects
|
ZCHR_PODATECHG
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
16
|
4
|
Unit test in DEV
|
12
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
36
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
PO Delivery Date Change Sample.txt
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
|
|
If the date format is wrong (other than MM/DD/YYYY, then ignore that date skip and update for the rest of lines which are having correct date format
|
Jingsha
|
08/12/2016
|
|
Functional Requirement
PO date change after the shipments are on the water:
After the shipment is on the water, the only change can happen to ECC PO is delivery or ex factory date change.
Any date change will be sent to ECC via a file from CHR. If the date change is >= +/- 3 days, update ECC PO delivery date. This update, however should not be sent to CHR again (no ZCHR output). If < +/- 3 days. NO change to ECC PO.
The number of days shall be in the input of the program.
Move the file to an archive folder after processing it.
Add the minimum day change in the parameter (selection Screen), in case we change the business requirement from >=+/-3 days to >=+/-2 days, etc.
A log which shows the list of POs for which dates have been changed and the POs that didn't get changed if the day change is less than the parameter date
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
CHR Pos would have the delivery date change in the POs and the existing PO Delivery date change program do not handle the input as a file and delivery date shall be update only if delivery date in the file is >= +/- 3 days which current program does not handle it. The new program shall also have the current functionality.
In Scope:
[List the
activities to be included in scope]
The Delivery date shall be updated for the Pos which are there in the file.
Out of Scope:
[Out of scope activities]
There is no check that the delivery date shall be updated only for the CHR pos.
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
Create a program which is has the same functionality of the existing PO delivery date change program.
The new program would have file as input which is attached above. A file path would be maintained in the input.
Another Input for the Program would be "Minimum Days Change" for which the program would calculate
The input file would be placed in a AlL11 folder and the program shall consider the file and update the delivery/ex factory dates for the POs in the file.
If Ex Factory is blank, it shall not update the ex factory date in the PO.
After the file is processed the File has to be placed in the Archive Folder CH in AL11.
There would be a Log for the program which would display the list of POs for which Delivery Date has been changed and the POs that didn't get changed if the day change is less than the parameter date.
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
DTCHG1
|
Execute the program with Input file
|
Delivery dates has to be updated for POs which have delivery date >= +/- 3 days.
Ex factory date has to be updated.
Delivery date shall not be updated for the POs which have delivery date less than 3 days.
|
DTCHG2
|
If there is no file in the application server
|
The Job has to be finished with the spool message that there are no files in the directory path
|
DTCHG3
|
If there are mulltiple files in the application server
|
Delivery dates has to be update for the Pos which satisfy the condition >+/- 3 days for all the POs in the files.
Files are to be placed.
|
DTCHG4
|
If PO has a Inbound Delivery, delivery date is updated for the Po
|
Delivery date shall be updated in the Inbound Delivery also
|
DTCHG5
|
If PO has a sales order
|
Delivery date has to be updated in the sales order also
|
Note: Please make sure that the Date format in the File is MM/DD/YYYY otherwise there may be a chance of wrong characters as delivery dates in the PO.
Skip the dates if the file has the wrong date format and update for ones which having correct date format.
Solution Details
[Provide complete technical details for configuration or programming here]
Develop a program "ZCHR_PODATECHG" which will update the PO Delivery Date / Ex-Factory Date from the input file.
A T code is created to access the program "ZCHR_PODATE"
Issues
[List Issues / Bugs identified in configuration or development]
Even after PO date is changed, such update should not be sent to CHR again because the shipments are on the water now.
Which is handled by IDOC 1st Delivarable.
2016-08-05 - 26998 - Rel Notes - CHR PO Delivery date change