Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In

Archives

 
Script that will search all tables for a specific field
This is our starting point for GL queries. 
This article will show you how to call the taRMTransaction stored procedure. This is the same procedure that eConnect uses to create RM transactions, and returns the same error codes. 

The PPS Amt Deducted for Credits (PPSAMDED) > Document Amount (DOCAMNT)  
The PPS Amt Deducted for Credits (PPSAMDED) > Document Amount (WROFAMNT)  

Explained below

 

This is our 'starter' template script for AA transactions. It's a good place to start

Prerequisite check for system component .NET Framework 3.5 SP1 failed with the following error message:

".NET Framework 3.5 SP1 requires manual activation on Windows 8 and Windows Server 2012"

See the setup log file located at 'C:\Users\xxx\AppData\Local\Temp\VSDFD80.tim\install.log' for more information

(sigh) Not that complicated, but the issue is remembering what to do to install the 3.5 Framework. 

Screen shots below : )

I just installed GP 2016 in a test environment, and when I opened it for the first time I got a series of error, the first two were

An open operation on table 'WDC_Security_Tag_TEMP' failed because the path does not exist

and

An open operation on table 'ASI_Explorer_Favorites' failed because the path does not exist. 

The fix is listed below

 

Today's task is to hide the post button in the PM Transaction entry window. 

From this:

 

To this. 

This article will detail how to hide a form field based on the user's name. Note that this is not the most robust solution: It won't scale well and would be hard to maintain... but it's here to demonstrate a technique. 

This piece of code will submit one SOP line. Probably most useful for updates.

 

(ahem)

Announcing the DynDeveloper eConnect schema reference

You can find the link on the main Knowledge Base menu above, under 'eConnect'

Now, some of you may say 'this looks just like the Microsoft reference'... and ... that's because I copied it. <smiles>

I did it so that I could add a navigation at the top. Way nicer than ... that other one. 

I hope to wiki enable it in the future, so that we can all make it better. 

Have an idea how to make the site better? Drop me a line. 

... I have time. <more smiles>

This post is designed to walk you through your first Visual Studio data access project. 

We've provided step by step instructions, and all the code... you don't even have to type anything. 

 

The application will query RM00101 (the customer table) and provide a list of customers. You can check some customers and click 'go', and the app will update the database and not show those customers any more

 

Last week we published a tutorial for WinForms SQL data access with the Telerik grid, today we'll do the same for the native DataGridView. 

The article below contains screen shots and all the code needed to access a stored procedure, display it in a DataGridView, and then loop through the grid and update SQL

This article is a code example for how to create this layout in a Winforms Telerik gridview. 

I am trying to restrict users from entering anything in the Trade Discount on the Customer Card.  

I tried to do the field lock by hiding it from certain users  but it's not working.

I see Trade Discount is also on the Vendor Card.  

I cannot find a satisfactory answer to this on Microsoft Dynamic's site.

 

Any help here will be appreciated, thanks.

 

I have a table with contents as follows:

Class, Description, Schedule Number, Markup percent

Example rows:

A,  Advertising,  1, 0.00

R, Candy, 1, 0.00

A, Advertising, 25, 0.00

R, Candy, 25, 0.50

A, Advertising, 30, 0.00

R, Candy, 30, 5.50

 

I want to produce a report that will look like this:

 

Class  Description   Schedule 1 Markup  Schedule 25 Markup    Schedule 30 Markup, etc.

A       Advertising    0.00                            0.00                                   5.50

R       Candy            0.00                            0.50                                    5.50

 

So I need to group the data in a different direction, so to speak.

I think I will  need to do some Grouping/ Select Distinct Sql here... ?

Thank you.

 

 







Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables