KEMBAR78
Steps: How To Upload Mappings For A Mapping Set Using FBDI | PDF | Business
Scribd
Upload
1K views5 pages

Steps: How To Upload Mappings For A Mapping Set Using FBDI

1. Download an Excel template to enter mapping set data including the mapping set name, application name, and mapping values. 2. Validate the entered data and fix any errors. Generate a CSV file from the Excel file. 3. Upload the CSV file through the "Load interface file for import" scheduled process in FinanceBuilder, selecting "Import Accounting Setup" and providing the CSV zip file. The import will insert all new mappings or fail if any data is invalid.

Uploaded by

sanjeev19_ynr
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
1K views5 pages

Steps: How To Upload Mappings For A Mapping Set Using FBDI

1. Download an Excel template to enter mapping set data including the mapping set name, application name, and mapping values. 2. Validate the entered data and fix any errors. Generate a CSV file from the Excel file. 3. Upload the CSV file through the "Load interface file for import" scheduled process in FinanceBuilder, selecting "Import Accounting Setup" and providing the CSV zip file. The import will insert all new mappings or fail if any data is invalid.

Uploaded by

sanjeev19_ynr
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
You are on page 1/ 5

How to Upload Mappings for a Mapping Set using FBDI

Steps
1.Download the Mapping Set FBDI template XlaMappingsImportTemplate.xlsm . Template can
be downloaded from here
2.Enter the mapping set data. In the XLSM template, open the Mappings worksheet and enter
Mapping Set Short Name, Application Name in Header part and Mapping Set Values data in Child
section and save.
3.Validate the entered data. Click on Validate Button in the sheet. This will validate the data entered.
Fix any errors reported, revalidate and save.
4.Generate CSV File. Navigate to “Instructions and CSV Generation” worksheet, Click on Generate CSV
FileWe ensured in macros- CSV File name is prefixed with “XlaMappingSetValuesInterface”. On
Prompt, user can select the destination folder and give any name to the Zip file
5.Upload Data. From Navigate to Scheduled Process – Select job –”Load interface file for import”
• Param 1 - Import process: Select “Import Accounting Setup”
• Param 2 – Data file: provide the zip file
• Submit the process
Demo – XLSM Template used to Generate CSV
Demo – XLSM Template used to Generate CSV
Demo
Quick reference points
1. In one CSV, user can upload Mappings related to one Chart of Account. To upload mappings
related to multiple chart of accounts for same mapping set, user need to prepare different CSV
files and upload separately.
2. Import process work on basis of “Upload all or none”. i.e if there is any one row invalid, entire
data is held back, and user needs to correct the reported data issue in XLSM / CSV file and upload
again.
3. By default, only insertion is supported. Hence user need to upload only new mappings in CSV. If
any existing row is present in CSV, import would end in error, for duplicate data violation.
4. Below is a sample to check error in log file.

You might also like