Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Originating Currency

Posted on by Microsoft Employee

i would like to know is there any option to get Customer / Vendor statement in originating currency in GP 2013, as our accounts are maintained with continuous exchange rate differences, and i am not able to take proper statement by putting currency rate.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Originating Currency

    thanks for the reply, i will check with the vendor for more details.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Originating Currency

    This is a customized form, it is already under the "Additional" menu. You need to check with the vendor who has customized this report.

    Your feedback is highly appreciated,

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Originating Currency

    Yeah, I haven't seen anything like that either.  Like Beat said, it looks to be a customization or something from an add-on.

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Originating Currency

    Sujith,

    The shortcut you describe is not standard in GP (at least I don't see it in 2013R2, nor in 2015R2), maybe it's part of specific setup from the Sales module or an add-on...

    What I meant with the Excel / SSRS reports is that you can eventually get the same information outside of GP.

    Sorry if I can't help more.. but I don't know have that 'Statements' form you printed on screen..

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Originating Currency

    Hi Béat Bucher ,

    I am trying to take report from Inquiry-Sales-Transaction by Customer-Additional-Customer Statement.

     

    SOA.png

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Originating Currency

    Hi Sujith,

    From where would you like to run the reports ? What reports are you trying to run ? Microsoft has provided since GP 10.0 several dozens of SQL views for the built-in SSRS & Excel reports deployed within GP.  Have a look at PurchaseLineItem, PurchaseOrders, SalesLineItems and SalesTransactions... There is even a view for Vendors and Customers.

    If you have deployed the out-of-the-box provided Excel reports, you'll likely have access to all the information.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans