
When taking a payment on account with a credit card it doesn't show up in the EDC report with a register number. I can see in the payment table that register is not an option. Has anyone been able to do a join statement to show payments with register number, cashier name and payment number in the EDC report? Any help is appreciated.
*This post is locked for comments
I have the same question (0)Hello Sammysue,
Thank you for your post.
I tested this issue on my end and I see what you are referring to. I do not have a SQL statement that would join this information. I would suggested the following options.
1. Create a service request to see whether we can add this information to the report.
2. Run the tender summary report.
I look forward to your response.
Thanks,
Nicole