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

 
Integration Manager - How to concatonate comment fields

The client has an existing Integration Manager integration and wants to concatenate two source fields into the SOP Line Comments. This short article will show how to do it.

                       

SQL - Removing all non printable characters from a SQL field

I have an existing piece of code at a customer (a law firm) that takes a set of data and transforms it into an XML document and transfers it to another system. I'm using CDATA to encapsulate the notes field, because there's a lot of trouble in there. 

That has been working fine for several years, but this week a user entered an odd character (¬) in the data and it crashed the XML. I was getting XML parsing: line 1, character 265, illegal xml character errors.

So, I wrote a trigger that scrubs SY03900 and dis-allows any characters except normal keyboard characters, and the Carriage Return and Line Feed characters.

I tested the trigger using this string:

!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþÿ

 

                       

eConnect - Sample XML for the BRBankTransactionType

This article contains a sample XML document for the BRTransactionType eConnect document. It contains the taBRBankTransactionDist and taBRBankTransactionHeader nodes
eConnect - Sample CODE for the BRBankTransaction eConnect document

This article contains a complete working code sample for the eConnect BRBankTransaction document.

SQL - View Template

This article contains code for a SQL view template.

I work for 4 or 5 customers a day on support calls; I don't have the luxury of setting up SQL Server SSMS the way that I like it and coding blissfully.

A basic task for me would be creating a view; but I really don't like the templates that come with SQL. So, here's my template.

SSRS - Add an existing SSRS report to the 'reports' menu in Dynamics GP

The task here is to launch an existing custom SSRS report from inside of Dynamics GP. This code was tested against GP2010.

The screen shot above shows the Sales desktop with the Report List option selected. The Sales Report Summary report was added using the technique outlined below.

                       

Modified linescroll of Sales Transaction Entry

Hi All,

 

I have a modified Sales Tranaction Entry window with some extra fields in the linescroll grid.  I need to populate these field when order number changes or update after user has entered a new value. I am trying to use linescroll events in order to first find lineItemSeuence but without success. Is there any other event that can accomplish this?

 

Thanks,

 

Anila
GP2010 Project Accounting Inventory Transfer without eConnect

Hello,

We are trying to transfer an inventory item to a Project in Project Accounting(PA) and have resorted to using SQL profiler to try and reproduce the actions taken by GP2010 to simulate the process.  It seems there are no eConnect schema/node combinations to perform this operation for us but I still believe there may be a better way then manually brute-forcing our way through.  I was told to extend eConnect by producing a new custom node but this would still require an in-depth understanding of what is happening behind the scenes of GP and Dexterity while building the necessary stored procedures.  Any suggestions or advice?

 

Thanks in advance,

Dave
Error 62 Tax table detail does not equal the tax amount

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

I have the following XML to enter 1 line item  $199.95  with 7% Tax:

<?xml version="1.0" encoding="UTF-8"?>
    <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>2</SOPTYPE>
                <SOPNUMBE>WS100000352</SOPNUMBE>
                <CUSTNMBR>WS100000352</CUSTNMBR>
                <DOCDATE>2013-12-07</DOCDATE>
                <ITEMNMBR>RE1000-SC</ITEMNMBR>
                <UNITPRCE>199.95</UNITPRCE>
                <XTNDPRCE>199.95</XTNDPRCE>
                <QUANTITY>1.00</QUANTITY>
                <MRKDNAMT>0.0000</MRKDNAMT>
                <ITEMDESC>RE1000 Scanner Combo - Internet Only Special!</ITEMDESC>
                <DOCID>SLSORD</DOCID>
                <ReqShipDate>2013-12-07</ReqShipDate>
                <TOTALQTY>1.00</TOTALQTY>
            </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
        <taSopLineIvcInsertComponent_Items xsi:nil="true"/>
        <taSopTrackingNum_Items xsi:nil="true"/>
        <taSopCommissions_Items xsi:nil="true"/>
        <taSopLineIvcTaxInsert_Items>
            <taSopLineIvcTaxInsert>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>WS100000352</SOPNUMBE>
                <CUSTNMBR>WS100000352</CUSTNMBR>
                <SALESAMT>199.9500</SALESAMT>
                <TAXDTLID>NJ - 7%</TAXDTLID>
                <STAXAMNT>14.00</STAXAMNT>
            </taSopLineIvcTaxInsert>
        </taSopLineIvcTaxInsert_Items>
        <taCreateSopPaymentInsertRecord_Items>
            <taCreateSopPaymentInsertRecord>
                <SOPTYPE>2</SOPTYPE>
                <SOPNUMBE>WS100000352</SOPNUMBE>
                <CUSTNMBR>WS100000352</CUSTNMBR>
                <CUSTNAME>lois gardner</CUSTNAME>
                <DOCDATE>2013-12-07</DOCDATE>
                <DOCAMNT>213.95</DOCAMNT>
                <CARDNAME>Authorize.net</CARDNAME>
                <PYMTTYPE>6</PYMTTYPE>
            </taCreateSopPaymentInsertRecord>
        </taCreateSopPaymentInsertRecord_Items>
        <taSopUserDefined xsi:nil="true"/>
        <taSopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taSopMultiBin_Items xsi:nil="true"/>
        <taSopHdrIvcInsert>
            <SOPTYPE>2</SOPTYPE>
            <DOCID>SLSORD</DOCID>
            <SOPNUMBE>WS100000352</SOPNUMBE>
            <TAXSCHID>NJ - 7%</TAXSCHID>
            <SHIPMTHD> FREE SHIPPING</SHIPMTHD>
            <TAXAMNT>14.00</TAXAMNT>
            <LOCNCODE>RE MAIN</LOCNCODE>
            <DOCDATE>2013-12-07</DOCDATE>
            <CUSTNMBR>WS100000352</CUSTNMBR>
            <CUSTNAME>lois gardner</CUSTNAME>
            <ShipToName>lois gardner</ShipToName>
            <ADDRESS1>55 ashwood dr </ADDRESS1>
            <CITY>brick </CITY>
            <STATE>New Jersey </STATE>
            <ZIPCODE>08723 </ZIPCODE>
            <COUNTRY>US </COUNTRY>
            <SUBTOTAL>199.9500</SUBTOTAL>
            <DOCAMNT>213.95</DOCAMNT>
            <PYMTRCVD>213.95</PYMTRCVD>
            <SLPRSNID>Web</SLPRSNID>
            <BACHNUMB>READY TO SHIP</BACHNUMB>
            <PYMTRMID>COD - Cash</PYMTRMID>
            <ReqShipDate>2013-12-07</ReqShipDate>
        </taSopHdrIvcInsert>
        <taSopToPopLink xsi:nil="true"/>
        <taSopUpdateCreateProcessHold xsi:nil="true"/>
        <taCreateSOPTrackingInfo xsi:nil="true"/>
        <taMdaUpdate_Items xsi:nil="true"/>
    </SOPTransactionType>
</eConnect>
 

Why am I getting the error:

 

Error Number = 62  Stored Procedure= taSopHdrIvcInsert  Error Description = Tax table detail does not equal the tax amount 







What makes a record unique in GL20000/GL30000
Hello,
What field(s) makes a record unique in th GL20000/GL30000 tables?
Invalid characters when when opening a dex form via a modal .net form

 

Hi Guys,

I have set up a .net form button to open an existing dexterity lookup form based on the lookup samples but once the lookup window is opened and I type something in my lookup field, tab, backspace etc don't work and I get funny characters come up see below. This only happens if the .net form that calls the lookup is opened modally eg showdialog(). 


Any help would be appreciated and no I can't just open my .net form modeless.

Cheers

 
EmployeeSummary view question

hi all,

I am building an employee website so that employees can log in and get their paystub info, view vacation balances, change contact information, etc....

I know this is what the business portal does, but I don't want to expose sharepoint and the business portal to the public.  so I am making a website in an asp.net website.

my main question at this point is:  where does the info on the employee pay detail page come from?  is this one or more stored procs, or is the page doing a lot of processing to show the pay stub?

http://mySharepointSite/BusinessPortal/Applications/Hrm/PayCheckDetailView.aspx      ?auditcontrolid=UPRCC00000520   &   paymentnumber=29434#

I tried to find this page, but it looks like it is compiled.

thanks!
Configure Fabrikam to Accept Project Accounting Employee Expenses

Howdy,

I'm writing an integration that utilizes Entity Framework, to pull data from GP, and then utilizes eConnect to create Time and Expense records.  The Fabrikam database comes with the Project Accounting module installed, but the employees are not configured to be able to accept expenses.  If I try to create an expense either via the UI or via eConnect, I get the same error, that the employee does not have a vendor record.  I've gone through the GP admin documentation, but its pretty cryptic and a number of the paths that are spelled out don't actually work or exist.  

Has anyone out there successfully configured the Fabrikam db to allow Project Accounting users to be able to create expense records.  If yes, can you please explain how to do this?  Pointing me to GP documentation won't be much help...

Thanks
Table SVC3500.RMA_Status Field

Does anyone know what the values  10, 20, etc., mean in table SVC35000, field RMA_Status?
ASP.NET - RadGrid - Confirm Delete
This code sample shows how to get a 'Confirm Delete?' popup on an ASP.NET radgrid                       
Winforms - committing the new row
I had an issue with the user clicking on the 'save' button before getting off the new row, and the new row would not save.                        
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 | Anchored Marriage
3