Change Invoices hangs when attempting to change an invoice in Accounts Payable
Description
Cause

This may be caused by one of the following:

  • A distribution for 0.00 was paid and then deleted before voiding the payment.
  • A credit distribution was paid, then changed to 0.00 and deleted.

For example, a credit invoice for -$200.00 is split into two distributions, Dist 1 is -$150 and Dist 2 is -$50. Then this invoice is included with a check to help pay some of the invoices. It is discovered that incorrect accounts were used on the credits. The invoice is changed and Dist 1 and 2 are changed to 0.00 amounts and Dist 3 is added for -$200 to a different account. Then Dist 1 and 2 are deleted. The invoice now shows open for -$200 because Dist 3 is not paid.

The invoice cannot be corrected or changed after this as there is an existing Dist Payment record for the deleted distribution that causes Change Invoices to hang.

Resolution

To confirm this is the issue, review the transactions for the invoice. Refer to How can I view transaction detail of a deleted invoice in Accounts Payable? You will find the credit distribution was paid and then changed to zero and deleted or a distribution for zero amount was paid and then deleted.

Once the issue is confirmed, contact Sage 300 CRE Support to request a file fix with Sage Professional Services Group (there is a fee associated with these services).

If this is not your issue or for a possible workaround, see Why does Change Invoices hang when I click Accept Invoice in Accounts Payable?

 

In the future, for invoices such as this, the original distributions should be left as they are and not changed or deleted. New distributions should be added to reverse/offset the original distributions and new credit distributions created to code them correctly.

See What changes can I make to a fully paid invoice in Accounts Payable? and How do I change distribution information on a paid Accounts Payable invoice? for more information.

 

Steps to duplicate
Related Solutions