select sales and sales return with quarterwise

[Anonymous]

hi guys,

please help me out to solve this scenario actual i stuck to find out the sales and sales return with quater wise after select invoice id .actual scenariois that  sales is different date with same invoice and return is different date with same invoice in different table.

But i want to  click quarter its show sales of quarter and then i click on invoice id in straight table  sales return under this quarter for a particular  invoice id. and second condition click only invoice id in sales table and its show sales return for a particular invoice id overall in different stright table.

[sushil353]

please explain your issue with example...

Your issue is not clear.

HTh

Sushil

[Anonymous]

1) i want sales and sales return in different table under selected quarter with invoice id wise.e.g  first i click quarter

so it's show sales table with invoice id and sales return table under same quarter in different table.

2)sales and sales return in different table invoice id wise which  means i click invoice id from sales straight table so it's show the sales return for that invoice id in different table.

[kaushiknsolanki]

Dear Faizan,

     Have a look at the attached files.

     Hope this is what you want.

Regards,

Kaushik Solanki

[Anonymous]

hi kaushik,

thanks for your reply actualy i want to click on quarter 1 its show the data related only quarter 1 means jan,feb mar and quarter 2 apr,may,june but its showing all if i click q1 its show mar,apr data ,but both of them belong to different quarter.

[kaushiknsolanki]

Hi,

     Kindly check the application i have posted in earlier post. It is showing same as you want.

Regards,

Kaushik Solanki

[Anonymous]

Thanks Kaushik it's work fine,problem in data format that's why its not showing right information.

your solution is perfect it's realy helpful to me.

[kaushiknsolanki · Accepted solution]

Hi,

     If its working, kindly close the post.

Regards,

Kaushik Solanki