PO Return Entry – UOM Flexibility Issue in Sage 300

Hi All,

I have a question regarding the PO Return Entry in Sage 300.

Let’s say I have an item called Apple, and the UOM (Unit of Measure) conversion rates are as follows:

  • 1 Pcs (Stocking UOM)

  • 1 Box = 6 Pcs

  • 1 CTN = 24 Pcs

Now, I want to order 100 CTN of apples from Supplier A. So, I enter a Purchase Order with the item Apple, Qty = 100, UOM = CTN.

After that, Supplier A ships 100 CTN of apples to my warehouse. Therefore, I enter a Receipt Entry for the item Apple, Qty = 100, UOM = CTN, as that is the actual quantity received.

As part of a business agreement with Supplier A, we are allowed to return any rotten apples, even after receiving the shipment.

A few days later, we find that 5 Pcs of apples are rotten and need to return them to Supplier A. I want to record a PO Return Entry to reduce the stock in my warehouse accordingly.

However, during the PO Return Entry process, when I apply it to the Receipt document, all the information from the Receipt is auto-populated. At this point, I only want to return 5 Pcs of apples, but the system does not allow me to change the UOM from CTN to Pcs.

My question is: Does Sage 300 have any settings or configurations that allow us to change the UOM during the PO Return Entry process?

  • 0

    Hi Yoyo, 

    You can always just leave the Receipt Number field blank and just enter the line items you want to return.. 

    If you associate the Receipt Number on the return, then you have to return the items in multiples of the UOM.. 

    If you allow Fractional Quantities in IC.. then you can enter a fractional quantity of the CTN.. so if you are returning 6 Pcs of the CTN, then just enter .25 in the Quantity.. if you are allowing Fractional Quantities..

    Otherwise, leave the Receipt Number field blank and just insert a line as you would normally do in a regular transaction.

    Regards,

    DCrampton

  • 0

    Hi DC,

    Once again, thank you for the information regarding this new query. I think I will proceed by leaving the Receipt Number field blank and just entering the line items I want to return.

    Regards,
    yoyo