Forum

I want to create a condition like WHERE SalesOrder.Date BETWEEN &BeginOfPeriod AND &EndOfPeriod. How can I ensure that if the period is null or undefined (i.e., if the "Sales Order Period" filter is unchecked), all sales order data is retrieved?

Dear Ahmad,

unfortunately, you have no control over this.

Imagine that your "Date" attribute is empty, and you set a filter for 2024, for example. Of course, you will not receive this document with such a filter.

To avoid such a situation, it is necessary to control that the "Date" attribute is always filled in when creating and posting a document. Then everything will be fine in the reports.

Besides, you want to use a filter on the "SalesOrder.Date" attribute - as far as I know, it is always filled in. Well, except for cases when some changes were made to the program...