another blog

Icon

About Microsoft Dynamics GP :-)

How to access non gp database table within GP window.

We have one database named “Other”, a non GP database.It has some table we need to use within GP.(read/write/edit/delete record)

1

2

On our GP Company Database ‘TWO’ we have created a view.

USE [TWO]

GO

CREATE view [dbo].[VOtherTable001]

as

select *,ID as Dex_row_id from Other..OtherTable001

GO

3

Let’s add a button on sales transaction entry window to read the first record of table.

4

5

6

we will give permissions to our view.

grant select , insert, update, delete on VOtherTable001 to almas

Now the next messages we got are

8

9

To solve these above issues

Create a new role like below in ‘OTHER’ database .

Create a user loging for user ‘almas’ in ‘OTHER’ database  so it could be mapped with TWO user.

10

11

12

13

How to access non gp database table within GP window.

Advertisements

Filed under: Dexterity Development, Dynamics GP, dynamics-gp, , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: