Cheque Error - There is No Data to Report / There is No Data to Lookup

I am fairly new to Sage and have been using the most basic features of posting invoices and paying vendors...My boss was rushing to get this cheque out before 5pm and I only had a few minutes to organize the payment so I am not even really sure where it went wrong but I will explain my steps.

  • I originally posted a cheque (Payables --> Payments --> Pay Purchase Invoices) but realized I had forgotten to add a memo that boss had requested. I voided the cheque and moved on to the next cheque number.
  • I printed the cheque with multiple invoices that needed to be paid for this particular vendor
  • I got very confused because the Vendor had invoiced us twice for the same thing, once as invoice 000616 and once on Invoice 8069 (they do reference Invoice 000616 but add it again...)
  • I tried to reverse invoice for Invoice 000616 and adjust invoice 8069 to ensure that it was the correct amount including the Invoice 000616 and completely disregard Invoice 000616 as "additional information pertaining to this particular charge".
  • I believe I did these reversed changes after posting the cheque... I realize now I should have adjusted the payment and then adjusted the invoices and then reprinted the cheque but now it is too late
  • When I view my Reports --> Journal Entries --> All I am able to view that these Invoices were paid on the correct cheque... But when I double click the cheque number to view the Payment it says "There is No Data to Report"
  • When I click Payments --> Find Payment or Payments --> Adjust Payment and try to open cheque  it says "There is No Data to Lookup"
  • I was thinking about reversing all the invoices and re-entering them but realized I can't do this because then all the invoices will be added as a CN but Sage (Will they?) Since cheque is already posted and Cannot be reversed.
  • I can view the Invoices and they read as "Paid" but yet I cannot view the payment records for the cheque.

Please help resolve this issue.

  • 0

    Hi,

    You may be able to match up the payments, by printing off the aged Payables listing.

    Select the date of the cheque as the report 'as of' date, and

    detail report type, and to include

    payments made in the last 1 day.

    I hope that helps, please post back

    Randy