hi Vilma, In this case when do the posting of invoice you can check the "Fixed Exchange Rate" field and enter the exchange rate into it and Pos the invoice.
This ensures that for this particular invoice the specified exchange rate is taken. welcome, regards, vaibhav pednekar --- "VilmaQ (Axteam)" <[EMAIL PROTECTED]> wrote: > Hi Vaibhav, > > We do have a source for the daily exchange rates. > Yet, each vendor > determines the exchange rate for their invoices. So > we end up with > transactions at different exchange rates that differ > from our daily one & my > customer wants to reflect the amount in both > currencies as shown in the > invoice. > > You have given me an idea on how to handle the > issue. > > Thanks for you the info, it has been great help.... > > Regards, > Vilma > > -----Mensaje original----- > De: vaibhav pednekar [mailto:[EMAIL PROTECTED] > > Enviado el: Martes, 09 de Noviembre de 2004 06:57 > p.m. > Para: [EMAIL PROTECTED] > Asunto: RE: [Axapta-Knowledge-Village] Post local > currency transaction not > at system4s default exchange rate > > > hi VilmaQ, > > Sorry, but i still cant understand your requirement. > Please give an example of transactions for two > different countries and show > what you want. > > As per my understanding, each company follows some > bank or an financial > institution for the exchange rate. > > Either they may go for the daily exchange rate or > can fix up the exchange > rate of last day of that month, applicable for the > whole month. Example > 1 Oct 04 exchange rate from indian rupees to USD is > 100 INR = 2 USD on 31st > Oct 04 the exchange rate is 100 INR = 2.20 USD. > so the company before doing the month end closing > procedure will setup the > exchange rate for the period > 1/Oct/2004 to 31/Oct/2004 - 100 INR = 2.20 USD > > and then run the exchange rate adjustment for the > respective module, in your > case the AP module. > > based on the setup of your currency, the adjustments > will be posted to the > unrealized and realized gain/loss accounts for the > individual currency. > > It may happen during that period you have done > transactions with fixed > exchange rate i.e. one Purchase order is created > with the fixed exchange > rate of 100 INR = 2 USD, this transaction will still > be recorded with > exchange of 2 USD and not 2.20 USD. > > Now for conoslidation purpose, you have > consolidation company setup for it, > in where you have the Primary currency as your HO > local currency and USD as > the secondary currency and all other currencies > recorded in the exchange > rate table with the approved exchange rates. > > Then when you do consolidation you can check the > Exchange adjustment box, > this tells the system to do exchange adjustment on > the accounts by using the > exchange rate specified /setup in the Consolidation > company exchange rate > master table. > > > this is the maximum which i can try to put, but i > have one question - how > come the users are able to select different exchange > rate for the same day, > your company does not have any fixed source for the > exchange rates? > > > Thank you > regards > vaibhav pednekar > > --- "VilmaQ (Axteam)" <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > My problem is a little different, I have 1 company > in 10 countries, > > each country need their accounting in local > currency (local fiscal > > requierements) and we need to convert to secondary > currency -USD- for > > consolidations. > > > > Transactions need to be posted in the currency > they take place. For > > example operative costs in local currency and out > of country purchases > > in USD. When I post the transactions, Axapta > converts the transaction > > to the other currency. That is, if I enter local > currency, it converts > > to USD and updates the USD accounting too . If the > transaction is > > entered in USD, it converts to local cuerrency and > posts in both > > currencies. > > > > When posting local currency, during the posting > process that the > > system performs, it goes to the exchage rate table > and gets the value > > to convert to USD. We enter a daily exchage rate > in this table but > > during the day we get transactions with a > different exchange rate than > > the daily one. > > > > With several persons entering data at the same > time, changing the > > value in the table each time we have a different > exhange rate is not > > the best because another operator could post at > the same time, > > obtaining the wrong exhange rate for their > transaction. > > > > This where I need to overide the exchange rate, > for local currency > > transactions so instead of using the table's > exchange rate, it uses > > the one I enter for the transaction. Yet if I go > to the exchange rate > > field in the journals, I get the 100 =100 local > currency. > > > > Thanks, > > > > Vilma Quiros > > > > > > > > > > > > > > _____ > > > > De: Subrahmanyam Mamidi > [mailto:[EMAIL PROTECTED] Enviado el: > > Martes, 09 de Noviembre de 2004 12:56 p.m. > > Para: [EMAIL PROTECTED] > > Asunto: RE: [Axapta-Knowledge-Village] Post local > currency transaction > > not at system4s default exchange rate > > > > > > Aha!, Hey guys hold on for a moment....I think > > VilmaQ is the same boat. > > well, I can explain his requirement ( as mine ). > As > > I explained before, I > > have European environment with 9 companies. 8 out > of > > 9 companies follow > > EUROs as the Local currency. but the UK ( > troubler) > > still uses Pounds as the > > local Currency. > > When I try to consolidate in a localcurrency, it > > won't yield me the exact > > results because of Pounds. So What we did is, we > > switched the primary > > currency to secondary currency ( which is Euros ) > > for the UK company and did > > all consolidation etc etc...... > > > > Yeah, I expected someone will be having my problem > > > > > > "Bonk, David" <[EMAIL PROTECTED]> wrote: > > > > I think that this is like an issue raised before. > > Because they also report > === message truncated === __________________________________ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
