How to Identify the Cost Accounting Process errors

Summary:

We have customer requirement that before error records coming to the "Review Cost Accounting Processes" page.

how can we identify those records in advance? Can we have a sql query to get those records? So that customer can

fix the error records in advance.

Content (please ensure you mask any confidential information):

Example of error message:

The work order close transaction could not be processed because there are unprocessed transactions on this work order.

The standard cost for this transaction does not exist.Enter a standard cost for the item and valuation unit.

Distributions weren't created for the COGS transaction.