[anglo_saxon] bug Cost for Credit Notes.
First of all, thanks for the whole work been made to achieve the functionality of the module, indeed, congratulations.
Whenever you make a credit note for a sale, and the client send back some products, the accounting move made by openerp takes into account the last cost of sale of the product and not the previous one used when sale was made, this happens whenever there have been a purchase in the meantime,with different prices for the products involved, between the sale and the credit note.
The accounting people has advised me that the cost of sale should be the same one when the product was invoiced and not the current one.
They say this should be the correct behaviour for the credit note and not the one used right now, because if the full sale is refunded then there will be mismatches between the movelines in the sale and the credit note,
Thank in advance for your attention,
The Solution: Improve the module with this behaviour configurable on FInantial Management > Configuration > Finantial Accounting.
Improve the method that is responsible of this behaviour and refer the "cost" to Last invoice_line of purchase and not to Stock. And need to refer to:
Document Number.
Invoice_Line.
Date Of the Original document.
Blueprint information
- Status:
- Complete
- Approver:
- hbto [Vauxoo] http://www.vauxoo.com
- Priority:
- Undefined
- Drafter:
- Nhomar - Vauxoo
- Direction:
- Needs approval
- Assignee:
- Javier Duran
- Definition:
- Approved
- Series goal:
- None
- Implementation:
-
Implemented
- Milestone target:
- None
- Started by
- Nhomar - Vauxoo
- Completed by
- Nhomar - Vauxoo
Related branches
Related bugs
| Bug #388145: Financial integration warehouse-location, purchase and sale transactions | Fix Released |
Sprints
Whiteboard
- All this behaviour must to be done on wizard for create Credits Note showed on Invoice VIew.
-- Insted Management > Configuration > Finantial Accounting the View where the selection between last Cost and Line cost must to be in:
Management > Configuration > Finantial Accounting.> Journal.
And Only Selectable if the journal is Purchase or Sale.
topic under discussion for approval
I fully agree that we need to use the cost of the product when it was invoiced, moreover, the return of the items to the inventory must force a recalculation of the value of the inventory, as if the item was re-stocked from a provider.
--- 20110127 Philu
Agree that must use the sale cost, and recalculate the value of inventory.
It can get tricky if the quantity on hand is negative; in such a case you may simply change the cost of the negative items to be that of the incoming item's cost, and then you have to write a variance journal to GL so that your inventory sub-ledger is kept in balance with your inventory GL account.
Otherwise, you can get disproportionate average costs calculated due to the negatives.
--- 20010127 Nhomar
IMHO Don't you think we should need to simply avoid negative inventory with internal procedures, if we allow negative inventory, the correction is not contemplated on any accounting book, and it should be corrected manually, if you think I'm wrong can you giveme an example please....
Did you install and try modules related to this branch?, thanks!
--- 20110127 Philu
IMHO I don't think you can avoid negative inventory because some stores receive their stock physically, but then the customer wants to take it straight away and get invoiced before the back office guys can even enter the purchase delivery, so for the system to handle that you need to allow negative stock.
Another situation is where a customer comes to the front counter to buy something and he's got the item in his hand but the system says there is none in stock, due to some processing error; you don't want to hold the customer up just because the computer says the stock can't go negative!
Final reason why the calculations need to handle negative stock is because the standard modules in OpenERP 6.0.1 allow negative stock.
Also, from my experience, it's not that hard to handle negative stock. Hope that helps.
--- 20110127 Nhomar
Let me see, we have conceptually 2 types of valuation inventory "Perpetual" an "Periodical", the Perpetual is what we are talking about here correct??? I think "perpetual inventory" what is the process of recalculate costs with every single inventory (Rhine) or invoice (Anglo-saxon) move, in this case --You NEVER can allow negative inventory-- for functional reasons.... If you decide allow negative values on inventory, you need to develop a post-procesing for your moves in fact it convert your valuation process in the other one "Periodical Inventory", we are deveoloping this one too! (it is not totally ready yet) you can see sme advances in a really big module called "report_profit" on venezuela localizaton, but the logic is than complex that we stop a little this development until this one is ready.
IOH. If you need both [I'm agreed are needed] you can wait for our development, but ALMOST all ERP's in market than i was tried (closed and open) needs post-manual-review and we think is possible do it automatically.
-- 20100127 Philu
Yes, my comments are for Average-Cost Perpetual (aka. Real-time) inventory, in the Anglo-Saxon context.
