AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Use of ACH Payment ...
 
Notifications
Clear all

Questions Use of ACH Payment Export with Company ID = 10 digits?

 
Everything Else
Last Post by Michael.Barker 5 years ago
4 Posts
2 Users
1 Reactions
2,692 Views
RSS
Michael.Barker
Posts: 28
 Michael.Barker
Topic starter
July 27, 2020 1:58 pm
(@michael-barker)
Eminent Member
Joined: 6 years ago

Hello AUG,

We implemented ACH payment processing earlier this year with great success. We have since added a new bank account to our portfolio that has a company ID of 10 digits. This is throwing errors on exporting the batch (attached) "Column 'BH_CompanyIdentification' size should be shorter than 9 symbols.

image

The bank has confirmed the company ID is 10 digits. 

What we have done:

1. Updated the remittance entry mask to enable 10 digits on the Company ID

2. Defined the remittance settings on the cash account

3. Updated the data provider for the above field to be 10 digits - no success

4. Scoured the export scenario for anywhere else the string length is defined to 9 digits

Can someone please help advise if we are even able to update the BH_CompanyIdentification string length to 10 and it still work?

 

Thanks!


Topic Tags
cash account; ach;
3 Replies
Michael.Barker
Posts: 28
 Michael.Barker
Topic starter
July 29, 2020 4:01 pm
(@michael-barker)
Eminent Member
Joined: 6 years ago

Figured it out. Thanks for looking!

FYI - Data Providers, Export Scenarios, Cash Accounts, Payment Methods are fun!


Reply
MSylvia
 MSylvia
(@msylvia)
Joined: 5 years ago

Active Member
Posts: 6
August 12, 2020 11:09 am
Reply toMichael.BarkerMichael.Barker

@michael-barker what was the final fix? I'm running into the exact same issue and can't find why it still wants 9 digits instead of 10


Reply
Michael.Barker
 Michael.Barker
(@michael-barker)
Joined: 6 years ago

Eminent Member
Posts: 28
August 17, 2020 11:19 am
Reply toMSylviaMSylvia
Michael.Barker

@msylvia - On the Cash Account Remittance Settings tab, the Company ID field is the last 9 digits of the 10 digit company code. The Company ID type is the first digit in the 10 digit Company ID. 

In my case, we are using a very unique ACH provider that required duplicating and modifying the "canned" export scenario to modify some hard-coded fields on the bank export file.

Let me know if that helps!


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Left justify a field on a GI
    2 years ago
Topic Tags:  cash account; ach; (2) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 31 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×