Cable Industry (VA076_)

1. Removed DBScript to change procedure name on M_PRODUCTION_RUN_NotFRPT process.

1. Done changes on Packing Material Issue process to calculate qty based on no of drums. 

Done changes on Packing Material Issue process to calculate qty based on no of drums. 

Added First Drum, Any Drum and Last drum fields on Operation tab under Production Order window. 

Added new field "Is Quality" on Operation window. 

Added new field "No Of Consolidated Lines" on Production Order Header. 

Update in Procedure of Metal Exposure Summary report for calculating SO Details, Manufactured Details, Accum Total 

1. Added BOM field on Production Order Component. 

2. Done change in procedure DB Script "VA076_M_PRODUCTION_RUN_NotFRPT". 

1. Done change in procedure "VA076_M_PRODUCTION_RUN_NotFRPT". 

2. Removing Procedure Error while running Process now in Production Screen 

1. Added read only logic on Total qty on Production Order Component.

2. Set read only checkbox to false on Total Qty and Packing Material checkbox on Production Order Component. 

1. Added VA076_TotalExtraLength on Production Order and VA076_ExtraLength on PO Operations. 

2. Done change in callout to set total qty in Production order 

1. Done change on update query on after save of Work Order Operation to set Any Drum and Last Drum. 

2. Worked on update quantity to set test length based on NoOfDrum. 

3. Done change to set TestLength, AnyDrum and Last drum values based on NoOfDrums on MD Line. 

1. Done change to create duplicate components for same product under Master demand. 

2. Added VA076_POQty column on Poduction Order window. 

3.Added script to mark Qty read only on Production Order

4. Done change to set total PO Qty on Production Order. 

1.Added FirstDrum, AnyDrum and LastDrum columns on VAMRP_PlannedDemand and VAMRP_PlannedOrder Tables and done data marking.  

2. Work done on callout to set drum details on MD line. 

3. Worked on round up decimal values based on UOM precision for First drum, Any drum and Last drum fields under Component tab on Master demand window. 

4. Done changes to calculate qty based on UOM precision for First drum, Any drum and Last drum fields under Component tab on Master demand window. 

5. Added Manufacturing Precision field on Unit of Measure window to set precision for production qty 

6. Done changes on after save and after delete logics to update First Drum, Any Drum and Last drum details on MD line for Operation tab under Master demand. 

7. Work done on update quantity process to calculate first drum , any drum and last drum details on component tab under Master demand. 

1. Changes done on Production Order Print(Drum Info and Drum size is corrected) 

1. Added DBScript to add new procedure VA076_M_PRODUCTION_RUN_NotFRPT and bind it on process now button on Assembly window. 

2. Added DBScript to change procedure name on M_PRODUCTION_RUN_NotFRPT process and update it on Process now column under M_Production table. 

1. Changes done in Production Order Print.

2. Added Length Per Drum and No Of Drum fields under Production Execution. 

3. Added DB Script to change validation on BOM field under Production plan tab for Assembly window. 

1. Added print format on Sales Order to print Technical Instructions 

1. Changes done in Production Order Print – Considered Order having more than 0 no. Of drum in Drum Info 

2. Done extra Length calculation changes for Routing. 

3. Added Search key with product name on Create Packing Lines form under PO. 

4. Hide Nominal Diameter and Max Product Length fields from Extra Length window. 

1. Colunm:VA076_ForexRate is created on C_Order and C_OrderLine table, and field also created. 

2. Done changes for create packing lines process to insert multiple packing materials with same product on component tab under Production Order. 

3. Compiled module with .NET framework version 4.8 

4. Added Few columns like Gross Weight, Net Weight, Dimensions , Nomenclature, Line No and added additional new logic for fetching Sales order and Sales Order related columns. 

5. Production Order Print format Issue and alignment corrected. 

1. Added callout on First Length, Any Length, Last Length and Operation Scrap fields under Master demand Line 

2. Done changes to make qty editable in Create Packing lines form. 

1. Added callout to set Extra Length on operation tab under Master Demand. 

2. Mark read only to Extra length field on operation tab under MD 

3. Work done to set Extra Length details on operation tab from routing. 

4. Work done on callout to set Extra length on operation tab on Master Demand. 

5.Added First Length, Any Length, Last Length and Scrap qty fields on operation tab under Routing. 

6. Added calculate extra length button on routing tab and process against the button. 

7. Added new field BOM on Master Demand Window under Components Tab. 

8. Added new process to calculate extra length on operation tab under routing. 

9. Work done to set BOM on Master Demand Components from Copy Operation Process. 

1. Added new field (Per Unit Quantity) on Packing Lines tab of Sales Order window. 

2. Added new button "Create Packing Component Trx Lines" on Production Execution. 

3. Added process to Generate packing components lines on Production Execution. 

4. Added script to active List record "Create Packing Material to production" on Transaction Type field under Production Execution. 

5. Added per unit qty column in create packing lines grid and set value for the same on component tab under production order 

6. Production Order Print format Issue resolution. 

1. Added new field (Per Unit Quantity) on Packing Lines tab of Sales Order window 

1. Added script to add callout on BOM field under Master demand line and marked Cost center as Mandatory UI to true on Work center window 

2. Added Extra length and total extra length fields on MD line and operations tab under Master demand. 

3. Added Customer drum, No of drum, Total qty, length per drum,  Length, width, height and contract no fields on attribute tab under Sales Order and hide same fields on Packing line tab. 

4. Added callout to get routing on MD line. 

5. Added after save logic on Operations tab under Master Demand.

6. Window : Master Demand

Tab: Operations 

Table: VA076_MD_WorkOrderOperation 

Create new Column: AD_OrgTrx_ID 

7. Work done to Set Trx Organization from Work Center to Master Demand Operation. 

8.

1. Added new process to update Metal price consumption on Order 

1. Added New Attribute Tab on Production Window with 93 Attributes. 

1. Added New Attribute Tab on Sales Order Window with 93 Attributes. 

2. Added new Attributes Product Cost and Cost /Profit Center in Product>Attribute 1 Tab 

1. Added new columns I.e. Test Length, FAT Length, No of Drums, Length Per Drum, SO Line Qty, First Length, Any Length, Last Length, Operation Scrap  on Production Order window. 

2. Added new field MR Confirmation No on Material Receipt window 

3. Changes done in callout to set Total Line quantity based on Test Length, FAT Length, No of Drums, Length Per Drum, SO Line Qty, First Length, Any Length, Last Length, Operation Scrap columns 

4. Changes done in Production order print, new print elements are considered – Dimension, Drum Info 

1. Addes new fields in Production order report 

2. Added callout to set ASI (Batch No.) on Production execution. 

3. Added callout to set IsDrum checkbox value on Packing lines under Sales Order. 

1. Enhancement to accommodate Attributes 2 with design

1. Added new Tab Attribute-2 on Product Window 

1. Product Order Print correction: Drum info, alignments

Note: On priority, this module is released for the Oracle users. This module also is marked as the private modules and are to be released only for the specific clients (SCB) using oracle DB. 

1. Added Non-Conforming Report. 

1. Work for Cable Industry requirement. 

1. Added print format for Production Order naming

VA076_ProductionOrderPrint (also include 3 report files : VA076_ProductionOrderPrint.rpt;VA076_ProductionOrderRSLine.rpt;VA076_ProductionOrderCOMLine.rpt) 

2. Work for Cable Industry requirement. 

1. Added Column in VA076_SOReference 

2. Added  Column in C_OrderLine Table for cable industry 

3. Work for Cable Industry requirement.

1. In Cable Industry, each Design/Product is defined with multiple attributes and are handled in the system by adding following features in the system. 

- Created a new tab ‘Attributes’ under the Product master. 

- Attributes tab includes the fields to capture Product Attribute Values. 

- For every Product, it is allowed to add single record in Product Attributes tab. 

2. Packing lines can be added against each Sales order line. To achieve it, the following features are introduced in the module.   

- A new tab ‘Packing Lines’ is created on sales order window to enter the packing lines manually against the Sales Order line