How to get the payload file from payments:


SELECT DOCUMENT FROM IBY_TRXN_DOCUMENTS WHERE PAYMENT_INSTRUCTION_ID =<document number from payment>

How to get the payment file information:

Transmit Payment File log  for file name

Format Payment Files for xml file

How to define a AR template for each BU :

Transaction « View Image » By Business Unit (Doc ID 2188688.1)

<?if:AmountChangeDisplay !=''?>Net Order Amount Changed :<?AmountChangeDisplay?> <?end if?>


<?if:OneTimeLocationFlag>0?><?ONETIMEADD?>  <?end if?>


<?if:RevisionNum <>''?>Revision :<?RevisionNum?> <?end if?>

<?if:OrderedDisplay=''?>Ordered :<?RevisionNum?> <?end if?>

<?if:RevisionNum=''?>Revision :<?RevisionNum?> <?end if?>

<?if:RevisionNum=''?>Revision :<?RevisionNum?> <?end if?>

<?if:RevisionNum !=''?>Revision:<?RevisionNum?> <?end if?>

<?if:ChangeOrderDateDisplay !=''?>Change Order Date::<?ChangeOrderDateDisplay?> <?end if?>

Ordered: <?OrderedDisplay?> <?CurrencyCode?>

<?if:OrderedDisplay !=''?>Ordered:<?OrderedDisplay?> <?CurrencyCode?> <?end if?>


Order Amount Before Change: <?OriginalOrderAmountDisplay?>



<?if:AmountChangeDisplay !=''?>Net Order Amount Changed :<?AmountChangeDisplay?> <?end if?>

<?if:RevisionNum !=''?>Revision:<?RevisionNum?> <?end if?>

<?if:RevisionNum !=''?>Revision:<?RevisionNum?> <?end if?>








<?if: INVOICE_CURRENCY_CODE ='CAD'?> 'USD Cu' <?end if?>

<?if:OneTimeLocationFlag>0?><?ONETIMEADD?>  <?end if?>


Net Order Amount Changed : <?AmountChangeDisplay?>


<?ChangeOrderDateDisplay?>

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.

Manage Transmission Configurations To do the setups related to payments.

Accounts Payable Payment Supervisor role for creating payments

Accounts Payable Specialist for creating invoices


Transmission Configuration to configure the server details.

Communicate Purchasing Documents to send the emails


Disable the profile option at the site level.

Here is the navigation:
1. Setup and Maintenance
2. Search 'Manage Administrator Profile Values', & click.
3. Enter 'Control Supplier Communication' in the field 'Profile Display Name'
4. Click on that record in the search result
5. Change Profile value to 'Disable' at the 'Site' Profile level.
6. Save and Close.
7. Sign out and sign back in.