An Incorrect Payment Total Prints on Your 1099 Form

The easiest method to locate an incorrect payment amount is to examine the Vendor Ledger report.

  1. From the Reports & Forms menu, select Accounts Payable. Sage 50 displays the Select a Report or Form window. Select the Vendor Ledgers from the report list.
  2. Click Options.
  3. Select This Year in the Date drop-down list.
  4. In the Filters section, click Vendor ID.
  5. Under Select an option, click the One or more radio button.
  6. Scroll to the vendor you want to view and check the box next to their name.
  7. To display the ledger on the screen, click OK. This will display all transactions for the year for the selected vendor.
  8. Check the accuracy of the Debit amounts, those with a type of CDJ. One or more of these payments will be incorrect.
    • Double-click the amount of any incorrect payment to drill down and display the transaction detail in the Payments window. Correct the payment; post the payment; and return to the Vendor Ledger report window. Continue this process for each incorrect payment.
  9. If you suspect that a vendor check is missing, you may have entered an incorrect date. For example, the check date could have been mistakenly entered in a previous year.
    • With the Vendor Ledger displayed in the Report window, select the Options button. Select ALL in the Date drop-down list. Then click OK. Locate the check; adjust the date; and post the payment.
  10. Finally, reprint the 1099 forms for these vendor(s).

    Note: Please keep in mind that the revised check amount will affect reconciliation of this cash account.