Setting Payment Cutoff Date


What it Does

Wise-Sync takes the last updated date of an invoice to determine invoices that have changed since the last payment sync, updating ConnectWise with the actual date of the Payment as per the accounting system.

What it Means

This allows QuickBooks Online & Xero to have a cutoff date, which will set the Payment Date to sync back to.

What Configuration is Required


ConnectWise: Creating API Credentials:
The API Key Setup Table enables you to set up a key to use to authenticate the member that is selected when using APIs.  API Keys and API Logs are available for all member types.
Setting up an API Key allows the API to impersonate the member and perform any actions that the member can.   The security role of the member is applied to API actions when an API key is used.
1. Click on your user account in CW members
2. Click on the API tab
3. Click new [ + ]
4. Enter a Name Wise-Sync
5. Save to generate the public and private key
6. Record the keys in Wise-Sync
7. Press Save.


Description: A name to describe your API Key.
Public Key: The key is used by the integration to set up and log into ConnectWise.  The Public key is automatically generated the first time the record is saved.
Private Key: This key is used by the integration to setup and log into ConnectWise.  The private key is automatically generated and only visible the first time the record is saved.
For further information please refer to the ConnectWise University: https://docs.connectwise.com/ConnectWise_Documentation/090/040/010/API_Members_Tab_-_Members_Screen


Wise-Sync: Part 1 Configuration:
1. Log into Wise-Sync
2. Click Account
3. Click CW API Member
4. Enter Member's Details
5. Click Test ConnectWise REST Connectivity
6. Click Save


Wise-Sync: Part 2 Configuration: 
1. Log into Wise-Sync
2. Click Companies
3. Click Payment Sync Options
4. Enter details
5. Click Save




Scenario's

Scenario 1:

Payment is applied in QBO to an Invoice before the cut-off date, and the payment details do not match the payment amounts applied on the ConnectWise Invoice

Current Functionality:
Currently Wise-Sync removes the payments, or updates to only payment amounts applied, not including credits or journals.

New Enhancement:
No changes will be made in ConnectWise.  Record and change date are before the cutoff period


Scenario 2:

Payment is removed from QBO for an invoice payment dated before the cut-off-date.  Invoice LastUpdateDate is now after the PaymentCutOffDate, and after the WiseSyncLastPaymentSyncDate. This will result in the Payment being returned from QBO as a currently payment for sync.

Current Functionality:
Currently Wise-Sync removes Payments, updating payment amounts and LastPaymentDate on Invoice (A) to the sum of current payments if other payments present.  Invoice (B) is updated with the new payment amount applied, not including credit or journals.

New Enhancement:
No changes are made in ConnectWise
Payment Sync displays a warning that the payment was not applied due to Payment CutoffDate, displaying the amounts of the payments as detailed in the Payment Sync Results.


Scenario 3:

Payment is added to ConnectWise before cutoff date (and no payment is applied in your accounting package).
No change has been made to the invoice in QBO, so LastUpadeDate will be before the WiseSyncLastPaymentSyncDate.  No payment data is laded from your Accounting Package.

Current Functionality:
Wise-Sync removes Payment applied in ConnectWise, updating ConnectWise Payment Amount and ConnectWise Payment Date to the date of the Payment Date and Payment Amounts.

New Enhancement:
Payment in not updated


Scenario 4:

Payment is added to ConnectWise after CutOff Date (and no payment is applied in you accounting package).
No change has been made to the invoice in QuickBooks Online, so LastUpdateDate will be before the WiseSyncLastPaymentSyncDate.  No payment data is loaded from Accounting Package.

Current Functionality:
Currently Wise-Sync removes payment applied in ConnectWise, updating ConnectWisePaymentAmount and ConnectWisePaymentDate to the date of the PaymentDate and Payment Amounts, which in this case would be 0, resulting in the payment being removed from ConnectWise.

New Enhancement:
Payment is updated in ConnectWise

Recommended for use only when: Past periods have invalid data resulting in incorrect payment applications in ConnectWise.

Additional Resources:


Xero Conversion Invoices: http://setup.wise-pay.com/knowledgebase/articles/1174939