Andrea Hargate
02/13/2025, 1:40 PMCeligo AI
02/13/2025, 1:40 PMAI generated answer (using internal Slack threads):****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To create a custom AP Aging Summary and Detail report that only looks at one of the Accounts Payable accounts, you can follow these steps: 1. Navigate to Reports > AP Aging Summary. 2. Click on the 'Customize' button to start customizing the report. 3. In the 'Filters' tab, add a new filter for 'Account'. Select the specific Accounts Payable account you want to focus on. 4. If you want to include Journal Entries in your report, you might need to use an "Or" condition in your filters. This is because when you use both 'Account' and 'Account (Line)' filters, they might conflict and result in no results. Please note that "Bill Credits" do not have a due date, so they do not get aged the same way as Bills. If you want to include them in your report, you might need to change the Aging Options to "Transaction Date". If you want to create a Vendor Statement, you can strip down the AP Aging Detail report to the specific vendor you’re looking for, clean it up to fit your needs, add logo & title and print or send as PDF. Alternatively, you can create a transaction saved search for AR aging with vendor as a filter, and port the results to a custom advanced pdf template. Remember, you can always reuse the search for any vendor just by using the filter. Formulas for AR aging can be found in suiteanswers.
Celigo AI
02/13/2025, 1:40 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846471727
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844928622
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834753573
Celigo AI
02/13/2025, 1:40 PMAndrea Hargate
02/13/2025, 2:57 PM