AR Auto Invoice

AgendaFunctional Overview

PurposeFeatures

Data FlowTable Descriptions

Temporary Table Interface TableStandard Apps. Receivables Tables

Interface Table StructureAssumptions & ValidationsConcurrent Request

Functional Overview

Purpose•Powerful tool to import & validate data from other financial systems•Create invoice, debit-memos, credit-memos and on-account credits Oracle receivablesFeatures

Auto Invoice Purge ProgramProvision to delete data from interface tables automatically if the data is successfully imported.

Features (Contd.)

Calculating Tax - Incorporate functionality to reflect taxes such as

Sales Tax, VAT, etc. - Flexibility to add Tax code lines, Tax exempt lines or

automatically determine taxes. Creating Transactions - Creates invoices using invoicing rules, grouping

rules, etc Invoices against commitments - Allows creation of invoices against commitment similar a manually entered invoice. Transaction Flexfields- Facilitates linking each transaction to the original system

Data Flow

Feeder System data file

Loader program

XXAR_AUTOINV_TEMP

Validation program

Error Record

?

YesNoP

Update the error record

RA_INTERFACE_LINES_ALL

Auto Invoice import program

P

Data FlowData Flow

Standard Apps tables RA_INTERFACE_ERRORS

Valid Data Error Data

Table DescriptionsTemporary Table - XXAR_AUTOINV_TEMPThis is used for storing data from the data file to meet

the specific needs of an organization.

Interface Table - RA_INTERFACE_LINES_ALLData enters this table after passing validation steps.

Records that enter this table are of type ‘LINE’, ’FREIGHT’,

‘TAX’ or ‘CHARGES’.

Table Descriptions

Standard Receivable Tables - RA_BATCHES_ALL

Stores information of each batch of invoice you enter.

RA_CUSTOMER_TRX_ALL Stores the header information such as customer, transaction type for each transaction

RA_CUSTOMER_TRX_LINES_ALLStores the line items linked to header stored above.

Table Descriptions

RA_CUST_TRX_LINE_GL_DIST_ALLShows distribution of amounts in the affected GL accounts for an invoice or credit-memo

RA_CUST_TRX_LINE_SALESREP_ALLStores sales credit information for invoice lines.

AR_PAYMENT_SCHEDULES_ALLStores all transactions except adjustments and this table is updated on receipt of invoice, credit-memo or debit memo.

Interface Table StructureImportant Columns1) Line_Type – Should be ‘LINE’,’TAX’,’CHARGES’,’FREIGHT’2) Set_of_Books_Id3) Batch_Source_Name4) Interface_Line_Context5) Description6) Org_Id7) Currency_Code8) Conversion_Type9) Orig_System_Bill_Customer_Id10) Orig_System_Bill_Address_Id11) Orig_System_Ship_Customer_Id12) Orig_System_Ship_Address_Id13) Interface_Line_Attribute1&2

Assumption & Validations

Organization is defined Set of Books and Currency are defined Batch Source is defined Customer Bill_to and Ship_to names and addresses are valid Inventory item and Unit of Measure code is valid for ‘LINE’

items Description field is not null Transaction flexfield values are valid.

Concurrent Requests

Request Set : Auto Invoice Processing 1) AR Auto Inv Loader Prog (Custom) :

Loads data from data file to XXAR_AUTOINV_TEMP. 2) Auto Inv Vld Prog (Custom) :

Validates data in XXAR_AUTOINV_TEMP and loads the interface table RA_INTERFACE_LINES_ALL.

3) Autoinvoice Master ProgramTakes in valid parameters and internally calls the Import program

3.1) Autoinvoice Import ProgramLoads data in the standard receivables tables.

HOPEYOU

LIKED IT