935
Hi All
I currently have an issue when trying to load the Cashbook's Deposit Enquiry / Void screen. I received an error 'Error loading enquiry screen'.
I have tried turning off access to the form and back on again but this hasn't fixed the problem.
I am not sure where else to look.
Regards
Charles
*This post is locked for comments
Hi,
Can you check, is thete any junk or orphen record in Cashbook's Deposit table. Please take backup of company database before making any table level changes.
You can check following tables data.
| CM10100 |
| CM10101 |
| CM20400 |
| CM20400 |
| CM20100 |
| CM20300 |
| CM20501 |
| CM20500 |
| CM20200 |
| CM20201 |
| CM20600 |
Regards,
Santosh
Ok, narrowed it down to where the error message is coming from it is coming up on the line.
'CB_Load of form CB_Recon_Cash_Receipts', "", "", table 'CB_Recon_Deposit_HDR', table 'CB_Recon_Deposit_TRN', table 'CB_History_Deposit_HDR', table 'CB_History_Deposit_TRN'
I was wondering whether anyone knows where I can find the source code for the Cashbook dictionary, it doesn't seem to be available with the Sourcecode program?
Here is the snippet of the results from the Dex log.
I can't see where it is making the warning message display on the screen, if somebody could help me out that would be great.
14:30:46 'Security_Profiler_PRE'
14:30:46 'Security', 1058, 2, 22097, ""
14:30:46 'Security_Profiler_PRE()', 0, 1058, 2, 22097, "", 1
14:30:46 'Security()', 0, 1058, 2, 22097, "", 1
14:30:46 'isDynUtils() of form LibSystem', 0
14:30:46 'ExcludedFromSecurity() of form sySecurityTaskEntry', 0, 1058, 22097, 2
14:30:46 'PA_ExcludedFromSecurity()', 0, 1058, 22097, 2
14:30:46 'FA_TRIGGER_AFTER_ExcludeFromSecurity()', 0, 1058, 22097, 2
14:30:46 'svcExcludedFromSecurity()', 0, 1058, 22097, 2
14:30:46 'ASI_ExcludeFromSecurity()', 0, 1058, 22097, 2
14:30:46 'BAS_TRIGGER_SecurityForWindows()', 0, 1058, 22097, 2
14:30:46 'MBS_Exclude_From_Security()', 0, 1058, 22097, 2
14:30:46 'GetAlternateModifiedSettings', 1058, 2, 22097, 1058, 0
14:30:46 'Create() of form sySecurityUserModAlt', 0, 0-, table 'sySecurityAssignUserModAlt', "", 0, 0
14:30:46 'ClearRange of form sySecurityUserModAlt', 1-
14:30:46 'SetIndex of form sySecurityUserModAlt', 1-, "sa", -1
14:30:46 'Get() of form sySecurityUserModAlt', 0, 1-, 25
14:30:46 'Get() of form TableObj', 0, 1-, table 'sySecurityAssignUserModAlt', 25
14:30:46 'GetSecurityModAltFormsID() of form sySecurityUserModAlt', "", 1-
14:30:46 'Release of form sySecurityUserModAlt', 1-
14:30:46 'Destroy of form sySecurityUserModAlt', 1-
14:30:46 'Create() of form sySecurityModAltOperations', 0, 0-, table 'sySecurityAssignModAltOperations', "", 0, 0, 101, 0
14:30:46 'ClearRange of form sySecurityModAltOperations', 1-
14:30:46 'SetIndex of form sySecurityModAltOperations', 1-, "DEFAULTUSER", 1058, 22097, 2
14:30:46 'Get() of form sySecurityModAltOperations', 0, 1-, 25
14:30:46 'Get() of form TableObj', 0, 1-, table 'sySecurityAssignModAltOperations', 25
14:30:46 'Release of form sySecurityModAltOperations', 1-
14:30:46 'Destroy of form sySecurityModAltOperations', 1-
14:30:46 'Security_Profiler_POST()', 0, 1058, 2, 22097, "", 1
14:30:46 'Security_Dictionary_Control', 0, 1058, 2, 22097, "", 1
14:30:46 'MBS_ScreenShot_Save_Form', 1058, 2, 22097, ""
14:30:46 'Pathname', 5261, 7, 0, ""
14:30:46 '[481] on form [-50]', script 'CB_Check_GL_Batch_Post_Ok', 0, 0
14:30:46 'iifi()', 0, 0, 22097, 0
14:30:46 'MBS_CompanySettings_Save_Form', 1058, 2, 22097, ""
14:30:46 'SQLPath', 1058, 1, 22000, ""
14:30:46 'CB_Cash_Payments_FORM_PRE on form CB_Recon_Cash_Receipts'
14:30:46 'CreateWindowNote of form [717]', -
14:30:46 'GetWindowNoteAndSetIcon of form [717]', -, "CB_Cash_Receipts", "Deposit Enquiry / Void", Note Absent Button -
Toolbar, Note Present Button - Toolbar
14:30:46 'SetWindowNoteIndex of form [717]', -, "CB_Cash_Receipts", "Deposit Enquiry / Void"
14:30:46 'GetStatus() of form [717]', 0, CB_Cash_Receipts-
14:30:46 'SQLPath', 1058, 8, 79, ""
14:30:46 'GetWindowNoteStatus() of form [717]', 0, CB_Cash_Receipts-, table 'SY_Notes_MSTR'
14:30:46 'ShowHide of form [717]', CB_Cash_Receipts-, Note Absent Button - Toolbar, Note Present Button - Toolbar
14:30:46 'ASI_NoteObj_GetWindowNoteAndSetIcon', CB_Cash_Receipts-, "CB_Cash_Receipts", "Deposit Enquiry / Void", Note Absent
Button - Toolbar, Note Present Button - Toolbar
14:30:46 'CB_Cash_Receipts_WIN_PRE on form CB_Recon_Cash_Receipts'
14:30:46 'CB_Account_Setup'
14:30:46 'SQLPath', 1058, 8, 65, ""
14:30:46 'SQLPath', 1058, 1, 22000, ""
14:30:46 'SQLPath', 1058, 1, 22000, ""
14:30:46 'SQLPath', 1058, 1, 0, ""
14:30:46 'SQLPath', 1058, 1, 0, ""
14:30:46 'CB_Load of form CB_Recon_Cash_Receipts', "", "", table 'CB_Recon_Deposit_HDR', table 'CB_Recon_Deposit_TRN', table
'CB_History_Deposit_HDR', table 'CB_History_Deposit_TRN'
14:30:48 'Create() of form cbVATWork', 0, 0-, table 'CB_VAT_WORK'
14:30:48 'CB_Cash_Receipts_WIN_ACT on form CB_Recon_Cash_Receipts'
14:30:51 'CB_Cash_Receipts CB_Post_Date_POST on form CB_Recon_Cash_Receipts'
14:30:51 'CB_Cash_Receipts CB_Post_Date_POST on form CB_Recon_Cash_Receipts'
14:30:51 'CB_CloseDepositInquiryDistribution'
14:30:51 'CB_Cash_Receipts_WIN_POST on form CB_Recon_Cash_Receipts'
14:30:51 'IsRangeSet() of form [713]', 0, 1-
14:30:51 'Destroy of form cbVATWork', 1-
14:30:51 'CB_Recon_Cash_Receipts_FORM_POST on form CB_Recon_Cash_Receipts'
14:30:51 'Destroy of form [717]', CB_Cash_Receipts-
14:30:51 'Close of form [717]', CB_Cash_Receipts-
14:30:51 'PRV_UnregisterForm of form [717]', ""
14:30:51 'Destroy of form [717]', -
14:30:51 'Close of form [717]', -
14:30:51 'PRV_UnregisterForm of form [717]', ""
14:30:51 'Destroy of form [717]', -
14:30:51 'Close of form [717]', -
14:30:51 'PRV_UnregisterForm of form [717]', ""
14:30:51 'Destroy of form [717]', -
14:30:51 'Close of form [717]', -
14:30:51 'PRV_UnregisterForm of form [717]', ""
14:30:51 'Destroy of form [717]', -
14:30:51 'Close of form [717]', -
14:30:51 'PRV_UnregisterForm of form [717]', ""
Ok, I have investigated further but still no luck (ie: I have got the Dex log and Dex SQL log to work) and reproduced the error but there is nothing obvivous to me, what should I be looking for specifically?
I have created the DexSQLLog, but the Deposit Enquiry/Void screen wouldn't load (not sure why). As soon as I turn the DexSQLLog off, I get the same error.
It is version 8, I haven't created a DexSQLLog, I will look into that, thanks
It looks like you are using an older version of GP. What version are you on? Have you created a Dexsql.log?
No, there isn't any DO table and the error just looks like this
Is there more information to the error? Does the error have a DO table in it? If so then someone has removed Dynamics Online module from the .set files which caused this issue. We can reinstall the module if this is the case.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (