Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by shimstar
-
Import Items into GP Pervasive SQL
Hello, I tried creating a dexsql log by editing the dex.ini and changing the three lines to TRUE but after going out and back into Great Plains and going into item maintenance, no .log file appeared. Is that a tool possibly only for SQL and not pervasive SQL? Any other ideas?- shimstar
- Post #3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Import Items into GP Pervasive SQL
Hi, In order to import items into Great Plains (Pervasive SQL), I ran a DTS in regular SQL taking the data from excel into a temporary SQL table (IV00101temp.) Then once I had the data in the temporary table, I ran an INSERT statement to populate information into the IV00101 table from...- shimstar
- Thread
- Replies: 3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Dynamics SQL Tables/Fields for adding an unposted G/L...
The tables are GL10000 and GL10001 and SY00500. SY00500 is the batch table so you can just run batch reconcile and this will populate the table.- shimstar
- Post #2
- Forum: Microsoft: Dynamics GP (Great Plains)
