Monday 8 April 2019

How to upload bank statements in Fusion:

1) Get the BAI2 files
2)go to schedule process and submit a program with below details.

load interface file for import 

parameters : Process BAI2 Format Bank Statements and select data file.

Once this program is complete you will able to see the transactions in system.

From:

 Manage Bank Statements in Cash Management role

3)Then you have to create a external transaction for the uploaded statements.

go to schedule process and submit a program with below details.

Create Bank statement Transactions 

Parameters are Bank account details and from and to date of statements.

Once this is done you are able to see these details in
Manage external Transactions in Cash Management role


4) Final process is need to move the transactions to accounting .

Submit a program called create accounting 

With below parameters:

Sub ledger as Cash management.

Ledger Name: you ledger Name.

Process Catagory as : External Transactions.

end date:

accounting mode: Final

Process Events: All

Report Style: Summery

Transfer to GL: Yes

Post GL: Yes

Journal Batch:

Include User transaction identifiers: Yes

Once it is done loading statement process is done.


No comments:

Post a Comment