There are three “Can I ” questions in above inquiry, many people want to know, so that’s why sharing link here.
Filed under: Dexterity Development, Dynamics GP, dynamics-gp, Can I ..., great plains, transaction entry
February 22, 2013 • 6:35 am 0
There are three “Can I ” questions in above inquiry, many people want to know, so that’s why sharing link here.
Filed under: Dexterity Development, Dynamics GP, dynamics-gp, Can I ..., great plains, transaction entry
February 19, 2013 • 10:07 am 1
Good informative article. There are ways of doing things and important is what to use when what is needed. Although it is a little advanced but always workable techniques. There were times when I use to accessed third party tables and what I did is not very different. I usually do this.
1. Create SQL view for the table which I need to access, just take an example of this FA General Information Master (FA00100) table, with some other unique name.
create view V_dynFA00100
as
select * from FA00100
Go
grant select on V_dynFA00100 to DYNGRP
Go
2.Then create table in dictionary with same view name, and fields (with same data types and dexterity field’s format). The number of keys is my choice but the Primary key will always be same as of FA00100 table.
and now I can use it like any GP table, get/previous and next. range or no range to show data on my form. And I don’t need to bother to create this table V_dynFA00100 from SQL Maintenance window.
almas
Filed under: dynamics-gp, 3rd Party Tables, Scrolling Window
Learn something new... - then Teach someone!
عالم تمام حلقۂ دام خیال ہے
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Sculptural stained glass of Andrew Kosorok
How to use MS Dynamics SmartList Builder, Excel Report Builder and other Reporting tools to get the data and analysis you need.