Hi, I’m running an AP Aging, filtering the report...
# ask-stanley-ai
h
Hi, I’m running an AP Aging, filtering the report on no vendor – which is pulling different JE and Checks. The JE don’t have the vendor name on them but it does have it in the account. the checks have the name under Payee. How do I add to the report for the checks to say payee name on it and JE to have account so I can see which vendor it is. TY
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that the issue you're facing is due to the fact that the AP Aging report is pulling in Journal Entries (JEs) and checks that don't have a vendor associated with them. For the JEs, you can create a saved search to pull the account details where the vendor name is present. This can be done by creating a new saved search with the following criteria: - Type: Transaction - Criteria: Main Line = True, Type = Journal, Account = Accounts Payable - Results: Internal ID, Line ID, Account, Vendor For the checks, you can modify the AP Aging report to include the Payee field. This can be done by customizing the report and adding the Payee field in the Columns subtab. Please note that these steps will only allow you to view the vendor details in the report. If you want to associate the vendor with the JEs and checks, you might need to manually update the transactions or use a script to update them in bulk. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850525498
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841677368
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839853406
Please provide your feedback on this answer.
h
i tried to add payee but it didnt work
what else can i do