110 likes | 559 Views
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.
E N D
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 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
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
AUTOINVOICE PRE-PROCESSOR Switch Payment Term to this