PERIODIC CONSOLIDATED INVOICE Presenters Ron Pollard CIO Specialized

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 & 2 nd half Payment Terms Assign Payment Terms To Customer 2 Develop Autoinvoice Preprocessor Switch Payment Terms between st 1 to 2 nd and 2 nd to 1 st 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_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 § Auto. Invoice 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

PRINT PROGRAM