DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
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

Archives

 
RadCombobox Google functionality

This functionality will give the RadCombobox type ahead functionality, like Google
RadCombobox AJAX functionality issues

I'm having a issue with the RadCombobox, I'd like to change the state of other controls on the page based on the text that is in the RadCombobox. I'm trying to use the RadComboBox ItemsRequested event to do this, but it's not working. I submitted a support case and got a very good answer, I'm going to blog it here so that I can easily find it in the future. 

 
BULK INSERT

Today I needed to import a csv file into SQL, a task I've done hundreds of times. But it's not my favorite. The wizard is a little clunky and if the data isn't in great shape I get errors. 

Today I tried BULK INSERT and it seemed to go great. I'll document the syntax below (much easier than looking the syntax up again), and I'll add notes as I go if I find anything worth reporting. 
ItemDataBound Set the image in a GridBoundColumn
This example shows how to get a reference to a grid bound column. The uniquename for the column is "imgWarning". To get the type to convert it to, run the code below and you'll get a convert error on the 'Dim imgWarning' line. The error will give you the type to convert it to.
Change the background color of an entire row
This code details changing the background color of an entire row
ItemDataBound Set the text of a GridBoundColumn
Set the text of a GridBoundColumn
Multicurrency entries GP 2018

Hi, we have to enter a lot of prior FX Rates,i'm tempted to do a SQL script in DYNAMICS.DBO.MC00100 and enter them like this:

NOTE: the Currency ID is USD-UYU and the Rate Type id is USD-UYU-DAILY.

insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-01 00:00:00.000','1900-01-01 00:00:00.000',42.1270,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-02 00:00:00.000','1900-01-01 00:00:00.000',42.2260,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-03 00:00:00.000','1900-01-01 00:00:00.000',42.2850,'2025-12-31 00:00:00.000');
insert into DYNAMICS.dbo.MC00100 (EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE) values ('USD-UYU-DAILY','USD-UYU','2025-04-04 00:00:00.000','1900-01-01 00:00:00.000',42.1080,'2025-12-31 00:00:00.000');

I just wonder if someone else tried it this way.

Have you tried Integration manager?

 
History tracking question
Is there a way we can turn on history tracking for multiple (50+) existing parts on the Item Master? We have several part that we were created without history tracking activated, the quantity received never appears in our inventory and it is not available to ship or sell.   Is there any implications to doing this after the fact?  Is there a SQL query that could do this or do I just need to go into item maintenance card for each item?  
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Anchored Marriage
3