Frequently Asked Questions on Sales Order Hold (P43070)

PURPOSE

 This document provides answers to some frequently asked questions on Sales Order Hold.

Table of Contents

QUESTIONS AND ANSWERS

Question 1: Why does P43070 issue the error '0491 - Invalid Password' error?

Answer 1: The error 0491 comes when the password defined in Hold Order Constants (P42090) is different from what the user has entered in P43070.

 

Question 2: Is there any way to reset the password to approve the held order?

The original approver has left company and currently there is no delegation option for the same.

Answer 2: The application Work with Hold Order Constants (P42090) allows you to view/add/update/delete data from F42008. In other words, you can change the password using the same application P42090.
  1. Log on to EnterpriseOne.
  2. Fast Path to P42090
  3. Look for the hold code 'D' for the Branch Plant '210'
  4. Select the row and change Person Responsible and password.

Meaning that you can change password first using P42090 not to hit the error in P43070 (when this user has a sufficient privilege)

 

Question 3: Is there way to update the approver who has left the organization?

Answer 3: No. Currently there is no option to update the approver - F4209.RPER.

In case F42008.RPER (person responsible, the approver) left the company,

  1. Update F42008.RPER with a new approver (who replaces the person that left) and update F42008.PWRD with new password (because you do not want the end user to release the held orders) using P42090
  2. Update F4209.RPER = The Address Number of a new approver Where F4209.RPER = Old Approver using query tool
  3. The new approver can go to P43070 and approve the held orders when needed using the password set at step 1.

Only the step 2 above requires the update using query tool.

 

Question 4: How does the hold order affect the related tables?

Answer 4:

  1. Read F42008 to get RPER (Person Responsible, or approver) on HCOD (Hold Code, for your case D) and MCU which is 210
  2. Insert a record into F4209 (Order Held) the data you are seeing in P43070|ZJDE0002 is data from F4209
  3. Set/Update F4201.HOLD = 'D'

 

 

Question 5: How does the order release update the related tables?

Answer 5: P43070 knows a certain sales order got released or not by reading F4209.RDC (Released Code) based on the processing option of P43080|Version below

When a certain order is released then F4209.RDC will be 'CD' (assuming that the release code in processing option above is CD) and the orders which wait for releasing contains the value blank. So, P43080 determines whether to show released lines or not by reading F4209.RDC.

As we can see here, depending on the value from F4209, the representation of data in the Grid varies. In case you want to verify same, you can try as below:

  1. Fast Path to UTB
  2. Open the table F4209
  3. Put HOHCOD = 'D', HOMCU = ' 210', and HORDC < 0, which will give you all sales order which wait for releasing the hold code (set F4209.RCD = CD and F4201.HOLD = ' ').

 

Question 6: Some rows from F4209 (Held Orders) contain orphaned data. Is there any standard routine to archive/purge it?

Answer 6: There is no standard application that enables you to purge the F4209, as described in E1: 42: Holds in Sales (P4210/P42090/P43070/R42642) (Doc ID 1904909.1).

Excerpt:
A record is written to the Held Orders table (F4209) every time an order goes on hold. F4209 records are not purged when Release Held Orders (P43070) or Release Credit Holds (R42550) release hold codes. Over time the F4209 can grow to be a large table. EnterpriseOne does not provide a standard purge program for F4209. The document E1:42, 43: How to Purge the Held Orders Table (F4209) and/or Limit Display in Release Held Orders (P43070) (Doc ID 643117.1) describes how a custom program can be created to select and purge already processed records.

You can delete any records from F4209.HORDC <> ' ' which is already released with further filtering like HOHCOD, HOMCU, HODCTO.

 

Question 7: In Confirming Shipment, why does the released sales order goes to Hold status again?

Answer 7:  The probable cause will be the Hold Code set in customer master. In case, the delinquency status is changed, try,

Go to the customer master (P03013) and check whether it has defined hold code.

  1. Write down the customer number (F4211.AN8) for the order went to hold
  2. Go to P03013 and look for the customer, (click tab) Billing Page 2
  3. Remove hold code if any