Transcript PERIODIC CONSOLIDATED INVOICE

PERIODIC CONSOLIDATED INVOICE
Presenters:
Ron Pollard, CIO, Specialized Bicycle Components
Co-Presenters:
Robert Hatter-Crawford, Senior Analyst,
Specialized Bicycle Components
Nathan Swaminathan, Solutions Partners, Inc.
Jennifer Martin, Solutions Partners, Inc.
BUSINESS REQUIREMENT
Produce Consolidated Invoices twice a month
 Invoices should look like normal invoices
- list all shipments in the prior 15 days
- should not be like a statement
- include all transactions like credit memos, debit
memos, etc.
 Separate invoices for different payment terms
SOLUTION OVERVIEW
Define
st
1 & 2nd half
Payment Terms
Assign
Payment Terms
To
Customer
2
Develop
Autoinvoice
Preprocessor
Switch
Payment Terms
between
st
1 to 2nd and
2nd to 1st half
3
Group invoices
After
Autoinvoice
Group invoices
by
Bill-To Customer
and
Payment Term
Define
Print
Program
Use
Imported Billing
Number
Parameter
1
4
Set
Billing Format
To
“Imported”
Include only
Transactions with
NO
Cash Activity
Oracle Vanilla Consolidated Billing Feature
 Customers configured with “Consolidated Billing Formats”
enabled, Type: Detail or Summary
 “Print Consolidated Billing Invoices” program processes all data:
- Loads selected invoices to
AR_CONS_INV_ALL
AR_CONS_INV_TRX_ALL
AR_CONS_INV_TRX_LINES_ALL
- CONS_INV_TYPE is “DETAIL” or “SUMMARY” in
AR_CONS_INV_ALL according to program argument
- Tracks running balances at consolidated invoice level
- Generates printable output with statement-like features
- Assigns selected invoices to one consolidated
invoice per customer
 Cash applications possible against consolidated invoice
Oracle Vanilla Imported Billing Number Feature
 Customers configured with “Consolidated Billing Formats” enabled,
Type: Imported
 User populates CONS_BILLING_NUMBER in
RA_INTERFACE_LINES_ALL table on pending invoices
 AutoInvoice program processes all data
- Loads selected invoices to
AR_CONS_INV_ALL (CONS_INV_TYPE is “MINV” )
AR_CONS_INV_TRX_ALL
AR_CONS_INV_TRX_LINES_ALL not populated
 User writes custom Invoice Print Program
 Cash applications possible against consolidated invoice
SBC Periodic Consolidated Invoices
 Combination of vanilla “Consolidated Billing” and “Imported
Billing” features in Oracle Receivables
 Customers configured with “Consolidated Billing Formats”
enabled, Type: Imported
 New Custom Package written to generate SBC invoice data
 Vanilla “Print Consolidated Billing Invoices” program cloned
and modified to process SBC invoice data and reformatted the
printable invoice output
 Data generated looks like vanilla Oracle and allows standard
handling by Oracle Receivables Application Forms and
Programs
SBC Periodic Consolidated Invoices - Details
 New Custom Package written to do processing and creation of data:
- Gathers open transactions in RA_CUSTOMER_TRX_ALL
based on selection criteria and program parameters
- Only transactions with no cash application activity selected
- Groups data by payment terms and bill-to customer site;
unapplied credit memos associated with last grouping for a
given bill-to customer site.
- Some logic from Oracle ARP_CONSINV package used
(originally called by vanilla “Print Consolidated Billing
Invoices” program)
- Loads selected invoices to
AR_CONS_INV_ALL (CONS_INV_TYPE is “MINV”)
AR_CONS_INV_TRX_ALL
AR_CONS_INV_TRX_LINES_ALL
PAYMENT TERMS
AUTOINVOICE PRE-PROCESSOR
Switch Payment Term to this
INVOICE GROUPING
SBC_AR_PERIODIC_CONS_INVOICES
Creates data from vanilla
Receivables tables:
AR_CONS_INV_ALL
AR_CONS_INV_TRX_ALL
AR_CONS_INV_TRX_LINES_ALL
SBC AR Periodic
Consolidated
Invoices
Consolidated
Billing Tables
SBCARXCBI_E
Oracle
Application
Tables
SBC Spain
Consolidated
Invoice
Generates Consolidated Invoice
from vanilla Receivables tables:
AR_CONS_INV_ALL
AR_CONS_INV_TRX_ALL
AR_CONS_INV_TRX_LINES_ALL
Consolidated
Invoice CFD
PRINT PROGRAM