Free Copy of SAP Business One To Go for Version 8.8 Available We’ve just uploaded the latest version of the always excellent SAP Business One To Go document for version 8.81 This includes all of the latest capabilities and new functions. You can think of this as the comprehensive product manual that doesn’t really exist … Continued
If you’ve ever wanted to import data into Business One (B1) directly from another data source such as SQL Server, Access or some other data source that supports ODBC (Open Database Connectivity) there is a new article on how to do this as the SAP Community Network. This makes certain data transfer situations easier as … Continued
Auto Numbering Of SAP Business One Master Files In version 8.82, you are now able to auto number Master files – Customer, Vendor and Items. The screenshots below, display how to setup auto number for Customers. The same would also apply for vendors and items. To Start: Go to – Administration -> System Initialization -> … Continued
Backup your database. Get everyone out of the system. Create a UDF (User Defined Field) (Tools->User-Defined Fields) at the marketing document header by clicking on the yellow (or gold) arrow to the left of the Marketing Documents row. Look for the row below that called Title and click on it. In the Lower right hand corner is a Add … Continued
Customizing the prompts in Business One Queries SAP Business one provides a powerful way to prompt users for parameters when running a query you define. One tip is the ability to change the name of prompting text from the default to something more meaningful. This method, gives you the ability to define any table/field combination … Continued
/* Business Partners */ SELECT * FROM OCRD /* Chart of Accounts */ SELECT * FROM OACT /* Item Master */ SELECT * FROM OITM /* Terms Codes */ SELECT * FROM OCTG /* Business Partners and their assigned payment terms */ SELECT OCTG.PymntGroup, OCRD.* FROM OCRD LEFT OUTER JOIN OCTG ON OCRD.GroupNum = OCTG.GroupNum … Continued
Are you already using SAP Business One dashboards? If you are, you will be fascinated that there is more information you can gather by adding “Actions” to your dashboards! These actions allow you to quickly gain insight from the data that displays in a dashboard. In the example below, I added the following “Actions” to … Continued
Have you ever wished you had the power to CHOOSE what information gets added to the journal entries that are created by documents? If the answer is YES, then you will be ecstatic to know that now you get to decide what additional information can be brought over to the journal entry by using SAP … Continued
As you are may be aware, ‘Petya’ is the latest global Ransomware outbreak. Just a month ago it was WannaCry. Petya does WannaCry one better. Instead of merely encrypting all your data files on all vulnerable servers and computers on your network, it makes them unbootable without paying the ransom and even then the odds … Continued
