Excel Tricks- Add alternate Cells with Value above

Needed to fill a data set with PO line quantity with duplicate value below.
Visual Basic Code just works magic here.

Here Is the Link


http://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html#a2

How to use V Lookup

Every time some data migration activity  comes up, We just go on sending mail to technical guys.
Every thing is there in data base and we have functional data. We need to match up data and give it to process to tech guys.
V look up comes handy when u have 2 set of data tables and u need to match the value of 1 column value to other set of data and retrieve information from 3rd column correspondingly.
Following You tube vdo is very much handy to learn the process and apply the V Look up feature in Excell.

Here is the link


Excel 2007 Tutorial VLOOKUP

Kuwait-Avenues

It has been 15 days that i have been in Kuwait  and when ever i see the road infrastructure in Kuwait i just can't get enough of it. I am always bewildered to see the quality of roadways they have in Kuwait. It seems to  so non-middle east. It is totally contrast to what ones thinks about middle east.
Today while going to avenues , I again could not stop wondering about the crossover bridges which so seamlessly connect to the main roads from your residence. It seems to be so effort less in the way the your corridor roads connect to main road. The designing is  just so unreal. It seems like i am playing NFS game.Every thing is so neatly maintained.
Then i start to realize like life ,economy is also unfair.Kuwait is sitting on big oil resources which is changing face of this nation. And it also adds up to there benefit as they have lesser mouth to feed.In India by contrast we have not  much resources of this sort and also we have larger number of population to feed.
We still have good amount of resources , but the problem is Central leadership.Here you see anything in Kuwait ,it reflects the policy of Kuwaiti central leadership - For the betterment of people.Otherwise you won't find public parks so often by the side of main road. The government here is so much concerned about the general public good.

Customized Sales Order Cycle

For One my client which i did a project , the Sales order cycle was customized.
The Customer would first come to client, Client will Raise a SO against the customer.
A purchase order Will be raised against already approved Blanket Purchase order for the qtr.
The PO will be fulfilled by Contract Manufacturer.CM  Will ship the  product to third party Logistics .
3PL will be then responsible to ship the product to Customer premises.
Invoicing will be done by client and client will pay in turn pay to CM 
Following the business flow depicted in Diagram:

Business process

Reverse Logistics

As Functional consultant of oracle, we’ve got lot of technical documents on forms and navigation for application. But as a Functional consultant we need to know the business process , how does the business work. If we have clear understanding of the business process, the turnaround time for issue resolution can drastically come down, as functional consultant won’t have to rely on customer’s testing.

I would like to share the business process a company here which is into semiconductor related component manufacturing in hi tech industry.

The item manufactured by company are mission critical and that is why if the customer is asks for item return , the items are first shipped to customers place and returns of the item takes place afterwards .

The entity which ship the item is called 3PL( third party logistics)

The entity which takes return of goods from customer is called 3PR (third party Repair).

These 2 entity are partners for the company. These will be different company , external to customer, bound by business  agreement.There fore we cannot use same Oracle production instance for these outside business entity. We do not want to expose our production related data to outside world, even if they are business partner. But still we have to provide the data for which they need to take action.

This is achieved by B2B messaging system where partner is B2B enabled.

If partner is not B2B enabled than we send and receive  flat file messages.

Here 3PR is non B2B enabled partner and 3PL is B2B enabled partner.

Messages exchanges takes place on Rosetta net standards

Following are the Reverse logistics operations  which takes place between the various entity:
 

1.       Adjustment 4B3

2.       Depot Transfer

3.       FG_Shipment

4.       Inventory Variance 4C1 3PL

5.       Inventory Variance 4C2 3PR

6.       Move Order

7.       Site Transfer

8.       RMA cycle

 Each of these Process is explained in upcoming posts

Personalisation-Requirement based on line type

Quote to sales order in orale application

In Quote to order cycle following steps are involved

1.Create a quote- Quote number generated in draft Status(hdr and line)-

Nav: Negotiation>quick quote

2.Get (submit for ) internal approval - status of hdr and line is Pending internal approval- Nav: Action>progress quote > Submit draft eligible

3.Get customer acceptance quote work flow completes -before acceptance quote will be in in pending customer acceptance

Nav : actions> customer aeptance

4.sales order gets created in entered status -Quotes heder/line data populates in SO header /lines

After Quote is accepted by customer we can create Sales order Agreement out of it and create relase which can be converted to Sales order.