Gesendet: Freitag, 25. Oktober 2013 um 07:23 Uhr
Von: Airidas <[email protected]>
An: [email protected]
Betreff: Re: [tryton] Cost Price on stock move
Von: Airidas <[email protected]>
An: [email protected]
Betreff: Re: [tryton] Cost Price on stock move
2013 m. spalis 24 d., ketvirtadienis 15:21:55 UTC+3, Cédric Krier rašė:
On 24/10/13 05:05 -0700, Airidas wrote:
>
>
> 2013 m. spalis 24 d., ketvirtadienis 14:54:26 UTC+3, Cédric Krier rašė:
> >
> > On 24/10/13 04:02 -0700, Airidas wrote:
> > >
> > >
> > > 2013 m. spalis 24 d., ketvirtadienis 12:18:28 UTC+3, Cédric Krier rašė:
> > > >
> > > > On 24/10/13 02:01 -0700, Airidas wrote:
> > > > > 2013 m. spalis 24 d., ketvirtadienis 11:19:28 UTC+3, Cédric Krier
> > rašė:
> > > > >
> > > > > > On 24/10/13 00:35 -0700, Airidas wrote:
> > > > > > > Hi,
> > > > > > >
> > > > > > > I have created sale document in USD (my company's currency is
> > EUR).
> > > > > > > I done Customer Shipment. Cost Price value is in USD on stock
> > move
> > > > > > > (outgoing move).
> > > > > > > The same situation with Supplier Return Shipment.
> > > > > >
> > > > > > I don't understand. The cost price on the stock move is normally
> > when
> > > > > > the move is done with the cost value of the product form which is
> > > > always
> > > > > > in the company currency. Also as there is no currency field for
> > the
> > > > cost
> > > > > > price value on stock move how can you say it is in USD?
> > > > > > If you are looking at the field currency on stock move, it is not
> > the
> > > > > > currency of the cost_price but the currency of the unit price.
> > > > > >
> > > > > I know about unit price and currency on stock move.
> > > > > I give example.
> > > > > USD exchange rate is 1 EUR = 2 USD. When calculate cost price by
> > FIFO
> > > > value
> > > > > is 5 EUR. But Cost Price value is 10 on outgoing stock move.
> > > >
> > > > Too few information on this example to understand.
> > > >
> > > I purchased product, quantity = 1, cost price = 5 EUR.
> > > I sold product, quantity = 1. Cost Price value is 10 on outgoing stock
> > > move.
> >
> > Now, I'm lost because you said the currency of the company is EUR and
> > here I don't see any currency exchange in this example.
> >
> The same as I wrote before. USD exchange rate is 1 EUR = 2 USD.
We are going no where. Please provide a way to allow us to see all your data.
1. My company's currency is EUR.
2. USD exchange rate is 1 EUR = 2 USD.
3. Product cost method = FIFO.
4. I created purchase, currency = EUR, quantity = 1, unit price = 5.
5. I created supplier shipment, quantity = 1.
6. Now I have stock move, quantity = 1, cost price = 5.
7. I created sale, currency = USD, quantity = 1.
8. I created customer shipment, quantity = 1.
9. Now I have stock move, quantity = 1, cost price = 10.
IMHO the internal valuation of material shall always be in house currency (= the currency of the company), otheriwse your bookkeeping is quickly messed up.
That leads to a design question: is tryton valuating at standard price (all moves are 5 EUR/1pc) or at moving average price (price may change due to different PO prices, freight charges etc)?
