Kat_Beeton
Experienced Cover User
Joined 8 years ago
User Profile
User Widgets
Contributions
SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException
Hi, Trying to record a journal entry for a purchase dated 18/08/2022. When i hit Record it keeps throwing an error message... Code: SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException Message: An exception was caught during the execution of an action query: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception. 30minute wait time when i call MYOB, didn't have time to wait. Can someone at MYOB look at this for me. Anyone else having the same issue??527Views0likes4CommentsRe: Receivables out of balance, but no transactions in the ledger on the day it goes out of balance...
Hi Neil_M Thanks for your reply. I tried clearing the cache, but it didn't fix this error.Does it matter that this file is in the cloud and i access it from 2 different computers? I tried clearing the cache on both computers. I'm pretty sure it's a 'glitch'. the balance sheet figure for debtors as at the day it goes out of balance is different from the debtors balance when i run a general ledger detail for that same date. any other ideas on how to clear it?1.2KViews0likes4CommentsReceivables out of balance, but no transactions in the ledger on the day it goes out of balance...
Hi, My receivables go out of balance on 1/1/20, but when i look for transactions on this day in the general ledger, there aren't any. When i pull up a 'jounal security audit' report for transactions dated 1/1/20, there are sales that were originally dated 1/1/20, but i've subsequently changed the date on those sales. Could this be causing a glitch in my file? I phoned MYOB 7/7/20, spoke to 'Ranjula'? who couldn't help & was organising a call back for me from someone who could help, but i haven't heard back yet.Solved1.2KViews0likes6Comments