Transcript 11.5.7 Payables New Features

11.5.7 Payables New Features
Steve Bradley
OASIS Consulting Group
Introduction
• Oracle has worked out most of the initial
bugs in 11i. Now they are rolling out
some really nice features that make the
move to 11.5.7 worthwhile
• My current project is upgrading a 10.7
Character and SC client to 11.5.7/8
NACHA Payment Format
• Finally!!! It has taken Oracle over 10
years to come up with this commonly
requested feature.
• In 11.5.7 you can now use direct deposit
for vendor/employee payments.
• We have taken this format and back
ported it to 10.7. This is not Oracle
supported but can be done easily.
E-mail Remittance Advice
• You can have Oracle Payables send the notification
of payment via e-mail by including an e-mail address
in the vendor site Payments region
• Notify employees of direct deposit payments of
expense reports
• The E-mail Remittance Advice includes appropriate
payment information for all invoices on each payment
• It is automatic upon confirmation of payment batches
or Quick payments
Enhanced Key Indicators Report
• This report can now be run on individual
Payables users or the full department.
Employee Update Program
This was included in 11.5.5 but is worth a
mention here.
• Updates the Payables supplier record
for any employee information changed
in HR or from the Enter Person form
• This program is run when you import
expense reports or it can be run as
needed
Enhanced Suppliers Report
• The old “New Supplier Site Listing” has been
eliminated by combining it with the “Suppliers
Report”
• New selection criteria have been added so
you can select by income tax reportable or
maintenance performed by a specific person
• New data in the report includes remittance
bank account, TIN, income tax type and
payment method
Approval Manager
This is so new, Oracle Sales did not know
about it and will not be able to demo it
until late November
There is very little activity for this topic on
the list servers
It is the future direction of approval routing
for all workflows
Approval Manager (cont.)
• Currently available for:
– Invoice Approval
– Expense Report Approval
– Purchase Requisition Approval
Approval Manager (cont.)
• It is a highly sophisticated method of selecting
the correct approval routing for documents
• Supports complex rules including:
– Pre-approval and post approval review groups
– Designated approvers for temporary absences
– Approval routings for
• specific documents
• departments
• other items you may want to define
Invoice Approval
• Uses Approval Manager to route
invoices for payment approval
• Invoice header and at least one
distribution line must be entered
• Entry of the “Requestor” of the product
or service becomes the “seed data” for
the approval process
Invoice Approval (cont.)
• If Invoice Approval is invoked almost all
invoices must be processed by the
Invoice Approval Workflow
• Exceptions:
– Imported Expense Reports
– Recurring invoices where template
indicates no approval
– PO Matched (can be configured to omit)
Effective Exchange Rate Calculation
• This is nice if you know the foreign
currency and functional currency
amounts for an invoice but not the
exchange rate.
• Enter both of these and Oracle will
calculate the exchange rate for you.
Unclaimed Property Report
• This report can be used to satisfy the
escheat laws. It lists all uncleared
Payables payments.
Payment Batch Scheduling
• Define payment batch sets (including
multiple accounts) and schedule them
for regular payment intervals.
• The scheduling routine will change the
pay through dates, exchange rate date
and payment dates as needed.
Automatic Bank Transmission
• Workflow is used in this feature to
transmit bank payment data and receive
payment confirmations.
• By combining this with the NACHA
payment format, payment batch
scheduling and e-mail notification you
can automate the whole payment
process for electronic payments.
Primary Pay Site
• If a supplier has more than one site you
can now specify one of them as the
Primary Pay Site.
• The Primary Pay Site will then be the
default site displayed for invoice entry
(as if it were the only site for the
supplier).
Still Not Fixed
• Laser check printing:
– Oracle’s “new” solution still requires custom code
for logos, signatures and MICR line
– Also suggests using Evergreen solution
• Invoice and Payment Currency not the
same:
– You still cannot enter a French Franc (EURO now)
invoice and pay it in USD. You can enter a French
Franc invoice and pay it in EURO.
11.5.7 GL New Features
Steve Bradley
OASIS Consulting Group
FSG Report Set Enhancements
• Multiple users can view and submit FSG
report sets at the same time.
• Prior versions locked the report set
when it was in use.
• Additionally, a history of report set
submissions is now maintained so ADI
users do not need to resubmit reports
sets to publish them in ADI
Hierarchical Security Support
• Hierarchy security relates to security
assigned to Parents of child segment
values.
• The children inherit the security
assigned to the parent.
• This means you can assign security to
the Owner’s Equity parent and have it
affect all children of that parent.
FSG Hierarchical Security Support
• This is a companion feature to
Hierarchical Security
• It provides the functionality for FSG
reports to exclude child data that is
secured at the parent level
• The security is assigned to the users by
responsibility.
Enhanced Compatibility
• Now you can perform the following in
multiple sets of books at the same time
(in parallel).
– Budget Upload
– Translation
– Open/Close Periods
– Posting
Enhanced MassAllocation
Performance
• The performance has been enhanced
for formulas that process large numbers
of child segments.
Account Hierarchy Manager
• This is in effect a web version of the ADI
Account Hierarchy Editor.
• It does not require the installation of any
client software at the PC level
Segment Value Security for
Journals Reports
• All of the journal listing reports have
been modified to exclude data in
compliance with Flexfield security
assigned to their responsibility.
Journal Import Adjusting Period
Support
• Prior to this enhancement, imported
journals (including ADI) could only use
non-adjustment periods.
• Now Period Name and Accounting Date
will be used.
• In cases of conflicting periods from
these values the Accounting Date will
typically be used.
Journal Import Currency
End Date Bypass
• This feature permits the import of
journals using expired currency codes.
• It does require the creation of a custom
profile option for its use.
11.5.7 New GL & AP Features
Questions will be addressed
in Breakout Session
Steve Bradley
OASIS Consulting Group, Inc.
[email protected]
(404) 788-8787