You execute a payment run of Receivables. On one of the payment proposals, the cash discount of the open items are not calculated automatically even though Payment Term, for example, 10 days 2% cash discount, 20 days net ( which means the buyer must pay within 20 days but receives 2% discount if he pays within 10 days from the invoice date), is assigned to these open invoices. You are sure that the payment date for this payment proposal is within 10 days from at least some invoice dates.
Reproducing the Issue
- Go to the Receivables work center.
- Go to the Automatic Payments view.
- Show All Payment Proposals.
- Select the Payment ID XYZ, and choose Edit.
- Under the General tab, you can see the Cash Discount is zero.
- Check the Payment Date, and you can see it's within 10 days from the invoice dates of some invoices in the Open Items list.
The issue lies on Customer Invoicing side. On the item level of the customer invoice, there is a check box option called Cash Discount. If Cash Discount is checked, a discount is allowed for the item. If it is not checked, no discount is allowed on the item.
Therefore if the check box on the item level is not checked, no possible cash discount will be considered even if the payment terms conditions suggest a potential discount if the invoice is paid within the timeframe defined in the payment terms.
To have the possible discount from the payment terms conditions to be visible as Cash Discount on the payment proposal, the check box Cash Discount on the item level in the customer invoice needs to be flagged.
As it is not possible to alter an already posted customer invoice, you have to cancel the existing invoice and create a new one with the check box flagged. If the invoice refers to a purchase order, cancelling the invoice will make the purchase order available to be invoice again in the Item to Be Invoiced view within the Customer Invoicing work center.
KBA , automatic payment , payment run receivables , payment term cash discount , SRD-FIN-ACR , Receivables , How To