We give discount to our dealers on the face of invoice through payment terms e.g 2 % 14 days. Our branch accountant if gets payment against the invoice within due date lets say 14 days as here will clear his invoice with discount given to him in F-32. Hence it is done upon realization of payment. Problem is this creates problem in reconciliation with customers. We want that invoice should be created net of discount. Mean an invoice of 10000 should now be created as 9800 with 2 % 14 days payment term attached. The check we want is if customer does not pay within 14 days the system should automatically generate a debit note against the customer which should be equal to the amount given as discount to him earlier at the time invoice was created. How can we achieve this automatic debit note creation functionality with reference to the invoice.
Expert's suggestions are awaited.