JIRA CODE : https://jobinandjismi.atlassian.net/browse/CTG-60
PROPOSAL SUMMARY
This proposal covers, how to populate #of spools and length of spools fields when the work order is created based on the “-B” item from the sales order.
REQUIREMENT
When a customer orders a custom cable, denoted with a “-B” at the end of the item name/number (for example, “12D50125MOM3P-B”) we would like to be able to track the # of spools and the length of those spools that the customer would like the item made into with two new Transaction Line Fields, “# of Spools” and “Length of Spools”. This way we would know the total quantity ordered, as well as the # of spools and length of those spools that should make up that total quantity. I.e., quantity = 5000, # of spools = 5, Length of Spools = 1000. Then we know the total length the customer wants as well as how they want that total length broken down into spools. We need these fields to populate form the specific “-B” item on the sales order to the specific component item on the work order. We will be creating below fields in PRODUCTION with following id:
Field Name: ID ideal ID
Number Of Spools: custcol10 custcol_ctg_num_of_spools
Length Of Spools: custcol11 custcol_ctg_lengh_of_spools
OUR SOLUTION
- To accomplish this customization, we have to deploy a script in the work order record.
- The script will run in the create context of a work order record.
- When a sales order is created and approved, a work order is created. During this time, the script will be executed in WO. It will retrieve the field values for the # of spools and length of spools from the assembly line item that ends with -B, and these values will be filled in the WO for the corresponding line-item fields that end with –MR.
ASSUMPTIONS
- If you try to update the # of spools and length of spools values in the sales order after it has been completed, the related work order field will not be updated.
- We assume that when creating a sales order, the quantity, number of spools, and length of the spools fields are added by user.
- The transaction line fields have already been created, and they have been added to the quote, work order, and sales order forms. We will create required custom field in production only.
- The standalone work order fields will not be updated, as we don’t have a related SO.
TIME
16hrs
| Task |
| Analysis |
| Implementation |
| Documentation |
| Testing |