Finally done salesman wise outstanding report

Thanks to all members
Finally done my Salesman wise outstanding full report

 

Due only


On account value

 

Yes
Check
Speed of this report with 300+ entries.

This report normally opens in a few seconds.

Not crash, not giving any error

 

Very Very Good Report

 

Please Checked 2500 + Entries

 

Hi Mr Hems,

I am Also create a module for builder & developers & filter the data as per colony wise & broker wise both. Can you help me to Sort this report as per (Sales Man) in my report Broker wise.
Can you provide me a sample code for sorting the report thru button.

Awaiting for your valuable replay. Screen Shoot is att.

Mani

 

Dear sir
Thanks to all of you
I learned a little from the comments and suggestions of all members on this platform:

Dear Sir

I have not created a custom udf for the salesman. The name of the salesman is written in other reference field during sales entry only.

I have fetched basicorderef in sales voucher collection.

And in my report, i have added option to the sales voucher collection and sorted it by variable using button.


Image attached

 

On account value
Comes in my report

 

Aap kya kehna chahte hain

Mai samjha nhi.

Please describe in hindi with example

 

Perhaps
it's whatever you want to say

 

In receipt voucher collection
Use parm var for variable svtodate

 

In my report
For pending amount calculation

Set as : #billamountfield-#totalrecfield-#discountfield

Simple

 

Aap bill se related collection use kar rahe hain.

Jaise sohail bhai ne kiya hai.

Yhi code pura use kar ke dekhiye.

 

please send me code mkraju_mst@rediffmail.com