Customer Orders Query > add another Primary Criteria option

On the Customer Orders Query form, we want to add another row under Primary Criteria for "Due Date". This is a field already in the SLCos table and I have added it as a DateCombo (see print screen). What I don't know is what I need to bind this to and how to change the query so that it looks at this field as well? Any help is appreciated.

Find more posts tagged with

General Discussions

Accepted answers

All comments

unknown

Anyone have any thoughts on this?

Stephen Cena

What's the actual SQL table the due date is located in? I didn't see a due date in co_mst.

unknown

I have never been able to modify those forms. I have always built a new one to include the new field as one of the primary search fields and create a site version of the (in this case CoNum) Property Class to have the right-click point to the new form. I believe it has something to do with how the filter is being constructed behind the scenes and I don't know of a UI tool that lets you edit the filter.

unknown

I kind of figured out that it would be easier to just create this form using the Wizard and choosing the form type "Query". I have now gotten everything that I wanted with the exception of one thing. I want to be able to right click on the Order number in the Results grid and click "Details" to go directly to that order. I know I have done this before on another form but I cannot remember what I did to make this work.

unknown

This is a custom field. Our business model does not allow individual items on an order to have a due date different from the Order Due Date.

Copyright © 2025 Infor. All rights reserved.