Thank you for sharing the requirements. Below is the proposed solution for cheque handling in Business Central.
Note: I am Certified in BC.(5 Certificates), and a lot of AL coding
When a cheque is received, the customer's account will be credited, and the Non-Return (NR) account will be debited. Upon sending the cheque to the bank for collection, the NR account will be credited, and the Checks under the Collection account debited. Once the cheque is successfully collected, the Bank account will be debited, and the Checks under the Collection account credited.
If the bank rejects the cheque, the amount will be returned to the customer's balance by debiting the customer account and crediting the Checks under the Collection account. All cheque details will be registered at the time of receipt, with subsequent transactions linked to the original cheque to ensure traceability and accuracy. This approach ensures compliance, clear transaction records, and effective reconciliation.