SQL VIEWS DDL

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Naga Kiran on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Alejandro James 215 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Nattis 487 on at

Like (0)

Report

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.

Was this reply helpful? Yes No