[Axapta-Knowledge-Village] Urgent: Exchange Adjustment

[Vilmaq]

Hi Subbu,
 
There are three methods that we can use to run the 
exchange rate adjustment in AP & AR:
Standard – Calculates local currency amount based on the 
exchange rate table for the date you choose. Posts an entry for the difference 
between the local currency amount in books and the local currency amount with 
the updated exchange rate. It handles the exchange differential by 
transaction.
Maximum - Makes an adjustment if there is a loss, and 
no adjustment if there is a profit, using the exchange rate in the table for the 
date you choose.
Invoice date - cancels all previously made exchange 
adjustments and creates an exchange adjustment with the same exchange rate as 
the original posting. 
 
We use the 
exchange differential adjustmentsfor accrual 
purposes, we run it once a month (at month end) using the Standard 
method. With this we make a monthly accrual of the exchange differential 
(unrealized loss & unrealized profit). We then reverse the entry on the 
first day of the next month, by running the adjustment with the Invoice date 
method. The definite and final exchange differential is recorded when the 
transaction is settled with the 
payment.
 
Hope this 
helps!!!
 
Vilma 



From: Subrahmanyam Mamidi 
[mailto:[EMAIL PROTECTED] Sent: Martes, 01 de Febrero de 2005 01:48 
p.m.To: Axapta-Knowledge-Village@yahoogroups.comSubject: 
Re: [Axapta-Knowledge-Village] Urgent: Exchange Adjustment

Hi Vilmaq,
 
This email will be very useful to me. Can you please let me know more on 
..
 
One 
way to do it, is to post another adjustment with the same option in the AP 
module, but using the method of Invoice date - cancels all 
previously made exchange adjustments and creates an exchange adjustment with the 
same exchange rate as the original posting. 
 
 
Can you please tell me 
more about this option?. how do you do that using invoice 
date???.
 
Because the adjusts are 
cumulative in nature....Its a little bit risky.  Is n't 
it?
 
regards,
Subbu
 
 
Vilmaq <[EMAIL PROTECTED]> wrote:

  
  Hi,
   
  I am not sure that you can reverse this entries manually. 
  Exchange difference adjustments will affect only local currency amounts and 
  does not convert to secondary currency since that is the purpose of the 
  transaction: to adjust local currency to it4s updated value at current 
  exchange rate based on the secondary currency amount.
   
  As far as I know, we cannot enter an exchage rate = 0.00, 
  therefore the reversion will affect our secondary currency 
  amounts.
   
  One way to do it, is to post another adjustment with the 
  same option in the AP module, but using the method of Invoice 
  date - cancels all previously made exchange adjustments and creates an 
  exchange adjustment with the same exchange rate as the original posting. This 
  would reverse the effect done in the first adjustment. The only thing is that 
  it creates an additional entry, nothing is erased or removed only 
  reverted.
   
  Rgs,
  Vilma Quiros
   
   
  
  
  From: Subrahmanyam Mamidi 
  [mailto:[EMAIL PROTECTED] Sent: Martes, 01 de Febrero de 2005 
  12:18 p.m.To: 
  Axapta-Knowledge-Village@yahoogroups.comSubject: Re: 
  [Axapta-Knowledge-Village] Re: Urgent: Exchange 
Adjustment
  
  Hi,
   
  Somehow I figured it , apart from these tables,
  I changed  VendTrans fields 
  LastSettlementVocher,ExchAdjust,LastExchAdj, VendExchAdjustmentUnrealized 
  etc.. reset them back..
   
  Let me see where I am now!.
   
  Thanks,
  Subbulinus_van_pelt_lvp2000 
  <[EMAIL PROTECTED]> wrote:
  "I 
    know that what I am doing  100% wrong by deleting some transactions 
    in Transtables which I shouldnot be doing.."You've got that part 
    right!  I cannot tell you what tables you need to look for, but the 
    "best" way was to look at the vouchers (look at the audit trail for 
    example) that was posted for the exchange adjustments and then reverse 
    them manually!Good luck!--- In 
    Axapta-Knowledge-Village@yahoogroups.com, Subrahmanyam Mamidi 
    <[EMAIL PROTECTED]> wrote:> Hi,>  > I 
    mistakenly ran Exchange Adjustments under AP---Periodics--- Exchange 
    Adjustment...>  > I troied to figure it out what and 
    tables it updated , but I am not sure if I am complete>  
    > I cleaned up some entries in>  > 
    LedgerTrans> VendTrans> VendSettlemnt> 
    LedgerBalanceTrans> LedgerBalancdDim>  > Or How 
    can I revert back??>>  > I would like to know what and 
    all tables are touched. I know that what I am doing  100% wrong by 
    deleting some transactions in Transtables which I shouldnot be 
    doing..>  > But I need to know which tables will be 
    updated.. I couldn't figure it completely for a momement..>  
    > Can some help me Please?.>  > Thanks,> 
    Subbu> SDBC>  >  > > 
                > 
    ---------------------------------> Do you Yahoo!?>  The 
    all-new My Yahoo!  Get yours free!Sharing 
    the knowledge on Axapta. 
  __________________________________________________Do You 
  Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around 
  http://mail.yahoo.com Sharing the knowledge on Axapta. 
  Sharing the knowledge on Axapta. 

__________________________________________________Do You Yahoo!?Tired 
of spam? Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com Sharing the knowledge on Axapta. 



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 the Yahoo! Terms of Service.