Datasheet

Release Notes - New Features included in Release 2.4.0
Page 56 of 89
4. Within the Oracle Financials environment, run the programs which process the fixed-filename
csv files, inserting entries into the Oracle Financials OpenInterface tables.
5. Run the Oracle Financials Open Interface programs to create corresponding journals, purchase
invoices and credits and sales invoices and credit notes.
The types of data extracted from TROPOS include static data (customers and supplier payment
accounts), sales invoices and credit notes, purchase invoices and credit notes and postings that
represent stock movements and revaluations.
The extraction of TROPOS financial information is performed on-line by four transactions which
are part of the TROPOS Accounting Control module.
Oracle Financials to TROPOS Interface Operation
The Oracle Financials to TROPOS interface also has two distinct phases:
1. Extraction of Oracle Financials data and transfer to TROPOS.
2. Update of TROPOS.
Customer receivables balances are extracted from Oracle Financials using a program that runs
within the Oracle Financials environment. The program generates files that contain the customer
receivables balances for each different Operating Unit within Oracle Financials. These files must be
renamed and transferred to the TROPOS system. The TROPOS CUPR (Process Receivables
Balances) transaction processes the renamed files and updates the receivables balance held for each
customer in TROPOS. This procedure can be configured to run automatically at user-defined
intervals.
4.2.16.2 Maintain Customer Refs for Oracle Financials Integration (SR4065)
This enhancement allows TROPOS to support the interface to Oracle Financials when customers
are already defined in OF Receivables. It takes account of situations where the customer number
used in TROPOS is different to the OF original system customer reference, which must be used
when posting invoices and credits to the OF Receivables Open Interface.
Manual Set-Up Procedures
Refer to TOCM transaction help text for guidance as to how and when this facility should be used.
4.2.16.3 Introduce Transaction Type as new TOFP Parameter (SR4066)
The parameters used by TROPOS for integration with Oracle Financials have been extended to
include the Transaction Type to be used when posting sales invoices and credit notes. As these
parameters are defined for each business, it is now possible to utilise a different Transaction Type
for sales invoices and credits for each business.
It is now possible to derive the GL account for VAT by obtaining 1 or more account segments from
the Transaction Type by using OF Receivables AutoAccounting. Thus if there are multiple
TROPOS businesses interfacing to the same Set of Books, a different GL account for VAT can be
assigned for each source business.
Manual Set-Up Procedures