1 / 11

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.

dmonk
Download Presentation

PERIODIC CONSOLIDATED INVOICE

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 • Cash applications possible against consolidated invoice

  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

More Related