Skip to main content
Solved

Routing number error when exporting payments

J
Freshman I

When exporting a payment batch an error appears saying

“The bank routing number specified for the vendor is invalid or empty. The number must be at least 8 digits.  Verify the vendor’s payment settings on the Vendors (AP303000) form.”

Is there a way to find out which vendor is the issue?  We’re dealing with a batch of hundreds of payments and don’t have a way to easily narrow it down.  

Best answer by ChandraM

Hi Jhinton, Please find the attached Generic Inquiry xml. You can import this file in the “Generic Inquiry”

The “View Inquiry” option will provide the below details for you to identify the issue.

 

  • filter the above Inquiry by “Payment Methodid” for ACH, review the data and identify the issue
  • For your convenience, provide created date and last modified date for the payment details that were created newly
View original
Did this topic help you find an answer to your question?

11 replies

C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • 715 replies
  • December 15, 2021

Hi @jhinton1 Please confirm if you are try to use Export Scenario to export the ACH details?

Chandra M
iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
J
Freshman I
  • jhinton1
  • Author
  • Freshman I
  • 4 replies
  • December 15, 2021

We’re exporting the txt file for upload to the bank from screen Batch Payments screen ID CST.AP.30.50.00.  Using the Export button next to the Actions drop down.

1 Attachments
iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
J
Freshman I
  • jhinton1
  • Author
  • Freshman I
  • 4 replies
  • December 20, 2021
ChandrasekharM wrote:

Hi @jhinton1 Please confirm if you are try to use Export Scenario to export the ACH details?

quoting just in case replying didnt notify you i responded earlier

iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
J
Freshman I
  • jhinton1
  • Author
  • Freshman I
  • 4 replies
  • December 29, 2021

Still looking for some assistance on this one

iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2759 replies
  • December 30, 2021

Hi @ChandrasekharM - anything further you can offer @jhinton1 ? Thanks and Happy New Year!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • 715 replies
  • December 30, 2021

Hi @jhinton1 Please send me the screenshot of the ACH Payment Method that you are using shown the below Export Scenario name:
 

Thanks

CC: @Chris Hackett 

Chandra M
iqraharrison
Chris Hackett
2 people like this
  • iqraharrison
    iqraharrison
  • Chris Hackett
    Chris Hackett
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • 715 replies
  • December 30, 2021

Hi @jhinton1 Will provide a Generic Inquiry to you shortly. You can use this Generic Inquiry to verify the Vendor ACH details, and identify the issue on the Vendor Bank details. Hope that helps for your original query.

Thanks
 

 

Chandra M
iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
C
Semi-Pro I
Forum|alt.badge.img+8
  • ChandraM
  • Semi-Pro I
  • 715 replies
  • Answer
  • December 30, 2021

Hi Jhinton, Please find the attached Generic Inquiry xml. You can import this file in the “Generic Inquiry”

The “View Inquiry” option will provide the below details for you to identify the issue.

 

  • filter the above Inquiry by “Payment Methodid” for ACH, review the data and identify the issue
  • For your convenience, provide created date and last modified date for the payment details that were created newly
1 Attachments
Chandra M
K
iqraharrison
Chris Hackett
4 people like this
  • K
    kmckenzie
  • iqraharrison
    iqraharrison
  • Chris Hackett
    Chris Hackett
  • J
    jhinton1
J
Freshman I
  • jhinton1
  • Author
  • Freshman I
  • 4 replies
  • December 31, 2021

thank you!  we’ll try this

iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
D
Jr Varsity III
Forum|alt.badge.img
  • dgross54
  • Jr Varsity III
  • 47 replies
  • September 12, 2022

Hello, I am troubleshooting the same issue and used the attached GI but nothing is showing up that comes from the VendorMethodPaymentDetail DAC.  I checked two other instances and this DAC does not have any data in it.  Is there something else to try?  The vendor payment method matches the payment method in the batch/checks.

 

 

 

iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison
E
Freshman I
  • ericmack94
  • Freshman I
  • 16 replies
  • March 15, 2023

Does anyone know off hand how to get that GI to show payment method and details for all locations for a vendor as well?

iqraharrison
1 person likes this
  • iqraharrison
    iqraharrison

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved