This has been happening way too often and Epicor support isn’t much help either
We have been shipping orders normally, but sometimes the shipped orders don’t update the sales order. When you go to the SO, the shipped qty does not get updated but the tracker shows that the line has been shipped and invoiced.
If we manually close the line then it shows that the line was voided.
Any idea how to fix this? This has been happening randomly, can’t identify any pattern. Epicor help can’t solve this for us either.
Do you have any data directives on our OrderRel table or any method directives on the CustShip Method, or any customisations on the Customer Shipment Entry.
My understanding is it’s the OurShippedQty fields on the OrdeRel Table that should be being updated to reflect in the tracker.
My thinking is you have some code that is preventing the update of those fields in the OrderRel table.
If you are using classic, I would do a trace when you are shipping a pack and see what it yeilds. This will tell you what methods are firing. It won’t help you if it’s a form customisation though. You would have to use VS and debug the form to step through.
Sorry I should have mentioned that this is happening quite haphazardly - this only happens probably 10% of the time and I can’t seem to find any correlation between the sales orders that didn’t work.
I checked any data directives on orderrel table but can’t find anything apart from the change log tracker
As much as I don’t want to say this, you may want to implement some check on shipping to confirm the SO release lines have updated and act appropriately to lot/alert and update the data…
As a matter of interest do you use the Auto Invoice option?
I would be wanting to dig into see if you have any errors in the event or server logs to see if you are experiencing any deadlocks. It may be that it is erroring silently behind the scenes. Are your invoices matching the correct totals on the Sales orders?
We had this issue in 9.05 on occasion. Epicor always had to supply a fix so we could update the quantity shipped on the order. We never figured out the root cause as it happened so rarely and sporadically.
