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 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.

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.

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