Wiki

SAP BUSINESS ONE

None Defined

Checks For Payment need to be cleared

Checks For Payment need to be cleared

Unwanted checks need to be cleared.

Manually added check numbers to our outgoing checks after check numbers had been applied via Payment Wizard. All checks printed with manuall numbers. Left with “Checks for Payment” with pre-assigned numbersthat need to be cleared.

The CHO2 table that stores the Void/Damaged record. Removing the row(s) in SQL allows for the check to be reissued with the same number and keeps the check register, journal entry and payment means consistent.

- backed up current live database - restored database to test company - tested performing transactions to correct the check number from 0 and replace it with the correct check # - provided information for client to review updated test database - received approval from client - in live database, performed transactions to correct the check number from 0 and replace it with the correct # - verified data looked ok - removed backup file and test database from sql server

Solution

06 Jun 2012