I have a supplier and I have a large number of bills from this supplier each month. Some of these bills are paid in full and some are partially paid over a number of instalments. By practice, I make one payment a month. When I make the payment, I identify the bills I want to pay and the amount I want to pay against each Bill - either to clear the bill or make a partial payment.
That's all fine and the payment transaction screen shows the total original amount of the bill and the amount that I am paying
My issue is the Bills and Payments report which shows the paid amount and underneath the bills that payment was applied to. However, the amount shown for the bill is the original invoice amount, not the amount paid off the bill. So for example I have a payment of 20,000 but the Bill amounts - which are showing the original Bill amount, not the amount applied - could total 150,000
Under any accounting basis, I would expect the Bill amounts shown to total to the Payment amount.
I want to use this report to reconcile with my supplier - but I can't get the information without manually going in and checking and writing down each payment and bill one by one
Support advice was to contact the feedback team and to date have been unable to provide a work around. So I reaching out here to see if anyone could provide some help. Or if this is posted in the wrong forum, could you suggest where best to post this to help me resolve this.
Many thanks
