Friday, 26 April 2013

What is ORDER TO CASH (OTC or O2C)

The order-to-cash (OTC or O2C) process contains everything from the order, packaging, and delivery of goods and services to depositing the money in the bank.
Order to cash (OTC or O2C) is a set of business processes that involve receiving and fulfilling customer requests for goods or services.
It is a business process for receiving and processing customer sales. It contains whole process ranging from customer purchase order to Invoice.
It covers business-to-business (B2B) and business-to-consumer (B2C) sales.
In a business models a contractual relationship is established first via a Contract or Subscription.
Orders are then received via different sales channels, such as phone, fax, email, internet or sales
person. The contractual relationship is confirmed and the Orders are fulfilled through shipping and
logistics. On completion of key events an invoice is generated and booked as Sales. If payment has not already been received, the debt is recorded. Order to Cash is completed by the Customer Care process (enquiries, requests and complaints).
An order to cash cycle consists of multiple sub-processes including:

  • Customer order is documented
  • Order is fulfilled or service is scheduled
  • Order is shipped to customer or service is performed
  • Invoice is created and sent to customer
  • Customer sends payment /Collection
  • Payment is recorded in general ledger
It can also be defined as:
Order to cash refers to the business process in which customer sales orders are accepted by a
manufacture, fulfillment of the order followed by shipping and receiving followed by the generating of
an invoice and collecting payment for that invoice.

  • Classic Order to Cash
Buyer orders products from Seller. Seller accepts Order and confirms order fulfillment. Seller sends
Advanced Shipment Notification to buyer as soon as products leave the Seller. Seller sends Invoice to Buyer.

  • Extended Order to Cash
Buyer orders products from Seller, Buyer may or may not place change order. Seller may confirm all line items in the Purchase Order Confirmation or uses Purchase Order Update to confirm pending line items.
Seller will send out Advanced Shipment Notification to Buyer. Seller will send out Invoice to Buyer.
Buyer pays invoice.

  • Order to Cash with Logistic Service Provider
The process involves three trading partner, the Buyer, the Seller and the Logistic Service Provider.

What is ORDER TO CASH (OTC or O2C) Read More >> 

Tuesday, 23 April 2013

Different type of Fetching Function in Mysql

All the fetching function is used to fetch data from mysql database. But its data representation and use can be different. No need to confuse while using this function. Programmer can used any of the fetching function below.
For best understanding, refer this table


Different type of fetching function is given below:
1.    MYSQL_FETCH_ROW()
2.    MYSQL_FETCH_ARRAY()
3.    MYSQL_FETCH_ASSOC()
4.    MYSQL_FETCH_OBJECT()


1.    MYSQL_FETCH_ROW():  It is used to fetch data in numeric array. It gives result row as a numeric array.

<?php
$result=mysql_query("select * from user_table");
$result_row=mysql_fetch_row($result);
echo $result_row[0];
echo $result_row[1];
echo $result_row[2];
?>

Result:   1    Discuss   Desk

2.    MYSQL_FETCH_ARRAY(): It is used to fetch data in numeric array as well as associative array . It gives result row as a numeric array as well as associative array.

<?php
$result=mysql_query("select * from user_table");
$result_row=mysql_fetch_row($result);
echo $result_row[0];
echo $result_row[1];
echo $result_row[2];

/* numeric array as well as associative array */

echo $result_row[id];
echo $result_row[first_name];
echo $result_row[last_name];
?>

Both Result:   1    Discuss   Desk

3.    MYSQL_FETCH_ASSOC(): It is used to fetch data in associative array. It gives result row as a associative array.

<?php
$result=mysql_query("select * from user_table");
$result_row=mysql_fetch_row($result);
echo $result_row[id];
echo $result_row[first_name];
echo $result_row[last_name];
?>

Result:   1    Discuss   Desk

4.    MYSQL_FETCH_OBJECT(): It is used to fetch data as object. It gives result row as a object.

<?php
$result=mysql_query("select * from user_table");
$result_row=mysql_fetch_row($result);
echo $result_row->id;
echo $result_row->first_name;
echo $result_row->last_name;
?>

Result:   1    Discuss   Desk


Different type of Fetching Function in Mysql

How to enable Task Manager in Window

While Installing new copy of window or due to any virus attack, sometime, Window has disable Task Manager. If you want to enable or disable task manager manually, do the below steps one by one:
 
1.    Click Start icon of your window (left side)
 
2.    Click Run or Press start+R
 
3.    Type REGEDIT and OK
 
4.    Click  HKEY_CURRENT_USER
 
5.    Browse the following
 
6.    HKEY_CURRENT_USERSoftwareMicrosoftWindows CurrentVersionPoliciessystem
 
7.    In the Right side, See the value of Disable TaskMgr
 
If Value is 1 , that is disable Task Manager
 
If value is 0, that is enable Task Manager
 
8.    If is disable then by Right click DisableTaskMgr and select Delete. (When prompted with "Are you sure you want to delete this value", select Yes.
 
9.    Close the Registry Setting and reboot the system.
 
10. Now click on the Task Manager
 

Discuss Desk

Discuss desk (www.discussdesk.com) is a blogging website with new technology content. Here, User can read and comment the latest blog. They can give suggestion about that blog. This Blog contain wide topics from Tech News, Web Design, Social Media, Software and Tech Tutorials

.http://www.discussdesk.com