Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The change below deployed to UAT at Jan 13, 2023 for work order no. WO-CNA-20230111-01 (JIRA BCCNA-305)

The customization aims to allow user to select Mill from a master list and able to change Mill for each PO Line. 

Use Case:  

  • After drop shipment PO created from the sales order, user may need to change Vendor or Mill
    • Change Vendor in sales order header if Vendor is same for all sales order lines.
    • Change Vendor in sales order line if Vendor is different for sales order lines.  
    • Mill only change in PO Line, no need to handle in Sales Order Line.
  • No need to separate PO by Mill.
  • Mill must exist in Vendor Card, Purchase Order Line and Group Shipment Line.
  • Vendor and Mill has no relation.  User can change default Mill for the Vendor in either Purchase Order Line

Module

Description

Master Steup List

New Type Mill is added. 

  • All existing Mill it recorded in Vendor Card and Group Shipment Line are added into the list.  
  • User can add new Mill into the list
  • Code to be use for selecting and show in the field in Vendor card or PO Line.

Image Modified


IMPORTANT NOTE: The data patch only patch the existing data from record to the master table.  User must need to check if any typo error it caused duplicate MILL created in the master table.

To fix the duplicate, please find the related record then change the value in the record.  After updated, delete the incorrect data in the master list.

Vendor Card

1) The field Mill is changed to select from drop down list.  The Mill its setup in Master setup list can be select in Vendor Card.

The value to be copy to Purchase Order and Purchase Order Line when the order is created by Create Drop Shipment PO function.

Image Modified


2) Validation is added for prevent Mill is missing enter in Vendor Card.  

Image Added


IMPORTANT NOTE:  Data patch for existing Vendor Card according to existing data

as of Jan 11, 2023,

has been done.  User should double check the data.

Sales Order

Note: 

Refer to system standard, Direct Unit Cost in PO line to be clear once the Vendor is change.  Since Mill will change according in case user change the Vendor, so even user only change Mill in PO Line, the Direct Unit Cost will clear accordingly.   

CNA is need to handle the case if Mill is changed in PO Line, the Direct Unit Cost need to retain.

To handle this case, system dialog is added for confirm clear direct unit cost in PO or retain the direct unit cost when user change Vendor in SO


For example:

If user want to change vendor in SO line which has related PO, system will prompt the message for confirm then another message to be prompted for confirm whether the existing direct unit cost in related PO will clear or not.   The steps show below for your information. 

Steps:

  1. Change Vendor from No. V00319 to V00312

Image Added

2. Confirm message for update vendor to SO Lines

Image Added

3. Confirm message for update vendor in related PO.

Image Added

4. Choose to clear the Direct Unit Cost in related PO or not.

Image Added

Purchase Order

Note:

  • Function for copy Mill from Vendor card when create PO is remain no change
  • Process flow for create sales order and create drop shipment PO function remain no change.

New change:

  1. The field Mill is changed to select from drop down list in General Tab and Lines

Image Modified

2. User can change the field Mill in General Tab then system will apply the new value to all PO Lines

Image Modified

3. User can change Mill in individually line, however, once there have multiple Mill entered in PO Line, Mill in General Tab to be change to Blank by system

Image Modified

4. If user select another MILL in General Tab again, system will prompt the notification message for confirm update to

PO Lines updated

Image Removed

Updated to PO Lines after confirm,

Image Removed

5. If Mill is changed in new added line after existing line is posted.

Image Added

Case Handling for Add new PO Lines and change MILL

For example, new lines

is

are added after one of PO line for Item I00143 and Mill is

VIPAP

BIZ Test created in Group

Shipment mill to be copied from General Tab

Image Removed

Shipment 

a) Original PO has 2 PO Lines and Mill is BIZ Test

Image Added

b) Group Shipment Line for PO line 1 item I00143

Image Added

c) New item added to sales order and created in related PO, system will default Mill from PO header accordingly

Image Added

d)

6.

If user want to change

Mill for all outstanding line

another Mill for the lines it just created yet, user can change Mill in General Tab

Image Added

Then system will update the Mill to the PO lines which is not created Group Shipment yet,

Image Added

User can change Mill in individual line if needs

Image Added

Group Shipment

Note:

  • Process flow for create Group Shipment remain no change

New change:

  1. Mill to be copy from Purchase Order Line and show on Group Shipment Line.  Mill is not
allow
  1. allowed to change in Group Shipment

Image Modified