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.
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