Order to Cash Application: Sales & Distribution Situation (Zoho Creator)

Management Information System's Project


Your company sells a fixed number of items each of which has a fixed price and at any point of time there is a certain quantity of each item in the inventory. Your salespersons are out in the market and meet clients to pick up orders. They can pick up an order if and only if the required amount is available in the inventory. When an order is picked up the quantity in the inventory has to be reduced. If the order falls below a certain quantity, a re-stocking mail has to be generated. After an order is placed, cash has to be collected against the order. Once the cash is collected, the order is tagged is paid. As the owner-manager you would like to know what are the orders that have been placed, what is the inventory ? What is the accounts receivable position and so on ... 


Click Here to view the video user manual for this application...
Click Here to view the Use Case of this application...

Order to Cash Form (Below) is an interface to add a client's order into the system. Select the Product's Name from the dropdown to place an order for a client.

Note: The Re-Order Stock Level has been kept as 10. This means that when the stock level becomes equal to or lower than 10 for a product, a request would be generated to purchase 30 units of the product. The new stock will be reflected in the new transaction.

Click Here to view the Inventory Records of Order To Cash Form. These records update after every successful transaction done through the above form.

Order Book Form (Below) shows the Order and Payment Status of each Client. Select the Client's Name from the drop down and alter the "Not Paid" Payment Status to "Paid", when the Client has made the payment.

Note: After you add an order through the form above, please refresh this page to see the data you've added. The Zoho Creator Embed picks up data at the time of loading of this form.

Click Here to view the Records of Order Books. These records update after every successful transaction done through the above form.

Advertising/Marketing Communication Agencies - Ethics & Performance

Ms. Raji Ramaswamy at VGSoM

Until a few days back, I was under the impression... or rather was told that in practice, the advertisement and marketing communication agencies don't handle communication for competitors at the same time. Quite reasonable I would say. Picture this-an agency making advertisements for both Pepsi and Coke! Quite amusing, isn't it?

But recently, I had a chance to participate in a workshop on advertising and marketing communications organized by Vinod Gupta School of Management, IIT Kharagpur in which Ms. Raji Ramaswamy, Senior Vice President, JWT ( World's best-known marketing communications brand) enticed the audience with insights on marketing communication. And that's where I got to know that JWT did marketing communication for both Cadbury's Perk and Nestle's KitKat. The two brands once upon a time were cut throat competitors. There are two main questions that arise: 

1. Can an advertising agency do justice to both the competing brands?
2. Can a client trust an advertising agency with its brand, knowing that the agency is doing marketing communication for its competing brand.

Interesting, isn't it? Ms. Ramaswamy answered my first question, saying that JWT has independent teams for brand communication for the competing brands. In this way the sanctity of brand communication for two competing brands is maintained.

Good enough! But isolation of both the teams to what extent, is the important question. What if they discuss their ideas casually? What if somehow one team's idea flows to the other? What if the brand to approach the agency first gets the first mover's advantage? And the most important question-Why shouldn't a brand choose a different advertising agency if it knows that its competitor is being served by the advertisement agency of choice? Is it because no brand wants to miss out on the best advertising agencies of the world? Is it because they know the second best isn't good enough? Or because the world's best advertising agencies prove wrong the age old hindi quote-Ek mayan mein do talwar nahi reh sakti (2 swords can't reside in the same case) !!!