Hi All,
I wanted to create a saved search which shows the invoice been generated month wise and also show the information about the payment ,based on this am doing some operation like is it partially paid , fully paid or not paid on the same month.
I have got the information about Invoice,Payment number and Invoice total amount.
But couldn't get the correct value for the Payment amount related to Payment Number.
What I have done till now?
If I use the Paying amount field ,am getting the correct value but with the payment number it's duplicating the records as below.
Related Information in the Invoice for INV786-703
I have also tried with the Applying Transaction : Amount with this for many of the invoices getting the total payment amount instead of the payment done the related invoice
The related payment information for the invoice 786-26077 is as follows:
Any suggestion / way to resolve this would be really helpful.
Thanks in advance
Chandanesh