Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Finding the number of invoices entered in AP? AP Analysis Report is showing data from a previous year. How do I change the periods it is pulling from?

Posted By L Energy 10 months ago

I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or, is there a better way to find the number of invoices being entered by month?

Thanks.

0 L Energy 10 months ago

So, it looks there are two factors. 1. The Period Ending Processing has to have been ran for the period. 2. Changing the period in Accounts Payable Options will dictate the periods (but 1 must have been completed for the period to show up).

Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 10 months ago

Depending on transaction volume, I'd do an Excel query of AP_InvoiceHistoryHeader and create a Pivot Table from that.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 L Energy 10 months ago in reply to Kevin M

Thanks, Kevin. I've tried finding a way to connect to the database, and I have no idea. The AP analysis report seems to report only open invoices and not a total of all.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M 10 months ago in reply to L Energy

https://support.na.sage.com/selfservice/viewContent.do?externalId=19495&sliceId=1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 L Energy 10 months ago in reply to Kevin M

Thanks. I'll give it a try. If I can't figure it out, I'll reach out to our consultant.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Finding the number of invoices entered in AP? AP Analysis Report is showing data from a previous year. How do I change the periods it is pulling from?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING