510 likes | 728 Views
Oracle e -Business Suite Oracle Receiv ables for B eginners. Csilla Noé Attila Ábel March 27 , 2014. Course Description. Manual Transactions Imported Transactions ( AutoInvoice ) Credit Memos Adjustments Receipts Customers Setup: AutoAccounting Reports. Manual Transactions.
E N D
Oracle e-BusinessSuiteOracle ReceivablesforBeginners Csilla Noé Attila Ábel March 27, 2014 See tutorial regarding confidentiality disclosures.
Course Description • Manual Transactions • Imported Transactions (AutoInvoice) • Credit Memos • Adjustments • Receipts • Customers • Setup: AutoAccounting • Reports See tutorial regarding confidentiality disclosures.
Manual Transactions See tutorial regarding confidentiality disclosures.
TransactionsWorkbench Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 4
Transactions Source: shows the origin of the invoice Number: assigned automatically when saving; based on a sequence setup definition Class: see next pages Type: see next pages Reference: someInvoiceTransactionreference (dependsonsetup) Document Number: another sequential numbering possibility, usually saved identically to ‚Number’ Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 5
Transactions Transaction Class Invoice: Bill customers for products or services Credit Memo: Credit customers (On-account credits do not refer to specific invoices) DebitMemo: Bill customers for products or services that were not included on the original invoice Chargeback: Adjust the remaining balance of anexisting debit item to zero, and create a new debit item to bill customer for unpaid balance of originalinvoice Deposit: Bill customers for contractual agreements Guarantee: A contractual agreement that is referenced by invoices (Bill customers for the items on the invoice, not the guarantee) See tutorial regarding confidentiality disclosures.
Transactions Youcanassigntransactiontypetoyourtransactions, whichdeterminesseveralproperties of thetransaction See tutorial regarding confidentiality disclosures.
Transactions • Transactiontypedetermines: • Transactionclass • Payment term • Printingoptions • Accounting • You can set up AutoAccounting to use transaction types when determining your generalledger accounts • In this case changing transaction type opens a pop-up window, allowing to recalculate GL accounts See tutorial regarding confidentiality disclosures.
Transactions If the currency is different from functional currency a pop-up window will appear to enter the exchange rate and/or rate type otherwise it will default from setup Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 9
Transactions Details button: show the main financial data of the invoice Refresh button: recalculatesthe transaction balances See tutorial regarding confidentiality disclosures.
Transactions ShipToCustomer: choose any ship-tocontact Bill To: customer, wheretheinvoicewill be sent SoldTo: The customer to whom the goods and servicesweresold Payment Term: specifiesthe due date and discount date ShipTo, billto and soldtocustomercan be different See tutorial regarding confidentiality disclosures.
Transactions Print: You can printall new or changed invoices at one time Print Date: lasttime, whenitwas printed Status: manuallyupdatable, notusedby AR Purchase Order Number: the PO forthetransaction; onlyforreference Remit To: wherethecustomerssendpayments Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 12
Transactions Select Lines button on Transactions form to enter the invoice lines Item: theitemfortheinvoice line Sales Order: the SO fortheinvoice line Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 13
Transactions Enter taxinformationfor: one line (onlyifopeningformtransactionline) alllines taxsummary Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 14
Transactions Itdependsonsetupiftaxlinescan be manually entered and deletedorcan be reviewedonly and Receivablescreatesthemautomatically Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 15
Transactions To review accounting information for a transaction or line, chooseDistributions Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 16
Transactions Receivablesalsoletsyou enter freightinformation Todothis, selectFreightbuttononLinesform Select ‚Freight’ or ‚ FreightForAllLines’ fromthedropdownlist Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 17
Transactions UseDistributionswindowtoreview accounting information IfyouopenitfromLineswindow, youcanchoosetoseedistributionsforoneoralllines Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 18
Transactions Copytransactionsfromexistingone Useitwheninvoice is recurringregularly Findtheexistingtransactionusingtheupperregion Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 19
Transactions • IfMultipleReportingCurrencies (MRC) is setup, ‚ViewCurrencyDetails’ iconisactive: See tutorial regarding confidentiality disclosures.
Transactions Itletsyouview transaction amounts in both your primary and MRC reportingcurrencies Oracle Trainings Series | 27 March 2014 See tutorial regarding confidentiality disclosures. 21
Imported Transactions(AutoInvoice) See tutorial regarding confidentiality disclosures.
AutoInvoice AutoInvoiceis an automaticinvoicecreationinterface, whichcanbe usedto import informationfromexternalsystems and tocreatetransactionsautomaticallyinReceivables See tutorial regarding confidentiality disclosures.
AutoInvoice • Run the RevenueRecognitionprogram tocreate distributionrecords for the invoices and credit memosthat you create in Receivables and import usingAutoInvoice. • When you submit the program, Revenue Recognition selects all transactions that haveinvoicing and accounting rules and that have not yet been processed since you lastsubmitted the program. See tutorial regarding confidentiality disclosures.
Credit Memos See tutorial regarding confidentiality disclosures.
Credit Memo See tutorial regarding confidentiality disclosures.
Credit Memo Select Menu: Actions/Applications to apply CM manually to existing invoice See tutorial regarding confidentiality disclosures.
Credit Memo Select Menu: Actions/Credit to credit an existing invoice fully or partially Data from the original invoice are copied to the CM See tutorial regarding confidentiality disclosures.
Adjustments See tutorial regarding confidentiality disclosures.
Adjustments • You canmake positive or negative adjustments to invoices, debitmemos, chargebacks, on-account credits, deposits, and guarantees • You can approveadjustments that are within your approval limits and give pending statuses toadjustments that are outside your approval limits See tutorial regarding confidentiality disclosures.
Adjustments • Adjustmentstatuses: • Approved: Adjustmenthas been approved. Receivables updates the debit or credititem amount and status to reflect the adjustment. • Research Required: Theadjustment is on hold because you are either researching thedebit or credit item, or are requesting additional information about the adjustment. • Rejected: The adjustmentis rejected. Adjustments with this status do not updatethe balance of the credit or debit item. • Pending Approval: The adjustment amount is outside the approval limits of the userwho entered the adjustment.Adjustments with this status can only be approved by auser with the appropriate user approval limits. See tutorial regarding confidentiality disclosures.
Receipts See tutorial regarding confidentiality disclosures.
ReceiptsWorkbench See tutorial regarding confidentiality disclosures.
Receipts • Enternew or query existing receipts See tutorial regarding confidentiality disclosures.
Receipts • ReceiptHistorywindowprovidesadditional details about saved • receipts See tutorial regarding confidentiality disclosures.
Receipts • Receiptstatuses: • Approved:has been approved for automatic receipt creation (availableonlyforautomatic receipts) • Confirmed:the receipt belongs toa receipt class that requires remittance (availableformanual receipts) • Remitted:the receipt has been remitted • Cleared: The payment of thereceipt was transferred to thebank account and the bankstatement has been reconciled within Receivables • Reversed:thereceipt has been reversed. (Available ONLY when your customerstops payment on a receipt, if a receipt comes from an account with non-sufficient fundsor if you want to re-enter and reapply it in Receivables. See tutorial regarding confidentiality disclosures.
Receipts • IntheApplicationwindowreceipts can be appliedto any type of transaction except guarantees and standard credit • memos See tutorial regarding confidentiality disclosures.
Customers See tutorial regarding confidentiality disclosures.
Customers • Findcustomersform • Queryexistingcustomers • Enter newcustomers See tutorial regarding confidentiality disclosures.
Customers Use Advanced… … or Text fieldtosearch See tutorial regarding confidentiality disclosures.
Customers Selecttheappropriatefromthe Match Resultsform and click OK See tutorial regarding confidentiality disclosures.
Customers Createnewcustomers Modifyexistingcustomers See tutorial regarding confidentiality disclosures.
Customers • Headerdata: • Customertype: Organization orPerson • Name: theofficialname of thecustomer, whichwill be displayed oninvoices • TaxRegistrationNumber: The customer’s unique taxpayer registration number (aka VAT number); will be printedon yourcustomer’s invoices. See tutorial regarding confidentiality disclosures.
Setup: AutoAccounting See tutorial regarding confidentiality disclosures.
Setup: AutoAccounting • AutoAccountingspecifieshow Receivables determine the GL accounts for transactions • ManuallyandAutoInvoiceimportedtransactions • Youcancontrolthevalues of allsegments • AutoAccountinggeneratedaccountscan be overridden See tutorial regarding confidentiality disclosures.
AutoInvoice • AutoAccountingtypes: • AutoInvoiceClearing:Receivables uses the clearing account to hold any differencebetween the specified revenue amount and the selling price times the quantityfor imported invoice lines • Bills Receivable: Receivablesuses this account when you exchange transactions for bills receivable. • Factored Bills Receivable: The factored bills receivable account for your billsreceivable transactions See tutorial regarding confidentiality disclosures.
AutoInvoice • AutoAccountingtypes: • Freight • Receivable • Remitted BillsReceivable • Revenue • Tax • Unbilled Receivable • Unearned Revenue • Unpaid Bills Receivable See tutorial regarding confidentiality disclosures.
Reports See tutorial regarding confidentiality disclosures.
Reports • TransactionRegister • Includesall transactions (such as invoices, credit memos, debitmemos, chargebacks, deposits, and guarantees) that increase or decrease a customer’soutstanding balance for a specified periodincluding transactions that do not post orage • Receivables groups and prints transactions by company, currency, and postablestatus See tutorial regarding confidentiality disclosures.
Reports • Unapplied and UnresolvedReceiptRegister • Reviewdetailed informationabout your customers’ on-account and unapplied payments for the date range that youspecify • Includesall receipts that are not fully applied to customer transactionssuchasreceipts with unapplied cash, in addition to receipts with applications thatrequire resolution • Excludesreceipts applied to activities that do not affect the customerbalance, such as receipt write-offs, short-term debt, and credit card refunds See tutorial regarding confidentiality disclosures.