The instructions in this article relate to Global Transactions. The icon may be located on your StrataMax Desktop or found using the StrataMax Search. |
Global Transactions can be used to find specific transactions across your portfolio, for example reporting all Income for a particular Tax Code, reviewing all transactions for an expense code or identifying buildings with Non Mutual Income to name some examples. There is the option to add in the Running Balance field to assist with reconciliation of accounts. The results can optionally be exported to excel and used for analysis.
Global Transactions | Security
To access Global Transactions screen, the user must have the permission set to 'Allow' for 'Global Transactions' under the 'Menus' category.
Global Transactions | Column Details
This section gives explanations as to what each of the default columns represents.
- Building Number: Used to identify the number of the building.
- Building Name: Used to identify the name of the building.
- Date: The date the transaction was either entered or the date entered when creating the transaction.
- Account Code: The account code the transaction is posted to.
- Account Description: The account code's description, which is managed in Account Maintenance.
- Type: The type of transaction. Hover your mouse cursor over the icon to display a tooltip Refer to the article on Transactions in StrataMax.
- Amount: The amount of the transaction. A minus figure is a credit.
- Running Balance: Displays the running balance of the transactions
- Invoice Code Description: Only displayed for lot/debtor account transactions. Admin Fund, Sinking Fund, Maintenance Fund, Overdue Interest, Other - all set up in Levy Invoice Code Setup.
- Description: The description of the transaction. If this is "Balancing entry" this is the contra side of a batch.
- Reference: Each transaction has a unique reference number. Refer to the Transactions in StrataMax article for further details.
- Extra Details: Reports the corresponding transaction reference or invoice number.
- Extra Text: The text displayed here will depend on where the transaction was entered. For example, if it was entered via Payment Entry as an owner refund or reimbursement, it will display the owner's name.
- Fund Code: Used to identify the fund. 004 being Admin Fund, 005 being Sinking/Capital Works/Maintenance Fund.
- Fund Name: Admin Fund, Sinking Fund, Capital Works Fund, Maintenance Fund, etc.
- Account Group: Used in Multi-OC buildings in Victoria to display which OC the transaction is in.
- Account Manager: Identifies the account manager of the building. Set in Building Information.
Global Transactions | Overview
Global Transactions has been designed for users to search transactions with the option of applying filters which can assist with reviewing account codes or financial queries. The transactions can also be searched across different Buildings, Years, Account Groups, Fund Codes and Fund Names and searches can be saved to be produced quickly in the future, with an option to export to Excel. Some examples of searches may be: reporting all Income for a particular Tax Code, reviewing all transactions for an expense code or identify buildings with Non Mutual Income.
Each column can be clicked on to sort and descriptions can also be edited for Directs (reference starting with 'B'), receipts, debtor transactions (Reference starting with 'M0', but not those starting with 'MA'), and journals, except for when they have the descriptions listed below. To change a creditor invoice description, you must follow these steps in Payments Management.
- Search or select Global Transactions.
- The 'Restrict To' fields will default to 'Date' and 'Account Code'.
- The 'Date' field can be removed to return all transactions
- To add another field, click the green plus button, then select the Field by clicking the drop-down menu.
- To remove a field, click the red minus button, then click Refresh.
- Based on the selected Field, the Condition can be changed if required, and then you can change/select the required Value.
- Click the Advanced button to display additional tabs down the left side:
- Columns to add, remove, or change the order of the columns.
- Sort Order to change how the data in the table is sorted (by column, A-Z, etc.)
- Advanced to change the maximum number of records to display in the table (10000, 1000, etc.).
- Click the Refresh button to search for the records.
- If you would like to, you can export the data to an Excel sheet, by clicking the Export button.
Each column can be clicked on to sort the order of transactions.
Global Transactions | Change Transaction Code
If you have taken over a property from another manager, local account codes may exist for the new building that do not align with your master chart of accounts. If you need to merge or move all of the local transactions from one expense code to another expense code, then you should use Change Code Number.
The Change Code function is used to move individual transactions from one income or expense account code to another. If the two account codes (transfer from and to) are within the same fund or account group, most transaction types may use this process. This function cannot be used on account codes that are setup to report as either Main or Sub-Accounts, so Journal Preparation will need to be used.
If the building is configured for the Invoice Hub and the Creditor Invoice is pending approval, Change Transaction Code cannot be used until the Creditor Invoice has been Approved and is no long on the Invoice Hub. If a Creditor Invoice has been part paid, the Creditor Invoice will need to be fully paid before the Change Transaction Code tool can be used.
If the original transaction has had No GST set and Change Transaction Code is applied to move the transaction to a GST on Expense account code, the GST will be applied.
If there are hidden transactions that require a change, these will need to be un-hidden first to allow the Change Code to apply. Use Transaction Report Manager to un-hide first and then apply the Change Code.
If the two account codes (transfer from and to) are for different funds or account groups within a property, only expense transactions that have been created via the Creditor Invoices menu will be able to use this process. Creditor invoice transactions are identifiable by a ‘D’ reference. This may exclude some transactions such as TaskMax services fees from using this Change Code to move transactions between funds.
If account codes within the Balance Sheet code ranges need to be changed or moved, this can be done using Journal Preparation. However take extreme care as Balance Sheet account codes are often totalling accounts and adjustments should be done within the income and expense code ranges instead.
Other types of transactions that may have previously been able to use the Change Code function and are required to be changed between funds or account groups should now be rectified using Journal Preparation.
Any code changes will also be logged in the Log Viewer and can be searched for with the Category called 'Transaction'. It's also important to remember that the Change Code function is not available for the following transaction types and scenarios:
- Balance Sheet codes.
- Non-posting accounts.
- Sub and main (including debtor and creditor).
- Hidden transactions.
- GST transactions (description ‘GST’).
- Building locked by another user.
- 'Change Transaction Code 'permission is not set to 'Allow' in Security Setup.
- Historical Years
- Old Year if the building is marked as 'Audited'.
- Appropriation transactions (description ‘Trf Surplus/Deficit’)
- Search or select Local Transactions or Global Transactions, depending on your requirements.
- Once you have located the required transaction, select it, and click the Details button.
- In the 'Transaction Details' window that appears, and if the transaction code can be changed, the 'Change To' field will be displayed.
- Please be aware that the system automatically enters the last code that was used in the 'Change To' field for ease of use so that changing multiple codes can be done more quickly. Simply remove the existing code if you need to select a different code.
- Click the ellipsis button [...] and the 'Account Code List' window will appear where you can locate and select the required code.
- Back in the 'Transaction Details' window, the selected code will be in the 'Change To' field, so click the Change Code button.
- Click Yes when the confirmation appears.
- You will need to click the Refresh button in order to see the code change appear in the table of records displayed.
Global Transactions | View Document/Invoice
- Search or select Global Transactions or Local Transactions.
- Locate and select the transaction by adjusting the Fields as required, then clicking Refresh.
- Click the Details button to display the 'Transaction Details' window.
- In the 'Transaction Details' window where the details of the transaction are displayed, click the Document icon on the far right.
- The DocMax 'Document View' window will open with the document displayed.
Global Transactions | Edit Invoice Number
This section covers how to edit the invoice number of creditor invoices. This can also be done in the Search Creditor Invoice Items and Local Transactions screens.
- Search or select Search Creditor Invoice Items, Global Transactions, or Local Transactions.
- Locate and select the creditor invoice by adjusting the fields as required, then clicking Refresh.
- If you are using the Global Transactions or Local Transactions screens, you will need to click the Details button to display the 'Transaction Details' window.
- When the transaction details of the transaction are displayed, click the Edit Invoice Number button (small pencil button next to the 'Invoice Number').
- The 'Change Invoice Number' window will appear, and the Invoice Number field can be edited. Click Save when done.
- The 'Change Invoice Number' window will close, and the change can be observed immediately.
Global Transactions | Edit Tax Code
This section covers how to edit the tax code on individual transactions that may be in the current or prior period, or the Old Year. This can also be done in the Search Creditor Invoice Items or Local Transactions screen.
Tax code changes, for the current period, can also be edited in the Business Activity Statement.
- Search or select Local Transactions or Search Creditor Invoice Items.
- Locate and select the Income / Expense code for the tax code adjustment by adjusting the fields as required, then clicking Refresh.
- If you are using the Local Transactions screen, you will need to click the Details button to display the 'Transaction Details' window.
- When the transaction details of the transaction are displayed, click the Edit Tax Code button (small pencil button next to the 'Invoice Number').
- The 'Change Tax Code' window will appear, and the Tax Code field can be edited. Click Save when done to process the adjustment transactions..
- The 'Change Tax Code' window will close, and the updated tax code can be observed immediately.
- Close the Transaction Details window and select Refresh to show the adjusted transactions.
The adjusting GST transactions will be dated the original Posting Date, this can be amended if required prior to saving.
Global Transactions | Saved Searches
'Saved Searches' are designed for convenience so that you can save a selection of fields, columns, and a specific sort order so that it can be loaded later. There is also a tool to assist with quick-finding fields of text information. Use the top right corner and enter text into this field to search. Click Find First or Find Next to locate results.
'Saved Searches' can also be set as the 'default' search for the selected screen. This means that the selection of fields, columns, and specific sort order will be the one chosen whenever the menu screen/icon is selected.
'Saved Searches' can be saved for the current user, globally (accessible to all users), or for a specific user group.
If a Saved Search is loaded/opened this will be noted at the top of the search screen.
Saved Searches | Security Setup Permissions
A security permission will either allow or deny individual Users or User Groups access to create or delete a search. The permission is called ‘Save Group and Saved Searches’ under the 'Menus' category in Security Setup. You can also type the word ‘Search’ into the filter field and click the Filter button to see the permission.
If the User or User Group do not have the permission set to 'Allow' then the ability to save a search for all users or a user group will be inactive.
Saved Searches | Set up a new Saved Search
- Configure the required fields and click the Refresh button to display the required data.
- Optionally click the Advance button to also configure the displayed columns, and specific sort order.
- Click the Refresh button to display the data.
- Click the Save Search As button, and the 'Save Search' window will appear.
- Enter a 'Name'.
- Select one of the three radio buttons, depending on your requirement:
- Available to current user only will save the search for the current user only.
- Available to users in security group will save the search for the User Group selected from the drop-down (this radio button is only available if you have the right permission, and the User Groups available in this list are limited to the User Groups that you are a member of).
- Available to all users will save the search for all StrataMax users (this radio button is only available if you have the right permission).
- Optionally tick the Save as default box to load this 'Saved Search' whenever the menu screen/icon is opened.
Saved Searches | Load or Delete a Saved Search
- At the bottom of the screen, click the Load/Delete Search button.
- In the 'Load Search' window, click the blue Load button to load the Saved Search, or click the red cross button to delete the Saved Search.
- If you click the Load button, the 'Load Search' window will disappear, and the screen will refresh automatically and load the Saved Search data.
- If you click the Delete button, a confirmation pop-up will appear; Click Yes to confirm the deletion.
When a Saved Search is loaded/opened, the Saved Search name will be noted at the top of the search screen.
Saved Searches | Edit a Saved Search
- If the Saved Search you want to edit has been set as the default search, it should be on screen already, and you can proceed to the next step. Otherwise click the Load/Delete Search button.
- In the 'Load Search' window, click the blue Load button.
- Now make any changes required to the required fields, and optionally click the Advance button to also configure the displayed columns, and specific sort order.
- Click the Refresh button to display and check the data.
- Click the Save Search button to save the applied changes.
Saved Searches | Add To My Dashboard
There is the option to add certain searches to your own Dashboard. This is limited to your own Dashboard only (you cannot add it to the Dashboard of another user or group), and only available in these specific 'Search' screens:
- Search Office Bearers
- Search Bank Accounts
- Search Creditor Invoice Items
- Search Work Orders
- Search Quotes
- Search Building
- Search Inspections
- Search Levies
- Management Fees Report
- Follow the steps to set up a new Saved Search, or edit a Saved Search (see the two relevant sections above).
- In the 'Save Search' window, click the Add To My Dashboard button.
- The 'Dashboard Configuration' window will then appear.
- The Report drop-down menu cannot be changed from 'Saved Search'.
- The Display Title can be changed to whatever is required.
- Choose the Display Type that is preferred. See Display Types for more information.
- Tick Show On Desktop if preferred.
- Depending on which Display Type was chosen, the fields for the different number values will change. Observe the Preview to assist with picking the right number values suited to the Display Type.
- Click the Save button.
- Back in the 'Save Search' screen, there are now buttons to Edit Dashboard and Delete Dashboard.
- Click the Close buttons on any remaining screens.
Export and Print
Each search can be exported to Excel or produced as a PDF-style report, and the column display for these reports will be included.
- Export—If there are more than 1000 results, Check the Advanced tab / Advanced area to report the maximum. Click Export for an Excel report.
- Print—Check the cogwheel from the Report Distribution screen to change fonts and set the letterhead style. This print style will produce the report based on the column width. Click Print for a PDF-style report.
Examples of Searches for Dashboard
The below are some examples of saved searches that can be used as a dashboard to either prompt based on particular dates or to provide quick access to information & reporting. Examples are reliant on fields being populated with data and information as part of your processes and your particular setup of Restrict To, Display Columns and Sort Order may vary to suit your requirements.
Last AGM where minutes have not been sent (Search Buildings)
Restrict To:
Displayed Columns:
Assigned Team Members (Search Buildings)
Restrict To: No requirements however you may filter by Account Manager for example
Displayed Columns:
Term Deposits maturing in next 30 days where no instruction has been provided (Search Bank Accounts)
Restrict To:
Displayed Columns:
Creditor Invoices Awaiting Invoice Hub Approval & dated more than 1 month in the past (Search Creditor Invoice Items)
Restrict To:
Displayed Columns:
Creditor Invoices on hold & dated more than 1 month in the past (Search Creditor Invoice Items)
Restrict To:
Displayed Columns:
Inspections due in next 30 days (Search Inspections)
Restrict To: setting the category to specific values allows dashboards specific to inspection types.
Displayed Columns:
Identify Creditors with no Compliance Code that have had recent activity
Restrict To:
Displayed Columns: