Hello Abram,

This could be due to orphaned allocations. Apply the suggested solution on this link and let us know if this fixes your problem.

support.na.sage.com/.../viewdocument.do

Sometimes it could be due to the user accidentally clicked on the "preparation" button. Check the "Sales -> Shipment Preparation -> Pick Tickets" and see if there's any pick ticket created by accident for this order. If there's one, just delete it, and it should release the order from "under preparation" status. 

That's what I thought but there aren't any pick tickets for this order.  

It did not.  There was nothing to deallocate.  Nothing came up when I ran the UTIVEN03 utility.  I had stuff come up in the stock resync but not for this product.  What does the stock resync actually do?  What is this telling me?

The thing out of the ordinary was last week someone changed an already existing product code from one product category code to another and I'm thinking we are getting some wierd things happen because of that.  But that product is not on this sales order.  

When I try to delete the line in the sales order this is the message I get:

But there is no pick ticket, delivery or invoice for this sales order anywhere?

Any ideas??

In the sales order right list, options....status, I found a prep list associated with this invoice.  Can anyone tell me where to go to find this list so I can delete it?  

Regarding to your question on stock resync, it's a utility to sync up your inventory in various tables. X3 keeps inventory balance and value in different forms. For example, it's keeps a FIFO stack base on each receipt with quantity and value. So if you decided to use FIFO valuation, the system can keep track of the cost and quantity. X3 also keeps the average cost and total inventory in a separate table. In theory, your total quantity on your FIFO stack should always be the same as total inventory. And your average cost should be the same as your  total value on your FIFO stack divided by the total quantity. However. if for whatever reason these number are not agreeing with each other, the stock resync function will make the adjustment so they will agree.  

In your case, it's showing the Average cost on product 111553 has been adjusted from $1.3451 to $1.345137 and the material cost portion of the average cost breakdown has been adjusted from $1.3451 to $1.345137. 

Try "Sales -> Shipment Preparation -> Preparation Plan". I haven't done this for a while, so I am not sure how to delete it. Maybe turn it into pick ticket and delete the pick ticket?

Thank you, that was the best explanation I've received!  I found a prep list associated with the sales order I'm have trouble with.  I found it in the sales order right list under options, then status.  Do you know where I go to find that list so I can delete it by any chance?

Try "Sales -> Shipment Preparation -> Preparation Plan". I haven't done this for a while, so I am not sure how to delete it. Maybe turn it into pick ticket and delete the pick ticket?

It worked!  Thank you so much.

Identify the preperation number via the journal traceability on the sales order line. Open prep plan and enter prep plan list number. If line is on the list untick and save to reverse.

Hi Abram2388, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey