Auto Invoice interface

Interfaces and Conversions in Oracle Applications, AskHareesh.blogspot.com

Auto Invoice interface

This interface is used to import Customer invoices, Credit memos, Debit memos and On Account credits.

Pre-requisites:
  • Set of Books
  • Code combinations
  • Items
  • Sales representatives
  • Customers
  • Sales Tax rate
  • Payment Terms
  • Transaction Types
  • Freight Carriers
  • FOB
  • Batch Sources
  • Accounting Rules
Interface tables:
  • RA_INTERFACE_LINES_ALL
  • RA_INTERFACE_SALESCREDITS
  • RA_INTERFACE_DISTRIBUTIONS
  • RA_INTERFACE_ERRORS (details about the failed records)
Base tables:
  • RA_BATCHES
  • RA_CUSTOMER_TRX_ALL
  • RA_CUSTOMER_TRX_LINES_ALL
  • AR_PAYMENT_SCHEDULES_ALL
  • RA_CUSTOMER_TRX_LINE_SALESREPS
  • RA_CUST_TRX_GL_DIST_ALL
  • RA_CUSTOMER_TRX_TYPES_ALL
Concurrent Program:
  • Auto invoice master program
Validations:
  • Check for amount, batch source name, conversion rate, conversion type.
  • Validate orig_system_bill_customer_id, orig_system_bill_address_id,
  • Validate if the amount includes tax flag.
Important Columns:
Some important columns that need to be populated in the interface tables:
RA_INTERFACE_LINES_ALL:
  • AGREEMENT_ID
  • COMMENTS
  • CONVERSION_DATE
  • CONVERSION_RATE
  • CONVERSION_TYPE
  • CREDIT_METHOD_FOR_ACCT_RULE
  • CREDIT_METHOD_FOR_INSTALLMENTS
  • CURRENCY_CODE
  • CUSTOMER_BANK_ACCOUNT_ID
  • CUST_TRX_TYPE_ID
  • DOCUMENT_NUMBER
  • DOCUMENT_NUMBER_SEQUENCE_ID
  • GL_DATE
  • HEADER_ATTRIBUTE1–15
  • HEADER_ATTRIBUTE_CATEGORY
  • INITIAL_CUSTOMER_TRX_ID
  • INTERNAL_NOTES
  • INVOICING_RULE_ID
  • ORIG_SYSTEM_BILL_ADDRESS_ID
  • ORIG_SYSTEM_BILL_CONTACT_ID
  • ORIG_SYSTEM_BILL_CUSTOMER_ID
  • ORIG_SYSTEM_SHIP_ADDRESS_ID
  • ORIG_SYSTEM_SHIP_CONTACT_ID
  • ORIG_SYSTEM_SHIP_CUSTOMER_ID
  • ORIG_SYSTEM_SOLD_CUSTOMER_ID
  • ORIG_SYSTEM_BATCH_NAME
  • PAYMENT_SERVER_ORDER_ID
  • PREVIOUS_CUSTOMER_TRX_ID
  • PRIMARY_SALESREP_ID
  • PRINTING_OPTION
  • PURCHASE_ORDER
  • PURCHASE_ORDER_DATE
  • PURCHASE_ORDER_REVISION
  • REASON_CODE
  • RECEIPT_METHOD_ID
  • RELATED_CUSTOMER_TRX_ID
  • SET_OF_BOOKS_ID
  • TERM_ID
  • TERRITORY_ID
  • TRX_DATE
  • TRX_NUMBER

*/