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

 

This piece of sample code will show how to display a PDF in an ASP.NET web page

I know, you don't need this right now... but you might later. Follow the link above to the menu page and look at where the link is, and it'll be there when you need it. 

Today we received a requirement to add a line to existing POs. The need is to scan the open POs at an interval and if the PO does not have a line for 'xxx', add it. 

How would you do it? What approach would you use?

My approach is below 

From a user: 

When I’m looking at the DEX_ROW_TS column the time is GMT, correct?

This code snippet will hide the close button on a Telerik Winforms RadDock control

Someone brought up something a little while ago about decrypting stored procedures, and I don't see a post on the method that I use most, so...

 

https://www.devart.com/dbforge/sql/sqldecryptor/

We do have a piece of code that will decrypt

http://dyndeveloper.com/ArticleView.aspx?ArticleID=39

but... I always use the free SQL Decryptor product from Devart. It works perfectly

This is a helper function to use when coding extender inserts. 

The user supplies the window id and field name and the field id is returned

 

Is there a way to add line items to an existing timesheet header record using eConnect? 

Hi everyone,

I'm trying to figure out how to delete line items off of an invoice and have already come up with the code to do so.

The problem I'm having is that it can only delete one line at a time per eConnect document.

According to Visual Studio its telling me that the 'taSopLineDelete' property of the 'SOPDeleteLIneType Class' will not accept an array of objects and even when I separate it into separate declarations it only deletes the last item number in the array of objects.

ex. 

            SOPDeleteLineTypeObj.taSopLineDelete = itemArray[0];
            SOPDeleteLineTypeObj.taSopLineDelete = itemArray[1];

In this case the values of object itemArray[1] are the only values present in the xml, thus that is the only item that get's deleted off of the invoice.

Does anyone know how to get this to work with multiple line items on the same eConnect Doc?

I've only seen examples here on DynDeveloper of the functions deleting 1 line item.

The Microsoft documentation explicitly states that the 'taSopLineDelete' property describes "A collection of nodes that remove one or more sales invoice lines".

If this is true then how come it won't accept an array of the relevant objects?

 

I can post the code or XML if required but it won't be anything different from what all of you have seen before.

Any help is appreciated and thanks again.

I'm trying to list all GP company database names and current versions via SQL query. We have over 200 company databases and would like a query to monitor what databases have been upgraded. We are upgrading from 2015 to 2018.

Thanks You,

Jeff S.

I am having issues trying to get the below XML imported using eConnect, Dynamics GP 2016 R2.

taPopEnterMatchInvToShpMultiLine is returning a "divide by zero" error, as I can't access that stored procedure I am not exactly sure what is causing it? 

Any help appreciated.

<eConnect>
    <POPEnterMatchInvoiceType>
        <eConnectProcessInfo />
        <taPopRcptLineTaxInsert_Items>
            <taPopRcptLineTaxInsert>
                <VENDORID>C039</VENDORID>
                <POPRCTNM>RCTC039-TEST02</POPRCTNM>
                <TAXDTLID>UKVAT-P20</TAXDTLID>
                <TAXTYPE>0</TAXTYPE>
                <ACTINDX>33</ACTINDX>
                <ACTNUMST>00-3210</ACTNUMST>
                <TAXAMNT>2.82</TAXAMNT>
                <TAXPURCH>14.10</TAXPURCH>
                <TOTPURCH>14.10</TOTPURCH>
                <RCPTLNNM>16384</RCPTLNNM>
            </taPopRcptLineTaxInsert>
        </taPopRcptLineTaxInsert_Items>
        <taPopEnterMatchInvLine_Items>
            <taPopEnterMatchInvLine>
                <POPRCTNM>RCTC039-TEST02</POPRCTNM>
                <PONUMBER>PO1681200</PONUMBER>
                <QTYINVCD>99</QTYINVCD>
                <ITEMNMBR>06100070</ITEMNMBR>
                <VENDORID>C039</VENDORID>
                <UNITCOST>0.14244</UNITCOST>
                <EXTDCOST>14.1</EXTDCOST>
                <TAXAMNT>2.82</TAXAMNT>
                <Purchase_IV_Item_Taxable>3</Purchase_IV_Item_Taxable>
                <Purchase_Site_Tax_Schedu>1PURSTD</Purchase_Site_Tax_Schedu>
                <NONINVEN>0</NONINVEN>
                <CURNCYID>EUR</CURNCYID>
            </taPopEnterMatchInvLine>
        </taPopEnterMatchInvLine_Items>
        <taPopEnterMatchInvToShpMultiLine_Items>
            <taPopEnterMatchInvToShpMultiLine>
                <POPRCTNM>RCTC039-TEST02</POPRCTNM>
                <POPMtchShpRcpt>RCT1967094</POPMtchShpRcpt>
                <QTYINVCD>49</QTYINVCD>
                <ITEMNMBR>06100070</ITEMNMBR>
                <VENDORID>C039</VENDORID>
                <NONINVEN>0</NONINVEN>
            </taPopEnterMatchInvToShpMultiLine>
            <taPopEnterMatchInvToShpMultiLine>
                <POPRCTNM>RCTC039-TEST02</POPRCTNM>
                <POPMtchShpRcpt>RCT1967095</POPMtchShpRcpt>
                <QTYINVCD>50</QTYINVCD>
                <ITEMNMBR>06100070</ITEMNMBR>
                <VENDORID>C039</VENDORID>
                <NONINVEN>0</NONINVEN>
            </taPopEnterMatchInvToShpMultiLine>
        </taPopEnterMatchInvToShpMultiLine_Items>
        <taPopEnterMatchInvHdr>
            <POPRCTNM>RCTC039-TEST02</POPRCTNM>
            <VNDDOCNM>C039-TEST02</VNDDOCNM>
            <Receiptdate>2020-09-18</Receiptdate>
            <BACHNUMB>EDI</BACHNUMB>
            <VENDORID>C039</VENDORID>
            <SUBTOTAL>14.1</SUBTOTAL>
            <TAXAMNT>2.82</TAXAMNT>
            <TAXSCHID>1PURSTD</TAXSCHID>
            <CURNCYID>EUR</CURNCYID>
        </taPopEnterMatchInvHdr>
    </POPEnterMatchInvoiceType>
</eConnect>

 

Is there a way to get GP to post Revenue Recognition entries to the GL in detail.  We are currently seeing only summary entries which is making it difficult / impossible to reconcile to the PA tables.

 

It seems that when using taPopEnterMatchInvToShpMultiLine to match an invoice line to multiple shipments the ACCRUED distribution amount is being duplicated, I have 2 lines so its doubled the amount.

A bit of "Googling" and it seems that taPOPCreateDistributions may have a bug, does anybody have a working version of this stored procedure? I have decrypted but can't work out where it's going wrong.

Hi,

I am the sa and I need to restrict users from accessing the Integration Manager.

See the screen shot below:

I want them to ONLY 'Run Integration'.

Can someone please tell me how to restrict this in security set up? GP2013

Thanks

Paul







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