Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Thomas Hill]

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

[Mark Wiley]

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

[Thomas Hill]

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

[Blair Christensen]

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

[Thomas Hill]

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

[Blair Christensen]

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

[Thomas Hill]

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

[Blair Christensen]

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

[Thomas Hill]

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