Get the sum amount of each Source No.

vandang

Hi Experts,

My report is totally different from the standard - all content is shown in integer dataitem part so I can't take the advantage from NAV report.

My target is step by step as following:
- Date filter in Chart of Accounts
- Go to Balance at date
- filter by each source no.
- sum amount for each source no.

I just confuse about the step how to input the source no. to the SETRANGE? I will write some code and need your help to complete, thanks!

vijay_g

Why don't you use GL entry table and group data by source no.?

vandang

Thanks vijay_g,

You got my idea correctly!So you mean that using calcsum function for this point?

Best Regards,

faizguy84

No need for calsums....Use GL entry as dataitem.
In group total field use Source no.
Total fields :-Amount
Make sure u have key with Source no.


_________________________________
Regards,
Faisal Bukhari