Skip to Content
Menu
This question has been flagged
2 Replies
4688 Views

Our bookkeeper entered wrong amount when entering payment for an invoice.  Our admin unreconciled and entered a new payment. Then unreconciled that and entered another new payment. Unreconcile enters a negative amount in the "Total" column, but enters positive amounts in "Sale Amount" and "Tax" columns. So the totals at the bottom of the list view are too high for "Sale Amount" and "Tax", and too low for "Total". We don't have the accounting module installed. How can we fix these totals amounts? I could post a screen shot, but I don't see where to do that here on this screen.


Avatar
Discard
Author

It's on Dropbox: https://www.dropbox.com/s/dl0i5vy1lz07l9o/Screenshot-1.jpg?dl=0 I've blacked out a few areas. The important thing is that notice how the columns labeled "Sale Amount" and "Tax" have all positive values, whereas the column labeled "Total" has a couple of negative values that were created when the accountant unreconciled invoice 781, created a new invoice 813, and then unreconciled that one. Therefore notice the sums at the bottom. We would prefer Odoo place negative values in the first two column during unreconcile just as it does for the third column. That way the numbers at the bottom would make sense for our purpose. Also notice invoice 1540 appears to not yet have been paid since both times a payment was entered it was subsequently unreconciled. Is there any way for us to accomplish this? We use this screen for tax reporting purposes and it would be better if we did not have to make a note and manually calculate correct sums.

Author Best Answer

I can't see how to do it, but this question has been solved and can be marked as such.

Avatar
Discard
Best Answer

Hi Donald: Which screen are you referring to for the "Sale Amount", "Tax" and "Total" ? The data in the Invoices List view seems ok when I try to simulate your scenario.

Avatar
Discard
Author

It is the screen for Customer Invoices, list view. I have modified the view to remove fields we don't use and to include more fields that we do use. I've included the fields for tax paid, sale amount and total amount. I've also included the invoice status field. At the bottom of each page Odoo by default gives totals for each field. When an invoice is "unreconciled" it lists Sale Amount and Tax fields as positive values and totals them as such, but lists Total field as a negative number and totals it as such (which is what we would want). We use the totals at the bottom in monthly accounting and the fact that when we unreconcile lists those fields as positive values makes it difficult for us. If you tell me how to post a screen print I'll do that.

Please take a screenshot and upload it on a site like imgur or imgbb. You can then post the URL to the image here.

Author

It's on Dropbox: https://www.dropbox.com/s/dl0i5vy1lz07l9o/Screenshot-1.jpg?dl=0 I've blacked out a few areas. The important thing is that notice how the columns labeled "Sale Amount" and "Tax" have all positive values, whereas the column labeled "Total" has a couple of negative values that were created when the accountant unreconciled invoice 781, created a new invoice 813, and then unreconciled that one. Therefore notice the sums at the bottom. We would prefer Odoo place negative values in the first two column during unreconcile just as it does for the third column. That way the numbers at the bottom would make sense for our purpose. Also notice invoice 1540 appears to not yet have been paid since both times a payment was entered it was subsequently unreconciled. Is there any way for us to accomplish this? We use this screen for tax reporting purposes and it would be better if we did not have to make a note and manually calculate correct sums.

Something does not sound right. Are you sure the Invoices have been "Unreconciled" ? Both Invoices (781 and 813) in your screenshot have a status of "Paid" which means a payment has been reconciled against them. If they had been unreconciled, they would have had a status of "Open".

Also, if I understood you correctly, there was no need to raise the second Invoice (813). After unreconciling Invoice # 781, it would have had a status of "Open" and the second payment could have been entered against #781. You are seeing double-counting because there are now 2 Invoices for SO 1540 in the system. You may want to unreconcile 813 and "Cancel" the Invoice (assuming you wanted only 1 Invoice against SO 1540).

Another thing I noticed - where are the rows with the -ve entries coming from ? I don't get these when I recreated this scenario. Has the underlying view for this screen been customized to show data in addition to the Invoices ?

Author

Paresh, I don't see any rows with "-ve entries". Which fields do you refer to? But yes, the underlying view has been modified, but it does not contain any external or additional data. For fields we don't need, I made them invisible. And I added other fields from the model that are not included in the original view. We track data during time periods and per customer. We use this view for tax reporting purposes where we report total sales, total tax collected and total collected. Another thing you may have noticed is that SO 1540 appears to not yet have been paid. There were 5 sales for that customer during that period, but only 4 of them are accounted for in the total column: 133.56 X 4. Yet the total for sale amount and tax represents 8 sales: 126 X 8 and 7.56 X 8. If we were to use these figures in our tax reporting we would be expected to forward $60.48 in taxes to the state, but really, since there were only 5 sales, the correct amount would be $37.80. We need to either: make sure the accountant never makes a mistake and the administrator never tries to correct it, or we must remember such incidents and manually make adjustments in an external addendum. I don't think the admin tried to cancel the invoice. I'll check, try it, and let you know what happens. One more question: would the accounting module treat any of this differently?

Hi Donald: Before I forget - when you try out a solution, make sure you do it in a backup copy of the database first to ensure it works for you. Don't do it directly in the production database because some of the steps may be irreversible.

Coming back to the issue. There seems to be a disconnect between the data I see in the screenshot and what the users of the system are saying. Also there seems to be some confusion about the terminology being used to describe the steps that the users took to resolve the issue.

Here's a summary of what I SEE in the screenshot posted by you (as opposed to what is being described by the bookkeeper and admin). You may want to cross check this with them because getting the terminology right will provide us clues on how to get this resolved.

1. Sales Order # SO/2019/01540 was created in the system.

2. Invoice # INV/2019/00781 was generated for this SO.

3. A "Refund Invoice" step was done for INV/2019/00781 which resulted in the creation of INV/2019/00812 (with a -ve total).

4. A second Invoice # INV/2019/00813 was generated for the same SO.

5. A "Refund Invoice" step was done for INV/2019/00813 which resulted in the creation of INV/2019/00814 (with a -ve total).

I see only these 4 Invoice related entries in the screenshot.

Now regarding the terminology. "Unreconcile" and "Refund Invoice" result in different outcomes in the system. The difference between them is as follows:

a. "Unreconcile" is used to back out a payment that was incorrectly adjusted (reconciled) against a particular Invoice. There is a tiny (i) icon that appears next to the Invoice Total at the bottom of the screen when you are in the Invoice that allows you to do this. Using this will change the status of the Invoice back to "Open" so that other payments can be adjusted (reconciled) against it. You will also see the unreconciled amounts received from that particular customer below the Invoice total.

b. "Refund Invoice" is typically used to process Credits for goods that were returned by the customer (Credit Note). Using this will allow you to mark the current Invoice as "Paid" and generate a second Invoice (aka Credit Note) with a -ve amount so that the outstanding amount in the customer ledger is 0.

From the screenshot, it looks like your users have used the "Refund Invoice" option instead of the "Unreconcile" option. Please confirm this with them before we decide how to resolve this.

Hi Donald: Did the issue get resolved ?

Related Posts Replies Views Activity
2
Dec 19
2088
1
Jan 20
9671
0
Sep 24
104
1
Sep 20
1768
1
Sep 24
233