Free Oracle Magazine Profit:The Executive's Guide to Oracle Applications

Enter your e-mail address to receive notifications when there are new posts

Profit Magazine: The Executive's Guide to Oracle Applications

What is “Order To Cash” in Oracle?

Posted on July 5th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales person, fax or by some other means like EDI, and then fulfilling the order, shipping, logistic and then generating an invoice and collecting payment for that invoice and then receipt. if we consider the flow ,this can be further categorize into seven sub-process like

  • Customer
  • Order entry (creation of order /booking of order )
  • Order fulfillment
  • Distribution
  • Invoicing
  • Customer payments /Collection
  • Receipt

A typical flow can be best represented as:

ordertocash

Posted in Beginner | 7 Comments »

Understand “Drop Shipment” in Order Management?

Posted on July 4th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Order Management allows you to enter drop-ship sales orders as well as standard sales orders.

It means you can receive orders for items that you do not stock or for which you lack sufficient inventory, and have a supplier provide the items directly to your customer.

dpship

 

The best can be described as:

Dpshipment

These are the following activity takes place when you have drop shipment

  • Supplier
    • Warehouse Item
    • Ship order
    • Shipment notification
  • Order Entry
    • Enter customer
    • Enter order
    • Demand order (optional)
    • Cancel order (optional)
    • Close order
  • Purchasing
    • Create and send Purchase Order
    • Enter shipment notification in system
  • Receivables
    • Create invoice
    • Collection of payment
    • Receipt

hence, drop ship order items ship directly from a supplier to the customer of the order processing company. A purchase requisition, then a purchase order, is generated to notify the supplier of the requirement. After the supplier ships the order, it notifies Purchasing to enter this information in the Purchasing module.

What are the advantages of Drop Shipment Orders?

These are the benefits:

  • No inventory is required
  • Reduced order fulfillment processing costs
  • Reduced flow times
  • Elimination of losses on non-sellable goods
  • Elimination of packing and shipping costs
  • Reduced inventory space requirements
  • Reduced shipping time to your customer
  • Allows you to offer a variety of products to your customers

How to understand the dataflow for Drop shipment Orders?

To understand, here are the processes divided in sub process and the underline activity is highlighted here:

DpshipmentflowHere are the Details as per Mark

1.Order Entry

Here the activity is entering process where oe_order_headers_all (flow_status_code as entered) oe_order_lines_all . The order is booked as DROP SHIP

2. Order Booking

3. The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is
po_requisitions_interface_all

4. After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders

7. After the goods are successfully received invoices for vendors are created in accounts payables as in normal purchase orders.

8. Invoices are generated for customers In account receivables.

9. oe_order_lines_all (flow_status_code ’shipped’, open_flag “N”)

10. oe_order_lines_all (flow_status_code ‘closed’, open_flag “N”)

Hope this is great help to understand the flow.

Posted in Beginner, Oracle Order Management | 16 Comments »

Procurement/Purchase - Requisition take a look

Posted on June 15th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Procurement/purchasing is basically buying of goods and services, based on internal requirements, which will be used as input for the processing of the end product for a given company.
The input varies from simple stationery or MRO requirement (termed as indirect goods, as they are not directly involved in production processing) to raw materials (termed as direct, as they are used for production processing) and services.

How many types of Requisition in PO module we have?

There are two different kind of Requisition

  • Internal Requisition
  • Purchase requisition

handWhat is an Internal Requisition?

A requisition from the Purchasing system that will directly result in the generation of a sales order in the Order Management system through the Order Import process in Order Management.

Why do we use internal requisition/internal sales order?
Internal Requisition/Internal Sales Order provide the mechanism for requesting and transferring material from one inventory organization to other inventory organization or expense location.

What is the location in Oracle Purchasing?
Oracle Purchasing uses locations to identify the final delivery location for both inventory and vendor sourced requisition. It is using the hr_locations table.

What is an Internal customer?
When using Internal Requisition/Internal Sales Orders, it is required to create an internal customer for each destination organization and a customer ship-to site for each deliver-to location within the destination organization. Define the same address for your customer ship-to-site as your deliver-to location.

handThen what is Purchase Requisition?

The Purchase Requisition is the procedural method by which different departments of organization may request the purchase of goods and/or services, which require processing by Procurement Department.

handWhat is life Cycle of Purchase Requisition?
If you are using i-procurement this consist of 4 distinct sub-processes like:
iproc flow

A Requisition is generated either manually or by system, which is ultimately turned into a purchase order by the buyer. Sometimes the buyer decides a request for quotation (RFQ) is required by other suppliers to determine the best price for the goods or services requested. Once the quote is back, that information is used to finalize the purchase order.

handWhat is flow of Requisition?
A functional flow of Requisition cycle can be represented as
req

handWhat are the important Tables for Requisition?
These are the main tables:

PO_Requisition_Headers_All : it stores information about requisition headers. Each row contains the requisition number and Addition relevant information. REQUISTION_HEADER_ID is primary key.

HR_Employees : it’s a view that contains information about employees. You must have a row for each requestor, requisition preparer, approver , buyer or receiver . The primary key is EMPLOYEE_ID.

PO_Requisition_Lines_All : This table stores the information about the requisition lines like quantity , item , deliver to location , requestor etc. Primary Key is REQUISTION_LINE_ID

MTL_System_Items_B : This is the definition table for items. This table holds the definitions for inventory items, and purchasing items. The primary key is INVENTORY_ITEM, ORGANIZATION_ID.

PO_REQ_Distributions_All : This table stores the information about the accounting distributions associated with each requisition line. Each requisition line must have at least one accounting distribution. Each row includes the accounting flex field id and requisition line quantity. The primary key is DISTRIBUTION_ID.

GL_CODE_Combinations: This table stores valid Accounting Flex Field segment value combinations for each accounting flex field structure within your GL application. GL_CODE_COMBINATIONS is populated by the system when a new accounting flex field combination is used, either through dynamic insertion or manually.

This can be best represented as per data model as:
reqsiaite

Here are the drill down information for these two driving table:

1. PO_Requisition_Headers_All

  • SEGMENT1 - Requisition Number
  • AUTHORIZATION_STATUS - Lookup code and can have values
    • APPROVED Document has been Approved
    • CANCELLED Document has been Cancelled
    • IN PROCESS Document is still undergoing Approval
    • INCOMPLETE Document is not yet Complete
    • PRE-APPROVED Document is Approved but not yet Accepted
    • REJECTED Document as been Rejected
    • REQUIRES REAPPROVAL Requires Reapproval
    • RETURNED Document has been Returned
  • REQUISITION_HEADER_ID Unique Requisition ID (PK)

2. PO_Requisition_Lines_ALL

  • REQUISITION_LINE_ID Requisition line unique identifier
  • REQUISITION_HEADER_ID Requisition header unique identifier
  • LINE_NUM Line number
  • QUANTITY Quantity of Line item
  • LINE_LOCATION_ID Document shipment schedule unique identifier
  • UNSPSC_CODE Standard UNSPSC CODE

How we map the Main screen for Requisition with database table.

req screens

Posted in Beginner, Oracle Purchasing | No Comments »

Understanding Accounting from Techies Mind

Posted on June 8th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Indeed, this is one of good area, where most of techies have lot of confusion and illusion about when accounting comes. Many of consultant came from Technical background and gradually moved into doing some techno -functional role or pure functional role, thus it is essestintial to understand the basic accounting and Guided principal .

Normally, there are two basic accounting methods available in the business world:

  • Cash
  • Accrual

And most of the ERP accounting products weather its SUN system, Oracle financial or SAP have functionality to capture on the basis of set up.

Then want is the difference:

handCash Basis Accounting
This is what “Based on Realization

We Most of us use the cash method to keep track of our personal financial activities.

The cash method recognizes revenue when payment is received, and recognizes expenses when cash is paid out.

For example, our local grocery store’s record is based on the cash method. Expenses are recorded when cash is paid out and revenue is recorded when cash or check deposits are received

If we summarize, under the cash basis accounting, revenues and expenses are recognized as follows:

  • Revenue recognition: Revenue is recognized when cash is received.
  • Expense recognition: Expense is recognized when cash is paid.

Take a note the word “cash” is not meant literally - it also covers payments by check, credit card, barter, etc.

Moreover it is not standard method in compliance with accountings matching principle.

handAccrual Basis Accounting
This is what “Based on Recognition

The accrual method of accounting requires that revenue be recognized and assigned to the accounting period in which it is earned. Similarly, expenses must be recognized and assigned to the accounting period in which they are incurred.

Then the underline question is what is accounting Period, Let explain like this normally a company tracks the summary of the accounting activity in time intervals, which we normally called as Accounting periods. These periods are usually a month long. It is also common for a company to create an annual statement of records. This annual period is also called a Fiscal or an Accounting Year.

In the accrual method relies on the principle of matching revenues and expenses. This principle says that the expenses for a period, which are the costs of doing business to earn income, should be compared to the revenues for the period, which are the income earned as the result of those expenses. In other words, the expenses for the period should accurately match up with the costs of producing revenue for the period.

Take a case:
logo mvp 152Company is doing a business and they have to pay sales commissions expense, so sales commissions expense should be reported in the period when the sales were made (and not reported in the period when the commissions were paid). Similarly, Salary/Wage to employees are reported as an expense in the week/month when the employees worked and not in the week/month when the employees are paid. If a company agrees to give its employees 2-month equivalent salary of its 2006 revenues as a bonus on January 25, 2007, the company should report the bonus as an expense in 2006 and the amount unpaid at December 31, 2006 as a liability. This is most simple kind of matching principal normally has.

In general, there are two types of adjustments that need to be made at the end of the accounting period.

  1. The first type of adjustment arises when more expense has been recorded than was actually incurred or earned during the accounting period.
  2. Similarly, there may be revenue that was received but not actually earned during the accounting period. Also known as Un-earned Revenue.

The accrual method generates tax obligations before the cash has been collected (because revenue leads to tax and revenue is recognized against receivable and not against receipt of money).

If we summarize, under the accrual basis accounting, revenues and expenses are recognized as follows:

  • Revenue recognition: Revenue is recognized when both of the following conditions are met:
    • Revenue is earned
      • i.e. when products are delivered or services are provided.
    • Revenue is realized or realizable.
      • i.e. either cash is received or it is reasonable to expect that cash will be received in the future.
  • Expense recognition: Expense is recognized in the period in which related revenue is recognized (Matching Principle).

Timing differences in recognizing revenues and expenses
Various accounting books did mention four potential timing differences in recognizing revenues and expenses between these of two. Just to recap of those:

a. Accrued Revenue: Revenue is recognized before cash is received.
b. Accrued Expense: Expense is recognized before cash is paid.
c. Deferred Revenue: Revenue is recognized after cash is received.
d. Deferred Expense: Expense is recognized after cash is paid.

Compare with a Case to explain these two methods

Your company purchase a new Laptop on credit in May 2007 and pay $1,500 for it in July 2007, two months later.

Under the both case see how this makes a difference:

  • Using the cash method accounting, you would record a $1,500 payment for the month of July, the month when the money is actually paid.
  • Under the accrual method, you would record the $1,500 payment in May, when you take the Laptop and become obligated to pay for it.

Pros and cons of these Two accounting method
Maintence
: The cash method is easier to maintain because you don’t record income until you receive the cash, and you don’t record an expense until the cash is paid, where as in the accrual method, you will typically record more transactions.

Cash-basis accounting defers all credit transactions to a later date. It is more conservative for the seller in that it does not record revenue until cash receipt. In a growing company, this results in a lower income compared to accrual-basis accounting.

Do you what is meant by GAAP?
No, I don’t know, but knows most of ERP follows these. Lets explain this way:
The word”generally accepted accounting principles” (or “GAAP”) consists of three important sets of rules:
(1) The basic accounting principles and guidelines,
(2) The detailed rules and standards issued by FASB(Financial Accounting Standards Board and its predecessor the Accounting Principles Board (APB)
(3) The generally accepted industry practices.

Normally Standard GAAP will have various guided Principal, such as

  • Economic Entity Assumption
  • Time Period Assumption
  • Cost Principle
  • Matching Principle
  • Revenue Recognition Principle

Will take a seprate case of some of them to understand in better way.

If you want to know more about GAAP, weather US-GAAP, UK-GAAP , refer wikipedia

ERP/Oracle Financials
Oracle Financials have been developed to meet GAAP requirements as well as the special needs of different countries. For example, in Oracle Payables you can choose whether to record journal entries for invoices and payments on an accrual basis, a cash basis, or a combined basis where accrual journal entries are posted to one set of books and cash basis journal entries are sent to a second set of books.

Will continue with some additional accounting stuff, keep reading and commenting.icn thumbs 32x32

Posted in Basic Accounting, Beginner, JumpStart | 13 Comments »

Next Entries »