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

 
Process cannot access the file

Dear All

 I am new to this forum. Hope someone can help me with this issue that's been bugging me for a while.

I create XML's which contains the applied information for the sales records. 9 out of 10 it works. At times it fails with an error

"The process cannot access the file "\\legsyddb01\GreatPlains\eConnect Source Files\Failed\v10970_dcvi0901003333_yivi238967_194649.xml" because it is being used by another process."

This is only instance of eConnect in the whole network. If I move the file out of the monitoring folder and redrop it manually it works fine.

Please Help!!!

 

Many Thanks

Senthil

  

Cannot handle Save button from Dialogbox from C#

Dear Team

I am working with VS2005, C# for any customization on GP 10

In the Sales àCash Receipts screen.

After the user adds all the information required in the screen he/she press the “X” to close the whole screen.

A message appears to the user asking him/her if you want to Save, Delete, or Cancel.

I do not want the Save operation to be completed until I make some validations from my Code.

I can handle the save button on the Screen.

However, the save button on the popup windows when the user press “X” close I cannot handle.

 

Please advise me what to do.

Thank you,

 
File not found with: eConnectMethods eConMet = new eConnectMethods()

I am currently developping an interface with eConnect 10.0. 

Everything works fine on my development machine.

When I deploy to another server I get  a FileNotFoundException (0x80070002) on the instruction

eConnectMethods eConMet = new eConnectMethods ()

Any clues?

Stephane 

 
GridView .net tools
Hi , i am using .net tools to create custom forms under GP 10, i have added a gridview on the form and bind the data for this gridview, when i run my form for the first time every thing is going ok, i can view the form and the gridview and i can select any row, BUT if i try to open the same form second time the Gridview is hanging and i can not do anything. Any Help.
Anyone using SQL Service Broker as a transport mechanism ?
In the eConnect Architecture diagram, the Integrating Applications use MSMQ as a transport mechanism.  However, MS is pushing Service Broker as an alternative to MSMQ: http://www.devx.com/dbzone/Article/34110 Would like to know if anyone is using SB?

Thanks

gi
Modifier w/VBA: Process status indicator / updates

 I have a simple Modifier w/VBA mod where I added a button to a form, and the button calls a VBA script that exports some payroll data to a text file.  Very simple, works fine.

 But the client has alot of payroll, so sometimes the export takes 10-15 seconds, during which you can't tell if the script is working.

 The user, quite reasonably, asked if there was any way to show a status, or an indicator that it is working.

I don't see any option to change the mouse cursor to Busy in GP VBA. With Word, Excel, and Access, mouse cursor changes appear to be proprietary and different with each app, and I don't see any equivalent in the GP VBA.

So then I tried adding a text field to the form to see if I could write out "x of y records exported".  But while the export script Sub is running, no GP window updates occur.  And it appears that there is no equivalent to Form.Refresh, or Application.DoEvents, so the only time the text field gets updated is when the script finishes.

Any other options for status updates I might be missing?

update GP tables using VS Tools

please let me know how to update item table iv00101 without using econnect and webservice.

Thanks in advance!!! 

 
Lookup window customization

please let me know shall we able to customize lookup window.

how to use company address lookup and how to invoke cancel button action? 

 
Add new menu under "sales order processing" menu in Sales home page

please let me know shall we able to add new menu under "sales order processing" menu in Sales home page

Thanks in advance!!!
Screen Sales  Transaction Entry error: “Illegal address for field”

Dear All

I am working with VS2005, C#, GP 10 SP3

All my customizations are done with VS2005

While I am testing a screen Sales à Transaction Entry

In debug mode for this event: “Dynamics.Forms.RmSalesEntry.RmSalesEntry.RmDocumentNumberWork.EnterBeforeOriginal”

void RmDocumentNumberWork_EnterBeforeOriginal(object sender, EventArgs e)

{

try

{

string strDocNum = Dynamics.Forms.RmSalesEntry.RmSalesEntry.RmDocumentNumberWork.Value.ToString();           

}

catch (Exception ex)

{

                MessageBox.Show(ex.Message, "RmDocumentNumberWork_EnterBeforeOriginal");            }       

}

I have this error: “Illegal address for field 'WindowState' in script '[Not Found]'. Script terminated.”FYI: all other screens dosent have this problem

Please advise me what to do.

 
LOCNCODE can not be used when Inventory is not a registered module

Error "LOCNCODE can not be used when Inventory is not a registered module" occurs when a Sales Order Processing transaction is pushed in with eConnect. The site is registered for Inventory and a Sales Order Processing transaction can be entered manually within the Great Plains company.

 I've seen this in GP 7 and 9.

 
Query that joins RM10101 and GL00105

From a recent support request:

:

I am querying the RM10101 table and looking at the field labeled 'DSTINDX'
 
Then I am querying the GL00105 so as to see what is in 'ACTINDX' that matches the 'DSTINDX' as I want the GL00105.ACTNUMST, not the index value.
eConnect Or WebService for Project Accounting Inventory Transfer

Hi to all,

Hope you all doing good. I am not able to find the Schema /Node for Project A/c Inventory Transfer on eConnect and Web service.

Is it available or not ? How can we do the PA IV Transfer with eConnect and Web Service.

 

Your earliest reply will be highly appreciable.

 

Thanks

Sandip Jadhav

 
eConnect "User Defined" Fields

 Nearly all of the eConnect transaction schemas include 5 "user defined" fields, with the help file saying they are for "developer use only", which has never been terribly explanatory to me.

 I have never used them before, so I'm wondering if anyone has used them, and if they will help me do something.

A client is using a 3rd party tool to send data to eConnect, and they would like to send a few additional fields to populate some of the SOP Header "User Defined" fields.  Because these fields are not available in eConnect taSOPHdrIvcInsert, we're looking for alternatives.

If the client sends data values in the USRDEFND1 - USRDEFND5 nodes, it looks like I should be able to grab the node values in the taSopHdrIvcInsertPost procedure and then insert them into the SOP10106 table to store the SOP User Defined field values.

Anyone know of any issues with this approach?  Or should this work okay?
taSopHdrIvcInsert: Document ID is invalid

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

 Hi,

I am new to GP and econnect. I am using Econnect10 evaluation version. I tried to save few quotes and orders from my appliccation to GP. But I am getting Document ID is invalid when I am trying to save Quote in to GP. But manually I am able to create a Quote with the same Doc Id in GP.

I am not able to find any solution for this issue. Please help me to resolve this issue.  Thanks for your help. I appreciate it.

The following is the error which I am getting.

Sql procedure error codes returned:

Error Number = 68  Stored Procedure taSopHdrIvcInsert 
Error Description = Document ID is invalid

Node Identifier Parameters: taSopHdrIvcInsert                                 

SOPNUMBE = OR-00000005-00000004

SOPTYPE = 1

Related Error Code Parameters for Node : taSopHdrIvcInsert                                 

DOCID = QTE00000000000002

SOPTYPE = 1

<taSopHdrIvcInsert><SOPTYPE>1</SOPTYPE><DOCID>QTE00000000000002</DOCID><SOPNUMBE>OR-00000005-00000004</SOPNUMBE><DOCDATE>2009/02/16</DOCDATE><CUSTNMBR>CUS1</CUSTNMBR><DOCAMNT>206.00</DOCAMNT>

<BACHNUMB>BAT001</BACHNUMB><PRBTADCD>Test Add1</PRBTADCD><PRSTADCD>Test Add1</PRSTADCD><USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES><DEFPRICING>1</DEFPRICING></taSopHdrIvcInsert>

The following is the econnectxml

<?xml version=\"1.0\" encoding=\"utf-16\"?>

<eConnect xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">

  <RMCustomerMasterType>

    <eConnectProcessInfo xsi:nil=\"true\" />

    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />

    <taUpdateCreateCustomerRcd>

      <CUSTNMBR>CUS1</CUSTNMBR>

      <CUSTNAME>Test User</CUSTNAME>

      <ADRSCODE>Test Add1</ADRSCODE>

      <PRSTADCD>Test Add1</PRSTADCD>

      <PRBTADCD>Test Add1</PRBTADCD>

    </taUpdateCreateCustomerRcd>

    <taCreateCustomerAddress_Items>

      <taCreateCustomerAddress>

        <CUSTNMBR>CUS1</CUSTNMBR>

        <ADRSCODE>Test Add1</ADRSCODE>

        <CNTCPRSN>Test User</CNTCPRSN>

        <ADDRESS1>Test Add1</ADDRESS1>

        <ADDRESS2>Test Add2</ADDRESS2>

        <ADDRESS3>TestUser</ADDRESS3>

        <CITY>Irvine</CITY>

        <STATE>Kansas</STATE>

        <ZIPCODE>92464</ZIPCODE>

        <PHNUMBR1>96799923450000</PHNUMBR1>

      </taCreateCustomerAddress>

      <taCreateCustomerAddress>

        <CUSTNMBR>CUS1</CUSTNMBR>

        <ADRSCODE>Test Add1</ADRSCODE>

        <CNTCPRSN>Test User</CNTCPRSN>

        <ADDRESS1>Test Add1</ADDRESS1>

        <ADDRESS2>Test Add2</ADDRESS2>

        <ADDRESS3>TestUser</ADDRESS3>

        <CITY>Irvine</CITY>

        <STATE>Kansas</STATE>

        <ZIPCODE>92464</ZIPCODE>

        <PHNUMBR1>96799923450000</PHNUMBR1>

      </taCreateCustomerAddress>

    </taCreateCustomerAddress_Items>

    <taCreateParentID xsi:nil=\"true\" />

    <taParentIDChild_Items xsi:nil=\"true\" />

  </RMCustomerMasterType>

  <CMPInternetAddressType>

    <eConnectProcessInfo xsi:nil=\"true\" />

    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />

    <taCreateInternetAddresses>

      <Master_Type>CUS</Master_Type>

      <Master_ID>CUS1</Master_ID>

      <ADRSCODE>Test Add1</ADRSCODE>

      <INET1>testuser@testuser.com</INET1>

    </taCreateInternetAddresses>

  </CMPInternetAddressType>

  <SOPTransactionType>

    <eConnectProcessInfo xsi:nil=\"true\" />

    <taRequesterTrxDisabler_Items xsi:nil=\"true\" />

    <taUpdateCreateItemRcd xsi:nil=\"true\" />

    <taUpdateCreateCustomerRcd xsi:nil=\"true\" />

    <taCreateCustomerAddress_Items xsi:nil=\"true\" />

    <taSopSerial_Items xsi:nil=\"true\" />

    <taSopLotAuto_Items xsi:nil=\"true\" />

    <taSopLineIvcInsert_Items>

      <taSopLineIvcInsert>

        <SOPTYPE>1</SOPTYPE>

        <SOPNUMBE>OR-00000005-00000004</SOPNUMBE>

        <CUSTNMBR>CUS1</CUSTNMBR>

        <DOCDATE>2009/02/16</DOCDATE>

        <ITEMNMBR>SKU Item 1</ITEMNMBR>

        <UNITPRCE>205.00</UNITPRCE>

        <QUANTITY>1</QUANTITY>

        <ITEMDESC>SKU Item 1</ITEMDESC>

        <PRSTADCD>Test Add1</PRSTADCD>

        <CNTCPRSN>Test User</CNTCPRSN>

        <ADDRESS1>Test Add1</ADDRESS1>

        <ADDRESS2>Test Add2</ADDRESS2>

        <ADDRESS3>TestUser</ADDRESS3>

        <CITY>Irvine</CITY>

        <STATE>Kansas</STATE>

        <ZIPCODE>92464</ZIPCODE>

        <PHONE1>96799923450000</PHONE1>

        <DEFEXTPRICE>1</DEFEXTPRICE>

      </taSopLineIvcInsert>

    </taSopLineIvcInsert_Items>

    <taSopLineIvcInsertComponent_Items xsi:nil=\"true\" />

    <taSopTrackingNum_Items xsi:nil=\"true\" />

    <taSopCommissions_Items xsi:nil=\"true\" />

    <taSopLineIvcTaxInsert_Items xsi:nil=\"true\" />

    <taCreateSopPaymentInsertRecord_Items xsi:nil=\"true\" />

    <taSopUserDefined xsi:nil=\"true\" />

    <taSopDistribution_Items xsi:nil=\"true\" />

    <taAnalyticsDistribution_Items xsi:nil=\"true\" />

    <taSopMultiBin_Items xsi:nil=\"true\" />

    <taSopHdrIvcInsert>

      <SOPTYPE>1</SOPTYPE>

      <DOCID>QTE00000000000002</DOCID>

      <SOPNUMBE>OR-00000005-00000004</SOPNUMBE>

      <DOCDATE>2009/02/16</DOCDATE>

      <FREIGHT>1.00</FREIGHT>

      <TRDISAMT>0.00</TRDISAMT>

      <CUSTNMBR>CUS1</CUSTNMBR>

      <DOCAMNT>206.00</DOCAMNT>

      <BACHNUMB>BAT0001</BACHNUMB>

      <PRBTADCD>Test Add1</PRBTADCD>

      <PRSTADCD>Test Add1</PRSTADCD>

      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>

      <DEFPRICING>1</DEFPRICING>

    </taSopHdrIvcInsert>

    <taSopToPopLink xsi:nil=\"true\" />

    <taSopUpdateCreateProcessHold xsi:nil=\"true\" />

    <taCreateSOPTrackingInfo xsi:nil=\"true\" />

    <taMdaUpdate_Items xsi:nil=\"true\" />

  </SOPTransactionType>

</eConnect>


 
GP AddIn and Stand Alone App in same project?

Conceptual question:  I'm wondering if it is possible to create a single .NET project, resulting in a single file, that can serve as both a GP AddIn, and a stand alone app?

 For instance, if a GP user needs to access the app, they might open the Vendor Maint window and click on Extras --> MyApp, and the window would open with the vendor ID pre-populated.  But if a user is not logged into GP, but wants to modify some of the data, they could click on an icon which launches the app, allows them to select a vendor and modify data.

Or would these have to be separate DLL (for the AddIn) and EXE (for the app) files?  (I'm currently assuming Yes)

If I started with the DLL AddIn file, could I then just write a separate EXE wrapper that launched the DLL window?  Or would the GP plumbing required for the AddIn make that impractical?

Or would an alternative be to just go with an EXE, and then try and use VBA to launch the EXE from within GP, passing the vendor ID as a command line parameter to the EXE? 


Olympic Project Cost table definitions

Table defs for the Olympic Project cost product. Very nice people, and a world class product.

http://projectcost.net/

 

pc00100 pcSystemMaster
pc00110 pcPeriodMaster
pc00119 pcPeriodMasterTemp
pc00120 pcPeriodYear
pc00130 pcProjectTypeMaster
pc00135 pcProjectSubTypeMaster
pc00140 pcTaskTypeMaster
pc00145 pcTaskSubTypeMaster
pc00150 pcCostCategoryMaster
pc00160 pcCodeMaster
pc00170 pcOverheadCategoryMaster
pc00180 pcOverheadDepartmentMaster
pc00190 pcValuationClassMaster
pc00200 pcProjectMaster
pc00210 pcProjectRates
pc00250 pcBudgetMaster
pc00260 pcAssemblyMaster
pc00270 pcAssemblyUofMMaster
pc00280 pcAssemblyClassMaster
pc00300 pcTaskMaster
pc00380 pcTaskMoveActivity
pc00390 pcTaskMoveTemp
pc00400 pcEmployeeMaster
pc00420 pcEmployeeClassMaster
pc00430 pcCrewMaster
pc00440 pcMinimumWageGroupMaster
pc00450 pcPayCodeDetail
pc00460 pcMinimumWagePayCodeSetup
pc00470 pcCrewMembers
pc00500 pcExplorerNodes
pc00600 pcDepartmentMaster
pc00620 pcPayGroupMaster
pc00625 pcPayGroupPeriod
pc00700 pcImportMaster
pc00710 pcImportFieldMapping
pc00711 pcImportFieldMappingTemp
pc00720 pcImportFieldTranslation
pc00721 pcImportFieldTranslationTemp
pc00751 pcbProjectTemp
pc00752 pcbTaskTemp
pc00753 pcbCostCategoryTemp
pc00754 pcbSubCostCategoryTemp
pc00755 pcbTransactionTemp
pc00841 pcProjectModel
pc00851 pcProjectModelDetail
pc00900 pcPayCodeMaster
pc00910 pcPayCodeUofMMaster
pc10000 pcTransaction
pc10001 pcTransactionTemp
pc10005 pcTransactionImport
pc11000 pcCrewTransactionTemp
pc12000 pcCrewTransactionHist
pc15000 pcBurdenTransactionTemp
pc15200 pcBurdenPostingRatesTemp
pc15400 pcBurdenPostingAccountsTemp
pc15600 pcBurdenGLTransactionTemp
pc16000 pcBurdenTransactionHist
pc20000 pcValuationHist
pc20001 pcValuationTemp
pc20100 pcValuationDetailHist
pc20101 pcValuationDetailTemp
pc20201 pcValuationGLTemp
pc25000 pcBudgetTransaction
pc25001 pcBudgetTransactionTemp
pc25100 pcBudgetBillingDetails
pc26000 pcAssemblyTransaction
pc26001 pcAssemblyTransactionTemp
pc30000 pcPOTransaction
pc30001 pcPOTransactionTemp
pc30100 pcPOReceiptTransaction
pc30101 pcPOReceiptTransactionTemp
pc35000 pcSOPTransaction
pc39000 pcGLReconciliation
pc39001 pcGLReconciliationDetail
pc90100 pcCreateSOP_Trx
pc90200 pcCreatePM_Trx
pc90300 pcCreateUPR_Trx
pc90410 pcPMTransactionWork
pcGLTransactionPri pcGLTransactionPrint
pcPreviousPurchase pcPreviousPurchaseOrders
pcPurchaseOrderPri pcPurchaseOrderPrint
pcSOPTransactionPr pcSOPTransactionPrint
zErrorReport zErrorReport
zPC00900 zReportMaster
zPC00910 zReportOptions
zTmplt1 OlyParentTable1
zpc10000 pcTransactionProcess
Customer Numbers

I am trying to find a routine in eConnect that would allow me to create a customer number if a customer number does not yet exist. Something like the GetNextSopNumber does, except with Customer IDs. Is this something that is available? I have been unable to locate it anywhere on the web.
Reg: how to get sql server name to pass in eConnect Connection String

Hi,

i am new in eConnect. i need to update itempricelist using eConnect.  i have just hardcoded the connection string value like sqlserver name, user id and password as below

data source=g6;initial catalog=two;integrated security=SSPI;persist security info=False;packet size=4096

it is working fine. but i need to get sql server name, database name dynamically. global function offers database but not sql server name. eConnect is not supporting DSN Connection string. please let me know how to fix it?

Best Regards,
P.Saravanan

 

 

 

 
Cannot find Application.CollectionsManagement.dll

We have a .NET VS Tools customization developed for Dynamics 9 by a vendor that we are now trying to just recompile for Dynamics 10.  This customization traps the Save event on a couple of the collections management windows so that when someone puts a customer on hold it sends an Email to the salesperson assigned on the customer card.

However, we cannot get this to compile on a Dynamics 10 machine.  We've removed Dynamics 9 completely and installed Dynamics 10 and the VS Tools SDK and all current patches.  We have removed and re-added all the references and all other DLL libraries are present - except Application.CollectionsManagement.dll.

This DLL file is nowhere to be found and not listed in the .NET assemblies list in VS.

Checked Dynamics GP (Programs & Features) and "Collections Management" option is installed under Dynamics.

Anybody know where the Applications.CollectionsManagement.dll file has gone to in Dynamics 10?

Thanks,
Bob

Ship Method Shipping Type of "Pickup" causes NULL field errors on Drop Ship POs

This related to GP10 SP2, eConnect 10 SP2

 I just spent 6 hours troubleshooting an unbelievably obscure eConnect error / bug, so I thought I would share.

A PO integration that has been working fine processing several thousand transactions over the last 5 months suddenly gets this error when trying to import a Drop Ship PO:

Cannot insert the value NULL into column 'CONTACT', table 'PROD.dbo.POP10110'; column does not allow nulls. INSERT fails.
The statement has been terminated.

 
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