We 've been having this same issue since early June , as well.

Negatives on Pending Purchase Orders reports / Dashboard  after an AP adjustment 

Our consultant has us running 'dbutil' and using Rebuild to recalculate the tables that are affected, but this issue is still ongoing.

I'm wondering if this is a result of one of the Sage Updates?  I feel like it need to be addressed.  The consultant reviewed our entire database and can find no errors.

We 've been having this same issue since early June , as well.

Negatives on Pending Purchase Orders reports / Dashboard  after an AP adjustment 

Our consultant has us running 'dbutil' and using Rebuild to recalculate the tables that are affected, but this issue is still ongoing.

I'm wondering if this is a result of one of the Sage Updates?  I feel like it need to be addressed.  The consultant reviewed our entire database and can find no errors.

Hi Tracey

Have you call support regards about this issue?  Do you have the steps to reproduce this issue?

the issue was incorrect pending order number and running Sage_SA_dbutil.exe resolved it temporary?

We are also having this issue, did anyone find a solution?

We had to contact Sage and they had to fix the issue for us.

We are not able to consistently replicate the issue....  only that it happens when posting in AP.   Not every posting.

Dbuitl does correct everything temporarily.   But we are posting daily. So error keeps occurring with negatives.

Do you know if you ran DButil? or if they had a actual patch/fix to run?  I have asked our IT dept to contact Support

Hi Tracy

There is known issue with adjusting an invoice that was from a partially converted order. This issue will be fix on next release 2020.0 

Workaround for this issue

1. Void the partially converted invoice(S), then adjust the order or convert the invoice again.

2. Run rebuild from Sage_SA_dbutil.exe, however, if you adjust another invoice that was from a partially converted order, it happens again.

Terrific news !! Thanks Jason