DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

This is a basic example of what data access code looks like in a script in Integration Manager.

We demonstrate the usage of the GPConnection object, Stored Procedures, and Parameters

Solved (one cause of this) today

 

Sql procedure error codes returned:
Error Number = 928  Stored Procedure= taSopLineIvcInsert  Error Description = Invalid Price Level
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = ORD0076107          
SOPTYPE = 2
LNITMSEQ = 32768
Related Error Code Parameters for Node : taSopLineIvcInsert
PRCLEVEL = WHOLESALE
<taSopLineIvcInsert>
  <SOPTYPE>2</SOPTYPE>
  <SOPNUMBE>ORD0076107           </SOPNUMBE>
  <CUSTNMBR>0019565        </CUSTNMBR>
  <DOCDATE>2/2/2017</DOCDATE>
  <LOCNCODE>WAREHOUSE1</LOCNCODE>
  <ITEMNMBR>175433                        </ITEMNMBR>
  <AutoAssignBin>0</AutoAssignBin>
  <QUANTITY>6.00000</QUANTITY>
  <PRCLEVEL>WHOLESALE </PRCLEVEL>
  <ITEMDESC>Insulated Tumbler, Lemon                                                                            </ITEMDESC>
  <LNITMSEQ>32768</LNITMSEQ>
  <DOCID>ORDER          </DOCID>
  <SALSTERR></SALSTERR>
  <SLPRSNID></SLPRSNID>
  <PRSTADCD>SHIPPING       </PRSTADCD>
  <ShipToName>PEN AND INK                                                     </ShipToName>
  <CNTCPRSN>SUSAN HERBERT &amp; MARTHA LYNN SCROGGIE                        </CNTCPRSN>
  <FUFILDAT>2/10/2017</FUFILDAT>
  <ACTLSHIP>2/10/2017</ACTLSHIP>
  <QTYFULFI>6.00000</QTYFULFI>
  <UpdateIfExists>1</UpdateIfExists>
  <CURNCYID>USD            </CURNCYID>
  <UOFM>EACH    </UOFM>
</taSopLineIvcInsert>
76121

This article contains an XML document that shows the minimum number of fields that I could send to update the QTYFULFI, ACTLSHIP and FUFILDAT.

 

Sql procedure error codes returned:
Error Number = 839  Stored Procedure= taPopRcptHdrInsert  Error Description = Invalid Purchase Misc Taxable (Purchase_Misc_Taxable) status (1=Taxable,2=Nontaxable,3=Base on Vendor
Node Identifier Parameters: taPopRcptHdrInsert
POPRCTNM = 26              
POPTYPE = 1
receiptdate = 2/3/2017
BACHNUMB = RCPT 0217     
VENDORID = 0000250       
Related Error Code Parameters for Node : taPopRcptHdrInsert
Purchase_Misc_Taxable = 0
Error Number = 840  Stored Procedure= taPopRcptHdrInsert  Error Description = Invalid Purchase Freight Taxable (Purchase_Freight_Taxable) status (1=Taxable,2=Nontaxable,3=Base on Vendor
Node Identifier Parameters: taPopRcptHdrInsert
POPRCTNM = 26              
POPTYPE = 1
receiptdate = 2/3/2017
BACHNUMB = RCPT 0217     
VENDORID = 0000250       
Related Error Code Parameters for Node : taPopRcptHdrInsert
Purchase_Freight_Taxable = 0
<taPopRcptHdrInsert>
  <POPRCTNM>26               </POPRCTNM>
  <POPTYPE>1</POPTYPE>
  <receiptdate>2/3/2017</receiptdate>
  <ACTLSHIP>2/3/2017</ACTLSHIP>
  <BACHNUMB>RCPT 0217      </BACHNUMB>
  <VENDORID>0000250        </VENDORID>
  <DISAVAMT>0</DISAVAMT>
  <Purchase_Freight_Taxable>0</Purchase_Freight_Taxable>
  <Purchase_Misc_Taxable>0</Purchase_Misc_Taxable>
  <CREATEDIST>0</CREATEDIST>
  <RATEEXPR>0</RATEEXPR>
  <DYSTINCR>0</DYSTINCR>
  <TRXDTDEF>0</TRXDTDEF>
  <RTCLCMTD>0</RTCLCMTD>
</taPopRcptHdrInsert>
<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>26               </POPRCTNM>
        <PONUMBER>PO001307         </PONUMBER>
        <ITEMNMBR>143345                        </ITEMNMBR>
        <VENDORID>0000250        </VENDORID>
        <UNITCOST>2.00000</UNITCOST>
        <QTYSHPPD>48096.00000</QTYSHPPD>
        <LOCNCODE>WAREHOUSE1</LOCNCODE>
        <AutoAssignBin>0</AutoAssignBin>
      </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>26               </POPRCTNM>
      <POPTYPE>1</POPTYPE>
      <receiptdate>2/3/2017</receiptdate>
      <ACTLSHIP>2/3/2017</ACTLSHIP>
      <BACHNUMB>RCPT 0217      </BACHNUMB>
      <VENDORID>0000250        </VENDORID>
      <DISAVAMT>0</DISAVAMT>
      <Purchase_Freight_Taxable>0</Purchase_Freight_Taxable>
      <Purchase_Misc_Taxable>0</Purchase_Misc_Taxable>
      <CREATEDIST>0</CREATEDIST>
      <RATEEXPR>0</RATEEXPR>
      <DYSTINCR>0</DYSTINCR>
      <TRXDTDEF>0</TRXDTDEF>
      <RTCLCMTD>0</RTCLCMTD>
    </taPopRcptHdrInsert>
    <taMdaUpdate_Items xsi:nil="true" />
  </POPReceivingsType>
</eConnect>
I am trying to link Time Sheet / Time Cards to Pay history detail, earnings, withholdings, deductions Through the UPR Tables.  I don't see the time card links that would create the pay and invoicing.  The time card detail is imported from a third party system.  Is the Timecard activity stored to hold the link from time entry import to pay and invoicing?

Hi everyone,

Someone made a change in my Chart of Account (Modified Date shows Feb 7, 2017). How do I know who made the changes and what was the change?

I am on GP2013 SP2 and do not have Audit Trail installed.

Can anyone help?

Thanks

PC

Hello, I'm trying to write a sql query which shows payroll distributions including employee, department, job title, payroll code, amount and G/L account.

I started linking the UPR30300 and UPR40500 tables for gross paycodes but it does not appear all transactions are necessarily stored on the UPR30300 table.

 

Thanks.

I have a few invoices with tax amount > 0 but the corresponding records in SOP10101 shows 0 in NCOMAMNT field and the CMMSLAMT is the same as ACTSLAMT. In my understanding tax should be part of the NCOMAMNT (as most of my other invoices do).

Can someone give me a clue on what might be the cause or where to start with for the troubleshooting?

Thanks a lot!

I am attempting to automate the creation of an RMA via dex customization. I can successfully update fields of the main RMA Entry/Update window but have been unsuccessful creating a line by setting field values in the SVC_RMA_Line_Scroll window via pass-thru sanscript.

 

Hear is the snippet:

                  clear tCode;                                        
                   set sCustomerNumber to 'Customer Number' of table SVC_Serial_MSTR;
                    set sItemNumber to 'Item Number' of table SVC_Serial_MSTR;
                    set sSerialNumber to 'Serial Number' of table SVC_Serial_MSTR;
                    set sReasonCode to "EOS";    
                    set sOfficeID to "DEFAULT";    
                    set sRMAType to "RMA";                        
                    set tCode to tCode + "inout string sReasonCode;";
                    set tCode to tCode + "inout string sCustomerNumber;";
                    set tCode to tCode + "inout string sOfficeID;";
                    set tCode to tCode + "inout string sReturnDocumentID;";        
                    set tCode to tCode + "inout string sItemNumber;";
                                                            
                    set tCode to tCode + "inout string sRMAType;";    
                    set tCode to tCode + "inout string sSerialNumber;";    
                                                                
                    set tCode to tCode + "open form SVC_RMA_Update;";  
                    set tCode to tCode + "run script '(L) New Button' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";  
                    set tCode to tCode + "set 'SVC Return Type' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update to sRMAType;";
                    set tCode to tCode + "run script 'SVC Return Type' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";
                    set tCode to tCode + "set 'SVC_RMA_Reason_Code' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update to sReasonCode;";
                    set tCode to tCode + "set 'Customer Number' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update to sCustomerNumber;";
                    set tCode to tCode + "run script 'Customer Number' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";  
                    set tCode to tCode + "set 'Office ID' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update to sOfficeID;";
                    set tCode to tCode + "run script 'Office ID' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";
                                       
                    set tCode to tCode + "set 'Location Code' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update to ""RETURNS"";";
                    set tCode to tCode + "run script 'Location Code' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";    
                                           
                    set tCode to tCode + "set sReturnDocumentID to 'Return Document ID' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";
                    
                
                    set tCode to tCode + "focus field 'SVC Return Type' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update;";
                    set tCode to tCode + "set 'SVC Return Type' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update to sRMAType;"
                    
                    set tCode to tCode + "focus field 'Return Item Number' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update;";
                    set tCode to tCode + "set 'Return Item Number' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update to sItemNumber;";                
                    {set tCode to tCode + "run script 'Return Item Number' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update;";}
                    
                    set tCode to tCode + "focus field 'Return U Of M' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update;";
                    set tCode to tCode + "set 'Return U Of M' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update to ""Each"";";
                    set tCode to tCode + "run script 'Return U Of M' of window SVC_RMA_Line_Scroll of form SVC_RMA_Update;";
                    
                    set tCode to tCode + "focus field 'QTY' of window SVC_RMA_Line_Expansion of form SVC_RMA_Update;";                
                    set tCode to tCode + "set 'QTY' of window SVC_RMA_Line_Expansion of form SVC_RMA_Update to 1;";
                    set tCode to tCode + "run script 'QTY' of window SVC_RMA_Line_Expansion of form SVC_RMA_Update;";

                    
                
                    set tCode to tCode + "set 'Return Serial Number' of window SVC_Serial_Line_Entry of form SVC_RMA_Line_Serial_Entry to sSerialNumber;";
                    set tCode to tCode + "run script 'Return Serial Number' of window SVC_Serial_Line_Entry of form SVC_RMA_Line_Serial_Entry;";
                    set tCode to tCode + "run script '(L) SVC_PB_Insert' of window SVC_Serial_Line_Entry of form SVC_RMA_Line_Serial_Entry;";
                    set tCode to tCode + "close form SVC_RMA_Line_Serial_Entry;";
                    {set tCode to tCode + "run script 'Save Button' of window SVC_RMA_Entry_DropDown of form SVC_RMA_Update;";}
                    
                    if execute(949, tCode, sCompilerError, sReasonCode, sCustomerNumber, sOfficeID, sReturnDocumentID, sItemNumber, sRMAType, sSerialNumber) <> OKAY then
                        error sCompilerError;
                        {13.3}
                        abort script;    
                    end if;    
                       

Are there any dex masters out there that can point out specifically why the code in bold does not update those fields?

 

Thanks

Mike

Hello GP Gurus! 

We have a very disturbing problem happening.  We are still in GP2010 (upgrading process is in the works now).

Twice in two weeks we had the following happen in this tab:    Sales \Utilities \ Sales Order Processing \ Numbers

                            On the Numbers screen, SOMEHOW, the mask for our Invoices was changed.   We are 99% sure that no users went into this screen and changed the mask - it's buried pretty well and not many people would even want to stray out of their comfort zone tabs. 

So we are wondering if there is some other process you know of in GP that could change this mask on the fly by somebody not knowing what they are doing in another screen?   (Example - entering a manual invoice for Bill Only, etc.)   We do have some Extender and custom programs in our installation.

 

 

Any thoughts will be appreciated, thank you.

 

                                                                                                 

 

I need to create a BIN Transfer integration either via SmartConnect or via Integration Manager.  Has anyone successfully done this and if so, any insights.  I have extremely limited experience CREATING any integrations, just performing them with ones already created.

THANKS

I have an issue where I need to default the ACCRUED side of the distributions for PO Receivings Transactions in Integration Manager.  Unfortunately, unlike other mappings (like AP Transactions), there is no option to set the Distribution Option Rule to Default Non-Imported. I have the PURCH distribution lines in the file, but need to default the ACCRUED distribution lines as these are not in my source file. Any suggestions?

We recently started trying to include item-level tax details on our purchase orders but we are receiving the  Error Number = 887 Stored Procedure= taPoHdr Error Description = Tax detail amount does not match the header tax amount. 

The change we made was adding the taPopIvcTaxInsert object along with the taPoHdr and taPoLine objects in the POPTransactionType.  We are also specifying the taPoHdr.TAXAMNT in our code but that doesn't appear in the XML that gets generated (see below) and passed to CreateEntity().  Is there a "TAXAMNTSpecified = true" property that I could be missing?  What else can we be doing to get the TAXAMNT to appear in the taPoHdr block on the XML (if that's even the problem)?

Thank you,

James

POPTransactionType XML:

<?xml version="1.0"?>
    <POPTransactionType>
        <eConnectProcessInfo xsi:nil="true"/>
        <taRequesterTrxDisabler_Items xsi:nil="true"/>
        <taUpdateCreateItemRcd xsi:nil="true"/>
        <taUpdateCreateVendorRcd xsi:nil="true"/>
        <taCreateVendorAddress_Items xsi:nil="true"/>
        <taUpdateCreateCustomerRcd xsi:nil="true"/>
        <taCreateCustomerAddress_Items xsi:nil="true"/>
        <taPopIvcTaxInsert_Items>
            <taPopIvcTaxInsert>
                <PONUMBER>PO1700102</PONUMBER>
                <ORD>16384</ORD>
                <TAXDTLID>VATTAXAP-COM </TAXDTLID>
                <TAXAMNT>11.04</TAXAMNT>
                <TAXPURCH>55.2</TAXPURCH>
                <TOTPURCH>55.2</TOTPURCH>
                <VENDORID>ELA001-COM </VENDORID>
            </taPopIvcTaxInsert>
        </taPopIvcTaxInsert_Items>
        <taPopDistribution_Items xsi:nil="true"/>
        <taAnalyticsDistribution_Items xsi:nil="true"/>
        <taPoLine_Items>
            <taPoLine>
                <POTYPE>1</POTYPE>
                <PONUMBER>PO1700102</PONUMBER>
                <VENDORID>ELA001-COM </VENDORID>
                <LOCNCODE>COMM </LOCNCODE>
                <VNDITNUM>10011 </VNDITNUM>
                <ITEMNMBR>10011 </ITEMNMBR>
                <QUANTITY>1</QUANTITY>
                <QTYCANCE>0</QTYCANCE>
                <FREEONBOARD>3</FREEONBOARD>
                <REQDATE>02/23/2017 00:00:00.000</REQDATE>
                <RELEASEBYDATE>01/01/1900 00:00:00.000</RELEASEBYDATE>
                <PRMDATE>02/23/2017 00:00:00.000</PRMDATE>
                <PRMSHPDTE>01/01/1900 00:00:00.000</PRMSHPDTE>
                <ITEMDESC>16mm Tri-rated Grey</ITEMDESC>
                <UNITCOST>55.2000</UNITCOST>
                <VNDITDSC>16mm Tri-rated Grey </VNDITDSC>
                <UOFM>EA</UOFM>
                <Purchase_IV_Item_Taxable>1</Purchase_IV_Item_Taxable>
                <Purchase_Item_Tax_Schedu>ALL </Purchase_Item_Tax_Schedu>
                <Purchase_Site_Tax_Schedu>VATAP-COM </Purchase_Site_Tax_Schedu>
                <BSIVCTTL>0</BSIVCTTL>
                <TAXAMNT>11.04</TAXAMNT>
                <BCKTXAMT>0</BCKTXAMT>
                <PLNNDSPPLID>0</PLNNDSPPLID>
                <BackoutTradeDiscTax>0</BackoutTradeDiscTax>
                <POLNESTA>2</POLNESTA>
                <ORD>16384</ORD>
                <LineNumber>1</LineNumber>
                <UpdateIfExists>1</UpdateIfExists>
            </taPoLine>
        </taPoLine_Items>
        <taPoHdr>
            <PONUMBER>PO1700102</PONUMBER>
            <VENDORID>ELA001-COM </VENDORID>
            <VENDNAME>ELAND CABLES LTD </VENDNAME>
            <DOCDATE>02/17/2017 00:00:00.000</DOCDATE>
            <BUYERID> </BUYERID>
            <PRSTADCD>UKTCC </PRSTADCD>
            <CMPNYNAM>AFL Services Europe Ltd </CMPNYNAM>
            <CONTACT>eur.accounts@aflgloal.com </CONTACT>
            <ADDRESS1>3 The Western Centre </ADDRESS1>
            <ADDRESS2>Western Road </ADDRESS2>
            <ADDRESS3> </ADDRESS3>
            <CITY>Bracknell </CITY>
            <STATE>Berkshire </STATE>
            <ZIPCODE>RG12 1RW </ZIPCODE>
            <COUNTRY>ALAF160001</COUNTRY>
            <PHONE1>13444078000000 </PHONE1>
            <PHONE2>00000000000000 </PHONE2>
            <PHONE3> </PHONE3>
            <FAX>13444078010000 </FAX>
            <VADCDPAD>REMIT TO </VADCDPAD>
            <PURCHCMPNYNAM>ELAND CABLES LTD </PURCHCMPNYNAM>
            <PURCHCONTACT> </PURCHCONTACT>
            <PURCHADDRESS1>120 HIGHGATE STUDIOS </PURCHADDRESS1>
            <PURCHADDRESS2>53-79 HIGHGATE RD </PURCHADDRESS2>
            <PURCHADDRESS3> </PURCHADDRESS3>
            <PURCHCITY>LONDON </PURCHCITY>
            <PURCHSTATE> </PURCHSTATE>
            <PURCHZIPCODE>NW5 1TL </PURCHZIPCODE>
            <PURCHCOUNTRY>United Kingdom </PURCHCOUNTRY>
            <PURCHPHONE1>02072418787 </PURCHPHONE1>
            <PURCHPHONE2> </PURCHPHONE2>
            <PURCHPHONE3> </PURCHPHONE3>
            <PURCHFAX>02072418701 </PURCHFAX>
            <PRBTADCD>UKTCC </PRBTADCD>
            <SHIPMTHD>DELIVERY </SHIPMTHD>
            <PYMTRMID>NET 30 </PYMTRMID>
            <DUEDATE>01/01/1900 00:00:00.000</DUEDATE>
            <DISCDATE>01/01/1900 00:00:00.000</DISCDATE>
            <TXRGNNUM> </TXRGNNUM>
            <XCHGRATE>0</XCHGRATE>
            <EXCHDATE>01/01/1900 00:00:00.000</EXCHDATE>
            <EXTBLSRC>0</EXTBLSRC>
            <TIME1>01/01/1900 00:00:00.000</TIME1>
            <POSTATUS>2</POSTATUS>
            <PRMDATE>02/23/2017 00:00:00.000</PRMDATE>
            <PRMSHPDTE>01/01/1900 00:00:00.000</PRMSHPDTE>
            <REQDATE>02/23/2017 00:00:00.000</REQDATE>
            <CONTENDDTE>01/01/1900 00:00:00.000</CONTENDDTE>
            <REQTNDT>01/01/1900 00:00:00.000</REQTNDT>
            <UpdateIfExists>1</UpdateIfExists>
        </taPoHdr>
    </POPTransactionType>
</eConnect>

Hi:

Is it possible to update a Service Call to add expense and labor lines via Econnect or Web Services?  If so, can anyone point me to an example?

I have Web Services installed, and the service is working (created an employee following the example in the docs.  Below is stack trace output and the code that is failing with an 'Object reference not set to an instance of an object. exception.'  Sorry for the mess!

 at Microsoft.Dynamics.GP.BusinessLogic.HandleServiceLineDefaulting`1.DefaultKeys(ServiceDocumentKey key, List`1 lines)

   at Microsoft.Dynamics.GP.ServiceCallDefaultStrategyImplementation.DefaultExpenseLine(ServiceCall call)

   at Microsoft.Dynamics.GP.ServiceCallDefaultStrategyImplementation.DefaultingForUpdate(Object sender, BusinessObjectUpdateEventArgs e)

   at Microsoft.Dynamics.GP.ServiceCallDefaultStrategy.DefaultingForUpdate(Object sender, BusinessObjectUpdateEventArgs e)

 

 

 

 
static void createServiceExpense() {
            CompanyKey companyKey;
            Context context;
            ServiceDocumentKey serviceDocumentKey;
            ServiceCall serviceCall;
            Policy serviceCallPolicy;
 
 
            // Create an instance of the service
            DynamicsGPClient wsDynamicsGP = new DynamicsGPClient();
 
            // Create a context with which to call the service
            context = new Context();
 
            // Specify which company to use (sample company)
            companyKey = new CompanyKey();
            companyKey.Id = (1);
 
            // Set up the context
            context.OrganizationKey = (OrganizationKey)companyKey;
 
            // Create a service document key object
            serviceDocumentKey = new ServiceDocumentKey();
            serviceDocumentKey.Id = "0000000025";
            
            // Retrieve the specified service call object
            serviceCall = new ServiceCall();
            serviceCall = wsDynamicsGP.GetServiceCallByKey(serviceDocumentKey, context);
 
 
 
            //List<ServiceCallExpenseLine> serviceCallExpenseLines = new List<ServiceCallExpenseLine>();
 
            ServiceCallExpenseLine expenseLine;
            expenseLine = new ServiceCallExpenseLine();
            ServiceTechnicianKey stk = new ServiceTechnicianKey();
            stk.Id = "418";
            ItemKey itemKey = new ItemKey();
            itemKey.Id = "5-STDLABOR";
            expenseLine.ItemKey = itemKey;
            expenseLine.TechnicianKey = stk;
            Quantity qtySold = new Quantity();
            qtySold.Value = 1;
            expenseLine.QuantitySold = qtySold;
            MoneyAmount unitPrice = new MoneyAmount();
            unitPrice.Value = 99;
            expenseLine.UnitPrice = unitPrice;
            expenseLine.TotalCost = unitPrice;
 
            expenseLine.UofM = "HOUR";
             
 
 
            ServiceCallExpenseLine[] expenseLines = { expenseLine};
 
 
            serviceCall.Expenses = expenseLines;
 
 
 
            serviceCallPolicy = wsDynamicsGP.GetPolicyByOperation("UpdateServiceCall", context);
 
            wsDynamicsGP.UpdateServiceCall(serviceCall, context, serviceCallPolicy);
 
            // Display the service call customer name
            //MessageBox.Show("Customer: " + serviceCall.CustomerName);
            //Debug.WriteLine("Customer: " + serviceCall.CustomerName);
             
            // Close the service
            if (wsDynamicsGP.State != CommunicationState.Faulted)
            {
                wsDynamicsGP.Close();
            }
 
 
        }

 


 

All,

Where can we find the eConnectProgrammersGuide for GP 2015 and GP 2016? We have if for GP 2013, but need it for GP 2015 and GP 2016 to determine schema changes for those versions.

Thanks in advance.

Jeff

 

Why are these tables called Work tables, when data persists in them? These tables contain thousands of rows:

select * from IV10200;  -- Inventory Purchase Receipts Work    -- 54,000 rows
select * from IV10201;  -- Inventory Purchase Receipts Details Work     -- 160,000 rows
select * from IV10202;  -- Inventory Purchase Receipts Sequence Number    -- 1,264 rows

How are these tables used in Dynamics GP? We are on version 2015 R2.

Thank you,

Karen

What table stores the recurring billing information?

 

Thanks

What tables drive the Billing Schedule Maintenance Card?

What's a standard/good practice way to update the status of an order to "ready to ship" or fulfilled/shipped? By our internal business rules, if an order meets the following requirement it's a "ready to ship" order:

- customer is in good standing (no late payment, not over limit);

- sales price meets requirement (we have a stored procedure to check table SOP10200);

- order has no hold;

- all items has available stock;

- it's on or after the ship date;

Is it a common way that people create a smart list to pull the list of "ready to ship" orders for the warehouse to print pick list and ship?

What is warehouse supposed to do after they complete the shipment? Is there something they do to mark the order "shipped" so that the order can be invoiced?

Thanks a lot!

We recently upgraded  our Dynamics GP 2010 environment  to   2015 R2.  SQL server from 2008 r2 to 2014 and server 0S  to windows 2012.

Ignoring  some datacenter issues with provisioning ,   sans and  AV  items,     we have noticed an extreme slowness  in all phases of the manufacturing operations .

Pickdocs are extremely slow to allocate and issue parts.   completions slowed down.  Bill of materials  additions, modifications   all are much slower.

Our pickdocs are extremely large due to the nature of  our production line/workcenters and products.

Several consultants  i've talked to indicated that   MS  in these 2013 and 2015 versions  did  "some code optimization" of the manufacturing procedures.

Also those consultants indicated that lots of manufacturing customers were experiencing slower functional operational steps in 2015 than 2010.

I'd like to get some weigh in  on this   from users  who do and  some who havent experienced the  speed issues . 

 

Thanks

Merlyn

 

 

 

I'm thinking about creating some functions to automatically transfer invoices in certain batch into invoice. One example is when warehouse confirms that an order is shipped I'll put the order into a batch like "ReadyToInvoice". Anyone has a clue whether/how this can be done in eConnect? I'm trying to avoid dexiterity development because I'm not too familiar. But if that's the only way then I'll dig into it. Thanks again!

GP2010 company....

 

We have a few Smartlists that were created using Smartlist Builder because we needed to use information from two or more tables.

However, the only users who can access these Smartlists are Powerusers.  

Security/permissions thoughts here?

 

I am importing payables transactions using eConnect. Everything is working good except some vendors allow a trade discount. Integration Manager applies the default trade discount and creates the distribution line without having to pass anything. Is there a way for eConnect to do this or does my routine have to check for vendors with trade discounts, do the calcs, pass in the trade discount value and create the extra distribution line? Thanks in advance for any help.

Como identifico el procedimiento almacenado, vista o el query que genera utilizan los SmarList originales de gp 10.0?

How do I identify the stored procedure, view, or query that generates the original SmarList from gp 10.0?

 

I'm trying to understand data flow from one module to another in GP 2015 R2, with respect to Inventory. If anyone could answer the following questions it would be greatly appreciated. I'm not finding answers in my research.

1.  Do all inventory item transactions (items of Sales Inventory type) from Project Accounting, POP, and SOP modules flow to Inventory, and are then posted from Inventory to the GL? Are there transactions that go directly to the GL, bypassing Inventory module?

2.  Is the POP10500 table (Purchasing Receipt Line Quantities) both a Work and Historical table? This is the only table where I find receipt line item quantity for unposted and posted documents. Or should I be using the IV10200 table:

IV10200  -- Purchase Receipt Work
IV10201  -- Purchase Receipt Work Details
 
These tables are used specifically to calculate average cost.
 
IV10200 is used to store all receipts or positive adjustments or transfers on
inventory to a specific site. It also tracks how many of the receipt quantity
has been used or "sold" and what the adjusted weighted average cost that was used.
 
IV10201 captures the use of these quantities that were tracked in the IV10200 table.

3. What is the real difference between the ASIV0001 view and the POP10500 table? The ASIV0001 view sums quantities, but when I compare the view and the table, quantities are identical per item document, so it seems the sum is unnecessary at this level of detail but maybe I'm missing something.

I have been using the following query for historical POP receipts, is this accurate:

SELECT -- POP Receipt History -- get headers with line items
       Module             = 'POP'
      ,DocState           = 'History'
      ,TRXSOURCE          = h.TRXSORCE
      ,BatchNum           = h.BACHNUMB
      ,BatchSource        = h.BCHSOURC
      ,POPRCTNM           = h.POPRCTNM  -- POP Receipt Number
      ,RCPTLNNM           = d.RCPTLNNM  -- POP Receipt Line Number
      ,POPTYPE            = CASE h.POPTYPE
                                 WHEN 1 THEN 'Shipment'  -- Receipt
                                 WHEN 2 THEN 'Invoice'
                                 WHEN 3 THEN 'Shipment/Invoice'
                                 WHEN 4 THEN 'Return'
                                 WHEN 5 THEN 'Return w/Credit'
                                 WHEN 6 THEN 'IV Return'
                                 WHEN 7 THEN 'IV Return w/Credit'
                                 WHEN 8 THEN 'In-Transit Inventory'
                                 ELSE 'Unknown'
                                 END
      ,ItemNmbr           = d.ITEMNMBR
      ,TRX_QTY            = CASE h.POPTYPE
                                 WHEN 1 THEN CONVERT(INT,q.QTYSHPPD)      -- Shipment
                                 WHEN 2 THEN CONVERT(INT,q.QTYINVCD)      -- Invoice
                                 WHEN 3 THEN CONVERT(INT,q.QTYSHPPD)      -- Shipment/Invoice
                                 WHEN 4 THEN CONVERT(INT,q.QTYRESERVED)   -- Return
                                 WHEN 5 THEN CONVERT(INT,q.QTYRESERVED)   -- Return w/Credit
                               --WHEN 5 THEN CONVERT(INT,q.QTYINVRESERVE) -- Return w/Credit
                                 WHEN 6 THEN CONVERT(INT,q.QTYSHPPD)      -- IV Return?
                                 WHEN 7 THEN CONVERT(INT,q.QTYSHPPD)      -- IV Return w/Credit?
                               --WHEN 6 THEN CONVERT(INT,q.QTYREPLACED)   -- IV Return?
                               --WHEN 7 THEN CONVERT(INT,q.QTYINVADJ)     -- IV Return w/Credit?
                                 ELSE CONVERT(INT,q.QTYSHPPD)
                                 END
      ,ExtdCost           = CONVERT(DECIMAL(12,2),d.EXTDCOST)
      ,PONUMBER           = d.PONUMBER
      ,DocDate            = CONVERT(DATE,h.ReceiptDate)
      ,DocUserID          = h.USER2ENT  -- User who entered the record
      ,GLPostDate         = CONVERT(DATE,h.GLPOSTDT)  -- date to be be assigned if Posting Setup is set to post by batch date
      ,Posted_UserID      = h.PTDUSRID  -- used for recurring batches; last user to post this transaction
      ,PACOSTCATID        = d.CostCatID
      ,Voided             = IIF(h.VOIDSTTS = 0,'No','Yes') -- all 0
      ,VEND_DocNum        = h.VNDDOCNM
      ,VEND_ID            = h.VENDORID
  FROM
             dbo.POP30300 as h   -- Purchasing Receipt History
       JOIN  dbo.POP30310 as d   ON d.POPRCTNM = h.POPRCTNM  -- Purchasing Receipt Line History
 
       LEFT OUTER JOIN  dbo.POP10500 as q   ON q.POPRCTNM = d.POPRCTNM  -- Purchasing Receipt Line Quantities
                                           AND q.RCPTLNNM = d.RCPTLNNM
 
       --LEFT OUTER JOIN  dbo.ASIV0001 as q   ON q.POPRCTNM = d.POPRCTNM  -- Purchasing Receipt Line Quantities (Summary View)
       --                                    AND q.RCPTLNNM = d.RCPTLNNM
 WHERE
       d.NONINVEN = 0  -- Inventory items only

 

 

I am trying to figure out a way of alerting when the link between a SOP order and the PO are broken on a drop ship order. I was hoping to find a field in a SQL table that I could scan for a change in value if the link was broken, but it looks like it wont be that easy. Does anyone have any ideas on what to look for in the database to tell if the link is broken on a drop ship?

Thank you.

Hi, im developing a web api2 application to integrate with GP2015. But my web api 2 couldn't catch any econnect exception error! May i know why?(But it did catch exception error) 

Code as Below:

 

...

                catch (eConnectException exc)
                {
                    throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                    {
                        Content = new StringContent(exc.ToString()),
                        ReasonPhrase = "Critical Exception"
                    });
                }

...

Every once in a while we come across some occurrences of SOP line total mismatch the subtotal of the whole document. I.e. in one order I have five order lines, the subtotal of each line is, say, $50. But the document subtotal is $300 instead of 250. After I run reconcile against the order, the document subtotal changed from $300 back to $250.

To detect this kind of issue I can create a smart list or SQL view to list orders that have this kind of issue. However, since we create hundreds of orders a day if not more, it's hard to expect people to pull this smart list every time they make some changes to the SOP document. Neither it's ideal to have users to frequently turn to GP admin to run reconcile.

Just wonder whether anyone has similar experience and how do you deal with that.

Many thanks and wish you all great weekend!

 

I have modified the sql trigger to update the Sales Person ID and Sales Person Territory.

The trigger seems to be firing, but it doesnt update  the item that is actually being created at the time.

It seems to update all previous items(if i do a update all statement), but never the item that is being created at the time.

The data being passed in the stored procedure is accurate and available to me.  I even Did a SQL SELECT statement on sop10200 and inserted into a dummy table to see if the line was added at the time of the trigger.  Data is successfully being inserted in this query.

Any ideas on why this procedure is not executing on the Sales Order Being created?

 

Error: Combination of Territory (SALSTERR) and Salesperson (SLPRSNID) have already been used on this Document


 

<?xml version="1.0" encoding="utf-8"?>
<eConnect xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOPTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taSopSerial_Items xsi:nil="true" />
<taSopLotAuto_Items xsi:nil="true" />
<taSopLineIvcInsert_Items>
<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
<DOCDATE>7/11/2016 12:00:00 AM</DOCDATE>
<LOCNCODE>Warehouse</LOCNCODE>
<ITEMNMBR>1-A3261A</ITEMNMBR>
<UNITPRCE>16000</UNITPRCE>
<XTNDPRCE>16000</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<DOCID>STDORD</DOCID>
<SALSTERR>TERRITORY 4</SALSTERR>
<SLPRSNID>GREG E.</SLPRSNID>
<PRSTADCD>PRIMARY</PRSTADCD>
<ReqShipDate>10/28/2017 12:00:00 AM</ReqShipDate>
<SHIPMTHD>MAIL</SHIPMTHD>
</taSopLineIvcInsert>
<taSopLineIvcInsert>
<SOPTYPE>2</SOPTYPE>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
<DOCDATE>7/11/2016 12:00:00 AM</DOCDATE>
<LOCNCODE>Warehouse</LOCNCODE>
<ITEMNMBR>100XLG</ITEMNMBR>
<UNITPRCE>59.95</UNITPRCE>
<XTNDPRCE>59.95</XTNDPRCE>
<QUANTITY>1</QUANTITY>
<DOCID>STDORD</DOCID>
<SALSTERR>TERRITORY 4</SALSTERR>
<SLPRSNID>GREG E.</SLPRSNID>
<PRSTADCD>PRIMARY</PRSTADCD>
<ReqShipDate>10/28/2017 12:00:00 AM</ReqShipDate>
<SHIPMTHD>MAIL</SHIPMTHD>
</taSopLineIvcInsert>
</taSopLineIvcInsert_Items>
<taSopLineIvcInsertComponent_Items xsi:nil="true" />
<taSopTrackingNum_Items xsi:nil="true" />
<taSopCommissions_Items>
<taSopCommissions>
<SOPTYPE>2</SOPTYPE>
<SLPRSNID>GREG E.</SLPRSNID>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
</taSopCommissions>
<taSopCommissions>
<SOPTYPE>2</SOPTYPE>
<SLPRSNID>GREG E.</SLPRSNID>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
</taSopCommissions>
</taSopCommissions_Items>
<taSopLineIvcTaxInsert_Items xsi:nil="true" />
<taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
<taSopUserDefined xsi:nil="true" />
<taSopDistribution_Items xsi:nil="true" />
<taAnalyticsDistribution_Items xsi:nil="true" />
<taSopMultiBin_Items xsi:nil="true" />
<taSopHdrIvcInsert>
<SOPTYPE>2</SOPTYPE>
<DOCID>STDORD</DOCID>
<SHIPMTHD>MAIL</SHIPMTHD>
<LOCNCODE>Warehouse</LOCNCODE>
<DOCDATE>7/11/2016 12:00:00 AM</DOCDATE>
<CUSTNMBR>ADVANCED0001</CUSTNMBR>
<CSTPONBR>123456</CSTPONBR>
<SUBTOTAL>16059.95</SUBTOTAL>
<DOCAMNT>16059.95</DOCAMNT>
<SALSTERR>TERRITORY 4</SALSTERR>
<SLPRSNID>SANDRA M.</SLPRSNID>
<BACHNUMB>ALL</BACHNUMB>
<PRBTADCD>PRIMARY</PRBTADCD>
<PRSTADCD>PRIMARY</PRSTADCD>
<DEFTAXSCHDS>1</DEFTAXSCHDS>
<FREIGTBLE>3</FREIGTBLE>
<NOTETEXT>1:Origin|3:List03|9:List02|D1:11/21/2016 12:00:00 AM|</NOTETEXT>
<USRDEFND1>Commit</USRDEFND1>
<USRDEFND2>CONFIRM</USRDEFND2>
<USRDEFND3>Ordered</USRDEFND3>
<USRDEFND4>hmm</USRDEFND4>
<USRDEFND5>efef</USRDEFND5>
</taSopHdrIvcInsert>
<taSopToPopLink xsi:nil="true" />
<taSopUpdateCreateProcessHold xsi:nil="true" />
<taCreateSOPTrackingInfo xsi:nil="true" />
<taMdaUpdate_Items xsi:nil="true" />
</SOPTransactionType>
</eConnect>