Knowledgebase : Pegasus Opera
Recently when user upgraded to a Windows 10 PC and had O365 Business account (so also a desktop version) to fix an issue with Opera3 emailing we had to carry out the following:  1. I uninstalled the Opera3 client and deleted all folders        c:\program...
To pay the three SSP waiting days in Opera 3 we recommend you create a new payment profile and select the SSP payment profile type. This will ensure the total SSP year to date values are correct. Finally, you will need to manually calculate the value to ...
This has been resolved on a couple of sites where one PC cannot communicate with the scheduler on another . They created a rule in the firewall on the PC that has Pegasus Scheduler on it to allow communication from all client PC's that are trying to comm...
The error 1098 illegal value is most likely because of either a blank line or corruption in the table used in whatever process is being performed by the user and is not version specific. You will need to use the relevant table dependent on the module in w...
This document outlines suggestions which can be used to resolve or prevent intermittent, non-reproducible file accessing errors. Note that these are distinct from software-handled locking conflicts within Opera itself, where the user is notified and given...
the payslip image was incorrect as the system creates one for the e-mail functionality in the PSSimage folder as well as holding one in the Payslip image folder So you need to copy the one from the Payslip image folder into this folder. Ensure that the n...
We have been made aware of issues with the HMRC submission portal, which may affect a small number of your Opera customers. MAKING TAX DIGITAL FOR VAT – HMRC PORTAL ERRORS HMRC has advised that there is currently an issue with the MTD VAT service affec...
You may get an error 41 fix when performing the period end in one of the modules.  Memo file \\O3 Server VFP Static and Dynamic\Data\COMPANYA\A_PNAME.FPT is missing or is invalid. So Get all users out of Opera. Open up dataviewer. Set exclusive on. Open...
As per Pegasus: The taskresults ini should exist in the following location by default: C:\ProgramData\Pegasus\Scheduler Server To resolve this please check that the scheduler dynamic share is present and shared correctly. The share name might exist but...
If the figures are already committed in the system. You need to check when the last committed date was e.g. 30/4/2019 and then amend the fields below in the SEQCO table for the company. MTD Effective – 04/01/2019 (American date format) Submission – 1 –...
If when posting a sales receipt on a Windows 10 you get Error 1098, try the following amendments to the registry (ensure to backup your registry before making changes) @ 6th August 2020 - it appears this only needs applied to Window Build 2004 - previous...
It can also relate to error XRL ERROR - MSSCRIPT.OCX. When you get this error. You need to run a registry fix. See attached - Take a backup of the registry - open up regedit, file, export, save to c:\temp\registry. OK. Close out of regedit - Double click...
I have attached the "Pegasus" document to this solution as well. If the XRL/Infor Add-In is not appearing in Microsoft Excel and you are frustrated that the  Add-In will not get into Excel, please find a possible solution in the attached document.  Item...
* Create a NEW nominal bank account with NO opening balance in nominal maintenance\accounts NOTE: if there is an already existing nominal account for the foreign bank which has been maintained as Sterling, then at point 3 below use this ACCOUNT as the b...
If adding the EC VAT module to an already live financials system - ensure to check after enabling the module the VAT CODES have all of their relevant boxes still ticked. The H/S/1 and H/P/1 vat codes for a particular customer after enabling the EC Vat Mod...
In the Adobe DC, Edit, Preferences, Page Display, Rendering box change the Smooth Text to NONE and untick all of the boxes (smooth line art, enchance thin lines etc) This may speed up your posting of large journals
Pegasus OperaII/3 ageing is firstly based on the Transaction Date of the transaction - not the due date. Also, set in your Set Options is the "Accounting Period" which will be set to either "Monthly", 7, 14, 38 or 30 Days which then determines what Opera...
LEVY EARNINGS are not based purely on Total Pay or Gross Taxable pay due to the criteria in which the levy earnings are calculated from and so are dependant on 1. The Employee's NI Code 2. The type of Pension Scheme an employee contributes to and the ...
If you try and reconcile amounts against each other on the bank account and they were previously rectified. Then you need to use the MATCHING option on ACTION on the bank account in cashbook. You can identify the issue when you view the transactions on t...
Recently when user upgraded to a Windows 10 PC and had O365 Business account (so also a desktop version) to fix an issue with Opera3 emailing we had to carry out the following:  1. I uninstalled the Opera3 client and deleted all folders        c:\program...
The PALLOC table holds the status of cheque printing on the field al_cheq. If al_cheq has a 'C' in it, then it will appear in the print cheques - remove the 'C' to remove from this list If al_cheq has a 'L' in it, then it will appear on the cheque list ...
You need to setup 2 payment profiles One called CC voucher Default Type Taxable NI'able Pensionable Attachable   One called CC Salary Sacrifice Which is the same settings as above   Then you need to set up a deduction Childcare Vou...
Due to the prior year journal being posted BEFORE the consolidation company was year ended, this has then caused the system to duplicate the journal as the year end process on the consolidation company is balancing forward its own balance and the prior ye...
In Invoicing, Set Options, tick to consolidate invoices when being batch processed. This option will want to consolidate all orders for the same customer into one invoice. If you require for a customer separate invoices, you MUST make the delivery add...
Trying to run CORRIN email payslips and getting an issue with trying to create the OUTPUT file. - ensure within Opera3 against particular user that the SYSTEMUSER PREFERENCE has the OPERA PDF PRINTER UNTICKED (so not using amuniyi pdf printer but using ...
Add the following to the firewall white list to resolves this Proxy error. Address: corrinsoftwareproducts.co.uk Port: 80
The easiest way is to use the copy function. So into Administration/system / Maintenance/ User profiles Then select an existing user from the list tab with the level of access that you would like to copy. Then click on the copy icon (This is between the p...
CSV files for Importing into Opera3 - ensure no spaces are in the file name, the file will error with no WR_Ref & WR_Trncde when there clearly is.
CYCLE TO WORK SCHEME _ _ _You as the employee will technically hire the bike over the hire period (usually 12 months). These hire payments are deducted as a Salary sacrifice__ (prior to Income Tax and National Insurance contributions) therefore you pa...
When sending FPS getting a Validation Message " If occupational pension element is included then employee occupational pension or annunity indicator must be selected". Pegasus say that on the employees Bank & details both the "Employee is being paid an Oc...
For directors national insurance to be deducted like a normal employee - ie equally over 12 months, make sure the ADV option is S. For those who wish to pay no NI at the beginning of the year but will be deducted in month 12 then change the ADV option is...
If when you view the database tables in SQL Express, if the database for a particular company has in brackets after it single user so for example DM_M (single user)  this needs set back to being multiple user by right clicking the DM_M and going into th...
When running e-mail payslips in Pegasus opera and you get a message in the SQL database - *THE FILENAME, DIRECTORY NAME, OR VOLUME LABEL SYNTAX IS INCORRECT. This is due to the PDF not getting created. So check that the layout is working by running a pr...
I have tried to run the bank account validation updates, but it is saying task failed. If the database is out of date and after looking in 'System Setup' > 'System Maintenance' you can see the last status as 'Task Failed'. Attempt to run the task manually...
If you get the above message however you HAVE installed the Pegasus Scheduler client on the client PC (and it's all working on the server ok) Compare the 'Scheduler' key in REGEDIT on the client PC and on server - the CLIENT TARGET path should be the same...
Error when generating Email Payslips - RETAIN DAYS IS OUT OF RANGE (READING CONTROL XML MAIN VALUES) - this is due to the payrollset options for the particular Payroll Group having the RETAIN PSS Payslips on Tab3 set higher than the keep history - set t...
If unable to establish the reason for an EMAIL PAYSLIP failing or a batch of emails failing, check with SQL Management Studio in the Peg Scheduler database; MessageItems table. This has a field with a more meaningful StatusText that helps in some circumst...
Need to be on Opera3 version =>2.32 1. Go into Personnel Processing, find the employee and edit the department code (to something else) and save the record - then put the original department code back and save. 2. Then go back into Payroll ProcessingDeta...
User rang to advise that when trying to do a preview of the email payslips it was advising that Scheduler Version 2.12 or greater should be installed. Got dialed onto the server to check the Services and found the Scheduler Service was not started - rest...
This error message relates to the HMRC not recognising your login credentials.
You are getting error 13 when trying to tidy up the purchase orders. As advised, please use the Action/View/Lines rather than EDIT as it appears there are purchase orders with possibly blank lines causing them to fall over - using the view and then the sa...
ERROR 1429 CANNOT RESOLVE BACKLINK This type of error occurs because there are tables within the data folder that the system believes should not be there (ie not part of the database container) this will cause a backlink error to occur when running updat...
When Printing Vat Reports after MTD is switched on - Getting Error 1734 Resolution below  We have seen the error the customer is experiencing reported when running the VAT reports prior to the development of the MTD VAT Centre so I'm not sure it is rela...
This has been seen where there are blank lines in a table and therefore Pegasus has been unable to process a request and would then give this error.
When trying to LOG into Opera3 after applying the Corrin bespoke - when it was trying to run the DLL to the webservice corrinsoftwareproducs.co.uk it was giving an error 'Corrin Web Service Error: The remote server returned an unexpected response: (417)...
It isn't possible to print off the statements to excel. But you can do a debtors report. Just select reports/debtors report Select the one account. Tick show transactions. Tick open document when done. Click publish and ensure that these figures are...
Take Opera backup Get onto server Log into Dataview Go to Tools Repair Tool Select Folder - this will be the company data folder Make sure tick is beside +Report Check Folder Normal Mode On the report which comes up on screen, find the t...
Transactions posted in the Cashbook for 759.00 (vat analysed) dated 31/08/2017 which is period 8 year 2017 £632.50 of this should have posted to nominal expense account Q130 ADM £126.50 of this should have posted to nominal VAT account E225 with the bal...
This is assuming that the company has got to the LAST PERIOD of the year Week 52 and they should be in Week 51 To fix this 1. Created a 'new weekly' payroll group and setup the calendar the same as current group. 2. Set the group to be in Week 51 3....
If wanting to use the "FELXIBLE or DEATH PENION" in payroll and the customer is on version 2.31.00 or below they will need to be upgraded to latest version This will fix the FPS submission issue.
If you get an Error 13 Alias is Not Found when going into MTD VAT Centre it appears to be an issue with the authorisation (found so far getting this error if there is a single user authorising for multiple companies) To fix, try the following: Login int...
When processing a payroll where a company holiday week has been used. When calculating the next weeks pay a message may appear saying that the employee returned from the holiday early, if they took an extra week. Or another employee got a message when he ...
Leavers are not removed from the system when the payroll year end is run they are converted to Historical leavers. Any 'L' or 'D' type leavers in the current tax year will become 'H' type leavers once the year end process is run. All 'H' type leavers w...
Browse to the employee record. Click Action History Highlight the week / month Click Action Resend payslip
If you log into SQL Management Studio and go to Pegscheduler database, then tables and DBO.Settings -
April 2020 saw HMRC change the guidelines to working out holiday pay average value increase from 12 weeks to 52 weeks. Calculating an employees average holiday pay relates to  - Full Time/Part Time Shift Workers - Employees with no fixed hours, so Zero...
When importing sales or purchase transactions, to ensure the correct tax point date is applied it is advisable to include this on the SANAL.csv, sa_taxdate or pa_taxdate - if not included the importer will assume the computer date (not the Opera system da...
When you drill into a transaction and the incorrect PDF is not correct then see attached document:- To find out which pdf document that is associated with which transaction. You need to find the invoice number of the transaction and account and then:- ...
Run either UDS or individually pack all of the tables trying to be updated by the posting. Customer was getting above when trying to progress an SOP order to an invoice, the problem turned out to be 4 out of 16 stock items on the order when trying to upda...
If when posting a purchase ledger invoice you receive a message 'Invalid Budget Code', this may be due to a data corruption on the JCLINE table. Firstly need to establish if there are any Window 10 PC's which use OperaII/3 and check that the DWORD regist...
Backup the company Take note of the LEVY values IF overridden in Statutory Tables Try using the COPY STATUTORY rates function and try running the calculation if this does not work Run UDS on the company, copying the Statutory tables and running a re-in...
If you receive a message when going into the MTD VAT Centre regarding "AZURE FAILURE", please try the following: 1. Close out of MTD VAT Centre, wait a few minutes and try again 2. Check that Microsoft .net 4.7.2 is present on the PC 3. It could be fir...
Please see the attached incident update from Pegasus in relation to this query.
If you have submitted your 1st MTD return and you log back into the MTD Vat Centre and get message 'An Open VAT period could not be retrieved from HMRC so the VAT period dates will not be displayed" [Image preview] This is an issue with HMRC and custome...
When going into the MTD centre an error occurs. We have had the message "Exception escaped during command execution. An error occurred while sending the request" reported by a few partners and in each instance it was the firewall on either the client mac...
CONFIDENTIAL: MTD AND THE PILOT SCHEME: NB: The customer is required to file their (QUARTERLY) VAT Return for the period ending 30/04/19 therefore the VAT Period start date is 01/02/19. PRIOR TO UPGRADE: Ensure all VAT data has been committed up to 31...
Error when text code was entered trying to authorise the MTD company A. We tried it again and it went through and granted authority with no problem.
When going into the MTD VAT centre you get a message on every company  - EXCEPTION ESCAPED DURING COMMAND EXECUTION. AN ERROR OCCURRED WHILE SENDING THE REQUEST.  My gut reaction is that this is due to HMRC getting too many requests for submission and ...
If your NEST file is not uploading, it may be due to one of the following 1. Payment Source description(s) do not match between your Opera payroll setup and the NEST setup, to check in the payroll system, go to PayrollMaintenancePayment Source and check...
Opera cannot hold NI numbers that don't follow the usual layout TN 001122 F For foreign nationals who get a number of HMRC like 65 25 81 62, Pegasus say to leave NI field blank and fill in as much other information including passport number as possible....
This will be due to a SPACE in front of a delivery note reference eg ' none' instead of ' none' To fix this, you need to find all instances of ' none' on CGLINE (field ci_dnote) and DOLINE (field do_delref) and remove the space
This may be due to the tick box not being ticked when running the Contract Period Billing process in utilities in Service management. It must have just had the Process and NOT THE INVOICE ticked
The OLE error code 0x message when logging on is usually caused by the Windows file MSCOMCTL.OCX which contains the Microsoft Common Controls such as tree view which are used by Opera. Re-register this file using an elevated command prompt and the regsv...
If this error occurs when trying to carry out RTI submission I may be due to .NET not being fully installed, especially on NEW window 10 PCs whereby .net 2.0 and 3.0 are not automatically enabled. See response from Pegasus:   This message: "Unable to ini...
Ensure to check the "Destination Details" setting when logged into On-Line Filing Manager is set to the attached
​If opera is running slow on PC try doing this one one of the systems (will need done on every PC if it works) Open Network and sharing centre click on 'Change adapter settings' Right click on NIC and select 'Properties' Select 'Configure' for NIC and cl...
When posting a Credit getting the message  "UNABLE TO POST REVENUE TRANSACTIONS INVALID COST RATE 0 FOR COST CODE INCOME" I checked the JCLINE & JWIPR to ensure Cost Rate did not have 0 and were all 1 but there were also blank lines on the JCLINE whick ...
Record out of Range Error - Went in to STRAN/PTRAN appended new record, marked for deletion and then PACK or Delete all records marked for deletion.  Then ran Validate Database, if this doesnt work a UDS will normally fix it.
When you try to print a Cash sales in Opera you get a mouse busy icon and Opera hangs. Fix; Set printer port on Opera_PDF printer driver to local port 'NULL'.  By default it is set to LPT1 This needs done for every system needing to print
​If opera is running slow on PC try doing this on the systems (will need done on every PC if it works) Open Network and sharing centre click on 'Change adapter settings' Right click on NIC and select 'Properties' Select 'Configure' for NIC and click on t...
If you get this error, it means ZVTRAN is corrupt and Pegasus have suggested to try either of the following: Take a backup of the Opera 3 data and then rename ?_zvtran.cdx (to retain it) and copied z_zvtran.cdx to ?_zvtran.cdx. Run a UDS as Admin user, r...
Possibly due to a windows update. Unzip and run the library error fix executable on the workstation and reboot the workstation and try again (executable found in Y:AccountsSupportTraining and SupportUpgrade InformationPayroll Upgrades 2017Documents2017l...
Please note that Opera3 does offer the ability to 'OVERRIDE EXISTING' records, however you cannot just import the new data for the particular field, you need to re-import every single field  for example Rather than go in and manually change the territor...
For any future customers who are wanting to use the Opera3 email payslips, the details must not be entered into Details and Bank as this then prevents paper payslips being produced - the details need to be entered onto a csv file which the template for th...
Does the PC have Malwarebytes? Has this been recently updated? An update of Malwarebytes Pro came out around 23rd March 2017 which causes a conflict with Opera3 - removing this fixes the issue.
To prefix the Vat Registration Number with "GB" on invoice, credit note layouts if you have an expression similar to this, change the expression seqco.co_vat to be "GB"+seqco.co_vat
THE BELOW CAME FROM THE PEGASUS SUPPORT FORUM AS A SUGGESTION: As observed, the issue was only affecting Windows 7/Server 2008 level machines.  That led me on a merry chase to nowhere checking and eliminating various things. LAN speed tests to the new o...
P45 laser does not work anymore - part 3 is in a different format to what HMRC have. According to Margaret you are allowed to print Plain Paper P45 and give this to an employee.
Validation issues when trying to submit an RTI FPS Submission. The following error is still occurring "Pattern of TaxablePayment does not match specification". This is caused when using Flexible Pension box on a payment profile in payroll. A tempory ...
When trying to assign a cost code. Pay elements must be present on all or none of labour rates. Brow for JO_CCODE="SHSTM_LR_SS" in table JCCOST Then remove the 0 from the field JO_WGPAY. Then the user is able to put the rate onto the system. It is not...
If a pdf image is created showing someone else account information but the stock items are correct, then you need to resave the pdf again. Go into SOP/Invoicing, publish the credit/invoice to File, save the pdf into the pdf folder. Make sure to go to th...
Pegasus released a KB Article 1651973 advising to check the following: ENVIRONMENTAL SUGGESTIONS FOR PERFORMANCE ISSUES NETWORK In the Opera system requirements guide a 100Mb network is specified as the minimum speed required. However, in testing we ...
Scenario 1 - DEP Settings ~~~~~~~~~~~~~~~~~~~~~ Normally when the customer is encountering the message "Opera.exe has stopped working" in the SPM module, this is usually related to the DEP settings on the client PC but if not already done then please also...
Please follow the following link for the Pegasus Opera and XRL folder Permissions and Exclusions for anti virus https://www.intsysuk.com/single-post/2015/01/22/Pegasus-Opera-and-XRL-Permissions-and-Exclusions  
If you remove for any reason transactions from the NTRAN table please ensure  1. That you are removing the same debit/credit value to keep the TB in balance and you pack the NTRAN table afterwards 2. For the nominal accounts you are removing transaction...
Issue can be due to a registry key not registering on PC which can cause the message Pegasus Scheduler Editor not available or not running. The registry key missing was the Client Target key which should have been set to net.tcp://sm-opera:51920/PSc and ...
This will be due to the TO-DATE report including Previous Employment figures for any new starts, whereby the This Period report does not.
If the above happens, run the Global Calculation report and check for any notes against an employee similar to 'Insufficient Pay for ???????? - Correct & Recalculate' The above got reported on a calculation report whereby an employee had a -36 units a...
Ensure the period you want to post into is OPEN and all subsequent periods which will be affected (Remember you can only open a closed period if you are logged in as the Admin user) Ensure the JOURNAL DATE is set to the period you want it to post into, e...
1. Ensure Keep PDF printer is ticked on in Opera II (Administration > System > Utilities > System Preferences) 2. Go into Control Panel , then Devices and Printers. 3. Select the Opera PDF printer, right-click and select "printer properties". 4. A...
There is a problem with a windows update that gives the attached error message when users are trying to run XRL.   So you need to roll back the software before the update by opening up command window as administrator run this from the command prompt. ...
Take Backup in dataviewer open the ZOLE.DBF in command line: SET DATE BRITISH SET CENT ON DELETE ALL FOR date < {01/01/2016}
Using Dataviewer, open SEQUSER.DBF from system folder and for Admin User set the following and remember to have access to Company Z ONLY Count 1 = 65535 Count 2 = 4666
Go to Sales Ledger History Action button Tidy History Enter date to delete sales history up to. Click OK.
This can't be done other than through a year end routine.  You can change the "keep transactions for", but it is only a year end that moves them out of NDETAIL.
For Glenkrag When their system vat file starts getting close to the 2Gb limit. Take a backup.  Could take a while to process so get them to do it at a weekend. Go to Reporting, EC VAT, Reports, ESL Report - enter a date to clear up to, then click in Co...
When getting the message "Rescource file not valid, overwrite it with a new one" when logging into Opera, Pegasus advise the following:- In order to resolve this message please try the following: 1. Delete or overwrite with a fresh version of the two ...
This could be 1 of 2 issues causing this. Possible Issue 1 - thumb files in the company data folder, on the server where Opera is installed navigate to the company specific data folder and ensure in windows explorer you set unhide all file and folders an...
There currently is no function within Opera3 to ADD the EMPLOYEE SAVING back into the contribution (same as Employer)  The saving needs to be worked out manually (the difference between the net pay before calculate ran with Salary Sacrifice switched on a...
In Administration User Profiles Continuous Posting You can untick this
Method 1: We cannot advise on the settings that the customer should or should not have in Outlook, the link below from Microsoft helps to explain why they are having an issue with outlook and it is then up to the customer to change if they wish https://s...
If in SOP the front screen is showing 0.00 but the lines on the order have been priced, this may be due to a document being edited at DELIVERY stage with the prices, so the 'A' line has no values but the 'X' line has been updated. Due to this the front sc...
To get the data send for stock take adjustments to work in Opera 3 (XRL 1.65) the reference field MUST be 10 characters - no less no more
If the IN-STOCK value on the Stock Valuation Report does not agree with the CNAME/CSTWH tables, you need to ascertain which is correct. If the values on CNAME/CSTWH are correct and the stock valuation report is wrong, you need to then look at the BALANCE...
TEST PEGASUS KNOWLEDGEBASE ARTICLE
When the user uses the transmit BACS function and expects the system to copy the file off to another location. You need to use the attached files
The way is to reinstate the leaver and change the email address. Then mark them as a leaver with the same leave date. Then you will be able to enter in the e-mail address on the new employee record
Get this message when going into OFM ? Need to install .Net2
If getting the Message in Opera 3 Document Management "Unable to launch Doc Management invalid arguments habe been passed" Uninstall Doc Management client and reinstall this should fix it 
Ensure before validating a DBC to backup both the SYSTEM and DATA folder!!! To validate the DBC in Opera II/3 Use dataviewer and click on OPEN EXCLUSIVE Then OPEN the company DBC table DO NOT CLICK 'VALIDATE DBC' In Command Line key in     validate datab...
Take a backup of the data and run a System Re-organise with TIDY VAT files ticked and putting in a 'DELETE VAT HISTORY UP TO' date in agreement with the customer (usually keeping at least 7 years)
When creating a new stocktake a warehouse isn't appearing in list. Brow for cs_whar = "xxx" Last Counted - Replace all for cs_takedte = {  /  /  } for cs_whar = "xxxx" Quantity Replace all for cs_takeqty = 0 for cs_whar = "xxxx" Active Stocktake ID R...
Email addresses had been input into the details and bank section of employees in preparation of setup of Opera3 Email payslips - however this then prevented the printing of payslips this week. Dialled on and extracted the csv file with already inputted e...
If setting up an XRL report and needing to use a IF statement on the auto enrolment status, using the following descriptions in your command Status LP - Wenrol.WAE_LSTAT Status TP - Wenrol.WAE_CSTAT 1 = NONE 2 = Auto-Enrolled 3 = Postponed 4 = Opt...
When you run an xrl report and get an error:- Problem found in Module AlchemyExecuteError SQL error Will continue program Country: 44 United Kingdom Computer: TPC-PC04 C:\Windows\system32\ Product=Opera 3 / Opera II Platform=FoxPro Table=NT Error -214746...
XRL ERROR 372 AND RUN-TIME ERROR 429 There are two commonly reported errors relating to the use of XRL as a result of the Microsoft Windows Update KB4011051 * Error 372 Failed to load control 'SSTab' from tabctl32.ocx * Run-time Error 429 You do not...
Summary Link field re-calculates when you are logged out of XRL In later versions of MS Office 2016, a Summary Link formula is not protected once you log out of the Infor Q&A Add in. This can lead to a re-calculation of the formula in the Summary Link fie...
If for a USER on a terminal server the XRL ADD-IN does not load into Excel (so you open Excel and go to Options\Add-Ins and under COM-ADDINS the Infor dll is listed and you tick it and it still doesn't load AND you have applied and checked for the user -...
If the XRL/Infor AddIn is not staying in Microsoft Excel and you are repeating the process to add the AddIn each time you open Excel, please find a possible solution in the attached document. 
DESCRIPTION: XRL ERROR 372 AND RUN-TIME ERROR 429 There are two commonly reported errors relating to the use of XRL as a result of the Microsoft Windows Update KB4011051 * Error 372 Failed to load control 'SSTab' from tabctl32.ocx * Run-time Error ...
Customer getting VB Script Error when trying to LOG onto XRL If customer's Office has updated to 2016  Version 1808 Build 1.730.20264 (semi-annual channel) Pegasus have advised to also try and apply a registry fix. This can be found in S:Training and Sup...
If there is an Opera system with multiple systems, XRL can only be pointed to a particular system at a time so if needing to report from a different system you will need to change which system you want to report from in the XRL setup