[Optimum] Some columns (eg. First Created Date,Last Modified Date & etc) in listing unable to do sorting/searching

Created by Cheng Kah Poh, Modified on Thu, 03 Sep 2020 at 03:34 PM by Cheng Kah Poh


Example in the Sales Invoice Listing as below picture, by default First Created Date and Last Modified Date cannot do sorting/searching, so invoice dated 04/11/2018 can appear in the middle of listing.

Description: http://supportsystem.livehelpnow.net/resources/3203/KB_Mak/sorting1.png


Step 1 -  So can go into Customization Center expand QNE Business Solutions>Views

Description: http://supportsystem.livehelpnow.net/resources/3203/KB_Mak/sorting2.png

Step 2 -  Expand QnEBS.BO.Sales

Description: http://supportsystem.livehelpnow.net/resources/3203/KB_Mak/sorting3.png


Step 3 -  Look for SalesInvoices_ListView, change the DataAccessMode to Client

Description: http://supportsystem.livehelpnow.net/resources/3203/KB_Mak/sorting4.png


Step 4 -  After restart QNE Optimum, check in the sales invoice listing it can do sorting now.

Description: http://supportsystem.livehelpnow.net/resources/3203/KB_Mak/sorting5.png

Please Refer KB - How to Access Customization Center


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article