Any customers using the SedonaX mobile app should not use the Document_Type_ID of ‘8’ in the SY_Document_Type table of the SedonaDocuments database. For some reason, this is hard coded in the app to ignore that document type.
If you have a customer reporting not seeing one of their types of documents in the SedonaX mobile app, if you look in the SY_Document_Type table, you will likely find that one has the SY_Document_Type of 8.
For customers experiencing an issue with this, the easiest fix is to update the “8” to “N/A” in the database; add a new entry to SY_Document_Type with the same label as the document type they are having issues with; and then update all documents with Document_Type_Id of 8 to that new Document_Type_ID in the following tables in SedonaDocuments database:
update d set document_type_id = x FROM [dbo].[AP_Vendor_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[AR_Customer_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[AR_Deposit_Check_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[IN_Part_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[SM_Prospect_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[SS_General_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[SV_Service_Ticket_Documents] d WHERE Document_type_Id = 8;
update d set document_type_id = x FROM [dbo].[SY_Employee_Documents] d WHERE Document_type_Id = 8;
