Unit4 Financials v12 (Coda) and End-of-Life for Internet Explorer 11: Act Now…
May 2022
Internet Explorer will be retired by Microsoft in most Windows versions on 15 June 2022.
If you are using Internet Explorer with a legacy version of Unit4 Financials (e.g., v12 (Coda) or earlier), you will need to switch to the Edge browser and make some configuration changes in order to retain full functionality.
Retirement of Internet Explorer 11
On the retirement date of 15 June 2022, the IE11 Desktop application will be disabled permanently. From that date onward, if a user tries to access it, they will be redirected to Microsoft Edge.
In order to use applications with legacy IE11 dependencies (including Unit4 Financials v12), you can access legacy browser support in Microsoft Edge by switching to Internet Explorer mode.
In a recent blog post, Microsoft recommended that organisations schedule their own internal retirement date in advance of switch-off: “The best way to prepare for IE disablement after June 15 is to proactively retire IE in your organizations before June 15”.
Unit4 Financials legacy versions: how to enable full functionality in Edge
Within Unit4 Financials v12, failure to enable the Internet Explorer mode within Edge will mean that the drop-down menus and multiple tab functionality will be initially disabled.
Also, if you select another menu item, the Input screen will be closed and the newly selected page displayed. It will not open in a new tab.
To enable Internet Explorer mode within Edge, go into the Edge – Settings – Default Browser screen and set “Allow sites to be reloaded in Internet Explorer mode” = Allow. You can also add the page URL for your system to this screen manually.
The next time you attempt to access your Unit4 Financials system, you can select from the settings menu “Reload in Internet Explorer mode”.
The Unit4 Financials login box will now show in the center of the screen.
On completion of the logon credentials, the system will now show drop-down menus, multiple tabs and other features.
The next time you attempt to access your Unit4 Financials system, you can select from the settings menu to “Reload in Internet Explorer mode”.
The Unit4 Financials logon box will now show in the centre of the screen.
On completion of the logon credentials, the system will now show drop down menus, multiple tabs and other features.
Time to Upgrade?
Ready to future-proof your Unit4 Financials investment? As an Elite Unit4 Partner, Millennium Consulting specialises in delivering a seamless upgrade, while also ensuring your upgraded solution is fully aligned with organisational requirements.
To discuss your options for moving to Unit4 Financials Continuous Release, contact us today.
Why upgrade to Unit4 Financials Continuous Release?
May 2022
The new Continuous Release quarterly roll-out model for Unit4 Financials makes it easier than ever for CFOs to achieve maximum benefit from their financial management and accounting software. If you are yet to make the switch from Version 14 or earlier, here are three very good reasons to upgrade…
Unit4 has traditionally provided full support as standard for the latest two Financials releases. At present, Version 14 and Continuous Release are the two versions that get this support. By the end of 2022 however, Continuous Release will be the only version that is supported.
Upgrading to Continuous Release ensures continued access to Unit4’s “in support” maintenance and support package. The clear benefit of this is that it helps you avoid the myriad of risks that come with running outdated software, including security vulnerabilities, bugs, lost data, and a drop-off in productivity.
Interoperability is one of the biggest plus points of Unit 4Financials, including the potential to establish real-time integration with operational systems for a holistic view of the business. Upgrading to Continuous Release is the best way to ensure Financials continues to work seamlessly with other systems and applications you have in play.
Are you planning on moving your data platform to SQL Server 2019? Do you intend to switch from Data Explorer to Edge? To ensure compatibility, these are examples of applications where upgrading to Unit4 Financials Continuous Release is a technical requirement rather than just a recommendation.
The last – but by no means least – benefit of Continuous Release is the ability to access a steady stream of new features. These new additions tend to be very much user-driven; exactly the type of enhancements that make life easier for your team and help to boost productivity.
Here’s a closer look at some of the new functionality that has already arrived through the new roll-out model. (Note: we’ve focused here on the additional features you can access by upgrading directly from Version 14 to Continuous Release. If you are upgrading from earlier versions, there’s a whole host of additional functionality available to you).
Technical Infrastructure
The Unit4 Financials security settings enable you to restrict the read and write privileges of individual users. Continuous Release has introduced a handy new user warning alert linked to these restrictions.
For example, you have restricted a user from viewing the sales control account. When browsing, the user will not be able to view those account settings. They will, however, get a warning stating that access has been limited by the security settings. This prevents users from developing the false impression that they have been able to access the full picture, when in fact, certain items have been restricted.
Element Authorisation
Version 14 saw the introduction of the Element Authorisation feature. Now, through Continuous Release, if a new element is created using Assisted Element, when you use the ‘show work item’ function, it will use the element template masters to display the elements. In practical terms, it becomes a lot easier to identify precisely what element you are looking at.
Anonymise Change Log
Introduced in Continuous Release (and retrospectively fitted to Version 14 in release 4), the Anonymise Change Log function automatically removes personal identifiable information from any history and audit trail records to satisfy GDPR.
Items automatically removed include things like element name, short name, long name, tax and NI details, addresses and bank details. No log created with the Anonymise Change Log function is activated will include this information.
Provisional Year End
We now come to probably the most popular new feature since the introduction of Continuous Release.
Previously, running a year end was an all-or-nothing task; once you’d completed it, there was no going back. It often meant holding back on the job just in case the auditor needed to make final adjustments, increasing the likelihood of a last-minute rush.
The ability to run a Provisional Year End solves this problem.
The new function does more-or-less everything you would expect from a traditional year end. In other words, it sums all relevant profit and loss accounts and posts the net figure to retained earnings and the balance sheet. It will then post the closing balance sheet figures to period zero of the following year.
However, what the new function won’t do is close the year end being processed. In other words you can carry on posting to that year.
For example, your new year is 2022. You can still post to 2021 for the auditors, but all the information will now be in period zero. What’s more, if you are doing on-site reports, the figures will be correct, because all the carried forward balances will be in the period zero, and your retained earnings will be in the balance sheet as well.
Undo Year End
So, your accounts are finalised, and you’ve run your full year end. However, six months later, the auditors flag up an irregularity that calls for an adjustment. What are your options?
Thanks to the new Year End Undo function, you can now undo a year end after it has been closed. Having effectively unlocked it, you are then free to make any necessary adjustments to the year in question.
For a closer look at Provisional Year End and Year End Undo functions, and the benefits these will bring to your reporting procedures read our dedicated blog post here.
Enhancements to Browse Transactions
Introduced in earlier Unit4 Financials versions, the Browse Transactions function made it easier to drill into transaction data when creating reports through the use of metadata, selectors and presenters.
Under Continuous Release, Unit4 has been hard at work in bringing the Browse Transactions feature up to par with the Browse Details function. For instance, Browse Transactions now lets you restart, cancel and view the history of the workflow of a document. You can now copy a document from within Browse Transactions, You can also drill to account summary, edit buying comments in the related information panel, and raise corrective journals.
Company Master
Previously, the Unit4 Financials Company Master template only offered you a single default address for each company. But let’s say the address and point of contact for sending remittances is different to the address that needs to go on the purchase order.
The new master under Continuous Release now gives you a separate address category purely for sending purchase orders: a simple addition that can make life a lot easier on the procurement side.
Also, let’s say accounts have already been posted, but someone omitted to put in a balance code for a particular company. Financials now allows you to add or change the actual and turnover balance codes on Company Masters after documents have been posted.
Intercompany Control Accounts
In the Intercompany module, you can now have customer and supplier elements in the control accounts. In practical terms, this allows you to handle Intercompany at arm’s length, and also gives you the ability to send an invoice to another company within the same database.
Browse Details
Presenting information has become easier thanks to a couple of enhancements to the Browse Details feature. A new primary attachment presenter lets you view attachments instantly. When you are setting up a ‘browse details’ there is now a new vocab on the presenter that opens up with one click (in previous versions, it was slightly more difficult to locate!).
Pay
You can now change the payment period and/or date after a pay run has been generated. This ‘change payment period’ option is accessed via the pay collection actions menu and is controlled by functional security on the capability master.
Reconciliation
The Reconciliation function now records the date of reconciliation and the reconciliation user (i.e. the user who runs the reconciliation process). These two items – date and user – are also available as vocabs.
Copy Company with Finance
When you copy a company within the finance function, you can now copy the element flexi field data (although this only applies when copying within the same database, not when copying across databases).
Elements and template customisations can also now be copied when using ‘Copy Company’ to copy the eminent template masters.
Both of these elements were introduced through Continuous Release but have also been put into later updates of Version 14.
Fixed Assets
In Fixed Assets, you can now set a scheduled task to depreciate assets.
Invoice Matching
In Invoice Matching, it is now possible to input a non-matching invoice or credit note where the invoice total is different to the tax total.
Previously, when you ran LRN housekeeping, a journal would automatically be posted to finance. Of course, the presence of a GRN or LRN is usually indicative of an error somewhere. So having run LRN housekeeping and identified an LRN, you had to notify finance and cancel the document. You now have the option of not posting a journal when you run LRN housekeeping.
Procurement
Within Procurement, orders that are automatically created by a conversion from a requisition can be automatically submitted to workflow. So, you don’t have to go through that manual step of browsing and submitting to workflow.
Billing
If you have the Billing module, it is now possible to copy a document in ‘browse’, in the same way as with Finance documents.
CodaXL
CodaXL is now fully compatible with 64 bits, in addition to the 32-bit version.
Your next step
Ready to future-proof your Unit4 Financials investment? As an Elite Unit4 Partner, Millennium Consulting specialises in delivering a seamless upgrade, while also ensuring your upgraded solution is fully aligned with organisational requirements.
To discuss your options for moving to Unit4 Financials Continuous Release, contact us today.
Find out more
If you are still thinking about upgrading to Unit4 Financials Continuous Release to take advantage of the new functionality or to ensure you remain within the Unit4 supported software window, then watch our latest Spotlight video:
Unit4 Financials 2022 Q1 Release
Unit4 Financials 2022 Q1 Release
The Unit4 Financials continuous release model helps to ensure that finance departments are equipped to handle their most pressing operational challenges.
March 2022
Unit4 Financials 2022 Q1 was made available on 8th March 2022.
The new release contains all the previous Unit4 Financials functionality, new features plus additional customer requested fixes. This release also replaces the temporary solution in place to protect against the Apache Log4j vulnerability identified in December 2021 with a permanent fix.
Highlights of the release include:
Finance:
- Print Invoices – attachment filename
- Copy Company
Billing:
- Use Structured Output in scheduled task for type Billing Issue
Console:
- OpenID configuration restructure
Administration:
- QR Codes on Print Formats
- Print Formatter and Workflow Designer Authentication
- OpenID Connect Authorization Code Flow with PKCE
Procurement:
- Requisitions and Purchase Orders
General Fixes/Updates
- Using a presenter with totals lines on matching from input lost a selected line because the software thought it was a total
- ITK process ending time was being recorded even when a process component failed early on in the process run
- Billing Flexifield dates on entry would always save on a different date if a Browser used a different timezone from the server
- Export to Excel Spreadsheet did not handle divide by zero cells properly
- Assets part disposal depreciation calculated incorrectly when cancel depreciation used
- Assets full disposal calculating depreciation in disposal period incorrectly when cancel depreciation used
- Assets Cost Centre Transfer – when transfer fails, the depreciation lock was incorrectly left in place
- Transformation Parameters XML validation field label was not being translated
- Running Table-Link Helper would left-justify document numbers, so then DTL would fail
- Browse details export did not pass though the URL of hyperlinked user refs to a relevant recipient e.g. Excel
- Bulk Load incorrectly creating log files for unrelated user and company code
The Release Notes detailing the fixes and features within this release can be found in the Documentation area on Unit4’s Community 4U.
Read here to find out when Financials updates are scheduled for 2022, along with important information for legacy V13 and V14 users.
Is it time to upgrade?
Upgrading your finance software can provide new functionality, increased automation and more efficient processes.
5 top functionalities you might not be using in Unit4 Financials
March 2022
Simple improvements to accounting software can often go a long way in saving time and effort for the user. The good news is that through its quarterly update model (Continuous Release), Unit4 Financials is constantly being enhanced to deliver the best possible user experience.
Have some valuable recent software additions passed you by? Here’s our rundown of some of the most noteworthy Unit4 Financials changes and new functionalities you may have missed…
A couple of new features in this area may be of interest. The first, released in 2020 Q1, was the option to change the posting period during the process of the payment run.
A further option is the ability to copy payment information into user references on the original invoice that was posted.
New options in this area make it easier to communicate payment information to customers.
There is now an additional checkbox under the Print Invoices function. When you print or send an invoice via email to a customer account, this allows you to add the PDF invoice to the Financials document.
You now also have the ability to generate an XML format invoice, rather than having to send a PDF.
The Print Invoice function can be set up as either a standalone or scheduled task. These additional enhancements (XML formatting and PDF attachments) can also now be used with scheduled tasks rather than just with standalone tasks.
Previously, your intercompany control account held on your destination and receiver masters could be set up as a matchable account, but not as a customer supply account. This meant if you wanted to generate invoices and send them to that intercompany counter party, you would have to create a separate element (because of the inability to generate any tax or VAT against the counter party when generating the invoice).
This has now changed, so the intercompany control account can also be a customer supplier account. It means you can use the same element against your intercompany control account, as you can against a control account where you were creating invoices etc. for that intercompany counter party.
The benefit is that it reduces the number of elements you need to create as part of your intercompany process.
The last couple of years has seen the introduction of some useful new access control, audit and general security measures.
From Version 14 onwards, you can now allocate users with different capabilities for different companies (for instance, you can assign a user with read only access for company A, but full admin access for company B).
In earlier versions of the solution, you had to log in as a LEVEL8 user or a LEVEL8 sub-user to change passwords and unlock users. In reality, this made it difficult to audit who was making the change. Unit4 has now widened the options for assigning capabilities to users. It makes it possible, for instance, to assign ordinary users with the ability to unlock other users and change those other users’ passwords.
For audit purposes, many organisations require journals to be reviewed by someone other than the document creator before those journals are posted. To facilitate this, Unit4 has introduced an optional control whereby users who are posting documents to the in tray can be prevented from posting the same documents to the books.
This update was designed primarily for cloud, but can be used with on-premise deployments as well. On the output device master, you now have the ability to specify that you want the file or document you are transferring to be transferred via SFTP. This is useful for tasks such as transferring BACS payment files when transacting with suppliers.
This option has also been added into structured output. It means that generated files – whether they are Avalara, XML or any other format – can also be transferred in SFTP.
How to unlock the full value of Unit4 Financials
From best practice advice, system optimisation and configuration through to migration from legacy systems, Millennium Consulting enables organisations to realise maximum return on their Unit4 Financials investment. For expert input from an Elite Unit4 partner, speak to us today.
Unit4 Financials and Community 4U
March 2022
The Unit4 product community is well supported by thousands of global customers and partners alike. Better still, the product developers pay very close attention to it, which means if you have a good idea for an enhancement, there’s actually a good chance of it being incorporated in a future update.
Here’s a closer look at the Unit4 peer support available, and at how active customer participation results in a stronger, more dynamic product offering.
What is Community4U?
This is Unit4’s customer and partner community, made up of dedicated forums devoted to specific Unit4 solutions (including Unit4 Financials).
Through it, you can engage with other customers and partners, get in touch and ask questions, share tips and best practices and find solutions that will make your life easier.
The community also includes a process through which customers can suggest product enhancements (see below).
Benefits of accessing the community
The most obvious benefit of Community4U is the mutual support element. Users can learn from each other’s experiences, quickly get answers to queries and keep up with best practice.
Dipping into the community can also be useful from a professional growth perspective. Because it’s well supported, it’s a good way to engage with peers (people in similar roles within similar organisations, for instance) and build your network.
How to log a product enhancement idea
Do you have an idea for making a particular template more closely aligned to your reporting requirements? Would a simple tweak to a particular field save you a whole lot of time?
As a Unit4 Financials customer, you can use the community to log any suggestions any time you want. Suggestions are reviewed regularly by developers and opened to a vote to all portal users.
If an idea gets customer backing, Unit4 will assess whether it’s deliverable. Popular and do-able suggestions go into the development backlog and are ultimately delivered.
Some recent suggestions for enhancements have included the following:
• Remove trailing spaces automatically
• Set the name of the attachment sent by email
• ‘Remove the line’ checkbox as movable item on input template
• Custom portal per company
• Sorting payment proposals by date instead of payment code
• Mandatory fields on element template
• Cr/Dr differentiation on Distribution Master / Revaluation
• CODA Procurement: Irrecoverable Tax on Reversing VAT
• Schedule Change Periods (000223)
• Flexi fields in Assets as an alternative for the user (free) fields
The beauty of Unit4’s Continuous Release process is that tweaks and enhancements are rolled out to customers in a seamless way. These enhancements are driven in large part by customer feedback. Examples of user suggestions that have found their way into the Continuous Release cycle recently include ‘Remove trailing spaces automatically’, ‘Remove the line checkbox as movable item on input template’, and ‘Sorting payment proposals by date instead of payment code’.
Accessing the community
To set up an account for the Unit4 Community 4U, please send an email to community4u@unit4.com
Are you considering an upgrade in 2022?
Upgrading from legacy finance software helps to ensure system security, the best possible user experience and, ultimately, higher productivity. For expert upgrade input from an Elite Unit4 Partner, contact Millennium Consulting today.
2022 Unit4 Financials Roadmap
February 2022
2022 Financials Roadmap
The Unit4 Financials continuous release model helps to ensure that finance departments are equipped to handle their most pressing operational challenges. This includes new regulations, volatile market conditions, and internal pressures to do more with less.
To ease your transactional workload, 2022 looks set to see the introduction of some welcome additions to the Unit4 Financials platform. Here’s a closer look at what’s in the update pipeline.
One of the most attractive features of Unit4 Financials is its multi-everything design (country, company, currency, tax, language), ensuring the ability to handle even the most complex or evolving corporate structures.
You can run your system as a single version worldwide, thereby ensuring consistency and visibility across the enterprise. But alongside this, you also get the flexibility to satisfy a huge range of local statutory and accounting approaches found around the world.
We are set to see further evidence of this ‘global yet local’ approach in 2022. A prime example comes in the form of new structured output for closer integration with ELSTER, Germany’s electronic tax return system.
The solution already includes the ability to produce invoices in an xml format. Unit4 is in the process of enabling this with billing, also.
The solution should also shortly accommodate QR codes on print formats.
For auditing and general ease of admin, life becomes so much easier if you can save actual billing documents within the platform itself. Unit4 added attachments to billing in early 2021. They are now going a step further, enabling you to copy those attachments over to the Financials document.
The last couple of years have seen a gradual extension of Financials’ ‘scheduled tasks’ functionality, (hierarchy updates, asset depreciation and reconciliation are a few recent examples). Driven by customer demand, you will also shortly be able to add a scheduled task for the Open/Close Period.
A new Supplier Filter will be added to procurement.
Future vision for 2022 and beyond
This functionality is already available with an on-premise set-up, Unit4 is looking at creating a cloud version.
Introduced in Continuous Release 2020, tablelink for cloud gives you an on-premise version of your link tables, and an API that takes the data into the cloud. Expect further enhancements to this function over the coming years.
• Define name for email attachments
Certain activities within the product involve emailing attachments to customers or suppliers (invoices and statements, for instance). This upcoming new function enables you to define the names of these attachments. This can be useful for preventing the messages from being caught by user email filters.
• Expiry for element banks and addresses
You will shortly be able to expire a bank as against a customer or supplier account. You can still see it (but not use it) when inputting your documents.
• Specify address for email output
At the moment, the system picks up the default email address for a customer or a supplier account. Unit4 looks set to make it easier to send different categories of communications to different email addresses within the same customer organisation.
• Copy company set open number range
It will shortly become easier to copy and move defined extracts of company information.
Areas of focus for Unit4 over the next few continuous releases include:
• Support for Wildfly 25
• 3rd party library updates
• Corrective maintenance
Seamless interoperability with business applications of all types is a further major benefit of the Financials product. Building on this, Unit4 will be looking to introduce further ways to integrate Financials with the Microsoft Office 365 suite. Other technical enhancements include the following:
• Clustering performance
• Cloud SaaS improvements
• Cloud product usage
• Rationalised and centralised DB access
• A simpler cloud deployment system
• Upgrade script improvements
• Audit trail upgrade improvements
• Download xml client libraries
• Alternative document repository
• People platform integration
Important upgrade information
Support for Unit4 Financials V13 has already been withdrawn. Support for V14 will expire at the end of 2022. Failure to upgrade before then increases the likelihood of incurring extended support charges from Unit4.
Upgrading enables you to:
• Access the latest functionality
• Reduce operational risk and processing costs
• Continue to access Unit4’s “in support” software maintenance and support package
• Ensure you are up to date with Unit4’s latest software security package
As an Elite Unit4 Partner, Millennium Consulting specialises in delivering a seamless upgrade, while also ensuring your upgraded solution is fully aligned with organisational requirements.
To explore your options in Unit4 Financials, contact us today.
Unit4 Financials Continuous Release Schedule 2022
February 2022
Unit4 Financials Continuous Release Schedule 2022
The Unit4 Financials platform is maintained via a continuous release model. Thanks to this predictable cycle of quarterly updates, users get timely access to the type of customer-driven enhancements that helps to keep the finance department ahead of the game.
Read on to find out when Financials updates are scheduled for 2022, along with important information for legacy V13 and V14 users.
Unit4 Financials planned releases
2022Q1 Release | Planned 8 March 2022 |
2022Q2 Release | Planned 7 June 2022 |
2022Q3 Release | Planned 13 September 2022 |
2022Q4 Release | Planned 6 December 2022 |
These dates can sometimes be subject to alteration.
To read a summary of what has been added since October 2020, along with a closer look at some of the most noteworthy enhancements, read What’s new in Unit4 Financials Continuous Release?
Post release, an .iso for each release is available from the Software Distribution Server.
Information for V13 users
V13 was previously maintained via Service Pack updates. The last Service Pack (23) was released on 27 September 2019. These previous updates are still available to download on the Software Distribution Server. No further Service Packs for V13 will be forthcoming.
Discover the latest Unit4 Financials features in V13 here.
Please note that maintenance for V13 was retired in February 2021.
No critical bug fixes for this product are being issued.
Information for V14 users
V14 is maintained via a full re-release of the software on .iso, available from the Software Distribution Server. The most recent V14 Release Pack – Release 17 – was made available on 28 November 2021.
Future Releases for 2022 are still to be confirmed (at time of writing) and will be dependent on user demand and the nature of any issues that arise.
Discover the latest Unit4 Financials features in V14 here.
Please note that maintenance for V14 will cease at the end of December 2022.
Distribution and notification of cloud updates
Unit4 Cloud customers are notified by Unit4 Cloud support when their pre-production and production systems will be updated. This information can also be found within the Cloud Services – Release Schedules area.
Updating your legacy systems
Support for Unit4 Financials V13 has already been withdrawn. Support for V14 will expire at the end of 2022. Failure to upgrade before then increases the likelihood of incurring extended support charges from Unit4.
Upgrading enables you to:
- Access the latest functionality
- Reduce operational risk and processing costs
- Continue to access Unit4’s “in support” software maintenance and support package
- Ensure you are up to date with Unit4’s latest software security package
As an Elite Unit4 Partner, Millennium Consulting specialises in delivering a seamless upgrade, while also ensuring your upgraded solution is fully aligned with organisational requirements.
Is it time to upgrade?
Upgrading your finance software can provide new functionality, increased automation and more efficient processes.
Illustrating the Benefits of Unit4 Financials Archiving – A Case Study
January 2022
For customers with high transactional volumes, the adoption of best practices around Unit4 Financials archiving allows them to significantly improve system performance and save storage space. A recent project undertaken by Millennium Consulting demonstrates the positive impact of archiving for Unit4 Financials users.
Read on to discover what we found, along with practical tips on addressing common archiving issues.
A case study in focus
Recently, Millennium Consulting undertook a company archival project for a global player in the pharmaceutical industry. The period covered was from 1995 to 2015.
The archiving exercise revealed that more than half of the documents within the organisation’s database were capable of being stored more efficiently.. Through the project, we were able to free up a significant amount of disk space within the production database but more significantly, we de-risked the organisation’s accounting solution against performance degradation over time.
At the conclusion of the project, we found that the archive tables on the database amounted to a significant 2.2GB of space. In total, 821,773 documents were archived representing 58% of the total documents within that company.
Most of the customers we speak to say that the volume of financial data they are processing is growing year by year. This is partly down to organic development, i.e., as an organisation matures, the number of transactions it is involved in intends to increase as a matter of course. But other trends are also in play here. Notably, for compliance and performance management reasons, businesses recognise the value of capturing a much wider range of granular data relating to individual transactions. The flipside, of course, is that more data means a greater burden on storage capacity and system performance.
What do we recommend?
• Archive all dormant companies, initially to the internal database using arc tables. Straight after internal archiving, you can then transfer these tables to the external archive database.
• Externally archive all live companies, except for the last four or five years. Again, you need to archive internally before transferring the tables to the external database.
• Archive to the internal database all live companies, apart from the last two full years.
• We recommend leaving in the current books all live companies for the last two full years.
If you follow this approach, then at each financial year end, you need to undertake the following:
• Archive to the internal database the third oldest year (e.g., at the end of 2021, you would internally archive 2019)
• Archive to the external database the sixth oldest year (e.g., at the end of 2021, you would externally archive 2016)
Find out more
You can learn more about the archiving function for Unit4 Financials in this brief demonstration video:
As an Elite Unit4 Partner, Millennium Consulting provides expert input to ensure Unit4 Financials is fully aligned to your organisational requirements. For help with archiving a backlog of legacy data, devising an archive policy, or optimising your existing archive processes, speak to us today.
Benefits of the automation of manual processes in Unit4 Financials
23 ways to automate and reduce cost and risk, by setting up the automation of manual processes in Unit4 Financials
January 2022
Workflow
With more people working remotely, re-configuring workflow allows organisations to keep efficient by ensuring each process is streamlined and everyone interacts with the process at the right time.
Banking payment XML
Reduce manual effort by setting up XML bank payment files.
Intercompany PO’s
Setting up intercompany PO’s will stop the need for companies to raise separate PO’s one-by-one in each company. With the Intercompany facility it is possible (for example) to raise a PO in one company that is for goods services in two other different companies.
Unit4 XL reporting
Set up reports in Unit4 XL for real-time reporting from Unit4 Financials and reduce any unnecessary manual Excel work.
Auto VAT Calculation
VAT can be calculated automatically based upon the VAT code being supplied – therefore reducing the input burden being placed on the user.
Derived fields
The entry of documents can be assisted greatly using derived fields on the input templates. This can automate the population of many of the fields on the Input screens which will speed up data entry and enhance the user experience.
Allocation
Allocation provides a flexible, automatic means of allocating centrally incurred costs across an organisation's operating units, so reducing manual work.
Currency Revaluation
The automation of currency revaluation enables you to recalculate home (GBP) values based on foreign values. The foreign values are selected, either from details or from balances, for reconversion at new exchange rates.
Account Summaries
Account summary is a user configured enquiry form that allows information from suppliers to be brought together with transaction details, balance, and diary information to produce a single view of the data.
Electronic remittances
In Continuous Release, electronic remittances can be generated automatically by email during a payment run.
Element Authorisation
Element authorisation can be used to automate new vendor and/or customer authorisations and creation.
Automatic accruals
There is an automatic routine within the invoice matching module that can create accruals and post to the financials module, so reducing month end effort.
Archiving
Archive enables the user to remove old data from the books to an internal archive area within the database. The archive process improves the system performance experienced by a user by reducing the amount of information held on the books.
Attachments
The attachments framework allows a user to attach documentary evidence to element masters, financial documents, purchase orders and sales invoices. The information can be in a variety of formats eg spreadsheet, PDF, Word etc that provides working papers or backup to a transaction. Once attached, the user can also view, remove, or replace the attached file.
Service Desk
Reduce cost and risk with Unit4 Financials Support and Maintenance from the Millennium Service Desk team.
Interface Manager
Interface Manager gives control back to the finance team to run and schedule their own interfaces so alleviating members of the IT department of doing these tasks.
Unit4 Travel & Expenses
Streamline and automate the expenses process, giving you more control over costs, better enforcement of company policy and help reduce the time and effort it takes to process employee or subcontractor expenses.
AutoCash
Save time and effort by automating your bank statement processing – automatically load, post, match and reconcile any items on your Bank Statements with transactions recorded in Unit4 Financials.
Unit4 Purchasing & Invoice Matching
Enforcing the authorisation and control over expenditure at the start of the process, rather than after the fact on receipt of invoice helps companies to stick to their budgets, control costs and gain efficiencies from better supplier leverage.
Unit4 Invoice Capture
Unit4’s Invoice Capture automates the capture and posting of invoices through intelligent OCR scanning and posts directly into Unit4 Financials.
Data Cleansing
Data cleansing removes major errors and inconsistencies that are inevitable when multiple sources of data are pulled into one dataset. Using tools to clean-up data makes the process more efficient since you will be able to quickly get accurate information into your system of choice.
Asset uploading
Do you regularly need to upload assets into Unit4 Financials fixed assets module – if so then Millennium’s Asset Uploader can streamline this process to help ensure all your assets are loaded error free.
Data Migration
Migrate your data between systems or to the Cloud, giving you quicker integration, faster implementation, and reduced risk.
Contact us for further details
Looking for ways to automate and reduce cost and risk? Submit your details and one of our experts will be in touch.
Archiving for Unit4 Financials
Archiving for Unit4 Financials
With any accounting or financial management solution, regular archiving helps you keep control over the size of your datasets, speed up processing times and ensure ongoing optimum software performance.
In this blog post, discover how archiving works in Unit4 Financials by Coda and the difference between the two types of archiving available.
What are the Archiving options in Unit4 Financials?
There are two types of archiving:
Internal archiving
With internal archiving, information continues to reside within your main Unit4 Financials production database.
Tables in the internal archive are given an “arc” prefix. The transactions within these internally-archived tables can still be accessed through enquiries. To search archived items, all you need to do is change your selector to ‘archive’ instead of ‘books’.
External archiving
External archiving involves moving data from the Unit4 Financials production database to a separate archive database. Note however, that this archive database still resides on the same database server. As with internal archiving, externally archived data is held in “arc” tables. To do external archiving, you first must do internal archiving.
How to utilise Archiving for Unit4 Financials
With any accounting system, the larger the dataset, the longer it takes to process requests (e.g. queries, searches and transactional reports). Especially if your Unit4 Financials users are experiencing a gradual drop-off in response speed over time, it’s a sign that archiving is likely overdue.
To avoid having to routinely process potentially millions of lines of irrelevant data for each request, it’s certainly worth focusing on the following:
• Establishing an archiving policy
Matters to consider here include whether and how often users need to query data that is over a year or two old. You should also look at how often your AP/AR teams need to query transactions paid/matched over a year ago.
• Ensuring a correct archiving set-up
As a start, you need to ensure the archiving feature in your Unit4 Financials system has been activated and configured according to your needs.
Does archived data remain accessible?
In short, yes. When you have archived your data in Unit4 Financials, that data remains searchable.
When you submit a query on the system, you have the option to search live data only, or include archived data. For most users, the majority of day-to-day queries relate only to recent data. So for these queries, users can stick with the default live data search setting. Regular archiving means that the system does not have to trawl through swathes of irrelevant data, thereby helping to maintain optimal search response times on routine tasks. On those occasions where you need to check historical data, you can simply switch the query type to include archived information.
Unit4 Financials Archiving: Watch how it works…
This brief video further illustrates the differences between each archiving method to help you choose between the two. It covers the issues that commonly arise in archiving financial information and how you can resolve them within the system. We also share a case study illustrating the benefits of archiving.
(Published January 2022)
As an Elite Unit4 Partner, Millennium Consulting provides expert input to ensure Unit4 Financials is fully aligned to your organisational requirements. For help with archiving a backlog of legacy data, devising an archive policy, or optimising your existing archive processes, speak to us today.