Vendor Prepayments from closed year will not show up

I have a vendor account (Kansas state withholding) that has a couple of payments that occurred in 2020 and are marked as prepayments. I have a current invoice that I would like to apply them against, but they do not show up in the "apply to invoices" tab of the payment. If I create a new payment marked as a prepayment in the current year, that new one does show up on the "apply to invoices" to invoices tab. This makes me wonder if part of the problem is due to the prepayments not being in the current accounting period. The other issue with the prepayments is that they continue to show up on the "Aged Payables Report", with no obvious way to remove them. How can I fix this?

  • +1
    Verified Answer

    It sounds like the prepayments were saved without a check/reference number. If they were in a current year you could just enter a check number to fix the problem. But since they're in a closed year, you'll have to print them.

    Go to the Reports & Forms menu, choose Forms, then Checks. 

    Select a check format and click the Preview and Print button.

    In the Preview and Print Checks window, click the Refresh List button. The prepayments should appear in the list. If there are other things in the list that you don't want to print, you can uncheck them, or change the "Include checks through" date on the left and/or set a vendor ID filter to just that vendor.

    Enter a dummy check number in the "Number of the first check: field and click the Print/Email button to print the "checks." If you don't want to waste paper you can go to the Print Setup tab and change the printer to Microsoft Print to PDF.

    Printing the payments will assign the check numbers. Now they should show on the "Apply to Invoices" tab of the Payments window.

    Steve Collins
    IQ Accounting Solutions LLC
    Certified Sage 50/Peachtree Consultant – providing personalized Sage 50 support and training, no contract required.
    918-851-9713 (Office hours Monday – Friday 8am – 5pm Central Time)
    [email protected]
    www.IQAccountingSolutions.com
    youtube.com/@IQAcctSolutions

  • 0

    That did it! Thanks, Steve at IQ Accounting Solutions.