How do I capture a payment date when confirming payment?
My system is set up with Bank transfer and Cheque payment methods i.e. a user is allowed to check out their order and then make payment at a later stage. We then scan through the bank account to check for incoming payments. When we come across the payment in the statement we head over to DC and confirm the relevant payment transaction.
The problem is that there is no standard field to enter/edit a payment date which creates a few problems:
1. It is very difficult to reconcile payment transactions back to bank statements because the payment transaction dates differ.
2. The user might have checked out the order on 1 Feb, payment cleared on 7 Feb and we finally confirm on 23 Feb. In this case the actual date we received payment (7 Feb) is not reflected in DC!
From my perspective it would be ideal to allow the capture of a payment date when confirming the payment transaction but maybe there are other better DC ways?