Hi Ahmed,
There are a few ways to do this.
One way is to make a plugin which adds a form showing which orders are Magento orders - we can identify those because the sales order in Jiwa has a custom field "magento_increment_id" which links it to the Magento order - so any orders which there value is not null or blank are a Magento sourced order.
Another way is to make a sales order search filter, showing the same orders.
The filter query would be:
- Code: Select all
SO_Main.InvoiceID IN (SELECT InvoiceID FROM SO_CustomSettingValues WHERE SettingID IN (SELECT SettingID FROM SO_CustomSetting WHERE SettingName = 'magento_increment_id'))
To show how to do this, load the sales order form in Jiwa, press the search button to load the search dialog, then select the edit filters button:
- Add Magento Filter
Then when searching, you can select the newly added filter:
- Filter Selection