Customers with no transaction in last 2 years

[svartak]

Dear Friends,

Can somebody tell me the easiest way of getting the list of those customers which does not have any transactions for last 2 years.

 

[lawrence_janes]

Hi svartak

Have a look in the F03012 - Customer Master

Field AIDLIJ - Date Last Invoice
Field AIDLP - Date Last Paid

I recommend running some test over these fields to ensure the data is correct prior to reporting any findings

Regards

 

[Mike Dupaix]

Look at the last invoice date on the customer master record

svartak <[email protected]> wroteear Friends,Can somebody tell me the easiest way of getting the list of those customers which does not have any transactions for last 2 years.
--------------------------
To view this thread, go to: http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=Apps&Number=66631

This is the JDELIST Applications Mailing List. To stop receiving these messages, login to http://www.jdelist.com/forums, click Control Panel, then click Edit by "Subscribe / Unsubscribe from receiving board posts by email, change message notifications, etc." and adjust your subscription preferences. JDEList is not affiliated with JDEdwards®


---------------------------------
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes


World, OW B733X and Xe