Seeking Assistance Querying for Basic Transactional Metrics
Summary
How to get counts of journal lines, invoices, and payments per month?Content
I'm hoping someone can give me a head start on how to query for the following transactional metrics in Fusion Financials tables:
Number of GL journal lines added per month |
Average number of lines per GL journal |
Maximum number of lines per GL journal |
Number of supplier invoices per month |
Average number of distribution lines per supplier invoice |
Maximum number of distribution lines per supplier invoice |
Number of supplier payments per month |
Any assistance appreciated. Wendy
Version
Rel 13 18A0