Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SQL VIEWS DDL
Microsoft Dynamics GP (Archived)

SQL VIEWS DDL

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

I have installed Dynamics GP 2013 R2 ESLA (spanish), the following views:

Accounts
AccountSummary
AccountTransactions
BankTransactions
Customers
ItemQuantities
Items
PayablesTransactions
PurchaseLineItems
ReceivablesTransactions
SalesLineItems
SalesTransactions

Vendors

Are defined in Spanish (the fields name are in spanish), all the Excel and SSRS reports fails because they are writen with the fields in english.

I need the "English versión" of those Views, somebody could extract de corresponding DDL for me??

Thanks in advance!!

*This post is locked for comments

  • Nattis Profile Picture
    Nattis 485 on at
    RE: SQL VIEWS DDL

    Dear Alejandro,

    Go to SQL >> your company database(s) >> Programmability >> Store Procedures. set filter by above name(s).

    for English intallation, un install the spanish version and install english version in your UAT machine.

  • Alejandro James Profile Picture
    Alejandro James 215 on at
    RE: SQL VIEWS DDL

    Hy

    Where do I get those stored procedures?

    My Smartlist change form Spanish to Englesh and my instalaation is in Spanish.

    thanks for your help

  • Verified answer
    Naga Kiran Profile Picture
    Naga Kiran on at
    RE: SQL VIEWS DDL

    Hello Luis,

    You may need to re-execute the below Stored Procedures for company database to make them available in English. Note that the parameter '0' indicates the Language ID (=English).

    exec sp_Dynamics_Accounts 0

    exec sp_Dynamics_AccountSummary 0

    exec sp_Dynamics_AccountTransactions 0

    exec sp_Dynamics_BankTransactions 0

    exec sp_Dynamics_Customers 0

    exec sp_Dynamics_ItemQuantities 0

    exec sp_Dynamics_Items 0

    exec sp_Dynamics_PayablesTransactions 0

    exec sp_Dynamics_PurchaseLineItems 0

    exec sp_Dynamics_ReceivablesTransactions 0

    exec sp_Dynamics_SalesLineItems 0

    exec sp_Dynamics_SalesTransactions 0

    exec sp_Dynamics_Vendors 0

    Hope this helps.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans