A repport for sales 2

[TheKnee]

I need to print out the paiment detail for a specific customer.... somebody know something about this

 

[Luvsql]

Would you like to just print a list of all payments for a customer or do you need to know each invoice that each payment is applied to? If it's just a quick list of payments, you can use Smartlist (doctype=payments, void status=normal, Customer Number=).

 

[TheKnee]

I need to know each payment is applied to.... i working to build a query in access to get a report after that.... i cant find the right table ( im still searching)

 

[Luvsql]

SELECT CUSTNMBR, APTODCNM, APTODCTY, APPTOAMT, APFRDCNM, APFRDCTY, APFRDCDT, APFRMAPLYAMT
FROM RM20201
union all
SELECT CUSTNMBR, APTODCNM, APTODCTY, APPTOAMT, APFRDCNM, APFRDCTY, APFRDCDT, APFRMAPLYAMT
FROM RM30201