Bank File Definitions can be very boring to create because each bank has different configuration setup. We spend most of our time in designing the configuration setup and testing it in the test environment. Once we have finished with the testing in the test environment, how can we configure the same bank file definition in the live folder?
We have the option of manually entering the definitions in the live folder which could be very time consuming and prone to types with all those formulas with multiple commas, semicolons, brackets, etc and there is a chance of doing mistakes in the setup.
To overcome that we could use the copy option. We need to navigate to Setup >> A/P-A/R accounting >>Bank file definitions.
However, copy of objects are only allows duplicating one definition at a time. If we wish to copy it on a different server, there isn’t a way to copy the bank file definition from here.
We can also take patch of the configured bank file definition. For that we need to navigate to Development >> Utilities >> Patches >> Patch creation
As shown in above figure we will select the destination type as ‘Client’. We will select the folder from which we have created bank file definition as we have created it in ‘SEED’ folder. We will select type as ‘AAA’. Click on action button on object name field and select the ‘Data models’
Setup template screen will be displayed as shown in below figure 4. Select data model as ‘TABFILBAN’ and click on the ‘OK’ button. After that we will return to the patch creation screen and an Object name formula is generated.
A patch of AAA type corresponds to a line coming from a setup model. It uses a specific format for the element code. This format is one of the two following:
MODELE~CODE_LEG~CODE_TRS~=’FORMULE_SELECTION’
MODELE~CODE_LEG~CODE_TRS~CLE~SOUS_CLE~SOUS_SOUS_CLE…
MODELE corresponds to the data model used to describe the tables to extractt
CODE_LEG corresponds to the legislation code, which can be empty (in this case, two ~ are placed one after the other)
CODE_TRS corresponds to the transaction code, which can also be empty
FORMULE_SELECTION is a filter condition. Any text chain must be put ‘in double quotes’ since the formula is put in ‘simple quotes’.
CLE~SOUS_CLE~SOUS_SOUS_CLE (the number of sub-keys being variable) corresponds to the specific case when it is required to select a key value corresponding to the model main table. It is only possible when calling up a model (AAA code) from the patch creation and then opening the window making it possible to select the model and enter the key by direct search.
We are using the first format. We will change the Object name from TABFILBAN~~~=” to TABFILBAN~USA~~=” which will filter our patch to include only Bank file definitions for the USA legislation.
For Type of patch, we will select Standard. Then, click OK to generate the patch.
The file is generated to our desktop’s Downloads directory and the file name will start with the letter “F.” We are ready to apply the patch. The file can be copied to the server of our choice for Patch Integration. Please note, The Patch integration process will copy over existing records if their identities are the same. Make sure to generate a patch from the same version and patch level as your intended target because the table structures may have changed.
Hence by doing above process in Sage X3, we can copy or take patch of the bank file definitions configuration.
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.