How do I remove old offsetting JE in AP aging detail report?

WSIMLR · ‎October 05, 2023

BigRedConsulting · ‎October 05, 2023

Not sure.

You appear to have more than one AP account, since the AP Account field appears on the Pay Bills window. If you pick one of your other AP accounts, then do you see one of the Journals?

If not, then one way to check to see if the Journals are already applied to each other, or to some other transactions - which would cause them to not appear - is to check to find out if they are 'linked' to each other or other transactions.

Do this by opening the Journal and then clicking the Reports tab at the top and then Transaction History. At that point you'll either get the History window or a message that the transaction isn't linked to any other transactions. The History window will show you the transactions the Journal is linked to.

View solution in original post

BigRedConsulting · ‎October 05, 2023

Use Pay Bills to apply the credit one of those entries will create to the other one, which will appear as a bill on the pay bills window.

WSIMLR · ‎October 05, 2023

Thanks but they don't appear in pay bills under the customer name

BigRedConsulting · ‎October 05, 2023

That's odd. They should appear under a vendor name in pay bills if they use the AP account (Customers won't appear there).

Are you sure neither of the line items appears? I tried mocking up your case, and a Journal with a Credit to AP always appears as a bill. And a Journal with a Debit to the AP account always as a credit. In my experience this is how it has always worked. Maybe try filtering pay bills for United Airlines?

WSIMLR · ‎October 05, 2023

They don't appear there, that's why I can't apply the credit to the debit JE

BigRedConsulting · ‎October 05, 2023

Not sure.

You appear to have more than one AP account, since the AP Account field appears on the Pay Bills window. If you pick one of your other AP accounts, then do you see one of the Journals?

If not, then one way to check to see if the Journals are already applied to each other, or to some other transactions - which would cause them to not appear - is to check to find out if they are 'linked' to each other or other transactions.

Do this by opening the Journal and then clicking the Reports tab at the top and then Transaction History. At that point you'll either get the History window or a message that the transaction isn't linked to any other transactions. The History window will show you the transactions the Journal is linked to.

WSIMLR · ‎October 05, 2023

Thank you so much!! This has been driving me crazy

Topics

Training

Community

Resources

How do I remove old offsetting JE in AP aging detail report?