We’ve run into issues where our PO accrual account is overstated due to duplicate or mismatched transactions. Examples include:
-
POs created but later paid by credit card,
-
Vendor bills entered without a matching PO,
-
Duplicate POs or receipts for the same items,
-
POs received in error or not closed properly.
Right now, the only way to confirm is by going line by line through hundreds of transactions, which is very time-consuming.
Question: Has anyone built reports, generic inquiries, or other tools in Acumatica that can quickly identify and confirm duplicate or mismatched PO accruals across these types of scenarios? If so, what fields, filters, or logic worked best?
In addition, what controls, best practices, or system setups have you found effective in preventing these issues from recurring (e.g., automated alerts, required fields, workflows, or periodic reconciliations)?
Any examples or lessons learned would be greatly appreciated.