Posts

Showing posts from May, 2014

AR Receipts Tutorial-1 by Pranay Tiwari

Image
Once transactions created for the customer and its next step will be creating receipts. Receipts will be created only after customer pays amount against the transactions. Its not mandatory to pay full amount of transaction to create receipts ,Even with partial payments receipts can be generated. In simple terms we can refer this terms in below methodology. Transactions: Invoice/Bill Receipts: Payment Receipts.  Now will see how to create receipts and how to apply transaction over to it? Before proceeding with the receipt creation there are certain Prerequisite setups which are mandatory in Receipt generation . Here is the set up to create Receipt Classes to create Receipts in Oracle Navigation :     Receivables Manager à Setup  à Receipt Classes Go to Receipt Class query it and add your Receipt Method Name  for example check below receipt name has been added as TEST RECEIPT CLASS .After adding the receipt method , Cli...

Oracle Transaction Interface, Auto Accounting Setups and Auto Invoice Concepts by Pranay Tiwari

Image
Before Proceeding towards interface concepts , We have to go through the base table of Oracle transactions. Base Tables :  RA_CUSTOMER_TRX_ALL   holds the header level data RA_CUSTOMER_TRX_LINES_ALL  holds line level data RA_CUST_TRX_LINE_GL_DIST_ALL holds distribution level data RA_BATCHES_ALL    table contains batch level information RA_BATCH_SOURCES_ALL table contains batch name RA_CUST_TRX_TYPES_ALL table contain information regarding transaction type data Interface Tables :  RA_INTERFACE_LINES_ALL     Line Interface Level Data RA_INTERFACE_DISTRIBUTIONS_ALL Distribution interface level data RA_INTERFACE_ERRORS    contains the information of rejected records from auto invoice program Auto Accounting rules and Set ups in Oracle . Auto accounting rule is nothing but a feature in oracle which automatically creates general ledger accounting flexifields at Distribution Level. In-order to set up Auto Accounting rule ...