error loading enquiry screen

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.

No, there isn't any DO table and the error just looks like this

It looks like you are using an older version of GP. What version are you on? Have you created a Dexsql.log?

It is version 8, I haven't created a DexSQLLog, I will look into that, thanks

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.

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?

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, 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?

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.

Regards,

Santosh