Posted/Voided Transaction Report Filters
Getting the exact information you need when running a report is even easier with our two additional filter categories. On several of the GL Reports, you will now see the Posted and Voided options. The additional filters are available on the GL Bible, GL Bible-amounts, GL Bible Subtotal by Sets (Detail) and GL Bible Subtotal by Sets (Summary). The Posted option allows for you run the reports that include unposted transactions, it defaults to posted only. The Void option allows you to not show voided transactions, the default is to show them.
To use these filters, click the Reports icon on the homepage then select GL Reports. Choose either of the four GL reports mentioned above then click RUN. In the filters, select Posted or Voided then select the option in the field on the right. Click NEXT then click PRINT.
Cost Report with Details
We've added a new cost report option that includes the detail cost lines for each account. Rather than just showing each expense account, this report will also allow you to see the breakdown of the transactions associated with each account. To use this report, click the Reports icon on the homepage then select Detail Cost Reports. Highlight the Cost Report with Details then click RUN. Select any necessary filters then click NEXT and PRINT. You can also create a CSV file.
Trial Balance Report Option in Bank Reconciliation
In the Bank Reconciliation window, we've added in the option to print both your Account Reconciliation report and your Trial Balance report. Rather than going through the Reports module after finishing your bank rec, you can simply print your Trial Balance the same time you print the Account Reconciliation report. To do so, click BANK RECONCILIATION from the Banking drop down menu. Click the PRINT button on the window and you will see three options for printing. Click ACCOUNT RECONCILIATION AND TRIAL BALANCE. The Account Reconciliation Report preview will open first ready for you to print. Once you print and exit that preview, the Trial Balance report preview will open automatically ready for printing.
Bank Reconciliation "Show All" Permission
We've added a new project specific permission to the accounting software that restricts a user's ability to view all transactions in the bank reconciliation window. Helping prevent the accidental selection of a transaction that should not be included on a specific bank statements reconciliation, users who do not have the Show All permission will only see transactions that are up to the statement date. The Show All permission is NOT enabled by default. If you or another user on your team require the ability to Show All transactions, please contact support and we'll be happy to grant you this access.
1st Assistant Accountant All Batches Permission
Users with 1st Assistant Accountant access on a project can be granted the new permission which allows them to see all batches in the Post and Pay Bills windows. Without the new permission, 1st Assistant Accounts can only post and pay transactions that are in a batch that they created; they are unable to post or pay transactions that were created by another user. If you would like a user to be given the permission to view all batches in the Post and Pay Bills modules, contact support and we'll update the access of the user for you.
GL Bible Reports with Suppressed Fringes
There are two additional GL report options that will suppress the fringes. We've added versions of both the GL Bible and GL Bible with PO's Merge that will show the totals for each fringe account but do not show the details of the transactions associated with them. To utilize these reports, go to the Reports icon on the homepage and select GL Reports. Choose either the GL Bible (with totals for *99) or the GL Bible with PO's Merge (with totals for *99) and click RUN. Select any necessary filters then click NEXT and RUN.
Detail Lines Sort Functionality
In each transaction window, there is a new option to choose how you would like to sort the detail lines. Whether in the Enter Bills, PC, PO, CP or JE entry windows, you will see the setting to select to sort by input order or sort by column. Sort by input order will display the detail lines in the order in which they were added to the transaction. Sort by column will allow the user to click the column header and sort the detail lines by numerical or alphabetical order.
To use the sort features, open up a transaction from the GL or a browse window and select the radio button for either Sort by Input Order or Sort by Column. If you select Sort by Input Order, the detail lines will automatically change to the order in which they were entered. If you select Sort by Column, click the column header of whichever column you would like to sort by.
Refresh Option on Cost Report Worksheet
While in the cost report worksheet, costs and PO's can now be refreshed without leaving the form. If you or another user create a transaction while the cost report worksheet is open, you no longer have to close out of the window in order to see the new transactions reflected with the addition of the Refresh option. To refresh the Cost Report Worksheet, simply click the Refresh button. NOTE: You cannot refresh the worksheet if you have already clicked EDIT and are in the process of making changes.
Report Currency Conversion
With the new currency converter, projects with multiple currencies can generate reports with all transactions listed in one currency regardless of how they were entered. Previously, reports in a project with multiple currencies could either be run to show transactions with all currencies or one specific currency, but with the converter, the report can be run to show all transactions in the currency of your choosing. The converter feature is available on all reports.
To use the converter, select Reports icon from the homepage then select the report you would like to view. Click RUN then highlight the Currency filter in the Filters field. Select the currency you would like to convert to from the Convert To drop down menu then click NEXT and PRINT.