Error Message Prompted when Post All Documents in Group Shipment

This problem may be occurred if user change vendor and split order to another vendor and system updated Vendor to original dimension set incorrectly. 

Scenario as below:

Day Process
1
  1. Create SO and enter Vendor in Sales Header (e.g. V001)
  2. Enter Sales Line
  3. Click Create Drop Shipment PO action button
  4. Purchase Order to be added 
  5. System default Dimension for Sales Order, Sales Line, Purchase Order Purchase Line as below

SO Dimension

  • CUST
  • DEPT
  • SALESORDER

PO Dimension

  • CUST
  • DEPT
  • SALESORDER
  • SUPP    *dimension value in this PO is V001
2

Change Vendor and split order

  1. Go to purchase order, delete the line which is intended to assign to another Vendor
  2. Go to sales order, clear the Vendor in sales header
  3. Go to sales line which is need to assign to another vendor, enter the Vendor in to the sales line (e.g. V002)
  4. Click Create Drop Shipment PO action button
  5. Purchase order for Vendor V002 to be created by system and associated to the sales line
  6. System default Dimension for the new Purchase Order

KOWN ISSUE - system will change the dimension value for previous Dimension set and it caused the problem on incorrect Dimension Value for SUPP in original PO


SO Dimension 

Remain No change

PO Dimension for 1st PO it assigned to V001

*Dimension Value for SUPP changed to V002 incorrectly

PO Dimension for 2nd PO it assigned to V002

New dimension set created with correct value. 


**This problem only alerted when user post in Group Shipment.   Error message to be prompted when post

Follow the steps below to check this problem

1) go to Change Log to see whether user is change the vendor in SO it similar with the scenario mentioned above, if Yes, then go to next step, if No, need to check if another problem occurred

2) go to Dimension Set Entry table (480), user SALESORDER to find all related dimension set is related to the sales order (NOTE, dimension value for sales order to be default to whole set of the document from SO to PI)

3) check the related dimension set, find if any dimension set have same set of value, in this case, 2 dimension set with same value to be find.  The dimension sets is associated to related PO respectively

4) if incorrect dimension find, check which dimension set it associated to the PO is incorrect

5) Data Patch by following steps

Steps for data patch in CNA server

1) Change our development license

2) Edit Dimension Set ID 93356  Change Dimension Value for SUPP to V00327

3) Go to User Setup - check if BIZADMIN is not allow to change PO, edit the list

4) Go to PO21070137, Edit Dimension for SUPP to V00327

5) Refresh the PO then double check both Header and Line dimension value.  Dimension Set ID should be changed to 93356 by system

6) Go to User Setup to reverse the setting 

7) Change back to CNA License


Follow the steps below if sales order related to multiple PO

1) Check the Dimension Set Entry Table to check which dimension set should be assign to the PO 

2) Change development licenses 

3) Go to page 54 Purchase Order Subform => Page Action => Dimensions = Set break point in ShowDimensions ; 

    Go to ShowDimensions definition - set bearkpoint in OldDim SetID and Is Changed

 

In break point, update the dimension in Purchase Line

4) Open the Debugger then run the Purchase Order

5) The PO header dimension should be same as Purchase Line

Please see reference for how to check the dimension set entry (step 1 ) and  the video for (step 2-4) in share drive

\\10.168.0.133\Project_shared\NAV\CNA\01_Production Issue\JIRA272-PO Dimension Issue