Just upgrading from JIWA6 to JIWA7 and come across a few items that we use in 6 that are no longer there.
Previously using "manage breakouts" we had a custom search installed so we were able to search using the Cash Sale Company name as below
SELECT SO_CashSale.Company, SO_Main.InvoiceID, SO_Main.InvoiceInitDate, SO_Main.InvoiceNo, DB_Main.AccountNo, DB_Main.Name
FROM SO_Main
JOIN DB_Main ON SO_Main.DebtorID = DB_Main.DebtorID
JOIN SO_CashSale ON SO_CashSale.InvoiceID = SO_Main.InvoiceID
ORDER BY SO_CashSale.Company DESC
Being a little bit new to all this I have modified the SQL usp_JIWA_SearchItem_SalesOrder to suit as below;
UNION
SELECT SO_Main.InvoiceID [SourceID], 'Sales Order' [SourceType], SO_Main.InvoiceNo [SourceDocumentNo], IN_Physical.Description [PhysicalWarehouse], IN_Logical.Description [LogicalWarehouse], 'Cash Sale Company' [MatchedOn], SO_CashSale.Company [MatchValue], CASE SO_Main.InvoiceType WHEN 0 THEN 'JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm' ELSE 'JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.BackToBackSalesOrderEntryForm' END [SY_Forms_ClassName]
FROM SO_Main
JOIN SO_CashSale ON SO_CashSale.InvoiceID = SO_Main.InvoiceID
JOIN IN_Logical ON IN_Logical.IN_LogicalID = SO_Main.IN_LogicalID
JOIN IN_Physical ON IN_Physical.IN_PhysicalID = IN_Logical.IN_PhysicalID
WHERE SO_CashSale.Company LIKE '%' + @SearchTerm + '%'
I had believed this would insert the new search line but was unsuccessful. How do i go about getting the search to appear in the search drop down for Sales Orders?
Currently not playing with live data as we are still live with JIWA6 but trying to get everything into JIWA7 prior to converting over.
Any help appreciated.