DynDeveloper.com

Before I launch into this cool trick, let me remind you that we're a community. Few people do what we do. Let's help each other. If you find a cool trick like this one, or a nice piece of code please click on the 'Write an Article' link above and share.

Besides, it's pretty cool to be at Convergence and have someone pump your hand and tell you how much you've helped them.

<end of diatribe><smiles/>

This is sooo cool! I've cut and pasted code into a text editor for years to use 'Block Selection'. Like this:

See how that area in the middle is selected?! You can now copy, or delete, or whatever.

So, you've modified a form and added a button (not covered here)

Then, you've run Dag.exe against your GP installation

Then, you copied Application.MicrosoftDynamicsGP.ModifiedForms to your bin folder and set a reference to it

Now, we'll show you the code that will allow you to handle a custom button click. The code here is specific to one custom button added to one GP form, you'll have to edit those things for your form.

We received a request in to make the Payment Terms field in the Vendor Options form a required field. We'll show the way that it's supposed to work (and it didn't), then we'll show a work-around using VBA.

We got in a support case here at 4Penny yesterday that was blog-worthy, so I thought I'd write it up.

It happens that your clients have characters in their data that eConnect won't accept. The errors that you get are various, but they point to data that's legal in Dynamics but not in XML.

Hello,

I have multi-bin enabled and am trying to transfer serial item from one bin/location to another bin/location.  I am getting the error "Error Number = 5234 Stored Procedure= taIVTransferMultiBinInsert Error Description = The quantity passed in for Multi Bin is > what was passed to the line
Node Identifier Parameters: taIVTransferMultiBinInsert"

Am I taking the correct approach in formatting this?  Any help is appreciated.  Thank you

Here is my XML:

<?xml version="1.0" encoding="utf-8"?>
<eConnect
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <IVInventoryTransferType>
        <eConnectProcessInfo xsi:nil="true" />
        <taRequesterTrxDisabler_Items xsi:nil="true" />
        <taUpdateCreateItemRcd xsi:nil="true" />
        <taIVTransferSerialInsert_Items>
            <taIVTransferSerialInsert>
                <IVDOCNBR>21015</IVDOCNBR>
                <ITEMNMBR>100BP</ITEMNMBR>
                <SERLNMBR>AABB9               </SERLNMBR>
                <LNSEQNBR>1</LNSEQNBR>
                <LOCNCODE>103G</LOCNCODE>
                <BIN>101</BIN>
                <TOBIN>100            </TOBIN>
                <TOLOCNCODE>103B</TOLOCNCODE>
            </taIVTransferSerialInsert>
            <taIVTransferSerialInsert>
                <IVDOCNBR>21015</IVDOCNBR>
                <ITEMNMBR>100BP</ITEMNMBR>
                <SERLNMBR>AABB10              </SERLNMBR>
                <LNSEQNBR>1</LNSEQNBR>
                <LOCNCODE>103G</LOCNCODE>
                <BIN>101</BIN>
                <TOBIN>100            </TOBIN>
                <TOLOCNCODE>103B</TOLOCNCODE>
            </taIVTransferSerialInsert>
        </taIVTransferSerialInsert_Items>
        <taIVTransferLotInsert_Items xsi:nil="true" />
        <taIVTransferLineInsert_Items>
            <taIVTransferLineInsert>
                <IVDOCNBR>21015</IVDOCNBR>
                <ITEMNMBR>100BP</ITEMNMBR>
                <LNSEQNBR>1</LNSEQNBR>
                <TRXQTY>2.00</TRXQTY>
                <UNITCOST>10.0000</UNITCOST>
                <TRXLOCTN>103G</TRXLOCTN>
                <TRNSTLOC>103B</TRNSTLOC>
            </taIVTransferLineInsert>
        </taIVTransferLineInsert_Items>
        <taAnalyticsDistribution_Items xsi:nil="true" />
        <taIVTransferMultiBinInsert_Items>
            <taIVTransferMultiBinInsert>
                <IVDOCNBR>21015</IVDOCNBR>
                <ITEMNMBR>100BP</ITEMNMBR>
                <LNSEQNBR>1</LNSEQNBR>
                <BIN>101</BIN>
                <TOBIN>100            </TOBIN>
                <QUANTITY>1.00</QUANTITY>
                <SERLTNUM>AABB9               </SERLTNUM>
            </taIVTransferMultiBinInsert>
            <taIVTransferMultiBinInsert>
                <IVDOCNBR>21015</IVDOCNBR>
                <ITEMNMBR>100BP</ITEMNMBR>
                <LNSEQNBR>1</LNSEQNBR>
                <BIN>101</BIN>
                <TOBIN>100            </TOBIN>
                <QUANTITY>1.00</QUANTITY>
                <SERLTNUM>AABB10              </SERLTNUM>
            </taIVTransferMultiBinInsert>
        </taIVTransferMultiBinInsert_Items>
        <taIVTransferHeaderInsert>
            <BACHNUMB>ALERT 21015</BACHNUMB>
            <IVDOCNBR>21015</IVDOCNBR>
            <DOCDATE>4/1/2016</DOCDATE>
        </taIVTransferHeaderInsert>
    </IVInventoryTransferType>
</eConnect>

Hi, 

We have a user who needs to be able to put a customer on Hold by checking the Hold box on the customer card.

Currently, only Powerusers have this ability and we do not want to make the user a Poweruser.   What security areas does this user need to have in order to be able to do this function?  She is an accounting manager, AR clerk, customer service rep, and an order processor right now.

When she clicks the Hold button, she gets an error:  

Unhandled database exception:

A save operation on table 'RM_Customer_MSTR' failed accessing SQL data.

Thank you.

K. Koehle

Necesito imprimir una listado de todos los Smarlist Creados por nosotros, no no los originarios de gp.

Es esto Posible?

I need to print a list of all Smarlist Created by us, not those from gp. Is that possible?

I'm trying to create a PO using eConnect.  I need to populate POP10110.JOBNUMBR but taPoLine_ItemsTaPoLine doesn't seem to offer a corresponding property.  Am I missing anything?

 I'm using GP2015 and I've tried eConnect 12 & 14.

Thank you, James

 The documentation for the taBankTransactionHeader node says "This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank."  (https://msdn.microsoft.com/en-us/library/jj193288.aspx) However, I am having difficulty getting updates to work.

Basically, if I create a BRBankTransactionType and send it to econnect via the CreateTransactionEntity() method, it creates an entry in the CM20200 table as expected, with the proper checkbook ID and check number.   It creates the one required distribution, and I am creating the matching distribution for the proper account.  From the documentation, I expected that using the UpdateTransactionEntity() method would allow me to update the transaction, assuming that the checkbook ID and check number matched an existing record.  The actual behavior is that using UpdateTransactionEntity() creates a second record in CM20200, so that I now have duplicate records with the same checkbook ID and check number, exactly the same as if I had used CreateTransactionEntity().  Using DeleteTransactionEntity() gives the same result.

 What am I doing wrong, here?  I could use BRBankTransactionVoidType to void the check and then re-enter it, however a) I'm not sure how that will work with Positive Pay (i.e. will the void and the re-entry be sent in the same batch?), and b) there will be a problem if duplicate checkbookID-checknumber records already exist - the void will fail, requiring a control number, and I'm not sure how it should be handled.  I would prefer to just update the existing record.

Error: PO Status for Header and Line items do not match

Hello all,

Having trouble retrieving the vendor item key using GP web services.  The system throws out a system exception 'There is an error in XML document(1, 980).' This happens in line 2 in the code excerpt below:

ItemVendorKey itemVendorKey = new ItemVendorKey() {ItemKey = new ItemKey() { Id = item }, VendorKey = new VendorKey() { Id = vend }};
ItemVendor itemVendor = wsDynamicsGP.GetItemVendorByKey(itemVendorKey, context);
itemVendor.VendorItemNumber = vitem;

Stack Trace:

   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
   at Microsoft.Dynamics.GP.EConnectAdapter.GetByKey(IKey key, Context context, Type type)
   at Microsoft.Dynamics.GP.GreatPlainsBusinessService.GetByKeyFromSource(Key key, Context context, Type type)
   at Microsoft.Dynamics.Common.BusinessService.GetByKey(Key key, Context context, Type[] types)

Request XML:

<?xml version="1.0"?>
<RequestObjects>
  <ItemVendorKey xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <ItemKey>
      <Id>86549</Id>
    </ItemKey>
    <VendorKey>
      <Id>351</Id>
    </VendorKey>
  </ItemVendorKey>
  <Context xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/dynamics/2006/01">
    <OrganizationKey xsi:type="CompanyKey">
      <Id>9</Id>
    </OrganizationKey>
    <CultureName />
    <CurrencyType>Transactional</CurrencyType>
    <RoleKey>
      <Id xmlns="http://schemas.microsoft.com/dynamics/security/2006/01">e18b321a-9548-48fb-b75a-dee0a618ddaa</Id>
    </RoleKey>
    <TenantName />
  </Context>
  <string>Microsoft.Dynamics.GP.ItemVendor</string>
</RequestObjects>

Thank you in advance!

Mike

Sample code relating to the GridViewImageColumn