I am putting a report together that mimics a spreadsheet we already do by hand. The smart list for cash receipts comes close, but still need a few columns.
So.. in crystal report I am using RM20101, RM30202 and RM00101. The two fields that I am missing are the field that contains whether that payment was by cash/check or Credit card. And the Customers Check number or Credit Card id from the payment record. What tables would these be in?
Basic layout is:
Customer, PaymentID, Applied Invoice, Paidby<Cash/Check/CC>, Check/CC#, AmountApplied
I am so close This will save our clerks alot of extra copy/pasting to and from excel when I am done
Please note this report will be processing at the end of the day AFTER the Final Cash Receipt batch is posted.
Thanks for any assistance
Julie
CR 9,10 CE10 Sql DB
So.. in crystal report I am using RM20101, RM30202 and RM00101. The two fields that I am missing are the field that contains whether that payment was by cash/check or Credit card. And the Customers Check number or Credit Card id from the payment record. What tables would these be in?
Basic layout is:
Customer, PaymentID, Applied Invoice, Paidby<Cash/Check/CC>, Check/CC#, AmountApplied
I am so close This will save our clerks alot of extra copy/pasting to and from excel when I am done
Please note this report will be processing at the end of the day AFTER the Final Cash Receipt batch is posted.
Thanks for any assistance
Julie
CR 9,10 CE10 Sql DB