Vendor totals may reflect last year totals or show an Amount Open when there are no open invoices.

Submit an enhancement request for a tool to recalculate vendor totals similar to the Recalculate 1099 Totals tool.

You can also submit a request to prevent posting invoices and checks with a date after the year following the current AP year.

The AP year wasn’t closed in Tasks, Close Year.

The AP Year is separate from the 1099 Year. They each have their own closing task.

Correct accumulated vendor totals

1. Verify that your AP Year Ending Date is the current year (File, Company Settings, AP Settings).
2. Close the year if it isn't current.
3. If the Year Ending Date was only one year behind, verify that your vendor totals are correct after closing the year. If they’re still incorrect, proceed with the remaining steps.
4. Download and print the reports attached below to determine the correct vendor balances and totals. How do I add a report in Reports Manager?
   • Notes:
     • The amounts on the APVendorCurrentBalanceVerification.rpt report correspond to the Current Balances tab on the vendor setup
       Attachment: APVendorCurrentBalanceVerification.rpt
     • The amounts on the APVendorTotalsVerification.rpt report correspond to the Totals tab on the vendor setup
       Attachment: APVendorTotalsVerification.rpt
     • For credit card vendors:
       1. Go to Accounts Payable, Reports, Cash Management, Payments by Credit Card.
       2. Run the report with the dates empty, the Include Verified checked, and the Include invoiced unchecked.
       3. Note the Credit Card Vendor Total.
5. Back up your entire data folder.
6. Turn on Audit Setup Activity.
7. From the Setup menu, select Vendors.
8. If prompted, click Start to print the audit report to a file or printer.
9. Enter the appropriate vendor ID and click the Current Balances tab.
10. Press Enter or Tab on your keyboard twice.
11. Correct all the incorrect totals and then click Save.
    • Notes:
      • The Open invoices box corresponds to the Amount Open total on the Vendor Totals of the Vendor Summary inquiry
      • The Available discount box corresponds to the Available Discount total on the Vendor Totals of the Vendor Summary inquiry
      • Enter something in the Last auto invoice number box before clicking the Totals tab, if needed
    • The Credit Card Vendor Total noted in step 4 corresponds to the Open Payments by credit card amount.
12. Click the Totals tab and enter the correct amounts in the appropriate boxes.
    • Notes:
      • The Amount purchased box under the This Year column corresponds to the YTD Purchases amount on the Vendor Totals of the Vendor Summary inquiry
      • The Amount paid box under the This Year column corresponds to the YTD Paid amount on the Vendor Totals of the Vendor Summary inquiry
13. Click Save and then click Close.
14. Turn off Audit Setup Activity.

Note: Correct your 1099 totals, if needed.

Warning: We provide the attached reports as a possible solution to your issue. Quality Assurance didn't review the reports. You may need to modify them to meet your reporting needs or adapt them for use with future releases of the software. Contact your Sage Consultant for assistance with modifying these reports.