SAP Business One Implementing Notes: Adding New Fields and Tables
In comparing to other ERP and Small and Midsize Business Accounting applications, SB1 is more flexible and where traditional system may require programmer to code the custom logic and then integrate it with existing user interface and the database – SAP BO may have this custom logic to be easily set up in User Defined Tables and User Defined Fields, and SAP B1 software developers already supplied simple user interface to work with newly created objects, let’s us show you how. We will be assuming that you are on SAB BO version 2007A, international version 2007B should be the same if you translate our article to you local language, and if you are on SB1 2005A/B, you should be able to find the same functionality in slightly different menu paths:
1. OK, let’s assume that you need few new fields to be associated with Business Partner, such as Statement Type: email or mail. You will need new field on the Business Master table, the field should be named Statement Method, it should be Drop Down List with two options: Email and Mail. Please, open Tools->User Defined Tools->User Defined Fields-Management. Expand Master Data, Business Partner, highlight it and click add button at the bottom of the form. Name the field Statement Method, give appropriate description, alphanumeric, Structure: regular, mark Set Valid Values for the Field and click new to create Email and Mail options in this new DDL. Now, open Business Partner and pull out existing customer, for example. in Menu: View->User Defined-Fields and you should notice that New Small Windows is now open to the right of the Business Partner Master Data window, here you may select Email or Mail from DDL, when you will click on OK (or Add, if you are adding new Business Partner/Customer), Statement Method will be saved together with the regular Business Partner info. For those of you who are IT people or Software Developers, please click on View->System Information and then place your cursor over new field – you will see that it is created in OCRD table (Business Partner Master Table)
2. Let’s come out on the fresh air and between us, who are Corporate ERP consultants discuss, what we just saw. In other more traditional Corporate ERP, MRP, CRM, Sales Order Processing systems, etc., this is legitimate so-called “customization”, where programming is required or at least recommended. SAP Business One does the job in out-of-the-box install with five minutes long setup procedure. Please, relax and expect more surprises, let’s move on to new custom table creation
3. User Defined Tables. Tools->Customization Tools->User Defined Tables Setup, here give it the name, description, and select No Object if the table will be stand alone, or select Master Data if it is supposed to be linked to Master Data table, or Master Data Rows (in you plan to link it to Business Partner Address, which is Master Data Row classified table), Document (if you plan to link it to AR Invoice, or other legitimate document header), or Document Rows (if you plan to link it to AR Invoice Inventory Item or Service Line, for example). In our example, let’s try to be moderate and give you just simple example, we would like to create Non-Inventory Item Monthly Cost table, which is No Object. Give it the name, description, and then Tools-> Customization Tools->User Defined Fields Management, expand User Tables, highlight Non Inventory Item Monthly Cost and click Add: Add Year, Month and Cost fields (feel free to apply your judging on the type). Now, let’s enter the rows into newly defined table. User Defined Windows, select your newly created table and feel free to enter data there. Small comment, SB1 designers looks like were trying to make our life easier, so the created two mandatory fields: Code and Name, we recommend you to enter unique values there
4. SAP Business One Executive Demo or technical presentation. Via Web Session and Phone Conference you can request this service being USA, Canada Nationwide, in Europe, Brazil, Latin America and Internationally
5. Second Opinion on SB1 implementation or modules selection. This service is popular if your local SB1 reseller failed in challenging implementation, when you have to do complex Data Conversion, Integration to Legacy Systems, including Lotus Notes, Oracle Custom DB, legacy ecommerce
6. SAP B1 as Publicly Traded Multinational Corporation local branch ERP. SB1 licensing is relatively cheap and considering the fact that it is localized (translated to local languages in the majority of the countries: Brazil, Mexico, Venezuela, Colombia, Israel, Russia, China, to begin the long list; plus it is certified with foreign countries tax agencies). Special considerations to the customers, where their corporate ERP is not localized in the overseas branches. Good example is Dynamics GP Great Plains, it is only supported in USA, Canada, UK, Australia, New Zealand, Arabic countries, Spanish Speaking Latin America and English Speaking South East Asia. If you have Dynamics GP Great Plains as your Corporate ERP in USA or Canada, please consider SAP Business One in such country as Brazil, Russia, Poland, Lithuania, Latvia, etc., for your local branch with GL or even full data consolidation to Dynamics GP via Great Plains Integration Manager. SAP Business One allows simple data export to Microsoft Excel, or you can do exported data marking on SB1 SQL DB level
7. How to get help? Please, call us: 1-866-528-0577, help@albaspectrum.com
About the Author
Andrew Karasev, Alba Spectrum, subdivision of M2-D2, help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America
Inspiring Venezuela’s Children a Note at a Time
|
|
5 BOLIVARES Note VENEZUELA 1989 National PANTHEON – UNC $4.87 |
|
|
Venezuela 20 Bolivares Note — Circulated $1.47 |
|
|
Notes On The Archeology Of Margarita Island, Venezuela. $20.43 |
|
|
VENEZUELA NOTE 50 BOLIVARES 1988 SERIAL Z P 65b XF+ $3.90 |
|
|
VENEZUELA NOTE 5 BOLIVARES 24.9.1968 SERIAL F P 50a $5.86 |
|
|
VENEZUELA NOTE 500 BOLIVARES 31.5.1990 P 67d UNC $4.88 |
|
|
VENEZUELA NOTE 100 BOLIVARES 1990 SERIAL T P 66c UNC $4.88 |
|
|
VENEZUELA NOTE 1000 BOLIVARES 1995 SERIAL E P 76b UNC $6.84 |
|
|
VENEZUELA NOTE 5 BOLIVARES 1973 SERIAL T P 50g UNC $24.44 |
|
|
VENEZUELA NOTE 20 BOLIVARES 1973 P 53c SERIAL C UNC $9.77 |
|
|
VENEZUELA NOTE 100 BOLIVARES 1979 SERIAL V PICK 55f AU $19.55 |
|
|
VENEZUELA NOTE 1000 BOLIVARES SERIAL C 9 DIG P 76a UNC $9.77 |
|
|
VENEZUELA NOTE 20 BOLIVARES 23.4.1974 PREFIX J P 53a XF $39.09 |
|
|
VENEZUELA NOTE 10000 BOLIVARES 2001 PICK 92 UNC $19.55 |
|
|
1990 VENEZUELA 20 BOLIVARES NOTE $1.51 |
|
|
VENEZUELA NOTE 5 BOLIVARES 29.01.1974 SERIAL Z 7 DIGITS P 50h VF $3.90 |
|
|
VENEZUELA – NOTE – 5 BOLIVARES YEAR 1968 P# 50a, SCARCE $12.70 |
|
|
NEW 2007 Venezuela 5 Bolivares note UNC $3.67 |
|
|
VENEZUELA 5 BOLIVERES 20.3. 2007 NOTE HIGH VALUE NEW UNC. $3.99 |
|
|
VENEZUELA Coin bank notes Gold topic set of 5 FDC $16.63 |
|
|
VENEZUELA NOTE 10 BOLIVARES 2007 SERIAL G PICK 90 UNC $5.86 |
|
|
VENEZUELA NOTE 5000 BOLIVARES 25.5.2004 P 84c UNC $4.88 |
|
|
VENEZUELA NOTE 2000 BOLIVARES 1998 PICK 77c UNC $8.79 |
|
|
VENEZUELA NOTE 10 BOLIVARES 2007 SERIAL C PICK NEW UNC $5.86 |
|
|
1992 Venezuela 20 Bolivares Bank Note Jose Antonio Paez P 63d $3.67 |
|
|
1989 Venezuela 1 Bolivar note P.68 UNC $2.44 |
|
|
Venezuela P-88, 2 Bolivar, 2 Dolphins, verticle note $3.04 |
|
|
1995 Venezuela 10 Bolivares note P.61d UNC $1.91 |
|
|
10 BOLIVARES Note VENEZUELA 1990: Bolivar & Sucre – UNC $5.85 |
|
|
VENEZUELA 500 BOLIVERES 1998 NOTE HIGH VALUE NEW UNC. $3.99 |
|
|
1989 Venezuela 1 Bolivar & 2 Bolivares Bank Notes P 68 & 69 UNC $3.42 |
|
|
1989 Venezuela 5 Bolivares note P.70 UNC $1.47 |
|
|
1995 Venezuela 20 Bolivares note P.63e AU/ UNC $2.69 |
|
|
Venezuela 20 Bolivares 1992 Bank Note Paper Money $6.18 |
|
|
500 BOLIVARES Note VENEZUELA 1998 Cattleya ORCHID – UNC $7.71 |
|
|
Venezuela 2007 2 Bolivares bank note 2 Dolphins $2.93 |
|
|
Venezuela 100 Bolivares Bank Note Banknote Paper Money $6.18 |
|
|
1998 Venezuela 1000 Bolivares note P.76 UNC $2.69 |
|
|
Venezuela 2 Notes Set 1 & 2 Bolivares 1989 @ Crisp UNC $2.49 |
|
|
1998 Venezuela 2000 Bolivares note P.80 UNC $4.40 |
|
|
Notes On The Archeology Of Margarita Island, Venezuela $19.59 |
|
|
Venezuela (2) Notes 20000 Bolivares 2004 P86b @ UNC $24.94 |
|
|
Venezuela (2) Notes 20000 Bolivares 2001 P86a @ AU $21.61 |
|
|
1999 Venezuela 500 Bolivares note P.67 UNC $3.86 |
|
|
VENEZUELA 2 BOLIVERES 20.3. 2007 NOTE HIGH VALUE NEW UNC. $2.99 |
|
|
Notes On The Archeology Of Margarita Island, Venezuela $47.18 |
|
|
Venezuela 100 Bolivares Banknote Bank Note Paper Money $6.18 |
|
|
VENEZUELA 45 BOLIVARES (3X NOTES) $4.88 |