Why the sync error occurs

This error occurs when the next payment in GP has already been used and the record exists in the PM00400 table and the sync can't grab the next payment number required to generate the payment batch in GP.

How to fix the sync error

The most straightforward resolution is to prefix the next payment number with four or 5 zeroes (based on the user's preference - for example if the next payment number is 12334 prefix it with zeroes to make it 000012334.)

Steps to grab the highest payment number:

1. Log in to SSMS (SQL Server Management Studio) and select the company database that's syncing to Bill
2. Run the following query to grab the max payment number in use

• select max (CNTRLNUM) from PM00400 where CNTRLTYP = 1

1. Open the payables setup windows and change the next payment number:
   • Purchasing>Payables under Setup>options
2. Prefix Next Payment Number field with 0000's + the last used payment number that the user gets after running the query in Step 2 ( number of 0's depends entirely on the user's preferences)
3. Save
4. Run Sync

Further reading/Reference: "Unable to generate next payment number" or "Unable to generate next voucher number" error when entering a payables transaction