About Data Collection Transaction Validation

Data collection transactions are not posted if they have an error status. After problems that caused errors are corrected, use the Validate Data Collection Transactions utility to revalidate the transactions and mark them as ready for posting. This utility forces the same interactive validation as if the data were being entered for the first time.

We recommend that you run this utility at the end of each work shift that includes data collection processing. Do not run the utility more than two or three times per day.

You can manually run the utility or use the Actions > Background Queue menu option to schedule it to run at a convenient time. If the adjustments or corrections will be performed throughout the day as time permits, schedule this utility to run several times a day in the background.

You can use the check boxes on the utility, along with the background queue, to create multiple schedules to revalidate transactions from different error processing forms at different times. The check boxes also allow different users to run the utility concurrently for different types of transactions.

Examples of Error Corrections that Require Revalidation

  • Miscellaneous Issue transactions may require an increase in inventory. Users might not issue all material for a work center item between the time multiple dcwc transactions are entered and the time the transactions are posted.
  • Miscellaneous Receipt transactions may require creation of locations.
  • Transfer orders, purchase orders and customer orders must have a status of Open in order for related transactions to post. Often these orders are closed before all the transactions are posted.
  • Product code and inventory locations may require corrections to the account setup.
  • An error might occur where the database was too heavily loaded and a transaction failed to post due to a deadlock. You can manually run this utility with the appropriate check box selected, as a quick way to clear the deadlock error so that another attempt can be made to post the transaction.

Notes

If On Hand Negative errors occur, all records from the dcwc table are placed in Pending status until posting is run. Depending upon how far the posting process gets before an error occurs, a significant rollback can occur. Resubmitting these records frequently can cause heavy loads on the database server and transaction processing. We recommend that you perform all inventory adjustments and corrections prior to running this utility. If adjustments and corrections are performed throughout the day as time permits, then you can schedule this utility to run only several times a day.