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 answers
Related Questions in ACUMATICA
- How to save the Change Orders screen automatically
- Acumatica application version mismatch with the L100 snapshot
- How to Access PXSelectorAttribute Joined Table
- Multi-selector Selector in Acumatica
- Update an attribute based User Defined Field using Acumatica.RESTClient.ContractBasedApi
- Is there a way to override [PXCopyPasteHiddenFields] on a built in view in Acumatica?
- How do I add a row in Employee Timecard via BLC code?
- How to modify the Create Prepayment action/button on Purchase Order?
- Using Checkbox Filter in GI for an API Call Always Returning True
- Subreport to add a new page per Main report item
- Acumatica API / Appointments / LocationID cannot be empty
- TemplateNotificationGenerator with PDF File from Rapport
- different reaction between with UI and REST API
- Change Location DescriptionField attribute to pull from another DAC
- How to save custom Workspace Tiles to a Customisation Project Package?
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
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?
Popular Tags
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)
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.