Hi Guys,

I want to a make a custom report similar to the Sales (Detail) report that's standard on OE. I simply want to show the line items for each invoiced order that it shows. I have the report how I want it and it works well EXCEPT that I'm not sure how to select the records like the standard report does.

It seems that it only selects the invoiced orders from the current open month (all closed months are ignored). What field in what table tells me what the open month is so I can make a selection formula to do such a thing.

Please let me know if I haven't been clear enough on my request.

thanks!
Lucas