Document Period Report Filtering

The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Oct 16, 2024
Company:

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?

 
#2
People who like this:0Yes/0No
Administrator
Rating: 32
Joined: Oct 3, 2019
Company:

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... :)

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.