Bank statement import for reconciliation via DIXF import setup.

// Bank statement import for reconciliation via DIXF import setup.

AFM_0277_Reconcile_Bank_Accounts:

1)      Target Entity Setup: (Bank statement report entry)

 

Go to Target entity from DIXF and click new and create a record as per below screenshot

Path: <company>/Data import export framework/setup/Target entities

Fig1.0

 

Click on Modify target mapping (highlighted in yellow Fig1.0) and set the target mapping as per below screenshot:

Fig1.1

Click on Entity structure (highlighted in yellow in Fig1.0) and set the target mapping as per below screenshot:

ü  Mark Run business validations

ü  Mark Run business logic as insert or update method

Fig 1.2

 

2)      Processing group Setup: (Bank statement report entry)

Click on new to create a new record for processing group. You have to create separate processing group for each bank.

Path :< company>/Data import export framework/Common/Processing group

FIG 1.3

 

Click on Entities (highlighted in yellow fig1.3) and set the Entity set up as per below screenshot.

ü  Provide the path of CSV file in the sample file path

ü  Select source date format as CSV

ü  Mark Run business validations

ü  Mark Run business logic as insert or update method

 

 

 

Fig1.4

 

Click on Modify source mapping from Fig1.4. set the mapping as below screenshot

 

Fig1.5

 

Go to mapping details from Fig1.5. Create new and select BankAccountID from staging field column and set Auto default to yes.

Set the mapping as below screenshot.

Fig1.6

Click on default value button in provide your bank details for which you have create a processing group.

 

Project XPO for reference:
https://drive.google.com/file/d/0B2J6oMXiIQ76RmVJSzQ2NzdoWUE/view?usp=sharing



1. DMFBankStmtISOReportEntryEntityClass -

This DMF class has implementation of importing data of bank statement to target table. - BankStmtISOReportEntryEntity.



2.BankStatementImportBatch - ( calling the DIXF batch automatically)

 this class has custom code for running the DIXF batch process automatically using dialog with processing group. considering each processing group refereeing to each bank for the import.