The purpose of the report is to get the quantities in various locations to be in sync with what is specified on the work order details. The open work order commitments can be incorrectly stated when a work order is closed or cancelled with open quantities remaining. It is recommended to run the R3190 repost on a regular basis to clear out these remaining commitments.
What the Repost Open Quantities batch program will do:
The R3190 looks at the WASHTY field (Work Order Pick List Printed) in the Work Order Master File (F4801). If it is set to 1 (WO pick list printed), the program updates the Commitments field in F3111 to H (Hard Commit) for the components on the WO.
This program subtracts the Quantity - Work Order Commitments value (FUN1) from the total commitments value (PCOM) in the Location File (F41021).
The program then recalculates the commitments based on the parts list records that belong to work orders with a status below the status in the program's processing option.
It will populate the FUN1 field with this value and then add it to PCOM to give an accurate commitment quantity.
Perform a net change on all values for the quantity and quantity committed in the Item Location (F41021) table for the selected items and then recalculate the commitments.
The R3190 (Repost Open Quantity) will not change a hard commit to a soft commit based on changes to the Manufacturing Constants (P3009). When a parts list is attached to a work order and the material is hard committed, that commitment remains until the work order is fully issued or until a user goes into the parts list and changes the location either manually, through the multi-location screen or if need be, by SQL. This commitment can be cleared out by running the R3190 once the work order is at a status that is at or above the status of the processing option set in the R3190, but it cannot be changed from a hard to soft commitment.
On a side note, if the Manufacturing Constants are changed from soft to hard then the R3190 will change existing soft commitments from soft to hard. If Manufacturing Constants (P3009) are set up originally with hard commitments and then changed to the soft commitment method, the quantities that were already hard committed will still be hard committed. Running R3190 will retain the hard committed quantity.
For parent Item
Repost the quantity value in the Item Location table for the parent item. The system uses the information from the Work Order Master table (F4801) and the following calculation:
Quantity ordered - (quantity completed + quantity scrapped)
For component Item
Repost the quantity committed value for components in the Item Location table for the location specified on the work order parts list for the item. Items selected based on values from work order parts lists are reposted for every location record in the Item Location File. The system uses the information from the Work Order Parts List (F3111) table and the following calculation:
Quantity required - quantity issued
How to use Repost Open Quantities batch program:
1. For the component:
- If there is a mismatch in the calculation (erroneous calculation) in F41021 (Availability), the status in the PO should be bigger than (more than) the status of the existing WO’s that need to be processed for recalculation.
- If there are WO’s at an intermediate status that need to be processed (they are not planned to be advanced to 99) and there are commitments created for them, the status in the PO should be smaller than (less then) the intermediate statuses. This will clear the commitments for the components and return the reserved quantities to the initial location.
2. For the parent:
- If there is a mismatch in the calculation (erroneous calculation) in F41021 (Availability) for On Receipt and On WO quantities, the status in the PO should be bigger than (more than) the status of the existing WO’s that need to be used for recalculation.
- If there are WO’s at an intermediate status that need to be processed (they are not planned to be advanced to 99) and there are On Receipt and On WO quantities created for them, the status in the PO should be smaller than (less then) the intermediate statuses. This will clear the On Receipt and On WO quantities for the parent.
It is recommended to use option B) with caution, as setting a small status (like ‘30’) in R3190 PO may cause all WO’s for that item to be affected (including the correct ones, which are not at ‘99’ yet). Workaround: temporarily have the WO’s that need to be excluded from the processing advanced to a status smaller than (less than) the one in the PO’s. Since there is no trouble with the corresponding quantities/commitments in F41021, after the processing of the target WO’s, the excluded WO’s status can be reverted back to what is was.
Also using in the PO a status smaller than ‘10’ (default WO first status) can cause unwanted WO selection.
Try this first in a non-production environment.
For more information on Work Order Repost R3190, please review the documents below:
- R3190 Understanding Work Order Repost (Doc ID 1248874.1)
- R3190 Work Order Repost Performance Checklist (Doc ID 661998.1)
- R3190 Repost for Service and Equipment Maintenance Orders (Doc ID 953132.1)
- What to Check When Troubleshooting Work Order Repost (R3190) Performance Issue (Doc ID 2300247.1)
- Enhancement Request For R3190 Report to show all changes made by repost UBE (Doc ID 2356330.1)
- To Add 2nd Item Number (LITM) In Data Selection Of Work Order Repost (R3190) (Doc ID 2287231.1)