After consulting on the Acumatica forums, I have been instructed that the tables which are available for ACH coding are restricted so that each entry is technically unique. But, the field I wish to display in the ACH lines is what we use in a Reference Number field (not necessarily unique, but the way we use it IS actually unique). While I can't join to the tables that would hold the data I want, is it possible to create a custom data field/attribute in APPayments (or one of the other tables that feeds the ACH coding forms) which I can then enter the Vendor Reference Number in order to pass it to the ACH code?
Acumatica - Modify APPayment table to contain User-Entered String for ACH
29 Views Asked by Don Ford At
1
There are 1 best solutions below
Related Questions in ACUMATICA
- Acumatica perfomance with threads
- Updating DAC Extension
- How to extend the RQRequestProcess release button
- Adding additional filter field on process shipments
- Process runs fine while running through process screen but not under automated schedule
- Acumatica BQL verification failed
- Can "Business Account" field ("AcctCD" field in database) be set as auto-generated id when a new Business Account is being added?
- How does function Match of Acumatica works
- Adding Acumatica Customer Contacts
- How to Check if Delete was Pressed as there is a MoveNext Error while deleting item
- Generic Inquiry - Format result column with two decimal places as number
- How to prevent discount in Acumatica?
- Sales order total different with actual total
- How to override the tax details when adding a sales order through web service API
- RevisionID may not be empty inserting purchase order
Related Questions in BANKING
- Managing a file
- How will a back dated transaction insert be traced in a timeseries container in griddb?
- How does one ascertain what the components of RFC 3615's examples represent?
- Implementing Razorpay Withdrawal System in Website
- Django: Implementing fund reversal in post_save signal
- Workload modelling_JMeter Performance Testing
- EBICS 3.0 Schema H005 Ebics errorcode 090004
- How can I serialize the Transaction model in django rest framework
- Acumatica - Modify APPayment table to contain User-Entered String for ACH
- R package for FFIEC and UBPR bank data
- Account statement of Different banks in PowerBI
- Implementing Name Synchronization and Money Transfers in Transactions Model with Account Number Input
- How did online banking work before Netscape added support for JavaScript and cookies in September 1995?
- Looking for Python package to parse NACHA files
- Counting balances in fintech project
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
In ACH files, you only have a few fields to put custom data in. The Identification Number is very common to put a reference number into. It's 15 characters long. Sometimes you have available the Entry Descriptor as well to set. ACH format also allows for an addenda record as free text.
These are in the actual NACHA format, so they should be supported by any vendor that takes ACH payments. If they show up in the file, they should be in the database as a field to join on.