Deleting AP Invoice

Is there a way to delete an AP invoice without it affecting my Financials? My financials are accurate, however I have 2 invoices on my AP Aging report that no longer show on my balance sheet, this was caused by making Journal entries to move two AP invoices to a Due To/From account for a related company. Any advice is appreciated.

Thank you,

Peter

  • 0
    Are these paid or unpaid invoices? It may be that there are transactions missing that are associated with the invoice(s) that are causing the invoices to show up on the AP Aging report, but not on for example the AP Open Invoice report. Run the AP Open invoice report from AP, Reports, Invoice registers ranging on this Vendor or Vendors to determine if the invoice(s) in question show up on this report. If they DO NOT SHOW there, then run the AP Open Invoices with cutoff date. Enter the appropriate cut-off date associated with your current GL period and then click Ranges to select the appropriate vendor(s). If the invoice(s) show up on this report but not on the AP Open Invoice report it may be due to issues with the related transactions such as missing transaction detail or future accounting dates. You can view the transaction detail in AP by selecting Inquiry, Other, AP Transactions. Double click on the vendor, then double-click on the invoice. From there you can see all of the transactions associated with the invoice and add additional columns to the view to include any of the information stored on the AP Transaction records. * The AP Invoice aging reports run from transactions, where the AP Open Invoice register runs from the AP Master file, so if the invoice is showing up correction on the Open Invoice report but not on the Aging and/or Open Invoice with cut off report, reviewing the transactions is going to be your best bet at determining how to resolve it. (The only way you can delete an invoice without it affecting the GL is by turning off the setting to CREATE ENTRIES to GL temporarily, delete the invoice, then turn it back on, but this is DANGEROUS) as changing this setting affects everyone working in Accounts Payable and not just you. Definitely recommend that you determine why the invoice is showing on the Aging reports and go from there on how to resolve it. If it looks like transactions are missing in Accounts Payable, I recommend that you call support for some help to determine the best course of action
  • 0 in reply to Denise Paulus
    These are unpaid AP invoices that our CPA had me move from AP acct 2000 to another account Due To/From one of our other companies, via a journal entry. So essentially I need to delete/remove the two unpaid AP entries without it affecting my GL, as we currently have a AP Aging balance of $1,200 and a zero balance on our financials (the financials are correct with a zero balance). I'm the only person who uses Sage CRE 300 so no problem turning off the Interface if that is what I need to do. I assume I would only have to turn off the interface to GL and not the other module, i.e. cash management, Job Cost, Billing?
    Thank you,
    Peter
  • 0 in reply to pmarkg1
    Did the CPA's journal entry move it from AP Account 2000 to another AP Account Number? Since mistakes are best corrected in the application that created the mistake, a less dangerous method of correction would be to leave the interface on and make the correction the way it should have been made in AP. Then, reverse the CPA's journal entry. Essentially the CPA does not understand your software and that the correction needed to be made in AP, which would have corrected GL through the interface.
  • 0 in reply to Rhonda V
    Thank you for your reply. In hindsight I should have reversed the GL entry provided by our CPA, but I believe I had closed the year in all applications prior to realizing a correction was needed, so I decided to make my entries with the interface turned off. I now realize the importance of making all adjustments prior to closing the year in all applications so changes can be made in the originating application. Regards, Peter