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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In

Archives

 
Does anyone know what tables are effected by the taPMManualCheck sproc? I need to do some modification in the taPMManualCheckPost sproc, but I am not sure which tables the data goes into.

When I'm trying to post batches using

Microsoft.Dexterity.Applications.Dynamics.Forms.SopBatchEntry.Procedures.PostBatch.Invoke(false, 2, _arrBatchList[i].ToString(), "Sales Entry", DestinationID);

some times it post normally and another times it gave me the follwing error

 

"SQL Error: 2601 cannot insert duplicate key row in object 'dbo.AAG20000' with unique index 'AK2AAG20000' "

 

Please Help???

I got the following error when I Use the Employee Expense Transaction through eConnect. The error is  "String was not recognized as a valid datetime at EcecuteSotedProcedured............."

Please note the same XML  is working fine in Our developement environment and throwing the error at the Client side.

 

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/23/menus-for-visual-studio-tools-the-wait-is-over.aspx

The link above is to David Musgrave's blog entry on 'Menus'. Here I'll walk you through the setup.

 

We have strange situation that we need your support in.

For example

1.       We have stock for item X = 100

2.       Make invoice using e-Connect for item X = 70

3.       Then the expectation to find this item allocated by 70, but we find the item is allocated by 100.

While we are trying to solve this issue, we make an invoice by the whole qty (100) then we delete it, the allocation now is 70, and there is qty = 30 free now!

I think that the e-Connect make wrong allocation or something like that, what do you think about this wrong allocation?







Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables