A customer was paying a partial invoice within the terms of the sales order, so we gave the customer the sales discount only on the part they paid leaving the rest of the balance open. A while later when the customer paid the remaining balance of the invoice, they took another partial deduction due to a promotion and we keep a separate GL account for promotions so we can't book it as sales discount. The alternative is to book the promotion by creating a credit memo and apply it to that invoice. What should happen when we do that in the distribution of the credit memo is debit the promotion account, credit accounts receivable for the remaining balance. However, in our system its creating a credit to sales discount for the terms, credit accounts receivable for the remaining balance of the invoice minus the credit of the terms and debit to promotions account. It is doing so thinking that we applied the full terms discount available in the original sales order.
When we manually change the distribution it would not allow us to post, stating that the distributions do not match, even though debits and credits are equal.
Any advise on how we can set the system to track how much terms discount was actually applied and it should not base it on what was available on the sales order?
*This post is locked for comments