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. 


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

looking the underlying query thats used to generate gp cashflow report
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.