Customer form invoices section displays refunds as positive number, which results in incorrect total in v7?
When we create customer invoices, we create through Accounting -> Customer Invoices. Likewise with refunds, Accounting -> Customer Refunds. When we process payments, we use Accounting -> Customer Payments.
Now, when going to Sales -> Customers -> [Customer] -> More -> Invoices, we get a list view of the customer invoices and refunds all on a single screen. This is great, however, the positives recorded in the Refund are shown on this screen. The Refund forms are correctly debiting from payments and such but on this screen, they're shown as positives.
So for example, I create a Customer Invoices for $500.00
I create a Customer Refund for $150.00
When I go to make payments, everything works out correctly and the customer only owes $350.00.
When I go to Sales -> Customers -> [Customer] -> More -> Invoices the total now reads $500.00 + $150.00 for $650.00. What am I doing wrong here?
We will never add customer invoice and customer refund to get the customer balance. Customer balance is the difference of customer invoice and customer refund. We can never enter negative value as this value is going to journal entry. In customer refunds, the accounting entry is reverese of invoice entry. ie, on customer invoice validation we will debit customer account where as in customer refunds, customer account is credited. Custome balance is the total debit - total credit in that customer account.
It isn't anything you are doing - this is just the way that view works.
It isn't accurate to have a total that doesn't take into account the negative nature of refunds, so the view is really misleading.
I usually add a group by type and make that the default, so that you can see the total of both regular invoices and refund invoices. The grand total is still wrong and not corrected by the group by, so you still need to educate users about what it is showing.
If you do this I would suggest also installing https://www.odoo.com/apps/7.0/web_group_expand/
You could do this now by way of an add-on that provides the corresponding invoice functions and overrides the existing "invoice_tree" columns via xpath replace.
The current sum at the bottom is so useless, even hiding it would be an improvement.
see also https://bugs.launchpad.net/openobject-addons/+bug/1104139
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/13/14, 3:21 PM|
|Seen: 1276 times|
|Last updated: 12/13/15, 4:45 AM|