Community mailing list archives

community@mail.odoo.com

Re: Return products and average cost

by
Nhomar Hernandez
- 01/09/2015 13:14:26

2015-01-09 11:22 GMT-06:00 Christophe Hanon <chanon@adins.com>:

Other issues are also related to this, for example the current system works by processing deliveries sequentially, but sometimes due to a wrong encoding order, the price is again false.

Actually I got it 'right' only one way, by having a recompute routine so corrections can be applied safely.

THIS is a third scenario that Odoo has never understand is needed.

We need is a recompute process which linking three components bring out thorught several ways audit process:

Proposed Level:
- Purchase Order (theoretical amount which is used to load the first valuation)

Real Level:

- Account Moves related.
- Stock Moves.
- Invoices.

Then with this 3 components


Post Mortem run a routine which analyse your inventories and make 2 options:

1.- Report with inconcistencies impossibles to solve automatically (purchases after deliveries with negative temporal inventories).
2.- Correction on Atock Move, Quants and Account Move related which can be done automatically.

With everything related to pull and push and procurements now, this process is bringing A LOT of use cases which are not sequencials and the postmortem routine is becoming mandatory.

But, again, Odoo must have the willing to design the process auditable and auto-fixable,

About this specific case.

Both are wrong.

What Fabien is saying is worng is because it is "incomplete"


Logistic Perspective                        |           Accounting Perspective

- Have 1 product at 10                     |  - Valuation 10
- Buy 1 product at 20 - ave: 15        |  - Valuation 30
- Deliver product at 15 - ave: 15      |  - COGS 15 - Valuation 15
- Return 1 product at 10 - ave: 15   |  - Valuation 5, COGS stay in 15
-----  This is the extra postmortem step.
- Fix the ave to 10                           | - Fix account move at credit 5 on valuation debit 5 at COGS 5


We are facing now this issue in a company with 10000 products, you can imagine the difficult process to audit, but then IMHO stock move -  quants - sales orderds - purchase orders - invoices MUST be perfectly relationables and normalized models to be able to audit everything in an automatic way (which is not the case totalñly now they has some leaks of normalizations).

I hope it helps!

Regards.
--
--------------------
Saludos Cordiales
 
--
Nhomar Hernandez
http://about.me/nhomar