Administration, Core Financials, and Project Accounting

[snolte]

I've got a real interesting one on my hands here and while I think I may need Sage to help resolve I'm wondering if anyone has come across this before:

Vendor A has $1,500 of unapplied payments on the Multicurrency/AP Aged Payables Report.  I look up Vendor A on the Vendor status, these payments do not appear.  I go the Vendor Payment Explorer and there are no payments in the list with an amount listed as "Unapplied".  However, if I click on the payments that should show as unapplied, and preview the applications, the section is blank.

If I go to Apply Payments/Memos, the payments do not appear for selection.  Other more current payments come up as do outstanding memos. 

This issue exists for a number of vendors from approximately the same time period in 2009.  It is our UK office, so I'm here trying to tidy the ledgers up for them and having no luck.  A bunch of them have a net 0 balance but obviously they still come up on our aging reports.

I am confident that the aged payables is correct (bank reconciles, vendor statements line up), but I need to clear the older invoices that are also outstanding against them.  Can anyone offer any insight or suggestion?  I'll likely be calling Sage next week but wondered if it's been seen before.

[trodman]

You would probably have to run a trace and look at the SQL tables to know what is going on.  Just curious though, have you tried running "AP -> Activities -> AP Utilities -> AP Recalculate History"? That's the only quick thing that I can think of.

[snolte]

Thanks for the suggestion, Tim.  I had tried that but with no luck, so have submitted a case on it.

Cheers,

Sarah

[snolte · Accepted solution]

The solution involved updating the Unapplied Amount and Unapplied Amount HC in SQL for each of the items that should still have been open.  Manual but effective, and everything balances out nicely now.