FAQ: What to learn for new comers in SAP B1
Objective:
FAQ: In my experience i have answered this question so many people. So am writing this document
Question: Am new to SAP B1 What i want to learn
Answer for Functional Consultant:
- Business Process
- Formatted Search
- SQL Query Report
- Crystal Reports
- Stored Procedure
- Preparing Documentation
- Good Communication
Note: This 7 points will help you to get good position in SAP B1 field.
Detailed Explanation :
- Business Process:
Purchase
- Import purchase process
- Local purchase process
- Fixed asset purchase process
- Subcontract purchase
- Service purchase
- Non stock item purchase like , paper, pen, tissue cloth etc…
- Quality process
- Refer this link for more details: How to Implement SAP Business One projects successfully
Inventory
- Stock Revaluation
- Stock Taking
- Purchase return
- Sales return
- Returnable Gate Pass “Configure GRPO-QC and Returnable Gate pass using – Inventory Transfer Ctrl + Tab in ITEMCODE field“
Production
- Production planning like , Daily, Monthly or based on sales order etc…
- Set multilevel BOM
- Stage wise production
- Send one process for subcontract
- WIP process
- Quality process for each stage.
- Re-process
- Handle Scrap in each production stage.
- Maintenance
- Refer this link for more details: How to Implement Production in Default SAP Business one
Sales
- Export Sales
- Local Sales
- Consignment Sales
- AS IS sales (You will buy sales with same tax value based on selected batch- This scenario related to INDIAN localization)
- Service Sales (In this case you will act as sub-contract for other business partner)
- Drop ship Sales (In this case stock will not come to factory it will be sale in transit)
- Production Scrap sales
Finance
- Reconciliation
- BRS
- SAP Account flow of all the documents like , Goods Receipt PO , A/P invoice etc..
- Char of account drawers like, What are all P&L drawers and what are all Balance sheet drawers etc..
- What is Cost of good sold
- Valuation method like FIFO , Moving average and Standard
- In which situation we have to use Set G/L method by Item group or by Warehouse
- What is the use of Trail balance, P & L, Balance Sheet
- Year end process
- What are all the stationary reports based on your project localization.
- Fixed asset setup : Fixed Asset SAP Business One 9.0 Configuration
2. Formatted Search
- You need basic knowledge of SQL to write this.
- Get one field value to other field
- How add two field and put a value in other field
- How to deal with Quantity and price field, for example you have use “.Number” keyword
3. SQL Query Report
- What is header table(OPOR) and row table (POR1)
- What is object types
- What is docentry
- Refer this link for more details: Database design in SAP Business One
4. Crystal Reports
- PLD in crystal report
- Normal reports
- Cross tab report
- Formula field
- Report using SQL quries
5. Stored Procedure
- You need basic knowledge of SQL to write a stored procedure.
- What is Object type and Trans Type
- What is the use of @list_of_key_cols_tab_del and @list_of_cols_val_tab_del
- Same object type should not contain more that one time. (you have to use only if and else if)
6. Preparing Documentation
- How to prepare AS IS and TO BE document
- Help document
- Technical document for addon.
7. Good Communication
- Communication is more import bcz we have to conduct meeting with top level people
- We have to be very careful what we are giving commitment to customer, if you say yes for not possible things then you will be in trouble of completing that.
- How to send a daily project status mail
- How to train end user (bcz you have to face educated and un-educated person and then you have train some times who didn’t used the computer in his life.)
Any questions or if anyone has any tips for me please post below.
Hi,
Valuable information!!! Thanks for sharing.
Best Regards,
Nagarajan
Hiii Sir,
Database design blog is nice one to learn for freshers..
Another things want to add is after implementation is done.
1)To teach the "Super users (manager user id )" about the SAP Customer Portal and S-user id for searching the SAP NOTES for any error messages received. And also find the solution in SCN.
2)Also main thing handling the ERP server, Where exactly data files are stored (mdf/ldf)
How crucial these files are and how the backup can be taken through SAP service manager as well through SQL Server.
3)Approval procedures to be taught and Creation of new Tax code specially for Indian Customers.
General point from my personal experience to add in for Freshers is Gaining entry to SAP World through SAP Business one is lot more easier when compared entry into SAP R/3 where minimum entry level is 3 years. And Good thing about SAP B1 you learn each every department how they work together to make business easy and connected and with lot of SME moving to erp SAP B1 is worth a shot...:)
Thanks & Regards
Darshan Desai
Hi Darshan,
Thanks for your valuable feedback, will update this document with you points ASAP.
Hi
Very good blog for new comers. System architecture missing?
Hi sridhar,
What do you mean the System architecture, can you give some example so that will help me to include it.
Dear Prasanna,
Very nice blog.........Congratulations
Thanks&Regards
Umesh Vaidya
Thanks for the points.
Now I find what items all are missing being a functional consultant.
Thanks for the blog, found very helpful
Regards
Lanish Kuruvilla George
Nice information for new b1 consultant...
Hi
Good Information...
Thanks...
Dear Prasanna
Thanks for sharing...Valuable information!!!
Thanks&Regards
Andakondaramudu