VS Tools Forum

All Things Code

Welcome to our code library. This site is our place to document the day-to-day machinations of code writing, a place to stick that nice little piece of code that we won't need to use for six months... and might not be there when we need it again.

Most of the code references are implemented via blogs, a blog for each area. That way if what we need is not immediatly searchable, we can just read through the subject area.

This site serves us two ways: it provides a place to put all the paragraphs of code that we hate to lose, and it provides a community for developers who work in/on/under Dynamics Great Plains. If you're one of those folks, welcome.

If not... well... welcome anyway

Proudly listed on Microsoft's Community Locator web site

What you'll find here:

Blogs:

Personal Blogs:
Steve Gray

Environments:
ASPDOTNET STOREFRONT
Community Server
Component Art
Crystal Reports
DataGrid
Dynamics
Janus Systems
Microsoft Access
Who's On

Languages:
ASP.NET
HTML
Javascript
SQL Server (T-SQL)
VB.NET

Blogs:

Links
Link Checker

Forums:

eConnect
Visual Studio Tools for Dynamics GP

Libraries:

eConnect Class Libraries
Dynamics GP Script Libraries

Resources:

Scripts
DDL scripts
Create a DAB class from a Stored Procedure

Sample Code
Example data access class
Sample code to get a VB project started

eConnect
Introduction to eConnect
Step by Step Walkthrough

Dynamics GP Table Structures
Collections Management (CN) Tables
Company Tables
General Ledger (GL) Tables
Inventory Management (IV) Tables
Olympic Project Cost (PC) Tables
Payables Management (PM) Tables
POP Workflow
Payroll (UPR) Tables
Receivables Management (RM) Tables
Wennsoft Job Cost Tables

VS Tools for Dynamics
Walkthrough for creating a project

What's New

Re: Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

I was trying to figure out how to allow Dynamics to calculate the taxes automatically. In order to make this work, I had to do this: .SUBTOTAL = dblSubtotal .FREIGHT = 0 .MISCAMNT = 0 '.TAXAMNT = 0 '.FRTTXAMT = 0 '.MSCTXAMT = 0 '.TRDISAMT = 0 'this is '1' .CREATETAXES = eConnect9.GP9.SOP.taSOPHdrIvcInsert.CREATETAXESType.dynamicsHandlesTaxes .DOCAMNT...

Posted to eConnect for Dynamics GP (Forum) by Steve Gray on 07-03-2009
Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

Server was unable to process request. ---> Sql procedure error codes returned: Error Number = 235 Stored Procedure taSopHdrIvcInsert Error Description = Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc) Node Identifier Parameters: taSopHdrIvcInsert SOPNUMBE = STD00440275 SOPTYPE = 2 Related Error Code Parameters...

Posted to eConnect for Dynamics GP (Forum) by Steve Gray on 07-03-2009
Duplicate MSTRNUMB

All: I need to create a series of SOP documents that all have the same MSTRNUMB, but when I try to create a doc using an existing master, I get a 'duplicate MSTRNUMB' error. I know that Dynamics allows the same MSTRNUMB on multiple SOP documents, it's a way of connectiong them together. But eConnect is not allowing it. Ideas?

Posted to eConnect for Dynamics GP (Forum) by Steve Gray on 07-03-2009
Re: is it posible to use eConnect9.0 in GP10

I'm sorry, there is just no way. Dynamics uses a huge pile of stored procedures to talk, since they're quite a bit different, it can't work.

Posted to eConnect for Dynamics GP (Forum) by Steve Gray on 07-03-2009
is it posible to use eConnect9.0 in GP10

Hi Can we use eConnect9.0 in GP10.0 install if posible what are the modification we have to Do?.if not what is the limitation with this Thanks Roshan

Posted to eConnect for Dynamics GP (Forum) by Roshan on 07-03-2009

All Things Code

Popular Tags

Blogs:

Blogs:

Forums:

Libraries:

Resources:

What's New

Re: Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

Duplicate MSTRNUMB

Re: is it posible to use eConnect9.0 in GP10

is it posible to use eConnect9.0 in GP10

Who Is Online