Report Set Posting Date Filter

nikeman77

Hi guys,

I would like to create a report that has a posting date filter range (eg: 010111..310111) this part is fine.

The tricky part is on another column i would like to view the value past year similar time(eg: 010110.. 310110)

Anyone care to share how to go about it?

Belias

write this after applying the filter on posting date

previousyearstartdate := calcdate('<-1Y>',GETRANGEMIN("posting date"));
previousyearenddate := calcdate('<-1Y>',GETRANGEMAX("posting date"));
setrange("other field",previousyearstartdate,previousyearenddate);

...not tested, but it should work

nikeman77

Hi Belias,

I realized the need to set group further by customer code as well.

In a nut cell, this report ought to reflect Salesperson earnings (presumably from Cust. Ledger Entry. Amount) for year indicated by user compare with similar date one year ago, group by customer.

End of the Report for each salesperson, it ought to calculate the total earnings of salesperson for this year (Eg: 01-08-07 to 31-08-07 AND 01-08-06 to 31-08-06).

For earnings the field to take from can I check should be Amount and Table: Cust. Ledger Entry, Document: Invoice ?

JDI

Belias

take a look at report 114, those values are probably what you need, but ask confirmation to your Project Manager

nikeman77

Ok, thank you

nikeman77

By the way some 'funny' thing happening,
on my second data item, Cust. Ledge Entry> Group Footer,
I manage to group all customers by Salesperson within a posting date,
what happen was the sales (LCY) is not appearing even though on the
Cust. Ledger Entry Data Item Pre Data Item, I inserted CurrReport.CreateTotals(Sales (LCY))