Please enable JavaScript.
Coggle requires JavaScript to display documents.
Financial Reporting for Vantage (Reports (AR Aging (Customer (Name/ID),…
Financial Reporting for Vantage
GL_View Function
Missing
Ability to view Adjustments that are not associated to an order
Main Goal : Provide consistency in reports
The totals shown in a user's account match the totals shown in other areas
We need to show what money has moved from one general ledger account into another
Reports
Exports
General Ledger, Vadim Export, Finance Report
Seem to be working properly
General Ledger Summary (Formerly GL Citizen Report)
Provide a summary of how much $$ is within a chosen GL Account at a selected time
See the grand total for the GL Account, as well as a table highlighting each of the transactions that result in that total
"See All" could show just the grand totals of all accounts (in the time frame)
AR Aging
Summary of the balances owing by customers as of selected date
Always starts at "beginning of time" - do not need to select a start date, only end date
Customer (Name/ID), Total Outstanding Balance (As of selected end date), Aged Columns (0-30, 30-60, 60-90, 90+)
The sum of the aged columns should equal the total balance
The value that is in a particular column represents the money owed during that time-frame. The time-frame is selected based on when the transaction took place compared to the date selected.
Invoiced Amounts
Adjustments Against Account
Deferred Revenue
Amount of Revenue that is sitting within the Deferred Revenue GL Account during a specified timeframe
Timeframe: always starts at "beginning of time", only need to select an end date
Customer (Name/ID), Total Deferred Balance (as of selected date), Forecast Columns (within the next 6 months, further out than 6 months)
Steps to Resolve Issues
Step 1: Define what information we need to provide to citizens
Step 3: Ensure the end totals shown for user accounts match across the reports
Step 2: Define the queries needed to display this information