Problem:

Customers can pay for goods using multiple payment methods, such as cards, cash and gift cards. A Business Central sales invoice can only have one payment method; this requires using payment priorities to allocate the most appropriate payment type to a sales order. If you are set up a payment method with a Bal. Account Type and Bal. Account No., a problem occurs with reconciliation.

Solution:

Continue to allocate the payment method based on priority and if the payment method has a Bal. Account Type and Bal. Account No. create a payment balancing entry for each payment method.

For example, a customer purchases £100 of goods and pays using gift cards, £50, and credit cards, £50. Two balancing payment entries are generated, one using the gift card Bal. Account No. for £50 and one for the credit card Bal. Account No. for £50.