Tuesday, September 12, 2023

EDI Setups for 820 Outbound

Bank Accounts Tab(At Supplier Site)
Supplier NameAPPLIED INDUSTRIAL FLOORING
Site NameMISSISSAUGA
Payment Method Electronic
Bank Account NameAPPLIED INDUSTRIAL FLOORING
Number 1
Bank NameDUMMY-CAD
Number 9999
Branch NameDUMMY BANK-C


EDI Tab(At Supplier Site)
EDI ID Number99999
Payment MethodZZZ
Remittance MethodEDI to payee
Remittance InstructionEDI Remittance Instructions
Transaction HandlingC

Payment Formats
Document NameHSBC - CAD CNR
Disbursement TypeCombined
Payment FormatEDI Outbound Program - CAD
Payment MethodElectronic


Define Trading Partners

How to you setup EDI Payment Outbound 820?
EDI Payment Outbound 820 (ECEPYO) 
1Profile Options Setup 
Using the System Administrator Responsibility navigate to Profile -> System
Set the following: 
 
    Profile = 'ECE: Output file path' 
    Site = ... (Path for output file directory) 
           Example: Site = /sqlcom/outbound
 
 
2init.ora setup
Add an environment vialable "utl_file_dir" in $ORACLE_HOME/dbs/init.ora 
Example:  utl_file_dir = /sqlcom/outbound
 
This path needs to be exactly same as the path you have defined in Profile 
Option. 
 
 
3Format Program Setup 
Using the Payables Responsibility, navigate to Setup->Payment->Format
Set the following: 
    Payment Format = EDI Outbound Program 
    Payment Method = Electronic Payments
    Currency = USD
    Build Payments = Build Payments Program
    Format Payments = EDI Outbound Program 
 
4Internal Bank Account Setup 
Using the Payables Responsibility, navigate to Setup->Payment->Banks 
setup a Bank Account as follows: 
 
    Bank Branch Type = (Select from LOV) 
    Account Use = Internal
    Account Type = EDI
    EDI Location = ...(Path for output file directory)
 
Create a new Payment Document to use 
Payment Format = EDI Outbound Program
 
 
5Supplier Bank Account Setup 
Using the Payables Responsibility, navigate to Setup->Payment->Banks
 
Create a new Bank Account, set: 
 
    Bank Branch Type = (Select from LOV)
    Account Use = Supplier
    Account Type = EDI
  
6Supplier Site Setup 
Using the Payables Responsibility, navigate to Supplier->Entry
 
Query the supplier, then choose the Site. 
 
Bank Account Region:
    Fill in the supplier bank account,
    Set Primary to 'Yes'. 
 
Electronic Payment Region:
set the following (Contact with your internal bank branch to set them up): 
    Payment Method
    Payment Format
    Remittance Method 
    Remittance Instruction
    Transaction Handling
 
7Trading Partner Setup
Using the EDI Manager Responsibility, navigate to Trading Partners.
Define a trading partner for the internal bank branch.
Assignment Region: 
    Bank Branch = the internal bank branch.
Contact Region: 
    Set the contact information.
Detail Region: 
    Document = Payment/Remittance Outbound, EDI = Yes.
8Invoice for EDI 820 
Set "Payment Method = Electronic Payments" for the invoices which you'd like 
the payment batch to select.
9Preliminary Payment Regiter
Create a payment batch for using Payment Format = EDI Outbound Program.  View 
the Preliminary Payment Register to make sure there is at least one document 
going to be paid before you run the Format Payment Program.
10Format Payment Program and ECEPYO output file
If the Format Payment Program completes successfully, view the output, it will 
give you a number, for example, the number is 123. 
The output file ECEPYO.123 will be in /sqlcom/outbound directory.




hr_locations.location_id = financials_system_parameters.bill_to_location_idAP Financial Options
Set  Bank Branch = the internal bank branchEDI Trading PartnersGo to the Trading Partner Setup Assignment Region

No comments:

Post a Comment