PERIODIC CONSOLIDATED INVOICE - PowerPoint PPT Presentation

Loading...

PPT – PERIODIC CONSOLIDATED INVOICE PowerPoint presentation | free to download - id: 58e81-MTUxN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

PERIODIC CONSOLIDATED INVOICE

Description:

New Custom Package written to generate SBC invoice data ... modified to process SBC invoice data and ... SBC Periodic Consolidated Invoices - Details ... – PowerPoint PPT presentation

Number of Views:696
Avg rating:3.0/5.0
Slides: 12
Provided by: Swam2
Learn more at: http://www.norcaloaug.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
About PowerShow.com