Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
Just upgraded company file to AR 2018.4 and when trying to expand the dates on the purchase register, say to 01/12/2018 to 03/01/2018 it immediately produces a window saying, 'something has gone wrong and MYOB need to close'
Inspection of the error log show the code; System.InvalidOperationException
and the message; The null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type.
I have been able to change the dates in the sales register and everywhere else.
If a pick a particular supplier and expand the dates it shows the invocies for that supplier, just not when it is showing all suppliers.
Solved! Go to Solution.
I have seen this error before, this is caused by a Null Value where one should not be in the database. We do have a script that can fix this if your file is online.
If your company file is Online:
I can run the script for you, please post:
If your company file is Offline:
You would need to run the script over your file, there is a hotfix tool that can be used. Here are the instructions for downloading and using it:
Task 1 - Back up your Company File:
You should always create a backup of your company file before completing any maintenance tasks. For instructions, see: Back up your company file
Task 2 - Use the repair tool:
Before using this tool, make sure you have backed up your company file as described in the previous task.
Complete these steps on the computer where the company file is stored, or has been checked out to:
Click Browse and locate your company file in the My AccountRight Files folder here:
C:\Users\<user.name>\My Documents\MYOB\My AccountRight Files (where is the name of the person currently logged into Windows)
C:\Users\Public\Public Documents\MYOB\My AccountRight files
This should then correct the issue, please note you may need to close and re-open the software in order to see the changes.
Please let me know how you go.
my file is offline.
Contacted MYOB and Alex was able to take my file and run the necessary script to resolve the issue as you described.