TOO EXPENSIVE TO PAY SAP MAINTENANCE?

Many of my clients ask what is the point for us to pay maintenance to SAP, which is 17% of the total license value that we buy. Suppose we buy 5 professional licenses for EUR 2,000, the annual maintenance we pay is 17% * (5 * 2,000) = EUR 1700 or around 25.5 million per year. That's five if you guess yourself :).

But before I explain why we (must) pay, I explain the definition of maintenance first, because many are mistaken about the definition of maintenance. The maintenance that we pay to SAP is maintenance of SAP Business One Products as it is. So it is not maintenance to configuration or suppose CR (Change request) to a function or make a new report, not like that. The maintenance in question if there is anything about the SAP program or our database will get support from SAP world wide.

Why do we have to pay? well, business must go on, so does SAP who must hire support teams and developers who always carry out Research & Development (R & D) on walking SAP products and forward development. Now the money we pay is intended for the kitchen of SAP's R & D. So, why is it that if we join the maintenance program then we get FREE update patches until the upgrade version.

What if we don't pay? All SAP B1 customers are required to pay first year maintenance. But it is possible that they will not pay in the second and subsequent years. Well, the matter of joining or not is human rights for every customer. But if something happens, for example the database is corrupt and others related to SAP Products will not be supported other than that the customer is required to pay a fine + to pay the annual maintenance that has not been paid. It's complicated, it's even more expensive. Now what do you do ??? The point is to determine the software & maintenance software strategy wisely ^ _ ^.

How to Use Flow Cash SAP Business One

Cash Flow Report

Cash Flow Report Used to analyze cash flows based on income or costs such as checks, credit cards, obligations and others.

This report:
Take into account whether there are still accrued payments, and if not, the possibility of the receivables is collected.
Allows you to predict income and costs in order to make decisions.
Can increase Turnover Cash flow issued by the company whether it is in accordance with the costs incurred should
To Use Cash Flow the step that must be done is to define in advance the levels to be used, to setup it located in the Financial Module - Financial Report Template

How to fill out a Financial Report Template

Select Report to use
Select the appropriate template, if you haven't registered it can be added.

Fill in the Naming Cash Flow to be Used As needed. Like the example image above. Charging is the same as doing COA Input (Chart Of Account).

Check Text Title If Only as Header (Not Used when conducting Transactions)

To Create a Sub Level Can use the Add Child Button

For the Name of Cash Flow that will be registered in the List When conducting transactions Text Title does not need to be checked

To make a Summary for Every Cash Flow must check Sub Total

After the template, the next step is to make an update

Then the Financial Report Template for Cash Flow has been completed

The next step is to setup the Financial - Chart of Account to determine the account code that will be used for cash flow. By checking the Cash Flow then click the Update button as shown below

 After All Setups Are Made Cash Flow Can Be Used On Transactions related to Cash Accounts.

For example, I use Incoming Payment for Petty Cash Transactions

Then When Doing Payment Means Will Appear One Field containing the Cash Flow. And it must be chosen according to the transaction

After the incoming payment transaction is completed, the results can be seen in the report on the module
1. Financial - Financial Report - Financial - Cash Flow

2. Financial - Financial Report - Financial - Statement of Cash Flows

3. Financial - Financial Report - Financial - Cash Flow References Report

Please try and see the results.

Budget Scenario Setting SAP Business One

To Make a Budget Setting things to watch out for are

1. Setup the Module Administration - System initialization - General Settings - Budget
2. Check Budget Initialization
3. Select Option to do Block Document, Warning or no warning when the transaction has exceeded the budget limit
4. Select

• Annual Budget - Annual budget arrangements are made for each user
• Monthly budget - Monthly budget budget settings for all users After logging back from SBO.

5. Check One or more transactions that will be given a warning, or block when making transactions that have exceeded the budget limit
The next step is to setup the Financial module - Budget Setup - Budget Scenario

Budget Name: Naming in accordance with the budget scenario in the current year. Naming Must Be Unique
Based On: Budget scenario that forms the basis of the budget scenario set. An independent budget scenario must be based on itself.

Initial Ratio: To set the percentage of the budget set based on the basic budget. If the Budget Scenario is based on itself, the initial ratio must be 100%

Rounding method: Rounding method for Amount budget in each scenario

How to input in Scenario Can be done in 2 ways

1. Right Click then Add Row

2. In the Data Bar Menu - Add Row (Ctrl + i)

Budget Distribution Method Is the method used for budget distribution. For Defaul System 3 methods have been used to use. The method is Equal, the amount of the budget is distributed evenly between 12 months

 Ascending Order, the Budget is distributed in such a way that most of it is dedicated for the last months, and only a small portion is used during the first months.

Descending Series, Budgets are distributed in such a way that most are dedicated to the first months of this year, and the amount set for each month decreases as the year progresses

You can add other methods if needed (manually), allowing you to manually determine how the budget is distributed between different months. You can, decide that the budget is distributed between just two months.

The next step is to fill the budget on the account that will be used.
The trick is to open the Financial module - setup budget - Budget

Select Scenario which will be used to determine the Budget filling
Select the account to be inputted with the budget.
click the OK button

Budget amount in local currency.
Debit, Budget calculation is always done on the debit side.
Credit, Amount of budget for incoming payment accounts, for reporting purposes only.
Actual, Actual amount of budget that has been used


The above example is the division of the budget using the Equal Method where the Budget is evenly distributed in 12 Months, For More Details or want to change the method used you can simply double click on the no on the left

You can change it if the budget wants to use the manual method, for example for January I want to give a budget of USD 900.

After the Budget Setup Is Done Now is the time for you to try to make transactions related to the account that has been setup. Continuation will be added later

For videos, please see this link http://www.youtube.com/watch?v=m9T0cPywUwg

Business Partner Master Data SAP Business One

Module: Business Partners à Business Partner Master Data.

Used for:

§  Looking for business partners (Vendors, Leads, Customers) 

§   Add new business partners

§   Edit existing business partners data

How to input master data vendors:

§  Click the Business Partner module

§  Click Business Partner Master Data

§  Click the Add icon 

§  Select Vendor or Customer in the field to the right of the code

• Customer - You can make sales transactions, activities, enter opportunities for sales and service calls.
• Vendor - You can make purchase and activity transactions.
• Lead - You can enter sales opportunities, sales quotes, sales orders, and activities.
• Fill in the vendor / customer code in the Code field

      Note

     You cannot specify a code if this code already exists for a defined G / L account or an existing business partner
      If the customer is also one of your vendors, create a Business partner with two different codes.

§  Fill in the vendor / customer name in the Name field

§  Select the vendor / customer group in the Group field

Note

If you don't choose it will default to the first group

§  Select the currency used in the Currency field 

Note

If you want to change the currency that is allowed only there are no transactions in the Business partner.

If the transaction has been posted to the business partner, and the selected currency is All currencies, if you have selected All Currencies it cannot be changed again                                        

§  Tab General; information no.tlp, fax, email, etc. for complete vendor and customer data.

Shipping type è Determine the type of shipment for business partners. The type of shipment will be displayed in each newly created document for business partners.

§  Contact Person; information on the contact person, information regarding; name, no.tlp, address, position, email, etc.

§  Addresses; address of the vendor and customer

§  Payment Terms; information about payment term, credit limit, vendor bank address, etc.

Price list è Used to determine the default set of sales transactions or purchase transactions, when you link a specific price list From a business partner, make sure that the price has been defined in the pricelist. Otherwise, prices are not displayed for items in documents related to Business partners.

Total Discount % è Discount is automatically calculated as a global Discount on all sales or purchase documents for business partners (if needed)

Bank Country è Determine the bank account of the business partner
The bank account that you specified:
Will be used for payments made by the Payment wizard.
Default bank account for checks on incoming payments

§  Payment System; information about the payment system, including bank names and no. account used by the company

 

§  Accounting;information about accounting and tax

§  Click Add/Update; Add to save the newly created data and Update to save the changed data.

Shortcut Used in SAP Business One

Shortcut Used in SAP 

Use of Shortcuts in SAP Business one is used to facilitate the user in opening the display more efficiently

General Shortcut

Display the Main Menu in SAP Business One	CTRL + 0 (zero)
Print a document	CTRL + P
Display Journal Transactions	CTRL + J
Exit SAP Business One	CTRL + Q
Undo	CTRL + Z
Redo	CTRL + SHIFT + Z
Cut	CTRL + X
Copy	CTRL + C
Paste	CTRL + V
Showing Customer Name or Item that starts with a certain letter	Enter the name at the end of the * sign, then Tab
Select multiple items at once	CTRL / SHIFT and select Item
Showing User Defined Fields (Additional fields)	CTRL + SHIFT + U
Showing Next Record / Document	CTRL + Right Arrow
Showing Previous Records / Documents	CTRL + Left Arrow
Change Mode to ADD	CTRL + A
Change Mode to Find	CTRL + F
Change Field Name	CTRL + Double Click
Fill in today's date	Input Any character then Tab
Close the Form that appears	Esq
Add Rows	CTRL + I
Line Duplication	CTRL + M
Delete Row	CTRL + K
Sort the Ascending and Descending Columns	Double Click on the Column header
Showing Row Details	CTRL + L
Return to First Line	CTRL + H
Return to the Last Row	CTRL + E
Copy from the line above	CTRL + ↑ / CTRL + ↓
Calculation of Gross Profit	CTRL + G
Open Document Base	CTRL + N
Opening Target Documents	CTRL + T
Go to the Customer Code Field	CTRL + U
Go to Field Remarks	CTRL + R
Open the Batch / Serial Number Form	CTRL + Tab In the Quantity column
Showing the Last Price	CTRL + Tab In the Price column
Display the Alternate Item	CTRL + Tab In the Item column
Showing the amount of stock in the warehouse	CTRL + Tab In the Warehouse column
Open the Settings Form	CTRL + SHIFT + S

Error Message SAP Business One

Error Message SAP Business One

Note: If the error message you are experiencing is not here, please send the error to the comment provided


When we want to do Data Input or when opening SAP Business One we often find errors. Therefore I will help you to provide a solution if you meet Error Message as follows.

Global

Event: When logging in
Error: You Cannot open Window [683] Message with your current license
Problem: Because you do not have licenses to use SAP
Solution: Buy a license, then install the license (ask your partner to install the license)
If you already have a license, the next step is to ask your boss who has a Superuser ID to check the Module Administration - License - License administration

Click Button Update, and congratulations on using SAP.

All Transaction

Event: When Transaction Add
Error: No Matching records found G / L Accounts
Problem: There is an account that has not been set
Solution: Please setup the account on the Item Group / Warehouse / Master Data Items depending on the G / L account setup by https://sapbusinessonesap.blogspot.com/

Incoming Payment


Event: When You Want to Open the Incoming Payment Form
Error: Primary sales account linking has not been completed
Problem: There is an account that has not been setup in GL Account determination
Solution: Account Setup in Administration - Setup - Financial - GL Account Determination Field (Domestic Account Receivable, Foreign Accounts Receivable, Revenue Account)

List of Visual Basic General Error Traps

Trap errors can occur when your application is running. Some pitfalls of errors can also occur during development or when compiling an application that you create. You can test and respond to errors that occur using the "On Error" statement and the Err object. Error numbers in the range of 1 to 1000 have been provided for use in Visual Basic in later periods.

The list of error traps below is a common error trap in Visual Basic coupled with general errors related to a certain general object, while for some other objects, such as ADO, or Datagrid, or others, have their own list of error traps, separate from the list of error traps below.

Code Message / Description

3 Return without GoSub
5 Invalid procedure call
6 Overflow
7 Out of memory
9 Subscript out of range
10 This array is fixed or temporarily locked
11 Division by zero
13 Type mismatch
14 Out of string space
16 Expression too complex
17 can 't perform requested operation
18 User interrupt occurred
20 Resume without error
28 Out of stack space
35 Sub, Function, or Property not defined
47 Too many DLL application clients
48 Error in loading DLL
49 Bad DLL calling convention
51 Internal Error
52 Bad file name or number
53 file Not found
54 Bad file mode
55 File already open
57 Device I/O error
58 File already exists
59 Bad record length
61 Disk full
62 Input past end of file
63 Bad record number
67 Too many files
68 Device unavailable
70 Permission denied
71 Disk Not Ready
74 can 't rename with different drive
75 Path/File access error
76 Path Not found
91 Object variable or With block variable not set
92 For loop not initialized
93 Invalid pattern string
94 Invalid use of Null
97 can 't call Friend procedure on an object that is not an instance of the defining class
98 A property or method call cannot include a reference to a private object, either as an argument or as a return value
260 No timer available
282 No foreign application responded to a DDE initiate
285 Foreign application won't perform DDE method or operation
286 Timeout while waiting for DDE response
287 User pressed Escape key during DDE operation
288 Destination is busy
290 Data in wrong format
293 DDE Method invoked with no channel open
294 Invalid DDE Link format
295 Message queue filled; DDE message lost
296 PasteLink already performed on this control
297 can 't set LinkMode; invalid LinkTopic
298 System DLL 'dll' could not be loaded
320 can 't use character device names in file names: 'item'
321 Invalid file format
322 Can’t create necessary temporary file
325 Invalid format in resource file
326 Resource with identifier 'item' not found
327 Data value named not found
328 Illegal parameter; can't write arrays
335 Could not access system registry
336 Component not correctly registered
337 component Not found
338 Component did not run correctly
339 object server 'item' not correctly registered
or not found (Error 339)
340 Control array element 'item' doesn't exist
341 Invalid control array index
342 Not enough room to allocate control array 'item'
343 Object not an array
344 Must specify index for object array
345 Reached limit: cannot create any more controls on this form
360 Object already loaded
361 can 't load or unload this object
362 can 't unload controls created at design time
363 ActiveX Control 'item' not found
364 Object was unloaded
365 Unable to unload within this context
366 No MDI form available to load
367 can 't load (or register) ActiveX control: 'item'
368 the file 'item' is out of date. This program requires a newer version
369 Operation not valid in a DLL
370 The ActiveX Designer's Type Information does not match what was saved. Unable to Load
371 The specified object can't be used as an owner form for Show()
378 'item' cannot be set while loading
379 You can 't put a Default or Cancel button on a Property Page
380 Invalid property value
381 Invalid property array index
382 'Item' property cannot be set at run time
383 'Item' property is read-only
384 A form can't be moved or sized while minimized or maximized
385 Must specify index when using property array
387 'Item' property can't be set on this control
388 can 't set Visible property from a parent menu
389 invalid Key
393 'Item' property cannot be read at run time
394 'Item' property is write-only
395 Cannot use separator bar as menu name for this control
396 'Item' property cannot be set within a page
397 can 't load, unload, or set Visible property for top level menus while they are merged
398 client Not Site
399 You can 't put a Default or Cancel button on a User Control unless its DefaultCancel property is set
400 Form already displayed; can't show modally
401 can 't show non-modal form when modal form is displayed
402 Must close or hide topmost modal form first
403 MDI forms cannot be shown modally
404 MDI child forms cannot be shown modally
405 Unable to show modal form within this context
406 Non-modal forms cannot be displayed in this host application from an ActiveX DLL
419 Permission to use object denied
422 Property not found
423 Property or method not found
424 object required
425 Invalid object use
426 Only one MDI Form allowed
427 Invalid object type; Menu control required
428 Popup menu must have at least one submenu
429 License information for this component not found. You do not have an appropriate license to use this functionality in the design environment
430 Class doesn 't support Automation
432 File name or class name not found during Automation operation
438 object doesn 't support this property or method
440 Automation Error
442 Connection to type library or object library for remote process has been lost
443 Automation object doesn't have a default value
444 Method not applicable in this context
445 object doesn 't support this action
446 object doesn 't support named arguments
447 object doesn 't support current locale setting
448 Named Not argument
449 Argument not optional or invalid property assignment
450 Wrong number of arguments or invalid property assignment
451 Object not a collection
452 invalid ordinal
453 Specified Not found
454 Code Not Resource
455 Code resource lock error
457 This key is already associated with an element of this collection
458 Variable uses a type not supported in Visual Basic
459 This component doesn't support the set of events
460 Invalid Clipboard format
461 Method or data member not found
462 The remote server machine does not exist or is unavailable
463 Class not registered on local machine
480 can 't create AutoRedraw image
481 invalid Picture
482 Printer Error
483 Printer driver does not support specified property
484 Problem getting printer information from the system. Make sure the printer is set up correctly
485 Invalid picture type
486 can 't print form image to this type of printer
490 Top-level or invalid menu specified as PopupMenu default
520 can 't empty Clipboard
521 can 't open Clipboard
523 The data binding DLL, 'item', could not be loaded
524 'item'
525 Data Access Error
527 The given bookmark was invalid
536 Could not lock the database
537 Could not access the desired Column
541 Could not lock the database
542 The row has been deleted since the update was started
545 Unable to bind to field: 'item'
672 DataObject formats list may not be cleared or expanded outside of the OLEStartDrag event
673 Expected at least one argument
674 Illegal recursive invocation of OLE drag and drop
675 Non-intrinsic OLE drag and drop formats used with SetData require Byte array data. GetData may return more bytes than were given to SetData
676 Requested data was not supplied to the DataObject during the OLESetData event
688 Failure in AsyncRead
689 PropertyName parameter conflicts with the PropertyName of an AsyncRead in progress
690 can 't find or load the required file urlmon.dll
693 An unknown protocol was specified in Target parameter
735 can 't save file to TEMP directory
744 Search Not text
746 Replacements too long
31001 Out of memory
31004 no object
31018 Class is not set
31027 Unable to activate object
31032 Unable to create embedded object
31036 Error saving to file
31037 Error loading from file

Daftar Perangkap Error CommonDialog
Berikut daftar perangkap error untuk object CommonDialog

Code Message / Description

20476 The FileName buffer is too small to store the selected file name(s)
20477 invalid filename
20478 An attempt to subclass a ListBox failed due to insufficient memory
24574 No fonts exist
28660 The [devices] section of the file WIN.INI did not contain an entry for the requested printer
28661 The PrintDlg function failed when it attempted to create an Information context
28662 The data in the DEVMODE and DEVNAMES data structures describes two different printers
28663 A default printer does not exist
28664 No printer device drivers were found
28665 The PrintDlg function failed during initialization
28666 The printer device driver failed to initialize a DEVMODE data structure
28667 The PrintDlg function failed to load the specified printer's Device driver
28668 The PD_RETURNDEFAULT flag was set in the Flags member of the PRINTDLG data structure but either the hDevMode or hDevNames field were nonzero
28669 The common dialog function failed to parse the strings in the [devices] section of the file WIN.INI
28670 Load of required resources failed
28671 The PD_RETURNDEFAULT flag was set in the Flags member of the PRINTDLG data structure, but either the hDevMode or hDevNames field were nonzero
31001 Out of memory
32751 Help call fail. Check Help properties.
32752 Low on memory! Can't bring up the dialog!
32753 couldn 't determine procedure address(es). \nSelect a different DLL.
32754 DLL selected couldn't be loaded
32755 Cancel was selected
32756 The ENABLEHOOK flag was set in the Flags member of a common dialog data structure but the application failed to provide a pointer to a corresponding hook function
32757 The common dialog function was unable to lock the memory associated with a handle
32758 The common dialog function was unable to allocate memory for internal data structures
32759 The common dialog function failed to lock a specified resource
32760 The common dialog function failed to load a specified resource
32761 The common dialog function failed to find a specified resource
32762 The common dialog function failed to load a specified string
32763 The ENABLETEMPLATE flag was set in the Flags member of a common dialog data structure but the application failed to provide a corresponding instance handle
32764 The ENABLETEMPLATE flag was set in the Flags member of a common dialog data structure but the application failed to provide a corresponding template
32765 The common dialog function failed during initialization
32766 The lStructSize member of the corresponding common dialog Data structure Is invalid

Make a Query in SAP business One

Cara membuat Query Di SAP business One

Cara Membuat Query di Query Generator SAP Business One

1. Understand how to create and conceptualize database structures, if you don't understand this, maybe this link http://www.w3schools.com/sql/default.asp can help you, or other links

2. Knowing the Table Name and Field in SAP

• Display System Information in advance (View - System information Or Shortcut CTRL + SHIFT + I)

• Open one of the documents that you will display in the query, for example I want to create a query to display the Sales Order

• Place the Cursor Position on the Field that will be displayed, then information about the Field and the name of the table will be displayed as shown below. Position is below the left

• After you know the Table Name and Field, the next step is to create the query. How to Tools - Query - Query Generator

• Then Forms Like This Will Be Displayed

• You Simply Fill in a Table Name In a field like the picture above Ex (OITM) then Tab, then a list will appear showing all the fields in the table

• Double Click the Field that will be displayed in the Query

Column Select - displays all fields that will be displayed in the Query
Column From - Table Name
Column Where - To fill in the Parameters / do Filters, you can click the Condition button below. see the next step
Sort By Field - Data displayed will be sorted by the Field selected
Group By - column If the data you want to display will be grouped.

Then click Execute, then the Form parameter that is registered will be displayed

Then select the item to be filtered and click the OK button and please enjoy the query that you created.

How to display the Save Query 
1.Select Tools - Queries - User Queries or on the toolbar click the image as below

will display the entire list of queries that have been saved

How to Edit a Save Query
1. Open the Query to edit, click the Pencil image

2. Edit the Query in the field as drawn.

3. Click Execute Button to see the results of query changes
4. Click Save Button to save the edited query