DynDeveloper.com

It's that time of the year...year end closing.  A prerequisite in year end closing is the Payroll Tax Update.  Have you received this error message?

The solution is quite simple - only 3 simple steps.

In this article we show how to craft a SQL script that will run against all the company databases in a Dynamics GP installation. Very cool stuff, read on.

I came across an interesting question and decided to write an article about it.  Create a calculated field, in report writer, to shorten the company name.  I kept getting errors with the following: Function_Script (RW_Left Company Name 3).  My goal was to shorten the company name to the left 3 characters. 

I'm getting the error

The security object does not exist.  Key = 25cc1a21-2cc4-4b13-a1c8-eea186fb688a

when upgrading an instance of Web Services for GP2013

This article discusses the fix

Today I had to solve the mystery of the following error:

I am attempting to create a purchase receipt as a precursor to creating an invoice matched to a PO. I.E. "2 way matching".

I am using eConnect 12 on GP2013. I will be attempting to use this same code on GP2010 and GP2015, so if there are any additional changes I need to do to make this work on those as well, that would be helpful.

 The POPRCTNM I am using here (I assume should be the number for the shipping receipt I am creating, which I obtained using the

GetNextDocNumbers.GetNextPOPReceiptNumber() function.

The eConnect XML I am sending is:

I am getting the following error:

ERROR: Error updating POPRcptHdr for PO - PO0997 - Invalid object name 'PA01303'.

I am new to both GP and eConnect, so bear with me as I try to understand whatever answer you may give.

Thanks.

OK, here we go.  This is a long one.  I've gotten past my original error in creating the shipping receipt.

That said, The shipping receipt, RCT1185, got successfully created.  HOWEVER, it seems like GP created TWO shipping receipts for some reason: The one I requested, RCT1185, and an identical one pointing to the same PO, RCT1187 (This is NOT an invoice receipt - it's a shipping receipt).  I'm not sure if this happened when I created the shipping receipt transaction, or when I later sent the invoice with the RCT1185 shipping receipt referenced. I know I didn't create two of them, because if I had, it would be in my application log.

The receipt was created successfully. However, when I tried to create the invoice, I got the following error:

ERROR: Error updating EnterMatchInvHdr for PO - PO2075 - Sql procedure error codes returned:

Error Number = 4852  Stored Procedure= taPopEnterMatchInvLine  Error Description = Shipment Line Item does not exist to match Invoice against
Node Identifier Parameters: taPopEnterMatchInvLine
POPRCTNM = RCT1186
PONUMBER = PO2075
POLNENUM = 16384
Related Error Code Parameters for Node : taPopEnterMatchInvLine
PONUMBER = PO2075
POPMtchShpRcpt = RCT1187
ShipRCPTLNNM = 16384
ITEMNMBR = 256 SDRAM
VENDORID = COMVEXIN0001

<taPopEnterMatchInvLine>
  <POPRCTNM>RCT1186</POPRCTNM>
  <POPMtchShpRcpt>RCT1187</POPMtchShpRcpt>
  <ShipRCPTLNNM>16384</ShipRCPTLNNM>
  <PONUMBER>PO2075</PONUMBER>
  <QTYINVCD>1.00000</QTYINVCD>
  <ITEMNMBR>256 SDRAM</ITEMNMBR>
  <VENDORID>COMVEXIN0001</VENDORID>
  <UNITCOST>0</UNITCOST>
  <EXTDCOST>0</EXTDCOST>
  <AUTOCOST>1</AUTOCOST>
  <POLNENUM>16384</POLNENUM>
< /taPopEnterMatchInvLine>

For reference, here is the shipping receipt transaction I sent:

<?xml version="1.0"?>
< eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
     <POPReceivingsType>
          <eConnectProcessInfo xsi:nil="true" />
          <taRequesterTrxDisabler_Items xsi:nil="true" />
          <taUpdateCreateItemRcd xsi:nil="true" />
          <taUpdateCreateVendorRcd xsi:nil="true" />
          <taCreateVendorAddress_Items xsi:nil="true" />
          <taPopRcptLotInsert_Items xsi:nil="true" />
          <taPopRcptSerialInsert_Items xsi:nil="true" />
          <taPopRcptLineInsert_Items>
               <taPopRcptLineInsert>
                    <POPTYPE>1</POPTYPE>
                    <POPRCTNM>RCT1185</POPRCTNM>
                    <PONUMBER>PO2075</PONUMBER>
                    <ITEMNMBR>256 SDRAM</ITEMNMBR>
                    <VENDORID>COMVEXIN0001</VENDORID>
                    <RCPTLNNM>16384</RCPTLNNM>
                    <VNDITNUM>256 SDRAM</VNDITNUM>
                    <QTYSHPPD>1.00000</QTYSHPPD>
                    <AUTOCOST>1</AUTOCOST>
                    <POLNENUM>16384</POLNENUM>
               </taPopRcptLineInsert>
          </taPopRcptLineInsert_Items>
          <taPopRcptMultiBin_Items xsi:nil="true" />
          <taPopRcptLineTaxInsert_Items xsi:nil="true" />
          <taPopRctUserDefined xsi:nil="true" />
          <taPopDistribution_Items xsi:nil="true" />
          <taAnalyticsDistribution_Items xsi:nil="true" />
          <taPopRcptHdrInsert>
               <POPRCTNM>RCT1185</POPRCTNM>
               <POPTYPE>1</POPTYPE>
               <receiptdate>1/13/2015</receiptdate>
               <BACHNUMB>PAYABLES BATCH </BACHNUMB>
               <VENDORID>COMVEXIN0001</VENDORID>
               <AUTOCOST>1</AUTOCOST>
               <NOTETEXT>http://sp2010dev/tap/Invoices/Invoice2.pdf</NOTETEXT>
               <USRDEFND4>http://sp2010dev/tap/Invoices/Invoice2.pdf</USRDEFND4>
          </taPopRcptHdrInsert>
          <taMdaUpdate_Items xsi:nil="true" />
     </POPReceivingsType>
< /eConnect>

Here is the invoice transaction I sent:

<?xml version="1.0"?>
< eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <POPEnterMatchInvoiceType>
    <eConnectProcessInfo xsi:nil="true" />
    <taRequesterTrxDisabler_Items xsi:nil="true" />
    <taUpdateCreateItemRcd xsi:nil="true" />
    <taUpdateCreateVendorRcd xsi:nil="true" />
    <taCreateVendorAddress_Items xsi:nil="true" />
    <taPopRcptLineTaxInsert_Items xsi:nil="true" />
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopEnterMatchLotInsert_Items xsi:nil="true" />
    <taPopEnterMatchSerialInsert_Items xsi:nil="true" />
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCT1184</POPRCTNM>
        <POPMtchShpRcpt>RCT1185</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>PO2075</PONUMBER>
        <QTYINVCD>1.00000</QTYINVCD>
        <ITEMNMBR>256 SDRAM</ITEMNMBR>
        <VENDORID>COMVEXIN0001</VENDORID>
        <UNITCOST>0</UNITCOST>
        <EXTDCOST>0</EXTDCOST>
        <AUTOCOST>1</AUTOCOST>
        <POLNENUM>16384</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items />
    <taPopEnterMatchInvHdr>
      <POPRCTNM>RCT1184</POPRCTNM>
      <VNDDOCNM>12345-2075</VNDDOCNM>
      <receiptdate>1/13/2015</receiptdate>
      <BACHNUMB>PAYABLES BATCH </BACHNUMB>
      <VENDORID>COMVEXIN0001</VENDORID>
      <SUBTOTAL>0</SUBTOTAL>
      <AUTOCOST>1</AUTOCOST>
      <NOTETEXT>http://sp2010dev/tap/Invoices/Invoice2.pdf</NOTETEXT>
      <USRDEFND4>http://sp2010dev/tap/Invoices/Invoice2.pdf</USRDEFND4>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPEnterMatchInvoiceType>
< /eConnect>

I am trying to simply update a flag in a table to say that I have integrated the integration works but the "After Script" Fails Wrong number of arguments or invalid property assigment"MyCon"

The database is on the GP SQL server but not a GP Database.

'Create a new connection object

Set MyCon = CreateObject("ADODB.Connection")

'Open the connection to the database

MyCon.ConnectionString = "database=Concur"

GPConnection.Open(MyCon)

sSQL = "Update concur.Cash_Amt set IntegrationFlag = '1' where Entity = 'SUS'"

'Execute the stored procedure

Call MyCon(sSQL)

It maybe a permissions thing as the database isn't a GP but any ideas would be appreciated.

Can someone tell me the SQL tables associated with this inquiry window in GP 2013???

Thanks,

I am a beginner with Dynamics GP.  I have worked with somewhat similar systems before but they were still different.  I have learned quite a bit about the tables and can pull the information I need but am having some trouble editing an invoice.  As a staffing service, we bill hours but I cannot find a way to create a line that totals the hours and multiplies by a surcharge.  This would just be an additional line in the purchase order.  From what I understand, it can be done in Report Writer but I just have not gotten to the point where I can do this.  Any help would be greatly appreciated!!!