report generation for customer last invoice

suri

hi good morning one and all
i want to generate a last invoice for every customer ,
can any one can give me suggestion please
thanks

mohana_cse06

Sort the Customer Ledget Entries on Document Type,Customer No.,Posting Date
Put filter on Cust. Ledger Entry with Customer No. and Document Type as Invoice and find the Last Entry

suri

ya mohana thanks for giving reply
from my table customer ledger entry
i am getting document type =invoice and customer number and posting date

but with customer number and posting date
customer number posting date
10000 1/1/12
10000 2/1/12
10000 3/1/12

with same customer number i am having three differant dates ,how can we get last posting date
i kept filter like this
WHERE(Document Type=FILTER(Invoice))

i have to write the code?

mohana_cse06

mohana_cse06 wrote:

find the Last Entry

Yes, you have to use FINDLAST

suri

ya mohana thanks for giving reply
i have written this code
postingdate :="Cust. Ledger Entry".GETRANGEMAX("Cust. Ledger Entry"."Posting Date");
i have assigned this postingdate variable to the text box source expression
but it was throwing an error regarding set filter for customer ledger entry table

pawanp

To use GETMAXRANGE function you need to first apply filter to that field. See here

To get the last invoice for the customer use FINDLAST as mohana has advised