DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In

Archives

 

I have in the past written a proc that takes a comment field and parses it for use in SOP10106, dividing the one string into four separate strings. The logic is a little more complex than you'd think. 

Today I discovered a native GP script that does the same thing, the script and how to use it are below. 

Dynamics GP Payment Term dates are sometimes difficult to calculate, there are several different types of calcs that are possible. 

This post documents how to call the native taCalcDueDatePM stored procedure, all the calcs are doe for you. 

Dynamics GP Payment Term dates are sometimes difficult to calculate, there are several different types of calcs that are possible. 

This post documents how to call the native taCalcDueDateRM stored procedure, all the calcs are doe for you. 


This is a short piece of T-SQL code that will resequence the lines in a grid. 

The table that we're resequencing has three unique keys, you'll need to adjust the code to work for your table

 

Hi,

I need to import Sales Orders from CRM and our GP environment is using Avalara.

If we use eConnect can we import without worrying about hitting the avalara tables directly?

Thanks!
Mark

Is there an SP for the IV module similar to the taGetSopNumber in SOP module? I'm trying to let it auto generate the IVDOCNBR to avoid duplication. What will be the common practice for this? Thanks!

Microsoft.Dynamics.GP.eConnect

Sql procedure error codes returned:
Error Number = 2052  Stored Procedure taPopRcptLineInsert  Error Description = Purchase order number does not exist
Node Identifier Parameters: taPopRcptLineInsert                                
POPTYPE = 3
POPRCTNM = RCT38227
PONUMBER = ORI01426
ITEMNMBR = PCA0700C051ZA62
Related Error Code Parameters for Node : taPopRcptLineInsert                                
PONUMBER = ORI01426

<taPopRcptLineInsert>
    <POPTYPE>3</POPTYPE>
    <POPRCTNM>RCT38227</POPRCTNM>
    <PONUMBER>ORI01426</PONUMBER>
    <ITEMNMBR>PCA0700C051ZA62</ITEMNMBR>
    <VENDORID>T42216</VENDORID>
    <VNDITNUM>PCA0700C051ZA62</VNDITNUM>
    <QTYSHPPD>25</QTYSHPPD>
    <QTYINVCD>25</QTYINVCD>
    <AUTOCOST>1</AUTOCOST>
    <LOCNCODE>TSHIRT</LOCNCODE>
</taPopRcptLineInsert>

Where in SQL are the table import setups saved?   I need to retrieve some setups in GP2016 that I believe were saved on another workstation that's not available.

Thanks for your assistance.

 

Best Regards,

C34OSC

So here is my problem. I am using C#.NET. We have serialized items in some of our kits and I am trying to fulfill these orders using eConnect. The taSopLineIvcInsertComponent object does not have a serial number property so I can't fulfill them that way. I tried using taSopSerial and I am able to pass a serial number in, but as soon as my kit tries to fulfill it's items, it will autoallocate a serial number. This autoallocation takes place no matter what I have the autoallocateserialnumber flag set. If I attempt to fulfill the serialized item only using the taSopSerial and only process the non-serialized kit components using taSopLineIvcInsertComponent then I'm getting an error stating that I'm not sending an SOPType (which I clearly am.) So, it seems to me that it is wanting that fourth kit item that I am trying to process with taSopSerial. 

My question is this: Is there any example code anywhere that shows how to fulfill a kit that has a serialized component, but will not autoallocate a serial number but allow me to manually pass the serial number? 

 

Thanks,

Lilly Allison

what is the table and the field where the next order number

of the screen is stored (default values of production order preference)

Good morning,

   I need create a relationship but one of the tables does not exist, by example i need a relationship between invoices table and the service call table but the service call table does not exist and I need add this table before. I have GP2016

Any suggestion is welcome.

Mr. Garcia


Hello!

We are creating enter match invoices vie econnect and having issues with inventory line items. When we pass in the below XMLs for noninventory GP is setting the distributions correctly with createdist=1 (meaning we are letting GP create them) when we pass in the same XML for inventory items GP never creates the distribution correctly and will leave out the purchase line or the calculate the wrong variance. We cannot use AUTO cost because the EXT cost can be different, thus the reason for the variance. Any help will be appreciated. 

Noninventory that is working fine

<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <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>
      <taPopRcptLineTaxInsert>
        <VENDORID>XXXXX</VENDORID>
        <POPRCTNM>RCPT00000001823</POPRCTNM>
        <TAXDTLID>P-94533        </TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>1933</ACTINDX>
        <TAXAMNT>100.82</TAXAMNT>
        <TOTPURCH>1206.24</TOTPURCH>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopEnterMatchLotInsert_Items xsi:nil="true" />
    <taPopEnterMatchSerialInsert_Items xsi:nil="true" />
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCPT00000001823</POPRCTNM>
        <POPMtchShpRcpt>R172502</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>PO124340</PONUMBER>
        <QTYINVCD>12</QTYINVCD>
        <ITEMNMBR>R90101701</ITEMNMBR>
        <VENDORID>XXXXX</VENDORID>
        <VNDITNUM>
        </VNDITNUM>
        <UNITCOST>2.92</UNITCOST>
        <EXTDCOST>35.04</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <POLNENUM>32768</POLNENUM>
      </taPopEnterMatchInvLine>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCPT00000001823</POPRCTNM>
        <POPMtchShpRcpt>R172502</POPMtchShpRcpt>
        <ShipRCPTLNNM>32768</ShipRCPTLNNM>
        <PONUMBER>PO124340</PONUMBER>
        <QTYINVCD>6</QTYINVCD>
        <ITEMNMBR>4WE6J6X/EG24N9K4/62</ITEMNMBR>
        <VENDORID>VALIN</VENDORID>
        <VNDITNUM>
        </VNDITNUM>
        <UNITCOST>195.20</UNITCOST>
        <EXTDCOST>1171.20</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <POLNENUM>49152</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />
    <taPopEnterMatchInvHdr>
      <POPRCTNM>RCPT00000001823</POPRCTNM>
      <VNDDOCNM>3339572</VNDDOCNM>
      <receiptdate>09/12/2018</receiptdate>
      <BACHNUMB>TD-09212018</BACHNUMB>
      <VENDORID>XXXXX</VENDORID>
      <SUBTOTAL>1206.24</SUBTOTAL>
      <FRTAMNT>38.51</FRTAMNT>
      <TAXAMNT>100.82</TAXAMNT>
      <TAXSCHID>XXXXX </TAXSCHID>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPEnterMatchInvoiceType>
</eConnect>

Inventory that does not work

<?xml version="1.0" encoding="utf-16"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <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>
      <taPopRcptLineTaxInsert>
        <VENDORID>XXXXX</VENDORID>
        <POPRCTNM>RCPT00000001723</POPRCTNM>
        <TAXDTLID>P-94533        </TAXDTLID>
        <TAXTYPE>0</TAXTYPE>
        <ACTINDX>1896</ACTINDX>
        <TAXAMNT>135.83</TAXAMNT>
        <TOTPURCH>1658.92</TOTPURCH>
      </taPopRcptLineTaxInsert>
    </taPopRcptLineTaxInsert_Items>
    <taPopDistribution_Items xsi:nil="true" />
    <taAnalyticsDistribution_Items xsi:nil="true" />
    <taPopEnterMatchLotInsert_Items xsi:nil="true" />
    <taPopEnterMatchSerialInsert_Items xsi:nil="true" />
    <taPopEnterMatchInvLine_Items>
      <taPopEnterMatchInvLine>
        <POPRCTNM>RCPT00000001723</POPRCTNM>
        <POPMtchShpRcpt>R172271</POPMtchShpRcpt>
        <ShipRCPTLNNM>16384</ShipRCPTLNNM>
        <PONUMBER>PO124381</PONUMBER>
        <QTYINVCD>4</QTYINVCD>
        <ITEMNMBR>XXXXX<</ITEMNMBR>
        <VENDORID>XXXXX<</VENDORID>
        <VNDITNUM>
        </VNDITNUM>
        <UNITCOST>414.73</UNITCOST>
        <EXTDCOST>1658.92</EXTDCOST>
        <NONINVEN>1</NONINVEN>
        <POLNENUM>16384</POLNENUM>
      </taPopEnterMatchInvLine>
    </taPopEnterMatchInvLine_Items>
    <taPopEnterMatchInvToShpMultiLine_Items xsi:nil="true" />
    <taPopEnterMatchInvHdr>
      <POPRCTNM>RCPT00000001723</POPRCTNM>
      <VNDDOCNM>30448212</VNDDOCNM>
      <receiptdate>08/31/2018</receiptdate>
      <BACHNUMB>TD-09212018</BACHNUMB>
      <VENDORID>XXXXX<</VENDORID>
      <SUBTOTAL>1658.92</SUBTOTAL>
      <FRTAMNT>18.00</FRTAMNT>
      <TAXAMNT>135.83</TAXAMNT>
      <TAXSCHID>XXXXX<  </TAXSCHID>
      <USINGHEADERLEVELTAXES>1</USINGHEADERLEVELTAXES>
    </taPopEnterMatchInvHdr>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPEnterMatchInvoiceType>
</eConnect>

Does anyone have a sample of an Excel template they use to translate non reporting currency companies in a consolidation report. I have heard people describe doing this on various boards, but no one provides an example of what the Excel worksheet looks like or how they reference it in the Column Set. I would really appreciate some help with this.

My big issue is that I need different accounts to translate at different historical rates, i.e. Inter-company, Equity, etc. I inherited a poorly designed GP implementation that never had FX setup correctly, and now, 5 years later, the effort to go back and try to tie out all of the rate issues is massive. This would be easier if I could use an Excel worksheet and Management Reporter. 

I'm trying to execute the taUpdateCreateVendorRcd SP from a wrapper SP that sends in the minimal required values.

I am getting an error number of 3396 which states this:

The Tax Type parameter is invalid: 1=Not a 1099 Vendor; 2=Dividend; 3=Interest; 4=Misc.

I am passing value of 1 for this parameter: @I_vTEN99TYPE

What am I missing?

 

 

We had a PO that we were trying to cancel, but the error screen shown below popped up.     

 

What is a "Master PO Lock", how does it get set,  and how do you remove it from a PO in GP?

(I had to go in the "back door" via SQL code to change the status of the PO to cancelled.)

 

 

 

These batches were processed and posted, the EFT files were generated and uploaded to the bank. But for some reason they remain in the window as available, and will not clear.  

I assume we are doing something wrong and missing a step. I would appreciate if someone could guide me to how to clear this list.

Thanks

 

 

 

Is it possible to add a warning message of something like, Document Not Found, when using the find option in GP?  For example, if I go to Apply Sales Document and use the Find - Sales/Invoice... If I enter an invoice and it isn't found, it just defaults to the top of the window. But I need a message that states the item was not found. Is this possible? 

Good morning,

   In the "Build Check" process the below message appear and no finish the build. 

GP2010 version. Any suggestion is welcome.

Thanks, Mr. García