REPORT- The Posting Date on the Sales Header should be automatically shown on the Sales Invoice Header

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, No. and Customer No…

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

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…

What’s you data item structure look like?

Sounds like you are trying to get a report that shows daily posted and non posted sales.

Have you looked at the " getfilters" function?

Thanks

I have tried the GETFILTERS but it is not coming up on the ReqFilterFields.

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

Did you try below code in Sales Invoice Header - OnPreDataItem()

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

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

Please help.
Thanks.

Can you be more clear on what did you try?