DynDeveloper.com

Solved (one cause of this) today

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 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

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

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:

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

What table stores the recurring billing information?

Thanks

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!

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:

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:

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"
                    });
                }

...

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?