PERIODIC CONSOLIDATED INVOICE

1
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.
2
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

3
SOLUTION OVERVIEW
Define 1st 2nd half Payment Terms
Assign Payment Terms To Customer
Set Billing Format To Imported
1
Switch Payment Terms between 1st to 2nd and 2nd
to 1st half
Develop Autoinvoice Preprocessor
2
Group invoices After Autoinvoice
Group invoices by Bill-To Customer and Payment
Term
Include only Transactions with NO Cash Activity
3
Use Imported Billing Number Parameter
Define Print Program
4
4
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

5
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

6
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

7
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

8
PAYMENT TERMS
9
AUTOINVOICE PRE-PROCESSOR
Switch Payment Term to this
10
INVOICE GROUPING
11
PRINT PROGRAM