An example of a case where a file fix is needed:

The Amount on the invoice is correct, the Amounts on the distributions are correct and sum up to the invoice Amount, the distributions have the correct Amount Paid amounts, and the payment transactions sum up to the distributions paid amounts, but the invoice Amount Paid is incorrect. In this case a file fix is needed to update the Invoice Amount Paid (there may be other records needing updating to, like the Invoice Payment).

There is a penny difference between an invoice's amount and its payment calculation.

Determine the Amount and Amount Paid to make appropriate changes. Use the attached report to identify and correct your invoices as follows:

Notice: The attached report is provided as a possible solution to your issue. It was not reviewed by Quality Assurance. You may need to modify it to meet your reporting needs or adapt it for use with future releases of the software.

1. Download and print the attached report amt_vs_amt_paid.rpt. Refer to article ID 18607 DocLink: How do I save, add, and print a report design?
   Note: Use Ranges or Conditions to select specific invoices.
2. Review the report and compare the following fields. Identify any that have a discrepancy but should be fully paid.
   • Amount and Amount Paid
   • Tax and Tax Paid
   • Retainage and Retainage Paid
   • Discount Offered and Discount Taken or Discount Lost
3. In Accounts Payable, from the Tasks menu, select Change Invoices.
4. Enter the vendor and invoice ID of the invoice you want to correct in Change Invoices.
5. Adjust the Amount, Tax, Retainage, or Discount on either the invoice or distribution level to equal the corresponding payment field which appears on the report.
6. Change the Accounting date if the invoice is for a closed period.
7. Accept your invoice or distribution changes.
8. If you changed the Accounting date, select Revised date for the reversing entry when prompted. Click OK.
9. Click Finish.
10. Click Start to print your journal to a file or printer.

To prevent this from happening going forward, when entering the the invoice, do not enter the tax amount at the invoice level. The invoice tax amount will calculate from the distributions once the invoice is accepted.

If the software does not allow you to change the invoice, for example you receive an error message that you cannot get past, or the change does not correct the problem, a file fix may be needed. Contact Sage 300 Construction and Real Estate Support to confirm if a file fix is needed and if so, request a file fix with Sage Professional Services Group (there is a fee associated with these services).