System.InvalidOperationException

[FinC]

Hi,

I am trying to finalise the FY19 PAYG Summaries and every time I get to the point of saving the EMPDUPE file it comes up with an error;

Code:
System.InvalidOperationException

Message:
An exception occurred while reading a database value for property 'EmployeePayrollDetailsUserDefinedEntitlementLine.Hours'. The expected type was 'System.Decimal' but the actual value was null.

Stack Trace
----------------------------------------
1 : System.InvalidOperationException
----------------------------------------
System.InvalidOperationException: An exception occurred while reading a database value for property 'EmployeePayrollDetailsUserDefinedEntitlementLine.Hours'. The expected type was 'System.Decimal' but the actual value was null. ---> System.NullReferenceException: Object reference not set to an instance of an object.

[Haydes]

Hi @FinC 

I've seen this error before, this can be fixed by running a script over the file. Depending on if the file is online or offline can depend if MYOB can run the script or if we can provide you a tool to run it over your file.

If your online, please post:

• The Last 4 Digits of the MYOB Serial Number (Found in: Setup > Company Information)
• The Company File ID (Found in: Help > About MYOB AccountRight)

We can then find your account based on the email address you signed in with and match the serial number by the last 4 numbers and run the script over the file.

If your file is offline, let us know so we can send you the tool.

[FinC]

Hi Hayden,

Thanks for your response.

Last four digits serial: 1944

Company FIle ID: 1

[FinC]

Hi @Haydes,

Are you able to run the script while people are on our system? If so, please feel free to run it.
Also, if there are any other mods than can run the script if Hayden can't, as I need to process the file ASAP so I can close the payroll year to do the required updates for payroll tomorrow.

Much appreciated.

[Andrew_Y · Accepted solution]

Hello @FinC FinC

Apologies for the delay in getting back to you.

I have now run that script for you against the aforementioned SN & CDF#  Please close and restart to see if it has been effective.

[FinC]

Thank you very much for your assistance.

[C_Fisher_MUB]

I am having this same problem could you please help me?

Charmaine Fisher

[Andrew_Y]

Hello @C_Fisher_MUB 

We would be happy to see if we can help with your issue .

Please refer to the original post and provide the appropriate information so that we can confirm what your issue/error log indicates, and check if it applies to your situation. 

As with Hayden’s post  we would need the appropriate information from you as to which file it applies to, as well as the last 4 digits of your serial number before we can proceed.

If your file is offline, we will need to direct you to a different avenue for solving your issue.

[MattLewis]

Hi,

Can you pelase provide me with the script / solution for offline file error?

Matt Lewis

mattl@eastmans.com.au

0897215422

[Gayathri]

Hi @MattLewis,

Thank you for the post! Welcome to the MYOB Community Forum.

Sorry for the delayed response. As you mentioned that your file is offline. Can you send a private message with the details:

1. The serial number of the company file (Setup>>Company Information).
2. Email Address
3. Company File ID

Thank you.