DynDeveloper.com

Sql procedure error codes returned:

Error Number = 11992  Stored Procedure=   Error Description = Error Codes were not found in table DYNAMICS..taErrorCode. Please insure that the table taErrorCode is up to update. 11992

<taPMDistribution>
  <DOCTYPE>1</DOCTYPE>
  <VCHRNMBR>00000000001007805</VCHRNMBR>
  <VENDORID>028029         </VENDORID>
  <DSTSQNUM>376832</DSTSQNUM>
  <DISTTYPE>1</DISTTYPE>
  <ACTNUMST>00-000-1063</ACTNUMST>
  <CRDTAMNT>1787.77000</CRDTAMNT>
</taPMDistribution>

You just gotta love 'no error description', right?

One of our external systems generates numerous output files into a format that are swept up nightly by a Dynamics integration.

As a result there are batches that then need to be manually processed, each time a batch is processed the posting journal is printed to .pdf and saved to a directory. As a company we are attempting to streamline our closing process and looking for ways to do this.

One suggestion has been to have the Integration post all of the batches and print each posting journal to the specific directory. Upon observing the processand asking questions I discovered that the batch names change daily using the date name convention. I looked at eOnes tools however that works for specifically named batches so that a filter or condition can be set, this will not work for us. Is this even possible to automate and remove the human element with the exception of having an individual only be involved should there be an error log?

Thank you

Mark

Hi I am creating an XML file that is posted via eConnect.  It is all seemingly working except this validation error, and I can't really figure out why.  Here is my code, this basically creates an xml file.  I've tried all sorts of decimal places for unit cost.  Have even created a record in dynamics, looked up DECPLCUR which is 9, and still it doesn't want to validate.  What am I missing?

POPReceivingsType oPOPReceivingsType = new POPReceivingsType();
                taPopRcptHdrInsert invoiceHeader = new taPopRcptHdrInsert();
                taPopRcptLineInsert_ItemsTaPopRcptLineInsert line1=new taPopRcptLineInsert_ItemsTaPopRcptLineInsert();
                taPopRcptLineInsert_ItemsTaPopRcptLineInsert line2 = new taPopRcptLineInsert_ItemsTaPopRcptLineInsert();

                invoiceHeader.POPRCTNM = "R000094";
                invoiceHeader.POPTYPE = 3;  //Shipping/invoice
                invoiceHeader.VNDDOCNM = "8751";
                invoiceHeader.VENDORID = "LEAFRIVE0001";// "TAN002";
                invoiceHeader.VENDNAME = "Leaf River Paging Systems";//Tank2Create";
                invoiceHeader.CURNCYID = "GBP";
                invoiceHeader.SUBTOTAL = Convert.ToDecimal(123.2);
                invoiceHeader.TAXAMNT = Convert.ToDecimal(24.64);
                invoiceHeader.TAXSCHID = "PSTD";
                invoiceHeader.PYMTRMID = "30 Days";
                invoiceHeader.receiptdate = DateTime.Now.ToString("dd/MM/yyyy");
                
                oPOPReceivingsType.taPopRcptHdrInsert = invoiceHeader;

                //add lines
                line1.POPTYPE = 3;
                line1.POPRCTNM = "R000094";
                line1.CURNCYID = "GBP";
                line1.NONINVEN = 1;
                line1.ITEMNMBR = "LANYARDS x 30";
                line1.ITEMDESC = "LANYARDS x 30";
                line1.UOFM = "Each";
                line1.QTYINVCD = 1;
                line1.QTYSHPPD = 1;
                line1.UNITCOST = Decimal.Parse("43.200000000");
                line1.EXTDCOST = Decimal.Parse("43.200000000");
                line1.UNITCOSTSpecified = true;
                line1.RCPTLNNM = 1;
                line1.VENDORID = "LEAFRIVE0001";
                line1.LOCNCODE = "01-N";
                line1.INVINDX = 1;
                

                line2.POPTYPE = 3;
                line2.POPRCTNM = "R000094";
                line2.CURNCYID = "GBP";
                line2.NONINVEN = 1;
                line2.INVINDX = 2;
                line2.ITEMNMBR = "A5 MEET THE TEAM INVITES";
                line2.ITEMDESC = "A5 MEET THE TEAM INVITES";
                line2.UOFM = "Each";
                line2.QTYINVCD = 1;
                line2.QTYSHPPD = 1;
                line2.UNITCOST = Decimal.Parse("80.000000000");
                line2.UNITCOSTSpecified = true;
                line2.EXTDCOST = Decimal.Parse("80.000000000");
                line2.RCPTLNNM = 2;
                line2.VENDORID = "LEAFRIVE0001";
                line2.LOCNCODE = "01-N";

                oPOPReceivingsType.taPopRcptLineInsert_Items = new taPopRcptLineInsert_ItemsTaPopRcptLineInsert[2];

                oPOPReceivingsType.taPopRcptLineInsert_Items[0] = line1;
                oPOPReceivingsType.taPopRcptLineInsert_Items[1] = line2;

 

                eConnectType eConnect = new eConnectType();

                eConnect.POPReceivingsType = new POPReceivingsType[1];
                eConnect.POPReceivingsType[0] = oPOPReceivingsType;
                // Create a file to hold the serialized eConnect XML document
                FileStream fs = new FileStream(filename, FileMode.Create);
                XmlTextWriter writer = new XmlTextWriter(fs, new UTF8Encoding());

                // Serialize the eConnect document object to the file using the XmlTextWriter.
                XmlSerializer serializer = new XmlSerializer(eConnect.GetType());
                serializer.Serialize(writer, eConnect);
                writer.Close();

Currently our Credit Memos age in Great Plains.
However, CM's have a due date the same date as the credit memo was run. I need to have the due date show up according
to payment terms the same as sales/invoices do.
On Unapplied payments, even though they age, the due date shows on all of them as 1/1/1900. Can this be corrected to
show according to terms as well?

Are these modifications possible?

Hi Guys

I'm receiving this message when I transfer an Order to an Invoice in the Sales transaction Entry Window. But the weird thing is that my company don't use this feature and I have the VAT Daybook disable.

How can this message be appearing ? 

I'm using Dynamics GP 2013 SP1

Thank You

Hello,

 In our company we already import all commissions we pay to our Channel Partners as Payables Invoices using SOAP Webservices

Now we want to import ACH payments from a file returned by our Bank as Manual Payments and .

We don't see this operation on Webservices WSDL, We use linux/PHP on our systems.

Can you please point me to the right mechanism we hace to use to achieve this.

Hello,

 I am experimenting with using eConnect XML to insert / update inventory items. So far my tests have lead me to construct the following message.

<?xml version="1.0" encoding="utf-8"?>
<eConnect>
    <IVItemMasterType>
        <taUpdateCreateItemRcd>
            <ITEMNMBR>ITEMXVII</ITEMNMBR>
            <ITEMDESC>Test SKU</ITEMDESC>
            <ITEMTYPE>1</ITEMTYPE>
            <ITMGEDSC>411</ITMGEDSC>
            <ITMCLSCD>411</ITMCLSCD>
            <UOMSCHDL>SEATS</UOMSCHDL>
            <PRCHSUOM/>
            <USCATVLS_1>VAV</USCATVLS_1>
            <USCATVLS_2>411</USCATVLS_2>
            <USCATVLS_3>DC020502</USCATVLS_3>
            <USCATVLS_4>NEW</USCATVLS_4>
            <USCATVLS_5>BUSINESS</USCATVLS_5>
            <USCATVLS_6>12</USCATVLS_6>
            <PriceGroup>STD</PriceGroup>
            <PRICMTHD>1</PRICMTHD>
            <Purchase_Tax_Options>3</Purchase_Tax_Options>
            <INACTIVE>0</INACTIVE>
            <LOCNCODE>TTS</LOCNCODE>
            <UseItemClass>0</UseItemClass>
            <UpdateIfExists>1</UpdateIfExists>
        </taUpdateCreateItemRcd>
    </IVItemMasterType>
</eConnect> 

However this message fails with the following cryptic error:

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'IVSCRVIX', table 'TTS.dbo.IV00101'; column does not allow nulls. INSERT fails.
The statement has been terminated.

 Is this un-documented column mapped to an XML element?What does it normally hold?

 Am I missing any elements or structure in the above XML message?

 Thanks

 Stephen