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 ...
You
Take a backup
Open the table in error files
Needs to be exclusive and ctrl y to add a new record,
then mark it for deletion delete it
close out of the screen
Pack the table
Run UDS with re-index
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...
After upgrading the Opera Scheduler you may get this message if the
account that you used was NOT the Domain Admin account when on the
server / PC that had the scheduler installed on it.
How you resolve it is by editing the registry setting
"Computer\HKE...
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.
Ensure to firstly check HMRC services are
available https://www.gov.uk/government/publications/making-tax-digital-for-vat-service-...
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...
The system allows you to enter the e-mail if you change one of the
letters to an upper case.
E.G.
On the old record it may have been [email protected]
When entering the new record change the first letters case to upper
[email protected] ...
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...
The main table which controls what is seen in the MTD Previous
Submissions table is the ZRCSL
For a customer there were dates missing from this for the previous
submission (possibly a crash or system not responding) which once
populated the submission wa...
As per Pegasus:
The taskresults ini should exist in the following location by default:
C:\ProgramData\Pegasus\Scheduler Server
To resolve this give full permission to the user account running the
tasks on top level at c:\program files x86\pegasus and
c...
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...
This is SCR OPERA-3231 Error 1976 UDS backlink error on sequrmap after
upgrading from 2.60.00. The error log is pointing to the sequrmap.dbf,
please delete this from the system folder and run the UDS, the UDS
will recreate this table in the system folder....
* 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...
Copy fields from the Peg052 3 Part Pay Advice Continuous payslip
(sqwgp83.frx) onto the payslip - if there are more than 2 Employer
deduction types you may need to then add fields using the matrix below
field description this period to-date
1,2 1,1...
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
...
attach
see attached
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...
Opera3 Version 2.81.02 to 2.81.?? has a defect whereby under a certain
scenario when a rectification is carried out and the REMOVED function
is used, when the reversing cashbook transaction gets created the
transactions assumes the ENTRY number of another...
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...
When an employee is setup in Opera3 against a "Director" profile, then
the NI for a director is calculated completely differently from a
normal employee as NI Contributions are worked out from their annual
earnings rather than from what they earn in each ...
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 using the "Extended SD Processing" feature in Opera3 to generate
the SD Despatches report to CSV, be very mindful if the CSV file is
opened to be edited that fields with proceeding zero's will be dropped
for example
1. CELL C1 holds the Branch ID whic...
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...
If a problem starts to occur when emailing payslips or P60's from
Opera3 where they FAIL
Run a TEST email from the Pegasus Scheduler Set Options, if you get:
Failure sending mail: unable to read data from the transport
connection: net_io_connectionclose...
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...
This error message relates to the HMRC not recognising your login
credentials.
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...
If getting this error when running the payroll to-date summary report,
copy back a clean SQWGRP8 and 9 frt and frx's - also look to see if
the customer has bespoke report layouts setup such as A_WGRP8 or
A_WGRP9 and remove these advising bespoking these r...
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...
"Error 230 Array dimensions are invalid"
This occurs when th NI Code on a leaver (usually this period) is
blank, when running the Departmental Analysis including leavers.
To fix this go into the WNAME and set NI Code to what it should be
then the repor...
ERROR 230 ARRAY DIMENSIONS ARE INVALID
When running the Departmental Analysis Report with leavers ticked,
getting Error 230 Array Dimensions are invalid. This is caused by
Historical Leavers with the NI Code D, on the employee change the NI
Code to X an...
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)...
This usually happens due to an existing installation of XRL not
uninstalling correctly:
Please carry out all of the following steps to resolve:
- Logon as domain admin
- Uninstall XRL ticking the completely remove box
- Use advanced uninstaller pro or a...
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
Go to run and type COMPMGMT.MSC
If you get the error above (could be any table where a memo field
resides), this will mean there is a record or multiple records where
if you try to tab through the MEMO field on the table (and there could
be several memo fields), you will get the Memo fi...
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...
If users start to experience an issue when logging into Opera3
"Variable Not Found" but then clicking on IGNORE continues the user on
into Opera3, check if they have any Corrin bespoke which the AMC has
been cancelled.
If this is the case, you need to op...
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 ...
Before carrying out a reinstallation of the On-Line Filing Manager
(OFM), if you take a copy of the c:\programdata\pegasus\ofm\gguser
configuration file - this holds the user details, you can paste this
back into same folder after the re-install
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 it 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 in...
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...
If an employee has left and then returns if you try to use the email
address associated with the leaver record you are unable to, however
if you simply change one character in the email address from say
uppercase to lowercase this will work for example;
...
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...
See attached document
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...
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 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...
If a user when they file on-line using the Pegasus On-Line Filing
Manager saves to the default location the submission receipt for
either the EPS or FPS these can be found in
c:\programdata\pegasus\ofm\audit
or
c:\programdata\applicationdata\pegasus\o...
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 in Opera3 you get the Error 2005 Error loading file - record
number 3. Frmdateselect1 . Loading form or the
data environment : OLE error code 0x80040154: Class not registered
Follow the following instruction as per Pegasus:
Thi...
If you remove or add transactions from/to the NTRAN table please
ensure
1. If removing a transaction to pack the NTRAN afterwards
2. For the nominal accounts you are removing/adding transactions for,
you will then need to also fix the NACNT table which...
If after installing or re-installing On-Line Filing Manager you get a
permission issue ensure that the following folders have FULL
read/write permission
c:\programfiles x86\pegasus\ofm and c:\programdata\ofm
if there is no c:\programdata\pegasus\ofm fo...
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...
Check the following file C:\Program Files (x86)\Pegasus\Scheduler
Server\serviceconfig.xml
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...
If posting a Prior Year journal to a profit and loss account ensure
that your balancing entry is being posted to a Balance Sheet Account
(check the Type set against the nominal account)
If your balancing entry is not a balance sheet type account the syst...
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.
...
This particular error occurred due to a customer record being set to
email 'Delivery Notes' however no report frx/frt existed for emailing
delivery notes. Once unticked on the customer record the order
progressed to delivery with no issue.
The same type...
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
Company = Z
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 ...
RESTORING OPERA FROM THE SERVER WHEN CUSTOMER HAS PTX
If a customer needs to restore and they use PTX, you must ensure that
PTX stops the services so the restore can be done. The reason for this
is PTX scans the Opera files every 60 seconds so there is a...
If when committing the standard VAT return, a message appears 'There
are no Reverse Charge Sales' for the VAT period. To commit this
listing please select the option for nil returns on the HMRC website'
This message is appearing due to a tick box on the ...
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...
To fix this, you need to use dataviewer or command line and amend the
period end date on both the PTRAN table and PHIST table
Allways ensure to have a backup before fixing the data and take
another backup afterwards before running the period end
for PTR...
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
Ready eggs Bespoke - When a user tries to go into "Shelf Life" on the
stock module.
the file is not there c:\program files (x86)\pegasus\o3 client
vfp\tmpsname.dbf.
Solution is to ensure all users group has read write access.
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
If when trying to validate a payment in Epay you get an error on the
Payment File 'Report Processing Error', this will be due to
permissions on the O3 Server VFP....\Data\Company? folder and it
trying to write back the ?_wgbacs.out or ?plbacs.out file
En...
When you log into XRL and get a message "Problem found in Module......
" and in the white box it mentions "Unable to access clipboard, try
again later"
You can resolve this by entering the Infor folder path in to the
trusted locations in the trust centre...
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
Reboot the client
Advice from Pegasus:
If you install a new PegScheduler database - Resending of payslips
will not work
1. Stop the Scheduler Service (just so their data is not being changed
while they are replacing their SQL Serve version)
2. backup the PegScheduler da...
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...
This relates to transactions on the ZVTRAN.dbf with a va_except flag
of T - true and has been previously committed so should not be
appearing.
To fix, check with the customer what the LAST VAT return committed
date was (not what the current one is) and...
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...
When XRL is installed in the RDS environment to then apply the Infor
Q&A (C:\Program Files (x86)\Infor\Query and Analysis
'ExcelAddinRemoveAdd function) to the users Excel Ribbon ensure to
carry out the following:
1. Ensure full/read write permissions to...
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.
When installing XRL getting "Error 1325. Document is not a valid short
file name" to fix this I checked the path of the Documents path in
properties, for example it should read something like
this C:\Users\Sharon Rowley\Documents and not \\servername etc...
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 ...
XRL NOT WORKING - FILE NOT FOUND - C:\WINDOWS\SYSTEM32\...GOAPPUSR.DLL
Ensure that there is an Opera client installed.
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
Help Desk Software by Kayako