REPORT-Posting Date on the Sales Header

liizz

Hi all,

I have a report based on Sales Header, Sales Line , Sales Invoice Header and Sales Invoice Line dataitems.

And for both I have set ReqFilterFields: Posting Date.

Upon running the report, I have input Posting Date: 31/03/2012 on the Sales Header dataitem.

The requirement is as such: The Posting Date on the Sales Header should be automatically shown on the Sales Invoice Header too.

Please help.

Thanks

Liizz

mohana_cse06

You can make it use in Sales Invoice Header filter via code but you cannot show it in ReqFilerField Posting Date of Sales invoice Header..

liizz

Mohana, I have spoken to client abt this issue, they are ok if it do not on the ReqFilterField but the filtering should apply on the Sales Invoice Header.

This is my piece of code, it's not working:
Sales Invoice Header - OnPreDataItem()

RecSalesInvHdr.COPYFILTER("No.",RecSalesHeader."No.");
IF RecSalesInvHdr.FINDSET THEN
REPEAT
"No.":=RecSalesHeader."No.";
UNTIL RecSalesInvHdr.NEXT=0;

Grateful if you can help me solve it out.

Thanks

Liizz

mohana_cse06

Try below code in Sales Invoice Header - OnPreDataItem()

"Sales Invoice Header".SETFILTER("Posting Date","Sales Header".GETFILTER("Posting Date"));

liizz

Mohana,
I have used your codes but the filtering is not being applied on the Sales Invoice Header.

Please help.
Thanks.

mohana_cse06

Can you explain the steps what did you write and where?

Did you give any filter on Sales Header Posting date?

liizz

mohana_cse06 wrote:

"Sales Invoice Header".SETFILTER("Posting Date","Sales Header".GETFILTER("Posting Date"));

I have placed this code in the Sales Invoice Header- On PreDataItem()

When I run the report on the Sales Header tab, I input date 03/11/10 and I did not put any date on the Sales Invoice Header tab. Then I choose Print to Excel. Also, I have created 2 worksheets-one for Sales Header and Sales Invoice Header

But when the report is being generated, only the date criteria for the Sales Header works actually. And for the Sales Invoice Header, it gives me all the data.

Please help.
Thanks.

mohana_cse06

I have created a simple report with Sales Header and Sales Invoice Header..(simple preview report not export to excel..)
tried with the above code and data is filtered correctly..

Are you using same Sales Invoice Header variable for export to excel or created global variable?

liizz

Mohana,

I find my mistake, I have created a global variable for the setfilter codes and on the excel I was using the Sales Invoice Header variable.

It works now.

Thanks
=D>

mohana_cse06

Welcome