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

 
SQL - Table Value Function Template

I'm about to post a really cool function that will grab email addresses from the RM statement email addresses... and I noticed that we don't have function templates. I like to post templates here because I do most development remotely, on my client's computers.

So, here is a template for a table value function
SQL - Table Value Multi-statement Function Template

I'm about to post a really cool function that will grab email addresses from the RM statement email addresses... and I noticed that we don't have function templates. I like to post templates here because I do most development remotely, on my client's computers.

So, here is a template for a table value function, this one allows multiple statements
ddf_SOP10106_SEL_EmailAddresses

This article contains a table value function that will return the addresses that are in the Dynamics Customer form, behind the Options button:

 

 

In the end, the result set looks like this. I break up the first 'TO' and subsequent 'TOs' because in .NET you can't add multiple TOs at the start when you insatiate the mail object. Easier for me.

eConnect - SOP Invoice that automaticaly creates taxes and totals

This article contains an XML document that creates a SOP Invoice, it will create the taxes and total the document automatically.

The code to create this document will be published next:
http://dyndeveloper.com/articleview.aspx?ArticleID=249

 
eConnect - SOP Invoice that automaticaly creates taxes and totals

This article vb.net code that creates a SOP Invoice, it will create the taxes and total the document automatically.

The XML document that it produces is blogged here:
http://dyndeveloper.com/articleview.aspx?ArticleID=248

 
cant return po remainder.

hi,

we sent a guy to stay in a hotel.  the bill was 199.36.  the po created was for 199.68.   so we got the invoice, received it at the actual price (199.36) and paid them.  now, our purchasing guy is trying to do a return on the 32 cents so it can be closed.

the problem is, that when we try to do the return, nothing shows up in the card (Return Transaction Entry) to do the return.   we should see the 32 cents in there, right?

 OH, one more thing....our purchasing guy likes to switch the amount and quantity fields, so the po line in question has a quantity of 199.68 and a cost of 1.0000.  not sure if this will make a difference though.  On the po itself, the REMSUBTO field shows a value of 0.32000.

postatus = 4, statgrp=1, potype=1

thx
Need GL transaction report showing all journal entries and Subledger data

1.
Journal Entry #
2.
TRX Date
3.
Account #
4.
Account Description
5.
Debit Amount
6.
Credit Amount
7.
Source Document
8.
Originating TRX Source
9.
Originating Source
10.

TRX Source

Vendor OR customer ID

11.
Company
12.
Originating Posted Date
13.
Document Status


Need all of the above columns, showing GL transactions, including Subledger, from the financial, POP, and SOP modules tables.

A SQL script, view, or any pointers would help.
How do I use this DTA/GL SQL table-function?
http://dyndeveloper.com/articleview.aspx?ArticleID=60

i don't know what field/whatever to pass this function to get all the GL data I need.
Window Service Application

 Hello i configure a service with IIS 7.5, the service was created with dot net framework V2.0.50727. The version GP IS 11 and econnect 11

The dll Microsoft.Dynamics.GP.eConnect.dll and Microsoft.Dynamics.GP.eConnect.Serialization.dll are correct in the bin folder inside the IIS folder.

When run the service in browser show me the following error.

Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect in Windows Server 2008 R2 64 - bit using IIS 7.5 with Application Pools V2.0.50727

I need help thanks a lote.

Angel Luis

System Developer

Server Error in '/posgp' Application.

Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.BadImageFormatException: Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.Dynamics.GP.eConnect' could not be loaded.

 

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


Stack Trace:

 

[BadImageFormatException: Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect' or one of its dependencies. An attempt was made to load a program with an incorrect format.]

System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0

System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +416

System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +166

System.Reflection.Assembly.Load(String assemblyString) +35

System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +190

 

[ConfigurationErrorsException: Could not load file or assembly 'Microsoft.Dynamics.GP.eConnect' or one of its dependencies. An attempt was made to load a program with an incorrect format.]

System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +11241896

System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +388

System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +232

System.Web.Configuration.AssemblyInfo.get_AssemblyInternal() +48

System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +210

System.Web.Compilation.WebDirectoryBatchCompiler..ctor(VirtualDirectory vdir) +191

System.Web.Compilation.BuildManager.BatchCompileWebDirectoryInternal(VirtualDirectory vdir, Boolean ignoreErrors) +54

System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) +295

System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +476

System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) +116

System.Web.UI.WebServiceParser.GetCompiledType(String inputFile, HttpContext context) +77

System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext context, String verb, String url, String filePath) +231

System.Web.Script.Services.ScriptHandlerFactory.GetHandler(HttpContext context, String requestType, String url, String pathTranslated) +89

System.Web.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +425

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +263

 
Purchase Order can´t delete?

I have a problem with a PO when i find the ponumber a message appears "Other user editing the transacction" and the point is nobdy is in this PO i try to delete and gp can't delete. i need your help for this is the first time it happens 

What can i do please

 
Business Portal Document Approval

What are the document approval tables that GP uses. We're getting an error when an employee attempts to change his address saying there's a similar document pending approval.

Looked at all documents submitted by user and there's one there but the status is completed.

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