Im stumped want to see if anyone can help. My AP director started to notice something funny with the AP aging. older bills showing up as unpaid and Bill Payments sitting alone. after some digging i see that the were applied at some point (no record just the email with pdf of the payment with the stub showing the invoices it was applied to) But the audit trail and system notes show no activity for any of these bills/bill payments yet their no longer related. How can this be?

Are they all posted to open periods? I've seen this before but it's because the vendor was changed although that should appear in the system information.

Your scenario sounds a little bit from your description, but I've often seen a similar thing happen when zero dollar payments occur. I.e. there's a Bill and a Credit/JE sitting out there for the same amount. When those are "paid" through Pay Bills, it simply marries those two up and marks the Bill as Paid and the Credit/JE as applied, but NetSuite doesn't actually generate a zero-dollar Bill Payment record. Thus there's nothing actually keeping those two records connected, so when the Bill or Credit or JE is updated (even via a script or something that has nothing to do with payment application), it automatically unapplies it and then both the Bill and Credit/JE are sitting out there again waiting to be applied to each other again.

Hi so the ones I've found so far. All were for some amount. and no activity in system info ill check the periods but as far as I can tell they were open. The only thing I have a hunch on is that our controller was changing around accounts and inactivating or making them a roll up etc. could that have caused this? Although very odd because its not wide spread just a hand full so far. I have hundreds more in the same period and even some from the same vendor that are still paired.

“The only thing I have a hunch on is that our controller was changing around accounts and inactivating or making them a roll up etc. could that have caused this?” - youbetcha!!! Before he starts playing with his COA he needs to reclass the balances from old accounts to new ones (regular re-grouping should not cause it) and validate there is no FX transactions posted on $0 balance accounts. So if he negated something and then tried to resurrect it, here you are