Skip to main content

Dear experts,

The customer wanted to receive 1 qty to inventory which is the same as the PO quantity. However, the inventoried quantity is 8 which is greater than the expected by 7. Please see the below.

Additionally, Purchase UoM and Inventory UoM are the same, and the inventory conversion factor in the PO line is 1. The receipt cannot be canceled currently.

Need to know the reason for this and a perfect solution to remove the excess qty.

Cheers,

 

 

Hi @R.Abeygunawardhana ,

Receival of goods more than the ordered quantity in PO (Over Delivery) can be restricted with below setting in Purchase Part.

If you select ‘Error’ for Action Authorized (for Authorized PO arrivals) and/or Action Non-Authorized (for Non-authorized PO arrivals) depending on your business scenario, system will not allow the user to receive goods more than the ordered quantity in PO. System will throw up an error message instead.

You may apply above setting to restrict over delivery in the future.

However, even in an instance of over-delivery, header Arrived Qty will be equal to the Arrived Qty under Inventory Units section, given that the source UoM & inventory UoM are similar.

To understand what has really happened in this problematic receipt, I would suggest you to check below records,

  1. ARRIVAL Inventory Transaction for this receipt
  2. Receipt history and Details tab in this receipt record

Once we could find the root cause for this issue, the best solution to remove the excess quantity can be decided.

Regards,
Kethaka


The issue appears to be that somehow with 1 as the Conversion Factor on the PO Line the math resulted as 1 PCS (Source) * 1 (Conv Factor) = 8 PCS (Inventory).


Hi @R.Abeygunawardhana ,

Receival of goods more than the ordered quantity in PO (Over Delivery) can be restricted with below setting in Purchase Part.

If you select ‘Error’ for Action Authorized (for Authorized PO arrivals) and/or Action Non-Authorized (for Non-authorized PO arrivals) depending on your business scenario, system will not allow the user to receive goods more than the ordered quantity in PO. System will throw up an error message instead.

You may apply above setting to restrict over delivery in the future.

However, even in an instance of over-delivery, header Arrived Qty will be equal to the Arrived Qty under Inventory Units section, given that the source UoM & inventory UoM are similar.

To understand what has really happened in this problematic receipt, I would suggest you to check below records,

  1. ARRIVAL Inventory Transaction for this receipt
  2. Receipt history and Details tab in this receipt record

Once we could find the root cause for this issue, the best solution to remove the excess quantity can be decided.

Regards,
Kethaka

Hi @KethakaG 

Below are the findings based on your comment.

Still can’t figure out where the issue has occurred.

Cheers,

Randunu


Hi @R.Abeygunawardhana ,

Thanks for sharing the additional details!

I have reviewed them but couldn’t identify any probable cause for this anomaly.

As @matt.watters mentioned, it seems that the conversion hasn’t happened properly. However, if the inventory conversion factor in the PO line is 1, then this issue is likely due to a data error.

I assume this is a one-off issue that cannot be recreated. Therefore, technical intervention might be required to fix the problem.

Regards,
Kethaka


Hi @R.Abeygunawardhana ,

Thanks for sharing the additional details!

I have reviewed them but couldn’t identify any probable cause for this anomaly.

As @matt.watters mentioned, it seems that the conversion hasn’t happened properly. However, if the inventory conversion factor in the PO line is 1, then this issue is likely due to a data error.

I assume this is a one-off issue that cannot be recreated. Therefore, technical intervention might be required to fix the problem.

Regards,
Kethaka

Hi @KethakaG 

Thank you so much for your input on this. I also believe this is a One-off issue. Thought of scraping or counting out the additional inventory added.

Cheers,

Randunu


Hi @R.Abeygunawardhana.  Did you look at the Supplier for Purchase Part record?  What shows for the Inv Conv Factor?

 

Based on the above setting, this is what the Receipt would look like.

 

I saw a note that it shows 1 for the Inv Conv Factor on the line.  If the Supplier for Purchase Part record shows something other than 1 and this was changed to 1 on the PO Line and the receipt quantities are not as expected, a case to IFS should be created to see if this can be replicated in a CORE environment and if it can be replicated, a solution can be provided.

Please advise if this helps and/or if additional information is needed.  Thanks!  Jane


Reply