Open Forum

Expand all | Collapse all

Integration Manager - GP2015R2

Jump to Best Answer
  • 1.  Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 05, 2019 03:30 PM

    I use Integration Manager to upload a batch of invoices each month.  A task I just completed.  The 30th record (invoice) was to a vendor on hold.  GP opened a window wanting a

    "Password​ required, but none specified"

    "Argument 'Number' is not valid value"

    "Password​ required, but none specified"

    This caused all of the subsequent invoices to fail.  These three error messages were repeated for each of the subsequent invoices.  Removing the ONE invoice, deleting the batch, and re-uploading worked.  47 invoices uploaded no issue.  

    Is there a setting that I am missing that would have triggered the invoice to fail and be skipped to continue correctly?  It seems it did at one point.  But I am not sure if that was when we were on GP2010.



    ------------------------------
    Thomas Hill
    Accounts Payable - Expense Processing
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------


  • 2.  RE: Integration Manager - GP2015R2
    Best Answer

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 09:42 AM
    ​Hi Thomas,

    Integration Manager generally pushes data into GP, as if it were being keyed-in through the user interface. (unless you are using eConnect destinations). So it doesn't expect to have a vendor or invoice on hold. You would need to remove the on hold vendors from the integration, or use another trick to resolve the issue.


    ------------------------------
    Mark Wiley
    Dynamics Credentialed Professional
    Senior Consultant
    DXC Technology
    Akron, OH
    ------------------------------



  • 3.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 09:59 AM
    Thank you Mark.  I may have to find the time to explore eConnect use over just Integration Manager.

    ------------------------------
    Thomas Hill
    Accounts Payable - Expense Processing
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------



  • 4.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 11:01 AM
    ​After looking at the Payables Transaction integration, it doesn't appear that there is a setting which will allow you to override the password requirement set by your AP department for On-Hold vendors.  Here's one way you might get around the issue:

    1.  Stage all the payments to a table in SQL.
    2.  Create a View which includes a flag (or flags) which indicate the status of the payment.  In this case you could join to the Vendor Master table (RM00101) and look at the INACTIVE and HOLD columns for indicators on the status of a Vendor.
    3.  Use the View as your datasource in the Integration and screen out anything with a flag.
    4.  After the integration completes, run a script which deletes any processed payments from the staging table.

    This approach would be simple to implement and maintain - being wholly dependent on the AP team for taking vendors off Hold before their payments can be processed into the system.


    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 5.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 11:43 AM
    The integration I am doing is in the Receivables Module, using SOP.  Although in AP, I got tasked with the subscription billing done each month.

    ------------------------------
    Thomas Hill
    Accounts Payable - Expense Processing
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------



  • 6.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 11:58 AM
    Overriding Customer Holds in Integration Manager​I misunderstood which one you were using.  Apologies.

    If you look at the options for the Receivables integration, there is an option to override Holds (see image).  You might try that.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 7.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 12:16 PM
    Thanks Blair.  I will check that configuration option.  I am still wrapping my hands around Integration Manager.  I am about to tackle integrating the checks that have cleared into Banking.

    ------------------------------
    Thomas Hill
    Accounts Payable - Expense Processing
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------



  • 8.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 01:59 PM
    ​You're also welcome to email me directly.  I've built a dozen different integrations for our company here and would be happy to help.  I've also detailed out most of the integrations available as to data types and destination field/tables.  I'm happy to share them.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID
    ------------------------------



  • 9.  RE: Integration Manager - GP2015R2

    TOP CONTRIBUTOR
    Posted Feb 06, 2019 03:33 PM
    Thank you Blair, I just might take you up on that.  We are working on some re-organization in accounting.  I have a feeling there are a number of tasks that will need to be changed to better work more directly with the software versus manually.

    ------------------------------
    Thomas Hill
    Accounts Payable - Expense Processing
    M&A Technology, Inc.
    Carrollton TX
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role