2013 in review and report of your blog focusing on ERP and eCommerce

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

  • Some visitors came searching, mostly for erp, implement, erp presentation,fortis hospital software, and happy end of financial year.
  • A San Francisco cable car holds 60 people. This blog was viewed about 2,900 times in 2013. If it were a cable car, it would take about 48 trips to carry that many people.
  • Visitors of iJyoti.com blog are from 105 countries in all!
    Most visitors came from India. The United States & The United Kingdom were not far behind.

Click here to see the complete report.

Senior Citizens Friendly grocery store uses GPS in the shopping cart

Map in the shopping cart for Senior Citizens

Grocery shopping can be quite an ordeal, long aisles with multiple signs, constantly changing sections, and distracting food samples comes between you and your final destination, the checkout.   Large malls will be coming up in India due to recent change in the Government policy pertaining to the Foreign Direct Investment (FDI).   But, what about old people who gets lost in the large super markets?  God help ‘Kirana‘ (old style small corner shop) store.

What is GPS?  The Global Positioning System (GPS) is a space-based satellite navigation system that provides location, anywhere on the Earth.  It is maintained by the United States government and is freely accessible to anyone with a GPS receiver.

To tackle this growing social issue, technologists across the world have invented a special shopping cart with a GPS system, for malls that leads confused shoppers to their desired targets, that is check-out or the POS terminal. Targeted for senior citizens:  Do you think a GPS-enabled shopping cart could be a boon to shoppers, who have  been known to go to buy just milk and return with Rs.1000/- worth of junk food?

In the back-end the ERP system will also be recording analyzing data for the ‘Business Intelligence’ (BI) to prepare reports that will tell the sellers information pertaining to fast selling items required by the senior citizens.   This kind of stores will become ‘Senior Citizen Friendly’ store, and from the CRM point of view this may attract more older people too.

This appears to be a good idea for the consumers, but the marketing people in the supermarket may not like this. They have spent lacks of Rupees analyzing consumers’ shopping habits;  that is why layouts keep changing.  It  is specifically to lure customers to spend more time wandering around the aisles, in a hope that the buyer will spend money on things they did not know about but would happily buy.  Next, you may find Apps on your iPhone (or the Android smartphone) that will tell you where you are and which way is the Exit.   Do you think this will really help senior citizens ?

[Source: This post is based on information from switch. com and device. com]

SAP ERP in Indian National Language – Hindi

Don’t say साँप – Pronounce as एसएपी

 

It is no hidden truth that Hindi, the official Indian language and the preferred language of transaction for over 40% of the population. Specifically in the public sector, there was the need for solutions that helped the Hindi-speaking workforce work in their own language.  SAP has pitched its Hindi ERP solution in the Indian market with an eye on the Hindi belt.

English: The word "Hindi" in the Dev...

English: The word “Hindi” in the Devanagari script. (Photo credit: Wikipedia)

The solution will surely set a precedent for various vendors to beef up work on the availability of software in local languages.  It will allow companies to employ Hindi-speaking people, thereby opening a pool of job opportunities. Vendors like Microsoft are already offering their operating system and office suite in the local language for quite some time now. It would be interesting to see if competitors like Oracle, Salesforce, etc also jump into the fray.

SAP seems to have seen a good opportunity in the burgeoning public sector where immense automation drive is on.   SAP also admits that the increased pace of adoption of the SAP ERP in the Government sector spanning across the Central, State, Public Sector Enterprises, Utilities, Municipal Corporations, Railways, Defense, Airports and Shipping, led SAP to localize its software to address local requirements of customers .

SAP ERP in Hindi will help to address areas such as Logistics including India taxation, accounting, employee data, and provident fund, Payroll including pay-slip, loans, claims and Employee Self Services.

Join this Facebook group Discuss ERP

Let us discuss:  Join LinkedIn group and Facebook Group focusing on ERP

–  Managed by Jyotindra Zaveri, ERP Consultant and ERP Trainer.

Will localize solution help unlock the domain knowledge and expertise that exists at user level in India?  What do you say?

Year ends on March 31- Due priority should be given by all stakeholders

Year-end procedure.  In India, the accounting year is April to March.  Accounting year 09-10 has ended on 31st March 2010.  Important procedure is given below to plan the ‘year ending’ in ERP.  The following procedure for ERP rollout is very important.  Due priority should be given by the stakeholders.

The procedure will vary depending on your current status as follows:

1.    ERP status is ‘go live’.  Users are online and entering transaction in real-time.  The closing stock was already entered.

2.    ERP is being implemented.  Conference Room Pilot (CRP) run is done.  You have to  decide on the cut-off date.  You may think of considering 31/03/2012 as cut-off date, or any suitable date.  The day after the cut-off date, users go online.  That is ‘Go live’, and embraces New Year 2012-2013 with more accuracy in inventory management and tighter discipline.   There are two kinds of closing balances that are required:

Accounts closing balance:  Debtor.  Creditors.  Closing balance of stock.

It is important to note that both inventory and accounts are tightly linked in ERP.

·         FAQ: “Can we enter creditor / debtor balance and closing stock, later?”  The answer is NO.

1.    Before doing anything take backup.  Copy on once writable CD; take the backup media to another location (different building).

2.    Task:  Enter closing stock for Inventory items.

3.    Count stock.  This exercise should be done very carefully.  This is important for ‘going-live’.

4.    Enter the closing stock, as on the cut-off date, from that date onwards, ERP will prepare the inventory related books, as well as accounts books, automatically.

5.    E.g. closing balance as on March 31, mid night is opening balance for April 01.
6.    Task: Enter ALL items in the item master.
It is strongly recommended that for EACH location stock balance be taken.  E.g. stores, rejection location, scrap location, WIP (work-in-process), third party (subcontractor location), etc.

7.    Task: Take location master printout (excel sheet showing all locations) from the ERP (not from Tally).  The list will also show names of subcontractor locations.

8.    Bought out items, raw material, consumables, spares, etc.  Items that are supplied by vendors (supplier).

9.    Sub-assemblies, semi-finished goods, factory made item, etc.  This may include items that are received from third party, if it is semi-finished goods. (WIP).

10.  Finished Goods, (FG or product that usually appears in the sales invoice).

11.  Task: Prepare the Item list using ERP software instant excel sheet option.  You can prepare category, sub-category wise, separate list.  Give to concerned person to take physical stock (count) and write on the excel sheet itself, put date and sign.  This is strongly recommended to avoid confusion of item code / description.

12.  Use this list (hard copy) to enter closing stock figures in ERP.

13.  From that moment onwards, every transaction must go through ERP.

14.  Depending on your judgment, estimate time required to do the physical count and the exercise to enter the data in ERP.  This will depend on number of persons allocated for the task.

15.  During the stock taking activity, there should be NO material movement.  All goods inward and sales issue has to be suspended.  For instance some companies would like to do this exercise on 1, 2 and 3 April and start the year on 4 April 08.  Some companies stop the manufacturing activity on 30 and 31 Match.

16.  You may find items that are physically present but not in the list – enter in the item master and enter closing balance.

17.  Account Closing Balance are required for the following:
• Debtor (customer),
• Creditor (vendor, service provider, and third party) balance pertaining to 11-12 balance will be carried forward automatically.
• Pass JV (cr. Note or debit note if necessary to get the correct balance).  Make sure the bank-reconciliation exercise is done well in time for ensuring correct ‘Trial Balance’ statement in ERP.

18.  In case you have already gone “Live”:
Count physical stock for each item and write on the excel sheet printout, next to ERP stock statement (book stock) figure.  Ideally, both should be same.  If not write the difference (plus or minus).  You will have to get explanation from stores-in-charge and pass SAN (stock adjustment note) to get the book stock same as physical stock.

19.  You may find item that are shown as stock in hand but there is no such item.  Check that there is no confusion in item name.  Any case one must reconcile the stock.
20.  You will have to do this exercise for each location.  Especially stock lying with the third party (if any).

21.  Print separate list for FG, WIP, Stores items, consumables, packing material, etc. from ERP software.

22.  You will need people so plan in advance, inform your team (staff), this is not one or two persons task.  More people are required depending on number of location, size of the inventory, and so on.

23.  At the time of login, into the ERP, select appropriate year (the first screen where you give log in name and password).

24.  New document number series will start from the New accounting Year – e.g. April 1, 2012.

25.   ERP System will allow you to enter 11-12 transactions even in April 2010, (for this select year 11-12).  Finally, when the audited Balance Sheet is available one can make a “closing JV (Journal Voucher).  This may be sometime in April / May 12.  Whereas the current year (11-12) transaction can be entered from 1st April itself (these will be in new document series).

26.  Cut-off date is ‘as on’ date in the Closing Balance data entry screen.

27.  In item ledger and item stock statement ‘From’ date should NOT be less than Closing Balance, date that is used for entering closing balance.

28.   User must press ‘enter’ key after entering the closing balance stock.

29.  Once closing stock is entered, user should check, and if mistake is found, then enter again; this will over-write previous figure.  Once all closing balance is checked, printed and confirmed then REMOVE access to the closing Balance menu-using user manage.  No one should enter again cl. Bal. because this is one time exercise.
30. Only after disabling, the cl. Bal. menu user should be allowed to enter inventory transactions.
31. Closing balance Rate or value:
• While entering stock closing balance, user also should enter rate.  This is required to calculate the value.
• For item that are purchased from outside – pl. enter the Weighted Average Rate (WAR) rate (weighted average rate), or last purchase Rate, if WAR rate is not available.
• For all factory made items – SFG (Semi-Finished Goods or sub-assemblies) or FG (Finished Goods)– user should enter ‘cost rate’.

For additional information study The Sarbanes–Oxley Act of 2002

The bill was enacted as a reaction to a number of major corporate and accounting scandals including those affecting Enron, Tyco International, Adelphia, Peregrine Systems and WorldCom. These scandals, which cost investors billions of dollars when the share prices of affected companies collapsed, shook public confidence in the nation’s securities markets.

In India PWC and Satyam is recent examples of accounts manipulation.

WordPress Blog is launched by the leader Anna Hazare

Anna blogs on WordPress

Anna blogs on WordPress: यापुढे याच ब्लॉगवरुन मी आपल्याशी वेळोवेळी संपर्क साधणार आहे.

Social activist Anna Hazare has launched his blog in Marathi, Hindi, and English using the WordPress digital platform.

Actually the post will be done by Parulekar Raju and Kuvalekar Vijay.  This is a good example of out-souring your blog activities.  WordPress is a popular digital platform to make your Website using the Web 2.0 technology.

We recommend blog strategies as follows:

Blog is one the important digital platform for social media strategies.

  1. sign-up or subscribe blogs pertaining to your industry, read and comment.
  2. Read blogs pertaining to your target market.  Find professionals who are blogging regularly and try to establish relation with them and plan a public relation strategy with them.
  3. Publish your own (company) blog to interact in timely manner with your target audience.
  • Blog best practice:

    • Recommended best practices for Business Blog.  1) Prepare a document containing guidelines and rules 2) Use blog monitoring technology – e.g. Blog analytics and  3)  Plan periodic training to all staff, especially sales and marketing professionals to leverage the power of interactive websites, that is called Blog.

    • Educate the stake holders.  Enterprise wide training should be planned and HR can keep track who has attended, number of hours, etc.  Appoint chief of Blogging ( a person who will also control passwords).  Make sure CEO and other senior management also is attending the training sessions, even if they are not planning to use.  This is to ensure everyone understands the risks and rules of using social media web sites.

    • The aim is to ensure users use the sites like LinkedIn, facebook, or twitter in a responsible way.  It is necessary to educate them about the consequences of not following the rules and guidelines.  You must have noticed that people use email with disclaimer footer in emails because they know it is legal, etc. However, the blog posting is also like email, a written electronic record.

    • It may be prudent to make individual sign a document that they have read and understood the blog rules.  Interactive sites use email id and secret password to restrict access.  It is necessary to have a clear idea about the passwords and control of using email id.

      Here is a video demo of reports giving information on – how many people are visiting your blog or reading your ppt, where they’re coming from, which posts are most popular, and which search engine terms are sending people to your blog.

  • We will help you in using the blogs and social media marketing techniques effectively.  You should try blog instead of traditional methods of print advertisements, Television, Yellow Pages, and so on.  All together it is a lot of work, but it is well worth it, and it does pays off at the end.  There is a lead time of three to six months for your blog to catch-up.  So what are you waiting for?  Go ahead start your own blog using Google’s Blogger or WordPress because it is free and it is fun.  There are many blogs targeting the emerging market in India.

  • Links to Anna Hazare blogs:

http://annahazaresays.wordpress.com/  and in English https://annahazaresays.wordpress.com/category/post-in-English/

IT training @ Belgaum, Karnataka, India

Organized by the Institute of Management & Research and Varnaaz.

Date: Saturday, September 17, 2011.  Venue:  IMER, Hindwadi, Belgaum, Karnataka, India.

Varnaaz IT seminar details

Zaveri will speak on the subject of Social Media Marketing


Program objectives
IT training program for small and medium size companies

 

In SAP ERP conference, Dabbawala explained supply chain management

Supply chain management without software ?
Supply chain management by Dabbawala

Mumbai Dabbalwala has six sigma

Learn about this amazing organization
 which got six sigma.
They deliver even in rainy season in Mumbai, India,
 without any excuse.


Here is a short presentation of 15 slides.
Let us know if any of you have actually
 experienced this 'lunch box' service.
%d bloggers like this: