Overview
This article provides a workaround when users are unable to successfully post a payment journal due to an error message stating that the journal needs to print the check.
Solution
For old transactions from previous years for which the customer is sure that the checks were printed, the check and print status can be updated from the database directly by executing the following query:
update BCH_HEAD set CHECK_PRNT='T', REF_NO = ['Transaction reference'] where BATCH_NO in ([Comma separated list of payment journal batch numbers]);
Important:
- Take a backup of records to be updated by selecting into a temporary table
- Edit the query to include the BATCH_NO for the Payment Journals that could not be posted
- Update the transaction reference as appropriate through the REF_NO field.
Example:
update BCH_HEAD set CHECK_PRNT='T', REF_NO='ACH' where BATCH_NO in ('8550','8552','8553','8556','8557','8562','8563','8565','8566','8568');
Testing
Payment journals should be posted successfully to the Accounts Payable Journal.
Comments
0 comments
Please sign in to leave a comment.