• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

Exchange rate question

Hi EE

Not sure if this the right forum for this question here goes. I have a friend who is a marine engineer and he wants me to put something together for stock control. No problems i have done this many times before. This situation is different he buys all his supplies from USA then converts the USA dollar to Australian dollar. My question is Stores are received and converted to current exchange rate. After a time stocks are getting low so more stock is ordered but at a different exchange rate. When We receives the stock we have a situation where we  have some stock at previous exchange rate and now if have stock at a different rate. Any help appreciated. Hope the question is clear

chestera
0
chestera
Asked:
chestera
2 Solutions
 
EyalCommented:
you need to save for each stock the rate on ┬┐urchase date
0
 
peter57rCommented:
I don't understand what the queston is.

Every stock system in the world involves having stock (for the same item) bought at different prices.  Whatever you do to deal with that situation is unaffected by exchange rates.  The exchange rate is just a factor in  determining the price.

SO first consider the same question ignoring the exchange rate.

You buy 100 of item A at 100 dollars and later 120 of A at 103 dollars .  How would you deal with that?
0
 
als315Commented:
It is more accounting problem. There are two mainly used methoods:
1. FIFO (every consignment have own price and it is used in profit calculations)
2. Mean (price is recalculated ith every incominng consignment): (CurrentPrice*CurrentQty + IncomingPrice*IncomingQty)/(CurrentQty+IncomingQty)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
peter57rCommented:
Ah - if what als315 is actually your question then you have to decide which method to use.
So I would say that your friend's accountant would probably advise/decide and you would implement their decision.
0
 
chesteraAuthor Commented:
ala315

Makes sense thank you. I will leave question for a bit longer

chestera
0
 
chesteraAuthor Commented:
Hi

Many thanks als315 and Peter57r for you input

chestera
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now