37

Our client needs the capability to settle multiple invoices within one journal line (they’ll receive a remittance for multiple invoices on one check). Deductions are applied and the user reduces the total credit amount/short pay for the first line (Original credit: $1,344.00 - $15 deduction - $10 deduction = $1,319.00).


The deductions are applied to different invoices (root of the issue), but these are still invoices that are marked within the settlement.


Upon posting the customer payment journal, the deduction workbench is populated correctly:


The issue is within open AR. The deduction for $15 in this case settles correctly, but the deduction for $10 now has a negative balance while its invoice has the offset balance. While the user can settle these transactions against each other, this should have been completed upon posting the customer payment journal. Dealing with hundreds of lines of deductions in some cases my client will not accept this extra step.


Only one of the deductions is being settled each time, but I have not been able to see why within the system.

 

I ran through the process with 3 deductions on the payment journal, and in that case it leaves two deductions with a negative balance in open AR. So in every case it only processes one deduction correctly by fully settling it, and leaves any extras in open AR.

STATUS DETAILS
Needs Votes
Ideas Administrator

Thanks for creating this Idea. The request is understood. We do not have plans at present to extend our current support, but we will monitor how much in demand such support is. 

Comments

W

Setting the amount to settle for each invoice will allow all deductions to be settled automatically. However, this adds additional time and chance for user error during the process. Another workaround is to not settle the payment and deductions until after posting, but this also adds more time and chance for user error.

Category: Sales and marketing