Every company has to make a series of payments to its Suppliers / Vendors. Nowadays, payments made using ACH are preferred by maximum companies because it not only saves time and money but is also easier and quicker to make payments/get paid with increased security while preventing the possibility of frauds.
Many of the Sage X3 users like to ease the Vendor payment process by exporting the payment information in the bank required format ACH NACHA from the system and sending the generated file to be used by the bank to import and execute the required payments. Both one time and recurring payment can be made using this method.
What is ACH?
ACH stands for Automated Clearing House, a network used for electronic financial transactions. The rules and guidelines governing the formats, specifications and exchange of ACH entries are published by NACHA, the Electronic Payments Association.
Advantages of using ACH payments:
- Reduces payment processing time.
- Eco-friendly, as checks don’t have to be printed.
- Greater security.
- Manual transport of cheques from company to the bank can be avoided.
Why is ACH customization required in Sage X3?
Payment file required by banks has to be in the NACHA ACH format. This cannot be currently exported in the desired format from Sage X3 using the standard X3 bank file export functionality due to the following limitations…
- Batch control records and File control records require some calculations which have to be customized for the company.
- Sum of all the Entry Hash fields in the ACH file has to be calculated using customization and truncated if the total contains more digits than the field size allows.
- In case of recurring exports of bank files, a specified file naming convention has to be followed. (I.e. The first file of the day will have ‘1’, second file will have ‘2’ and so on in the last position of a file name.)
- The Blocking factor record required in the bank file, to make the total number of lines in the exported ACH file as a multiple of 10, needs to be inserted using customization.
- Customization can be done to export the AP payments for a given invoice date range and/or given invoice number and supplier as well.
- Customization is required to ensure that the same record is not exported multiple times in case of recurring bank file exports.
How can the ACH – Sage X3 customization help the end user?
Greytrix’s easy to customize solution uses a combination of standard Sage X3 settings and customized entry screen. Supplier, Customer and Bank information saved in the Sage X3 system is used to generate the ACH bank file. Customization can be used for any US bank with minimal modification required to make the generated ACH bank file compliant with the specific bank and specific X3 installation. A user entry screen to specify the range of suppliers for which the payments are to be generated is also provided to enable the end user to create a single bank file.
If you are looking for tailor made features to enhance your Sage X3 functionality and experience for your industry, Greytrix would be your right choice.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.
Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.
Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.
For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.
