web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Applying AED amount to...
Microsoft Dynamics GP (Archived)

Applying AED amount to Forigen invoice in GP

(0) ShareShare
ReportReport
Posted on by Aida Al Braiki 45

I have microsoft dynamics GP and am using the payaple section, what am trying to do is to apply AED amount to GPB invoice, but i don't know what  is the corect way to do it.... please help me

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    The first question is what is your functional currency? Is it eithre GBP or AED?

    Or are bothe AED and GBP 'foreign' currencies?

    Ian.

  • Aida Al Braiki Profile Picture
    Aida Al Braiki 45 on at

    Our functional currency is AED...

    Aida

  • Suggested answer
    Dale Coulthard Profile Picture
    Dale Coulthard 3,055 on at

    Was the vendor paid in GBP?  Did your company pull funds from an AED currency account?  If yes to both, then you should be able to enter a payment in the system showing the GBP amount paid (be sure to reflect the GBP currency id at the payment level) and apply the exch rate the bank used to convert the GBP amt to AED.  This will enable the bank account to be reconciled becuase GP will reflect the AED amount at the checkbook level and the A/P subledger will allow you to apply the payment (Transactions>Purchasing>Apply Payables Documents) because the vendor was sent GBP and any exchange rate gain/loss will be calculated by GP once the payment is applied to the invoice (for me, I only apply transactions with the same currency id - if that does not exist, I create several entries in order to reflect the correct amounts in each subledger).  NOTE: The g/l number for the checkbook and a/p has to allow GBP.  

    Basically, only two steps required:

    1) Enter/Post the payment showing the GBP amount paid by using the GBP currency id (ensure the correct exchange rate is used so the correct AED amount will be pulled from the bank account)

    2) Apply the payment to the invoice (Transactions>Puchasing>Apply Payables Documents

    If you are unable to convert the GBP to AED or use GBP at the payment level, then I assume multicurrency has not been setup for GBP.  I assume GBP has been setup but want to make sure that I stated this fact in case the invoice was entered with an AED value only (which would bring a lot of issues if that is what has occurred).

    Best regards,

    Dale

  • Aida Al Braiki Profile Picture
    Aida Al Braiki 45 on at

    thanks a lot................

  • Murugan Profile Picture
    Murugan 140 on at

    We are currently using NAV 5.0 sp1 on SQL Server 2005 and planning to upgrade SQL Server 2005 to SQL Server 2012.

    In one of the PC I installed SQL Server 2012 and I made a copy of NAV 5.0 SP1 databse in SQL Server 2012. When I try to access I get the following error :

    "The trace flag 4616 is not set on the server ASW-TDB01. You must set this flag and restart the server before you can connect using Microsoft Dynamics NAV."

    As per my inderstanding setting trace flag is not a requirement in newer versions of SQL Server.

    Can anyone confirm that NAV 5.0 sp1 is compatiable with SQL Server 2012?

    Thanks

    Murugan

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,999 Super User 2025 Season 2 on at

    I hope its a duplicate post

    community.dynamics.com/.../97315.aspx

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans