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

 
taPopRcptLineInsert Error: Invalid Account Index

Edit 9/17/15 View the main article for this error here 

Hi all,

I'm attempting to create a receipt in Dynamics using eConnect.  Reviewing the eConnect documentation for the taPopRcptLineInsert node, I don't set the INVINDX property explicitly (in turn, leaving it to its default value of 0).  Most of the time, the receipt is created successfully.  However, occasionally, the receipt fails due to the following error:

Sql procedure error codes returned: Error Number = 4612 Stored Procedure taPopRcptLineInsert Error Description = Invalid Account Index Node Identifier Parameters: taPopRcptLineInsert POPTYPE = 1 POPRCTNM = [XXXXXXXXXX]  PONUMBER = [XXXXXXXXXX] ITEMNMBR = [XXXXXXXXXX] Related Error Code Parameters for Node : taPopRcptLineInsert INVINDX = Note: This parameter was not passed in, no value for the parameter will be returned.

Any idea what this occurs?  Please help.  Thank you!

add in .net tools app.config

Hi,

please can any body advice where i should deploy the app.config file to read the updated value,

i have tried to deploy it inside the Great plains  folder  c:\program files\microsoft dynamics\GP\AddIn  (the same location where i have deployed the DLL for my customized application) but when i change the values in the app.config those new values does not appear in my application
Need an eConnect data import sample for GP8

Hi ,

I am new to Dynamics GP. I want to know how to import Sales order data to GP sql server and then display the data in GP window.

My client needs to do it for GP8. I want to do this using asp.net / C#.net using econnect method of data integration.

What are the GP tables needs to be used? Please give some insight. Which version of .Net framework needs to be installed for GP 8?

Thanks for any help.

Thanks

PD 

 

 
Dynamics GP 10 Company Tables

dsFilterJoinView                            dsFilterJoinView               DS10000
dsUnassignedAcctsView                       dsUnassignedAcctsView          DS10100
Multicurrency Posting Definitions Master    MC_Batch_Headers               MC00500
Account Format Setup                        SY_Account_Format_Setup        SY00300
Work Menu Master                            SY_Work_Maintenance_MSTR       SY00400
Posting Definitions Master                  Batch_Headers                  SY00500
Company Location Master                     SY_Location_MSTR               SY00600
Window Notes Master                         SY_Notes_MSTR                  SY00700
Source Document Master                      SY_Source_Document_MSTR        SY00900
Audit Trail Codes                           SY_Transaction_Source_MSTR     SY01000
Posting Account Master                      SY_Posting_Account_MSTR        SY01100
Internet Addresses                          coINetAddrs                    SY01200
Custom Links                                coCustomLinks                  SY01201
Process Monitor Information                 coProcess                      SY01300
User Defaults                               coUserDefaults                 SY01401
Posting Journal Destinations                SY_Posting_Journal_Destination SY02200
Posting Settings                            SY_Posting_Journal_Settings    SY02300
Routines Master                             SY_End_Routines_MSTR           SY02500
End Routines Check Master                   SY_End_Routines_Check_MSTR     SY02800
Shipping Methods Master                     SY_Shipping_Methods_MSTR       SY03000
Credit Card Master                          SY_Credit_Card_MSTR            SY03100
Payment Terms Master                        SY_Payment_Terms_MSTR          SY03300
File Maintenance Error Log                  SY_File_Maintenance_Error_Log  SY03400
Record Notes Master                         SY_Record_Notes_MSTR           SY03900
Comment Master                              SY_Comment_MSTR                SY04200
Internet Address Prompts                    coINetPrompts                  SY04800
Extended Pricing Locks                      coExtPricingLocks              SY05500
Address Electronic Funds Transfer Master    AddressEFT                     SY06000
List Action Status Header                   syListActionStatusHdr          SY07250
List Action Status Line                     syListActionStatusLine         SY07255
Period Setup                                SY_Period_SETP                 SY40100
Period Header                               SY_Period_HDR                  SY40101
Tax Period Setup                            SY_Tax_Period_SETP             SY40102
Tax Period Header                           SY_Tax_Period_HDR              SY40103
Report Group Master                         SY_Group_List_ROPT             SY70100
Series Report Groups                        SY_Group_Names_ROPT            SY70200
Report Option Names                         SY_Report_Names_ROPT           SY70300
Combined Report Groups                      SY_Master_Group_Names_ROPT     SY70400
System Report Options                       SY_Options_ROPT                SY70500
Company Report Options                      SY_Comp_Options_ROPT           SY70501
Report Destination                          SY_Report_Destination          SY70600
SY_User_Object_Store                        SY_User_Object_Store           SY90000
Sales/Purchases Tax Schedule Header Master  TX_Schedule_MSTR_HDR           TX00101
Sales/Purchases Tax Schedule Master         TX_Schedule_MSTR               TX00102
Sales/Purchases Tax Master                  TX_Detail_MSTR                 TX00201
Sales/Purchases Tax Summary Master          TX_Detail_MSTR_SUM             TX00202
Sales/Purchases Tax Period Summary          TX_Detail_Period_SUM           TX00203
Tax Rebate                                  taxRebate                      TX20500
Tax History                                 taxHistory                     TX30000
Tax Module Setup                            TX_Module_SETP                 TX40101
VAT_IV_Comm_Code                            VAT_IV_Comm_Code               VAT00200
VAT_ADDR_MSTR                               VAT_ADDR_MSTR                  VAT00300
VAT Tax Comm Code MSTR                      VAT Tax Comm Code MSTR         VAT10000
VAT Country Code MSTR                       VAT Country Code MSTR          VAT10001
VAT Transport Mode MSTR                     VAT Transport Mode MSTR        VAT10002
VAT Transaction Nature MSTR                 VAT Transaction Nature MSTR    VAT10003
Intrastat Maintenance                       syIntrastatMstr                VAT10007
VAT_INTRA_WORK                              VAT_INTRA_WORK                 VAT10302
Account Cache                               coAccountCache                 coAccoun
Period Cache                                coPeriodCache                  coPeriod
SQL for Security Details in Dynamics GP

 

 I copied this from Victoria Yudin's blog, because it's too important to not to be able to find again. If you work on/in/under Dynamics GP, you need to subscribe to this.

 This script shows all security roles, tasks and detailed resource descriptions by user by company

VS installation

I tried to install VS tools, but I always got this message <<.NET framework 2.0 not detected >> i have check the server the .net framework is already installed.

 Any body can advise

Thanks 
Olympic Project Cost Tables

This page is depreciated, the complete listing of Olympic Project Cost tables is here:

http://dyndeveloper.com/DynProduct.aspx?Product=Olympic%20Project%20Cost

 
PM Apply

,

       I want to apply the posted PM transactions. I think no eConnect schema is availble for PM apply.

Please tell any alternate way to do this?.

Thanks in advance.

 

 
eConnect - Transaction Dimension assignment does not exist

Edit 9/16/15 View the main article for this error here 

Working on these one... Anyone seen it?

Transaction Dimension assignment does not exist
Cannot find a distribution amount based on input values
Unable to update/create distributions - Edit 9/16/15 View the main article for this error here and here
Transaction Dimension assignment does not exist
Analytics distribution does not exist

 
Windows Server 2008 Startup folder

Recently I've been installing the BGINFO utility from sysinternals on all my servers and VMs, I have so many that sometimes I don't know where I am <smiles>

I'm fond of just dropping a shortcut into the 'startup' folder on the machine, but on Windows Server 2008 it's a pain to find, I have to spend 5 minutes searching for it, so...
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 | Gold Star Locksmith
3