Customer Last Invoice Issue Date

1

Hi All,

is there any format in Custom Report to get the Customers Last Invoice Issue Date Detail Report, its take too much time to go one by one to check each Customer.

Any Help Appreciated,

Thanks in Advance.

2

What exactly do you mean by Customers Last Invoice Issue Date Detail Report

3

Something like this?

image
image684×619 18.2 KB

image
image674×934 21.3 KB

1 Like
4

@Joe91 Really Thank full to you, Exactly what i want. :+1:

5

Dear @Joe91, One more thing,
Last Received Amount with Date from Customer
by
Custom Report. Thanks

6

So when you tried to create this custom report, how did you go? What part did not work as expect?

More importantly how is your custom report writing skill development going?

7

image
image825×655 9.11 KB

image
image641×575 8.15 KB

@Patch Much Closer, but dont know about Blank Entries :zipper_mouth_face:

8

in this report Invoice is showing also, its not required
and i want last received amount. its showing all transaction in date range

9

Much Much Closer, now how to fix the criteria to Last Receipt Only with wide Date Range
Snaps Attached

image
image960×602 9.72 KB

image
image809×594 9.37 KB

10

I am inclined to think that it is not possible to select only one entry form this list so it is not possible to get what you want

11

:pensive:

12

As date use only last date in from and to date field. You will get the report of one or last days

13

You cannot. Custom Repost is a visual no code semplificarono of SQL. You would need additional SQL comands (ie MAX) and also nested queries to achieve what you want.

14

No way to execute any sql here.
You can do much things in custom report.
Check it.