Welcome

Welcome to the More4apps ERP Cloud Toolbox Finance Module.

Through the use of our Microsoft Excel ERP Cloud Toolbox Add-in, More4apps now offers a new Oracle Cloud solution, providing assistance with data processing, manipulation and cleansing of the Oracle ERP Cloud Finance area.

The Finance Module contains a growing list of Integrators. It currently performs the following:

Integrator	Tasks
Payables Invoices	Create invoices, debit memos, and credit memos. Create invoices with headers only. Create invoice lines with GL accounts, distribution sets, purchase orders, or project accounting information. Download Purchase Order details for easy matching to invoices. DFF and Global DFF support at header, lines and distributions. Attachment upload. Holds during invoice creation. Add holds to existing invoices. Download existing invoices, credit memos, debit memos and their associated lines and distributions. Run Payables Invoice Validation during invoice creation. Run Payables Calculate Tax during invoice creation.
Receivables Invoices	Create invoices - Excludes credit & debit memos. Create invoices with headers and lines using AutoAccounting. Create invoices with headers, lines and distributions. DFF and Global DFF support at header, lines and distributions. Header Attachment upload.
Receivables On-Account Credit Memos	Create Credit Memos with headers and lines using AutoAccounting. Create Credit Memos with headers, lines and distributions. Apply new or existing on account credit memos to existing transactions. DFF and Global DFF support at header, lines, distributions and applications. Header Attachment upload.
Holds and Releases	Create holds against existing invoices (Create). Create holds and releases at the same time (Create). Apply releases to existing holds (Update). Download Invoice and Hold data using different download sources. Holds DFF support.
Suppliers	Create and update Supplier Master Data including suppliers, addresses, sites and site assignments, business classifications, products and services, contacts, contact addresses and Third-Party Payment Relationships. DFF and Global DFF support at Supplier and Site level Supplier Attachment upload. Submit the Spend Authorization process during upload.
Customers	Create and update Customer Master Data including parties, accounts, profiles, contacts, contact assignments and, responsibilities, addresses, sites, site purposes and site reference accounts.
Asset Additions	Create Fixed Assets including Transactions, Assignments and Source Lines.
Asset Adjustments	Update Descriptive Details and Financial Details.
Asset Assignment Transfers	Create Assignment Transfers of existing units.
Supplier Payment Details	Create and update Payment Attributes, Payment Methods and Bank Account Assignments for Supplier Profiles, Addresses and Sites.
Supplier Bank Accounts	Create and update Bank Accounts, Bank Account Owners, Intermediary Bank Accounts and Assignments at Supplier, Address or Site levels.
Receivables Receipts	Create and update Manual Standard AR Receipts with Remittance Bank and, optionally, Customer Account information. Apply Receipts to Transactions or On Account. Unapply Receipts. Reverse Receipts. Create Miscellaneous Receipts. Create Receipt Refunds and Receipt Write-offs. Adjust Applied Transactions.

Integrator

Tasks

Payables Invoices

Create invoices, debit memos, and credit memos.
Create invoices with headers only.
Create invoice lines with GL accounts, distribution sets, purchase orders, or project accounting information.
Download Purchase Order details for easy matching to invoices.
DFF and Global DFF support at header, lines and distributions.
Attachment upload.
Holds during invoice creation.
Add holds to existing invoices.
Download existing invoices, credit memos, debit memos and their associated lines and distributions.
Run Payables Invoice Validation during invoice creation.
Run Payables Calculate Tax during invoice creation.

Receivables Invoices

Create invoices - Excludes credit & debit memos.
Create invoices with headers and lines using AutoAccounting.
Create invoices with headers, lines and distributions.
DFF and Global DFF support at header, lines and distributions.
Header Attachment upload.

Receivables On-Account Credit Memos

Create Credit Memos with headers and lines using AutoAccounting.
Create Credit Memos with headers, lines and distributions.
Apply new or existing on account credit memos to existing transactions.
DFF and Global DFF support at header, lines, distributions and applications.
Header Attachment upload.

Holds and Releases

Create holds against existing invoices (Create).
Create holds and releases at the same time (Create).
Apply releases to existing holds (Update).
Download Invoice and Hold data using different download sources.
Holds DFF support.

Suppliers

Create and update Supplier Master Data including suppliers, addresses, sites and site assignments, business classifications, products and services, contacts, contact addresses and Third-Party Payment Relationships.
DFF and Global DFF support at Supplier and Site level
Supplier Attachment upload.
Submit the Spend Authorization process during upload.

Customers

Create and update Customer Master Data including parties, accounts, profiles, contacts, contact assignments and, responsibilities, addresses, sites, site purposes and site reference accounts.

Asset Additions

Create Fixed Assets including Transactions, Assignments and Source Lines.

Asset Adjustments

Update Descriptive Details and Financial Details.

Asset Assignment Transfers

Create Assignment Transfers of existing units.

Supplier Payment Details

Create and update Payment Attributes, Payment Methods and Bank Account Assignments for Supplier Profiles, Addresses and Sites.

Supplier Bank Accounts

Create and update Bank Accounts, Bank Account Owners, Intermediary Bank Accounts and Assignments at Supplier, Address or Site levels.

Receivables Receipts

Create and update Manual Standard AR Receipts with Remittance Bank and, optionally, Customer Account information.
Apply Receipts to Transactions or On Account.
Unapply Receipts.
Reverse Receipts.
Create Miscellaneous Receipts.
Create Receipt Refunds and Receipt Write-offs.
Adjust Applied Transactions.

The Finance Module is an Excel user interface built on top of the supported Oracle REST Web Services, designed to upload and retrieve data to and from the Oracle ERP Cloud Application. All standard features of Microsoft Excel are also available to the user and columns can be moved to suit user preference.

This document is written with the assumption the user knows how to work within the Finance sector of Oracle ERP Cloud from a functional point of view. The document explains functionality up to and including the latest release. Refer to the Release Notes to explain the differences between module releases.

This module is supported on Oracle Cloud 20D (11.13.19.02.0) onwards. If any issues are encountered or you have any enhancement suggestions, please go to our online community.