SAP Business One is one of the most widely used ERP (Enterprise Resource Planning) products worldwide, especially for the small and medium enterprise market. At present more than 60,000 businesses use SAP Business One, with most having between 10 and 200 employees and having annual revenues of between $ 1 million USD and $ 50 million USD. Subsidiaries from larger organizations also use SAP Business One as a solution to the needs of ERP systems in the company.
When you generate a financial reports, or inventory reports somehow you’ll find various document type on it, such as: IN, PU, PD, JE, DP, etc.
It was called document type.
Note that all of document type not stored on any table on SAP Business One.
Not familiar with SuSE Linux, but your SAP Business One HANA often get a services error and not running? Today, we want to share about restarting related services for all of SAP Busines One HANA users.
Follow there steps about how to restart SAP HANA related services in SuSE Linux Enterprise 11 SP 4 Operating System.
Especially if your SAP HANA System is not responding or some service is not running, and affected to your daily business process, you can try to restart services below.
Sometimes, you’ll need to create simple queries to preview and analyze data, you can use “Query Generator” feature, or create some validation with SP Transaction Notification, create another SP Post Notification on your database, with custom queries that directly created on SQL Management Studio / HANA studio. But, you can’t remember all of tables name on SAP Business One.
Here’s the full list of Object Types with Primary key on B1:
There are 2 types of Period End Closing on SAP B1:
Monthly Closing and Year End Closing.
Please backup your current database first, before you doing this steps for Period End Closing and Fiscal Year Changes.
Open the Exhange Rate Differences on Financials menu.
On SAP Business One, there’s two type information that provided for identify user access into SAP Business One application, and user access for modify (edit/update) any data on SAP documents.
User Access Log (Go to: Tools > Access Log)
This option often used for monitoring daily activity from user when they log in, or log off from SAP, and information about the number of failed access attempts since the last successful logon for each user.
As an internal IT and superuser, you can be monitoring your user access with running a query use table USR5.
In SAP Business One, you can allow or block negative number (below zero) of your inventory. You can setting it on Administration – System Initialization – Document Setting – Block Negative Inventory (check the box if you want to block).
You also can set the block negative inventory by 3 options :
- Company : When you specify Block Negative Inventory By Company, SAP Business One blocks an item only when its cumulative inventory quantity across all warehouses in your company goes below 0.
- Warehouse : When you specify Block Negative Inventory By Warehouse, SAP Business One blocks an item if its inventory goes below 0 in any warehouse to which it has been assigned.
- Item Setting : When you specify Block Negative Inventory By Item Setting, SAP Business One blocks negative inventory either at company level or for each warehouse, depending on the status of the Manage Inventory by Warehouse checkbox in the item master data.
You are an It support in your company and need to update the system while need to make sure everyone is logged out from SAP Business One Client? Well don’t worry since this tips will make your work easier :
Go to Administration → Utilities → Connected Clients
This screen above will show you all active user that still logged in to SAP Business One.
Well, what if the user forgot to logged out and they already out of office at the moment? Rest assured, after confirming to the selected user they don’t use it at the moment you can disconnected selected user remotely from your server using disconnect button after choose which user need to be logged off.
Notes: This tips need an administrator level (In this case a super user).
We are PT. Sterling Tulus Cemerlang is a Gold Partner of SAP Indonesia for SAP Business One products. Currently has more than 15 years of experience and has implemented in hundreds of companies. To help SAP Business One users around the world better utilize the SAP Business One they already have, we share our experience and knowledge in the form of tips for users on the website https://www.sap-business-one-tips.com
Up to the beginning of 2020, we have shared more than 300 tips and will continue to share them with the development of SAP Business One as a product that continues to innovate and develop following the times. Here are Top 7 SAP Business One Tips that are the most widely viewed according to the www-sap-business-one-tips.com: