Shipment status broken again, confirmed status shipment can neither be prepared invoice nor correct shipment.

  • 29 December 2020
  • 8 replies
  • 109 views

Userlevel 4
Badge

Hello,

       We are using 2020R2 103 version.

      We encountered another shipment status issue.  We are having shipment as status “confirmed”.

However, the user can not “prepare invoice” based on it. It will show error:  

And, the user can not “correct shipment” . It will show error:  

 

I checked the Database, it looks like for some unknown reason , the “confirmed” column has not been set to 1.

 

This is the second time, our user met the status mess up issue.  Unfortunately, we do not know how to reproduce it.
Can Acumatica developers do an in-depth research to solve the root cause?


8 replies

Userlevel 4
Badge

Hello,

       I do not recommend the below steps. But I used it to fix the issue I met.

Note: Our user recreated a new SO and Shipment to fulfill customer’s need. so the incorrect shipment and its related SO are not needed anymore.

So, I just updated the shipment status to Open with sql script in DB, which is very risky, and I do not recommend it .
Then, after the shipment has been backed to Open, I can delete it from the screen, and then also I can delete the related SO.

But I do help Acumatica can fix this potential issue from the root.

Badge

@ray20 , such data consistency issues should be addressed as suport case since it is customer specific

We never recommend inventing your own data correction scripts - there are really risky

Userlevel 4
Badge

@ray20 , such data consistency issues should be addressed as suport case since it is customer specific

We never recommend inventing your own data correction scripts - there are really risky

@mvolshteyn

Hello,   Mark. Sure. I truly and fully understand.
Actually, the first time I met such issue, I did submit a case, and got support from you and your teammate.
The second time, I met it, I figure it is quite similar, So I can get this done.

Poorly, just today, we met a third time, the same user. I don’t know what her steps. We have multiple user s and only this user make this error out. But she would do 10+ shipments a day, and she only get 1 wrong. I don’t know why? Any suggestions?
We need to get the root cause. 

Following. I have a customer experiencing similar issues.

Badge

@ray20 , this should be resolved through support cases. Can you tell me case(s) number(s)?

 

Userlevel 4
Badge

@ray20, this should be resolved through support cases. Can you tell me case(s) number(s)?

 

@mvolshteyn  Hello Mark, as I said, we encountered this issue 3 times until now.
The first time I submit a case with case number “166486”
This case is solved and closed, however it is only solved the invalid status itself.

 

The second one and the third one I solved it on my own, because they are similar. And I take very care.

 

Now, I have enabled the “audit trail”, if this issue happen again, I would submit a new case with the audit details. Does this sound good?

 

Badge

@ray20 , yes, this exactly what I request. You might also explicitly ask the support not to close the case after the incident resolution, but try to look into root cause

I am experiencing the same issue, so definitely would like to know the root cause. I have audit trail enabled and do not see anything in the audit that would point to the problem. I have already opened a case and awaiting resolution.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved