How can we reduce time for shipping in Oracle Order Management?

In one of my client they are facing problem that oracle shipping process is very hectic and lengthy for making one gate pass / delivery note they need 10 to 15 minutes

They are following these Steps to Ship / dispatch an order

Release order

Navigate to Transact Move order

Allocate quantity

Transact Quantity

Switch to order Management responsibility and navigate to shipping Form

Make delivery

Make Trip

Close Trip

Solution

We can Reduce Dispatch Time by follow the following steps

On the release sales order form, if we select Auto Pick Confirm as Yes and Auto Create Delivery as Yes then the pick release program will complete creation of Move Order, allocation of move order, transaction of move order, creation of delivery.

After this User need to ship confirm the delivery and dispatching process will be over.

We can also have an option to automatically ship confirm ‘Automated Ship Confirmation’. We can use the Ship Confirm Rule on the Release Sales order form. From the Release Sales Orders for picking window we can specify an individual sales order to perform Auto Ship Confirm. Auto Ship Confirm will be performed for all the deliveries assigned to the individual order

Accounting Entries of Accrue on receipt (APO) in Oracle Application?

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

How can I unreserved quantity, Reserved against a closed / canceled sale order

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