[OpenVPMS Developers] [JIRA] (OVPMS-1117) Link payment to invoice so invoice can display the paid amount
Link payment to invoice so invoice can display the paid amount --------------------------------------------------------------
Key: OVPMS-1117 URL: https://openvpms.atlassian.net/browse/OVPMS-1117 Project: VPMS Web Application Issue Type: Improvement Components: Financial Affects Versions: 1.5 Reporter: Tim Anderson Assignee: Tony De Keizer Priority: Minor
(Originally From http://www.openvpms.org/forum/bug-calculating-allocatedamount-invoices )
The invoice allocatedAmount node is currently being used in the invoice jasper report to display the amount paid. This is not the same as the paid amount, as it represents how much of the invoice has been allocated by other credits. As Paul says: {quote} To reproduce, I do a credit adjustment (or credit) to a customer account (say $20), formulate an invoice (say $200), and then process a payment ($180). At this point, the $\{allocatedAmount} field in invoice.jrxml is coming through as $200. We've had a couple customers complain that they didn't get their discount, or had to pay the full amount. Usually showing them the receipt calms them down, but the invoice should probably reflect the actual payment here. {quote}
This could be worked around by introducing a relationship between payments and the invoice. This way, the paid amount can be determined by summing each of the payment totals.
-- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://openvpms.atlassian.net/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________ OpenVPMS Developers Mailing List developers@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/developers Posts from this mailing list can be viewed online and replied to in the OpenVPMS Developer's forum- http://tinyurl.com/openvdf
Re: [OpenVPMS Developers] [JIRA] (OVPMS-1117) Link payment ...
Linking payments with Invoices is extrodinarily difficult IMo, there is too many variables to consider.
EG.
How do you allocate a 2 partial payments, for 3 invoices.
EG.
How do you deal with cases where a client recieves a credit and leaves it on the account for months.
The problem is its a many to many association.
I would have thought that a better solution would be to offer the ability to print a ministatement instead of an invoice. at the invoice printing interface. You could simply set the statement to print only items generated that day. Carry a balance forward from credits or other invoices outstanding and show new invoices +/- items then show payments which each line containing a seperate payment. This would ensure clients could see the payments made (and the type).
I'm not sure if this is harder or easier...but its a suggestion