OraNA :: Oracle News Aggregator

Accounting entries for purchase orders with destinations type expense, item type expense and with accrue on receipt option is true.

Sequence of actions and accounting entries

Action

Create, Approve, Reserve PO

Accounting entries

Budget a/c DR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO line unit price))

Action

Invoice Validation after matching

Accounting entries

Recoverable Tax calculated for the (received quantity * PO line unit price) and Non Recoverable Tax calculated for the (received quantity * PO line unit price) DR @ tax amount

Action

Create Accounting for invoice

Accounting entries

AP Expense accrual a/c DR @ PO price excluding tax and tax DR @ tax rate separately

AP Liability a/c CR @ invoice price

REC Tax and Non Recoverable Tax calculated for the (received quantity * PO line unit price) CR @ tax amount

Action

Receive the PO

Accounting entries

Receiving Inspection a/c DR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO line unit price))

AP Expense accrual a/c CR @ PO price (base+ Non Recoverable Tax calculated for the (received quantity * PO line unit price))

Action

Deliver the PO

Accounting entries

Expense Charge a/c DR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO line unit price))

Receiving Inspection a/c CR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO line unit price))

Budget a/c CR @ PO price (base + Non Recoverable Tax calculated for the (received quantity * PO line unit price))

Reference

Accounting Flow against Purchase Orders, Receipts and Matched Invoices.

Authors: Manighandan Venkatraman & Asha Ravada

Problem

In one of my operating unit sale officer enter order and released to ware house, after that sale officer cancel that sale order. Now it showing me quantity reserved for that sale order in system but actually order is canceled how can I unreserved this quantity

Solution

For 11i - 11.5.7 / INV.G and above
——————————————-

Download and review Patch.3170660 “script i2471362.sql not correcting orders for cancelled qty”

Run i2471362.sql to remove any old reservations

To delete a reservation manually

NAVIGATE to INV/On hand Availability/ Reservations Query up the item and find the associated row for the order Place cursor on the row to be deleted and click on delete icon and save icon.

Reference

Metalink Note Id 150081.1

Complete manual payments and adjustments for the period (including cleanup of ‘Out of Balance’ batches)

Check and Complete final Receivables Interface from Order Management

Complete manual invoices,Debit Memos and credit memos

Run your final Auto Invoice process

Correct ALL Auto Invoice rejects and re-run

Clear all receipts from Cash Management

Apply receipts against Invoices and Debit Memos

Review the Unapplied Receipts Register

Reconcile receipts

Apply Credit memo to Debit Memo and Invoices

Approve or reject ALL Pending Adjustments

Complete or delete ALL ‘Incomplete’ invoices

Complete or delete ALL ‘Incomplete’ credit memos

Correct and post ALL open Lockbox batches (If Lock Box Implemented)

Print Dunning (Reminder) Letters (Optional)

Run Journal Entries Reports

Review Journal Entries reports for ‘unusual’ accounts and correct as needed

Run Period End Reports

Balance to the Aged Trial Balance

Post to the General Ledger using the period start date through the period end date - verify that ALL steps completed successfully.

Close the period - verify that there are no items in error

Open the next period and the next Future period

Post Journal Entries (In General Ledger)

Balance to the General Ledger (for the key accounts)

Refrence

Why Don’t My AR and GL Numbers MATCH BY Cathy Cakebread

Metalink

Oracle Account Receivable user Guide

e business Suite Diagnostics Period / Year End Close Note:402237.1

Please apply Patch#4900462 and find the following example scripts under $QP_TOP/patch/11.5/sql directory.

1. QPBLKEX1.sql - Script populates interface tables to insert price list header and price list line.

2. QPBLKEX2.sql - Script populates interface tables to insert price list header and price list line and pricing attributes.

3. QPBLKEX3.sql - Script populates interface tables to insert price list header and price break line.

4. QPBLKEX4.sql - Script populates interface tables to update price list header with qualifiers.

5. QPBLKEX5.sql - Script populates interface tables to attach secondary price lists to the primary price list.