Troubleshoot contract invoice payments

The following table describes potential error conditions that might occur between payments and contract invoices and provides possible solutions.

Problem Possible solution

Payment date <date> cannot be before the <invoice number> contract invoice posting date.

Enter a payment date that is later than the invoice date <<DATE>>, or use an advance to receive an early payment.

To ensure data integrity, the Contract data workflow requires the receive payment date to be on or after the invoice GL posting date. This is true for contract invoices even if your company doesn’t have the "Payment dates must be greater than their invoice dates" option selected in the Configure Accounts Receivable page.

In scenarios where you need to receive a customer payment before the invoice GL posting date, do the following:

  1. In Accounts Receivable, create an advance with the following information:
    • Customer ID = Customer ID on the contract invoice
    • Receipt date/Payment date = the actual receipt and payment dates
    • Dimension values = select desired values. For example, it can be helpful to tag the advance with the applicable contract dimension for reference.
  2. Receive the payment using the Receive payments page as follows:
    • In the Payment information section, select the applicable Customer and use the contract invoice GL posting date as the Receipt date.
    • In the Selected invoices section, add the applicable contract invoice.
    • Select Available credits and select the applicable advance.
    • Select Save.
A payment has been made against this Invoice / Adjustment. You can't delete a contract invoice if a payment or credit was applied to the invoice. Even if you reverse the payment, you won’t be able to delete the invoice. In this scenario, see Reverse the effects of a contract invoice.
We found an internal error with the payment dated <payment date> for billing schedule keys <keys>. The payment data  is not synced with the latest payment schedule data. Contact your Sage Intacct Support resource, tell them you received this error, and they will resolve the issue.

This may occur when you try to reverse a contract payment. This is a data issue —there is nothing you can do to fix this error on your own.

Contact your Sage Intacct Support resource and they will resolve the issue.