RKL eSolutions Blog Trends and Insights

PO Showing Open When all Orders Have Been Recieved in Sage X3

Are purchase order still showing open when all have been received using different lots.

If you have the scenario shown below.
1. You have a product that is Mandatory Lot Managed.
X3 Mandatory Lot Managed

2. You enter a Purchase Order for a Lot Managed product with the quantity of 3000.

X3 PO ALL Full Entry

3. You receive in 3000 but use 2 different Lots, one for quantity 1000 and one for quantity of 2000, however the Purchase Order stills shows 2000 on order.

4. To create the first receipt – you entered the Site and Supplier and then from the Left List chose the Purchase Order.

X3 Purchase Reciepts

5. You change the quantity on the receipt to 1000 and enter the Lot number.

Qty Change6. For the second Lot you go to Line 2 of the Receipt and enter the information, including the quantity of 2000 and the new Lot number.

7. Create the Receipt

8. Go back to the Purchase Order and it still says that there are 2000 open.

What went wrong?

When you entered the second line you neglected to choose the Purchase Order again from the left list.  Selecting from the left list will link the Purchase Order to the Receipt.   If you go back and delete the second line and then select the Purchase Order from the left list and enter the quantity or 2000 and new Lot the Purchase Order will now show ‘Received Completely’.

[feature_box_creator style="1" width="" top_margin="" bottom_margin="" top_padding="" right_padding="" bottom_padding="" left_padding="" alignment="center" bg_color="" bg_color_end="" border_color="" border_weight="" border_radius="" border_style="" ]

Read More Sage X3 Technical Blogs from Debbie:

Resequence Components for Work Order in Sage X3

Sage X3 Serial Number Management for Product Stock

[/feature_box_creator]

Tags: Sage X3
RKL Team

Written by RKL Team

Since 2001, RKL eSolutions has helped growing companies maximize their technology resources and investment. Over the years, we have helped hundreds of small and medium sized businesses as their strategic business partner. We specialize in the needs of Entertainment, Software & SaaS, Professional Services, Manufacturing, and Non Profit organizations. Our experienced consultants have a passion for making every facet of your business successful and are intent on building a long-term relationship with every client.