GP Table Structure

I too am learning Crystal Report.  Its clear that understanding GP tables is 
key to writing Crystal Reports.  It is also clear that comprehensive 
information regarding GP Table Structure is very hard to come by.  Is there a 
textbook available that defines table names and inter relationships.
0
Trafford (1)
4/24/2008 6:28:06 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
654 Views

Similar Articles

[PageSpeed] 24

Ed,

Your best bet is the Microsoft Dynamics GP Software Development Kit (SDK) 
documentation. Accolade Publications also publishes a set of useful titles 
exclusively dedicated to explain in detail the flow of information and 
posting ("Information Flow & Posting") and other tricks of the trade.

Best regards,
-- 
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com


"Ed Trafford" wrote:

> I too am learning Crystal Report.  Its clear that understanding GP tables is 
> key to writing Crystal Reports.  It is also clear that comprehensive 
> information regarding GP Table Structure is very hard to come by.  Is there a 
> textbook available that defines table names and inter relationships.
0
MarianoGomez (3440)
4/24/2008 6:45:05 PM
Also check out the user guide "Working with Crystal Reports." It can be found 
in the Reporting area of the Printable Manuals from your Help menu.
-- 
Charles Allen, MVP



"Mariano Gomez" wrote:

> Ed,
> 
> Your best bet is the Microsoft Dynamics GP Software Development Kit (SDK) 
> documentation. Accolade Publications also publishes a set of useful titles 
> exclusively dedicated to explain in detail the flow of information and 
> posting ("Information Flow & Posting") and other tricks of the trade.
> 
> Best regards,
> -- 
> MG.-
> Mariano Gomez, MIS, MCP, PMP
> Maximum Global Business, LLC
> http://www.maximumglobalbusiness.com
> 
> 
> "Ed Trafford" wrote:
> 
> > I too am learning Crystal Report.  Its clear that understanding GP tables is 
> > key to writing Crystal Reports.  It is also clear that comprehensive 
> > information regarding GP Table Structure is very hard to come by.  Is there a 
> > textbook available that defines table names and inter relationships.
0
callen (2505)
4/24/2008 6:52:00 PM
Reply:

Similar Artilces:

Pivot Table
Hi My data in table are very simply organised as below: --------------------------------------------- Res.no City Code Var1 Var2 Var3 --------------------------------------------- 1 City1 CD0001 num num num 2 City1 CD0002 num num num 3 City1 CD0003 num num num 4 City1 CD0004 num num num 5 City1 CD0005 num num num 6 City2 CD0006 num num num 7 City2 CD0007 num num num 8 City2 CD0008 num num num 9 City2 CD0009 num num num 10 City3 CD0010 num num num 11 City4 CD0011 num num num 12 City3 CD0012 num num num 13 City3 CD0013 num num num 14 City3 CD0014 num num num 15 City1 CD0015 num nu...

CRM for GP or SBF
Question that I think will be interesting for everybody. Is there any CRM (microsoft, 3rd part) integrated with SBF or GP? Any suggestion, because SBF is good but everybody wants more and more. thanks Vitali Microsoft CRM 3.0 integrates with GP 9.0 through the XML processing engine. As for SBF, there are a few third party add-ons that are available, and it's possible to integrate it with CRM 3.0 as well. -Mike -- Micheal LoPatriello Coordinator, Luna Development mlopat@lunadevelopment.com http://www.lunadevelopment.com "Vitali V" wrote: > Question that I think wi...

Adding to an imported table
I am a beginning Access user. When I order items, I am able to import the order information (info about each specific ordered item) into an Access database. I have figured out that I can add information from subsequent orders to the same big table (and could use a query to ID stuff from specific orders if necessary). I want to mark items received or not received. If I do this in the table, I mess up the column names and importing the order information doesn't work (at least, it doesn't work with my limited knowledge). I have tried to create a form where I add in a checkbox, but I ...

Update from previous versions to GP 10.0
Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and then GP 9.0 to GP 10.0? Please help me as soon as possible, I need to make decisions. Put service pack 5 on version 8, then update from there to 10.0 Make sure you also immediately use sp1 for Version 10 Mike "arielqs" <arielqs@discussions.microsoft.com> wrote in message news:12AD9FCB-84AD-45CF-898C-A943DB8216F4@microsoft.com... > Can I update GP 8.0 to GP 10.0 or I have to update first GP 8.0 to 9.0 and > then GP 9.0 to GP 10.0? > > Please help me as soon as possible, I need to make dec...

Sorting Cube dimension names in a Pivot Table
How do I get the dimension names in the "pivot table field list" sorted by the translated names? The pivot table field list contains: - one measure-node - one dimension node for each cube-dimension. The cube-dimension-nodes are represented by their translated names. It looks like, this names are not sorted by this translated names, but by the order of the data source. The related radio-buttons in the pivot-table-options are greyed ("A to Z" and "sort by data source"). I would need the "A" to "Z" order. Pleas notice! I...

Does anyone know of a software application for Pivot tables other. #2
We have some very complex pivot tables in Excel that unfortunately are not very stable or flexible when you make changes. The data list is used to generate multiple pivot tables in the same workbook but the data and the number of records can change frequently. One time we might have 18000 records and the next time we might have 2500 records. So far it seems that everytime we have to change the data we have to reset the data source range for each pivot table. I believe each pivot table was copied via Edit, Move or Copy, rather than being generated as anew pivot table or based on anot...

Need historical tracking of activity coming into GP via eConnect
Currently if transactions come into GP via eConnect then get deleted for some reason, there is no audit trail of what happened to these transactions. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrows...

Access 2007 Pivot Table Chart
I've created a Pivot Chart and would like to add value labels to the columns. Is that possible? ...

Purging old data from pivot table
Is there any way to purge old data from a pivot table? I modified th contents of a column of data, and "refresh" put the modified data int the pivot table but also retained the old data (which no longer exist in the original spreadsheet). It gets confusing when I need to selec different items for a new view, since the old non-existant data appear to be selectable as well as the current data. Saving, closing, reopening did not help either -- Message posted from http://www.ExcelForum.com Hi have a look at http://www.contextures.com/xlPivot04.html -- Regards Frank Kabel Frankfur...

Renaming forms tables and reports
Is choosing "save as" and making a copy and removing the original the only way to rename a report, table, or form? I started with the Issues template but I want to change the names of the objects. I can right click and rename the shortcuts in the navigator window, but the name doesn't change and the references are still under the old name. I do not want my shortcut to be a different name than the reference name because then there will be confusion for database maintenance. I've also tried renaming the objects in their properties window, but I couldn't find a na...

Problem with Analysis Cubes for GP 10 FP1
I got it installed but when I try to run the SSIS packages I get an error. Error: Error 0xC0014049 while preparing to load the package. Cannot find folder "\DynamicsGPWarehouse\DynamicsGP_DynamicsWarehouse_CompanyMaster". What did I setup wrong or how do I fix? -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com Is the folder, in fact, there? I recently installed it using as much of the default settings as possible and had no problems. -- Charles Allen, MVP "Japheth Nolt" wrote: > I got it installed but when I try to run t...

Conditional Formatting in data table of a chart
I'm using Excel 2007, and trying to apply conditional formatting to the data table of a line chart. I've tried creating the chart without the formatting applied to cells with the original data (data source), and then applying the format to the source; as well as creating the chart after applying the format to the source. The data table in the chart will naturally update with changed data since it is linked, but will not incorporate any style formatting. Any thought? Thanks. Data tables in charts are not particularly flexible. They do not, for example, support conditional fo...

Report using Fields with the same name from different tables
Hello all - I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field names. Apparently Access doesn't like this....I attempted to change the names in the BE but when I relink the FE it is prompting for parameters. What is the best way to proceed? Thanks - Lee -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1 TheLee via AccessMonster.com wrote: >I created a db with no knowledge of naming convention. Now I am attempting to &...

Rotate data table by 180 deg.
Hi, How to rotate data table (matrix) by 180 deg.? Kind of what Transpose function do just I need to do two Transposes in the same direction, as to rotate picture by 180 deg. For example to rotate table: 1 2 3 4 11 12 13 14 21 22 23 24 And get: 24 23 22 21 14 13 12 11 4 3 2 1 Of course it is possible to do by linking one cell to other, but very long process for big matrix. Thank you. Gedi. With your range called "myrng", select A1 of a new sheet, enter this formula, and press <ctrl><shift><enter>: =OFFSET(myrng,ROWS(myrng)-ROW(),C...

GUID In Table
I have a GUID in a table that I fill programmatically. Often the table will be searched on the GUID. It is just a GUID generated from dotnet in a varchar field. The majority of the time the table will be searched on this GUID... only sometimes will be it be searched on an the primary key ID (just an identity). What type of index, if any, should I place on the GUID? Unique Constraint, Unique Index? The table may get to a couple million records. I suggest you store the GUID value in a uniqueidentifier column instead of varchar . This way, you'll store the native 16 byt...

PayPeriod table
I am working on a payroll system. One of the task is to create a payperiod table to capture the previous payroll currently store in the Excel file from year 2006 to present. The payperiod is bi-weekly and I want to populate this table with the pervios payperiod and up to year 2050. The columns in this table will have the following fields: ID Calendar Year - which is determined by the PayPeriod End Date PayPeriod Start Date PayPeriod End Date PayPeriod - PayPeriod Start Date - PayPeriod End Date How to write a sql query to populate this table? PayPeriod always start on Sund...

How to transfer a journal entries from excel to GP
I read about integration assistant for excel , How can I transfer a journal entry from excel?.\I have Integration manager already . Thank you You can do it through integration manger or through a macro "Gustavo Rojas" wrote: > I read about integration assistant for excel , How can I transfer a journal > entry from excel?.\I have Integration manager already . > Thank you Integration Assistant for Excel does not work for entering information in scroll windows. We tried it with a client since the promotional material said it can be used with "any" window. ...

Removing a field From a Pivot Table
I'm working with a pvt table in excel. Right now there are several fields in the pvt table, including the month different entries are made and the account that made them. When i hit the show detail button in the pivot table i get the detail all of the entries grouped by month and by account on a separate sheet. I want to continue to do this, but i want to also be able to get a second view where i hit the show detail button and only see the detail grouped my account (month is either hidden or totally removed from this list of data in the pvt table and the rows that composed the different...

Wave file in GP login
It used to be in past versions there was a welcome.wav file that a voice said "Welcome to Dynamics" when you logged in, and one could edit this file, etc. Is there any way to do this in Version 10? Matt, Check out this blog post by David Musgrave: http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/09/welcome-to-dynamics-example.aspx -- Victoria Yudin Dynamics GP MVP Want to use Crystal Reports with GP? http://www.flex-solutions.com/gpreports.html blog: http://www.victoriayudin.com "Matt Mason" <MattMason@discussions.microsoft.com> wrote in message...

Directory Structure starting with the Current Directory ..
Hi, Could someone Pls tell me how do i do this: In my macro the user gets to select the file to open: ExcelFile1 = Application.GetOpenFilename("Excel- files,*.xls", _ 1, "Select Input File To Open", , False) My requirement is the Windows explorer should show the directory structure starting with the Current Directory rather than showing the directory structure Starting with desktop or some other. Thanks in Advance for any help. Neeraja. ...

show full account number in Dynamics GP GJ entry
show full account number in Dynamics GP GJ entry it does not make sense that you can't see the last 2 digits ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=4567fd64-71...

Linked Excel Table, Update Table
Using Access 2002. I import an Excel table into my database that is regularly updated from my company's main database via a BusinessObjects query. I need to create a table that constantly updates to mirror the linked Excel table because of record locking issues (can't have multiple people in the database if queries are based on the Excel table). I use a make-table query as a starting point... My question is how do I keep the table updated? Thinking I need to do an update query, a delete query and/or an append query but not sure how or in what order. Any help would be apprec...

Tables update interrupted
SOP is configured to post through to the GL, I came this morning and saw this status message, 'tables update interrupted'. I know I can use the batch recovery for this batch, but before I do anything, why did this happen? And how can it be prevented? rcr, You know your environment better than anyone of us. Without a description of what processes, etc., run on your server while posting is happening is very hard to even venture to give an aswer. This is one of those cases where it's anyone's best guess if you do not provide any extra info. My first guess would be check ...

Comments on a pivot table
Dear All, How would one add comments to a pivot table? I want to add two comments to items in a pivot table however when I select different items in the filter list, thus changing the range covered in the pivot tables, the comments remain static and just stay on cell D12 for example. Any items how I can apply a comment to a specific item in the pivot table? Please see pivot layout below: Invoice Date Range 10-20 21-30 1234 £10.40 5346 £12.50 I want to add a comment to, for example, the cell with £12.50 i...

Remote Users for GP 8.0
We have a remote site with 5 users that are connected to us via a T1 point to point at 1.5mbps. We would like to have these w/s connect to run great plains. Is a vpn possible? SHould we use a terminal server? Any advantages in using citrix? Thanks John John, I would usually recommend Terminal Server 2003 for what you're describing. VPN only (without TS or Cirtix) is not supported by MS, nor advisable, even over a point to point T1 you're not going to like the performance. Citrix doesn't really offer too many advantages over TS for 5 users, but is also a viable alter...