- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: Tables Information
Links Sort by: Hits | References | Alphabetical
1) Goto--Tools--Resource Description--Tables
Table Names screen shows all the Table information for the specific series in above example its shows the Display, Technical and Physical Name for the Sales Series
2)Let’s find the Table Information for specific screen say : Customer Maintenance
Open the customer Maintenance screen from (Cards--Sales --Customer)
Goto --…
- Excerpts from the blog of Victoria Yudin
Recently, I grazed through this really useful piece of blog article written by Victoria Yudin in her blog. It contains information about the various key tables in various modules and the…
Dave Musgrave has updated his seminal newsgroup post on where to find table information and added it to his blog. Victoria Yudin continues to add to her list of…
Instinct says that if you are asked to write a report, go and look in the tables. Instinct says that if you need to reference a field on a web page, go look in the tables. Instinct says that if you need to import data, go an write to the tables. Instinct says ....
Is it possible that natural instinct is wrong? There is a long Darwinian discussion that could follow here. YES - instinct can be wrong. When it comes to Microsoft Dynamics GP eXtender, instinct is wrong.
Just yesterday I had some of our internal team helping to build a demonstration for WWPC which is on later this month. One of the tasks was to have a web page reference some data that was being stored with an eXtender form. Yesterday I heard cursing, muttering and the banging of office stationary…
| Setup | PP_Prepayment_SETUP | PP000001 |
| GL Batch Info | PP_GL_Batch_Info | PP000002 |
| Profiles Header | PP_Profiles_HDR | PP000010 |
| Profiles Header WORK | PP_Profiles_HDR_WORK | PP000011 |
| Profiles Header History | PP_Profiles_HDR_HIST | PP000012 |
| Profile Distribution Type | PP_Profile_Distribution_Type | P… |
This post describes how to read the On-Line Field Description Tables (OLFD001.dat & OLFD002.dat) using the c-tree ODBC driver. It is the tool I have used forever to put the table and window names in a spreadsheet for easier access.
FairCom c-tree Plus
Dynamics GP v 7.5 and prior supported three databases. Pervasive SQL 2000 (Btrieve), FairCom’s c-tree Plus and MS-SQL. Dexterity still supports these formats. If you search the GP folder, you will find a few tables with the extensions .dat and .idx. These are c-tree tables. Although there are others, I’d like to focus on the On-Line Field Description tables. When you navigate to Microsoft Dynamics GP > Tools > Resource Descriptions > Tables, you are reading those files. While you can, of course, access these tables using Dexterity, you can also read them with an ODBC driver.
The c-tree ODBC Driver
GP used to sell a read-only ODBC driver for c-tree files. I think it was about $300 per workstation. They do not sell it anymore, but you can get it from FairCom http://www.faircom.com/ace/ctpodbc_information_t.php.
If you still have your CDs from version 6 of Great Plains…
Leslie Vail has an interesting look at using ODBC to read the On-Line Field Descriptions…
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
- AX 2012 R2 - Lista de nuevas funcionalidades
- AX 2012 - Dimensiones financieras para las letras de cambio
- Microsoft Dynamics GP Technical Airlift 2013 – Registration Now Open
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Analyze Dynamics GP Data Using Microsoft PowerPivot for Excel
- Taking Your Financial Reports to the Next Level with Management Reporter – Postings Audit (5 of 8)
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.