Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

The currency id is not selected for this posting account

Posted on by 2,095

Dear i am having a problem in GP dynamics we have around 90 unposted transaction not posted because of some error one i post this error comes in the report ..

The currency id is not selected for this posting account

we are using multi currency system USD and YR and USD is the functional currency ..

 this problem is only happining with the YR pretty cash transactions not with USD .

so after posting it gives the error mentioned above with transaction error - edit required

and it keeps again and again showing the same message ... and day by day the transactions is increasing .

 may i find the solution for this problem.. appriciate your kind assistant ..

 

Thank you and B. regards

Rashed

 

 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The currency id is not selected for this posting account

    please make sure that you choose the right currency for the 2 posting accounts; the debit and the credit amounts.

    I am sure it will help.

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: The currency id is not selected for this posting account

     Hello Mariano and Ian ,

     

    Thank you very much for your kind cooperation .. you really helped me alto .. the problem got resolved after deep check in the currency assigned to the accounts. with the exchange rate rebuild ..

    one of the accounts was not linked to the currency YR and causing this problem ..
     

     i appreciates your kind assistant..

     

    Thank you and B. regards ,

    Rashed

     

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: The currency id is not selected for this posting account

    Can you post a screen shot of your exchange rate table? Both the 'Multicurrency Exchange Rate Table Setup' window and the 'Multicurrency Exchange Rate Mantenance' window...for the YR to USD exchange rate table.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: The currency id is not selected for this posting account

    How are the transactions getting created? Manually or are they being integrated. If integrated, what product are you using to integrate them?

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    The currency id is not selected for this posting account

    Hi again ,

     Actually there should not be a problem with valid exchange rate as i can select the exchange rate from the exchange table.. and it will be effected during the creation of the bank transaction ..

    side from that i checked also the exchange table it was showing a valid exchange rate effective 1st june 2009 expire end of august ..and another one starting 1st june ending 31st june2009 with different exchange rate..

    checked all the accounts its already associated with YR currency

     thats why it becomes issue for me..

    Thank you  

    Rashed


     

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: Re: Re: The currency id is not selected for this posting account

    Rasheed,

    I was taking a look at the picture links you sent and the system is actually saying that you don't have a valid exchange rate for the transaction that you entered. Since your functional currency is USD, you will need a valid exchange rate for the transaction. Did you set these up? This error does not seem to be related to what you have been describing as the issue.

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: Re: Re: Re: The currency id is not selected for this posting account

    Hi ,

     

    Thank you for reply..

     but its assigned other wise how its possible to save the transaction..

    it will not be accepted to save..

    how to come out of this problem.. incase its not assigned ?

    appriciates your kind help ..

    Rashed


     

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: Re: The currency id is not selected for this posting account

    Hi dear ,

     

    the resault was :

    Actindx

    Curncyid

    Revaulue

    revluhow

    Post_resault_to

    Dex_row_ID

    96

    YR

    0

    0

    0

    421

    252

     

    0

    0

    0

    276

    252

    YR

    0

    0

    0

    275

     

    as you can see the second row second column has no value ..

    wish this will help

    Rashed

     

     

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: Re: Re: Re: Re: The currency id is not selected for this posting account

    Ok, so it means you have not assigned the YR currency to the accounts in question.

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    Re: Re: Re: Re: The currency id is not selected for this posting account

    Hi

    i run  this query and it was showing .. USD as currencyid ..

    plz find the link bellow :

    http://www.felixairways.com/gp/3.jpg

    http://www.felixairways.com/gp/4.jpg 

    http://www.felixairways.com/gp/5.jpg 

     

    hope that will help ..

     

    thank you for ur assistant ..

    Rashed



     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans