Question: Why doesn't the System allow the User to issue Quantities that are Greater than the Shortage Quantity from the "Shortage List & Issue" button in the PO Receiving module?
Answer: This would require the receiving code to get into yet another level of complexity to take care of the whole new logic, which KIT module is already designed to deal with. The complexity gets even greater when receiving parts that are lot coded and/or serialized. To deal with this new level of complexity we are facing to issues; 1. Slowing down the PO receiving save routine, which can cause lockups like we experienced before not only in the PO modules, but KIT and Inventory modules as well. 2. Managing the code – Even though the code in the PO and KIT modules for the over-issue logic is similar it cannot be exactly the same due to the differences of the data moving in those modules, therefore we cannot create one function to use by both modules, and this usually creates a “code management” issue. As modules evolve the code will start deviate between two modules and we will face un-necessary errors from having two similar codes but serving different functions. The verdict is that the user should use KIT module in situations when the quantity issued to the work order from PO receiving is greater than the shortage quantities.
Problem: User enters the PO Receiving module and receives PO #990026, for part number XXX-OOO, after entering the accept quantity, user goes to "Shortage List & Issue" button to issue part number XXX-OOO to WO #34. The KIT required for part number XXX-OOO is 58.5 inches. The Purchase Order UOM is feet, so the PO Receiving converts the KIT required qty to 58.56 inches. Which is more than KIT required qty, and makes the "Short Qty" negative. So system will not allow user to save the issue.
Here is a bit more explanation why the situation (described above) is not allowing to kit from PO Receiving because of the UOM conversion.
Our tables POITEMS, PORECDTL, and INVTMFGR have qty field with two decimals after the point.
In case like described above, the purchase UOM is “FT” and Stock UOM is “IN” conversion is 1FT=12IN. user has shortage for 58.50 IN. If you convert this number into the FT you will get 4.875 but it is being rounded to two decimals 4.88, now if you convert 4.88 back into the IN now you will get 58.56 which are more than shortage and we do not allow issue more than shortage to the KIT from the PO.
In order to check that we can validate the quantities involved, we have to run forward and backwards the numbers to be sure they match up. Sometimes they don’t. Our only option is to calculate the shortage number from converting from the shortage in stock units to the receipt in purchase units, then back again. But when this happens, we don’t always end up with the same number in stocking units to be applied to shortages. Because we can’t issue more than the exact shortage through the PO module, we can’t complete the action. To make provision to have the overage issued to the shortage and create wo-wip inventory would be just too much complexity to the receiving module, already a very complex set of programs. See the "POuom.xls" attachment for further detail.
This is why the PO Receiving Shortage option is thinking that you are attempting to over-issue to the kit and will not allow overissue to the kit from PO receiving.
Resolution: The user will need to use the KIT module when the quantity issued to the work order from PO Receiving is greater than the shortage quantites.
|