1 2 3 11 Previous Next

SAP Business One Application

155 Posts

Following is the method required to add dynamic images to Crystal Reports.


The example adds the image from the item master.


NB: You will need to have the OADP table and the OITM table in your report, or have the relevant fields in your command.

The image path is stored in OADP - OADP.BitmapPath


IF ISNULL({OITM.PicturName}) THEN ‘’ ELSE {OADP.BitmapPath}&{OITM.PicturName}



First add a picture to your details section where your item code is using the insert picture icon:

CR Tool Bar.png


This open a browse box, just choose any image, as it will be replaced in the next step


Right click on the image you have created & choose “Format Graphic”:

CR Editor.png


From the Editor, choose the Picture tab, then select the formula button beside Graphic Location .CR Formula.png


Create a formula that starts with the bitmap path: {OADP.BitmapPath}, then adds the image name for the item code { oitm.PicturName}


You may also need to deal with NULL values in the graphic location path - e.g. IF ISNULL({OITM.PicturName}) THEN ‘’ ELSE {OADP.BitmapPath}&{OITM.PicturName}


You may need to do some image resizing, and put the can grow on to get the image to fit a space.

The image should now display dynamically.

Dear all,


As a SAP customer or partner, the Idea Place is your channel for submitting ideas to improve SAP Business One. We recommend the idea place very frequently, also out of support incidents as shown in SAP note 1028874.


NOTICE: The Idea Place for SAP Business One will be transitioning from a public website to a private website on September 15th, 2016.

Access will be restricted to customer and partners with SAP S-user IDs. To confirm whether you are logging on with an S-user ID (SXXXXXX), please logon to https://accounts.sap.com and ensure your ‘User ID’ begins with an ‘S’. Customers without an S-user ID can request one from their partner. Partners can request one via here http://service.sap.com/request-user.
Note: Public accounts from general email providers such as gmail.com will no longer have access to the site.


Please continue to take advantage of the opportunity to participate in the development of the future SAP Business One releases by exposing your ideas and voting on the already proposed ones. The Idea Place facilitates the process of creating and also handling the ideas you exposed.


Thank you for helping us to further optimize and enhance SAP Business One!

Best regards, Peter


Here I am putting one project management configuration which is been created for client for demo purpose.Hope it will be helpful.


The basic Screen of Project management:


Following things to be noted from image displayed:

  1. 1) Customer for which project to be carried out will be entered in the field which will be picked from master data
  2. 2) Project name needs to be entered in Project Name field
  3. 3) Due date need to be put in due date field
  4. 4) Stages for project will be defined
  5. 5) Task related to the particular stage will be entered and description for particular task can also be incorporated.
  6. 6) Start date and end date for particular stage and task will be defined
  7. 7) Planned Cost for particular stage and task will be defined in planned cost column
  8. 8) Owner for particular stage and task can also be defined, data will get picked up from employee data
  9. 9) Stage dependencies for particular stage will get defined in here e.g. Analysis is first stage and design will be second stage so before completion of analysis design cannot be done, so design is dependent on analysis that is stage 1 as shown in the screenshot.


Summary- Project summary will appear as below:




          I) Attachments: Documents regarding to particular stage can be linked to the attachment tab as shown in the screen below:


For example,

If designing stage we have preliminary drawing as one task, we can define several tasks under designing stage like drawing revisions and all . One can attach the particular drawings by assigning the document path shown in the window.


     II) Document Linking: Document related to particular stage will be linked through SAP itself. Here is the screenshot enclosed below:   

     One can select the document type through the drop down list and documents related to the particular project will appear in the same window.



To open the document one need to click on the golden arrow preceding the document number, so the related document will get displayed in there.

Screenshot for the same is as enclosed below:





             III) Activities: Activities for particular project can be linked through Activities window. Here is the screenshot enclosed below:




    If there is an Activity related to kick of meeting, we can link the activity through activity window. If we will click on the golden arrow, Activity window will get     displayed



     IV) Issues: Issues regarding to project and regarding to particular stage will also get captured in Project management. If there is issue while installation.              Here is the screenshot enclosed below:


If One will click on the golden arrow solution knowledge base screen will get displayed as shown below, Solution knowledge base will be stored  in the system as a standard database for issue resolution.




SAP Business One Sales lets you effectively handle your sales activities anywhere, anytime. The app connects to the SAP Business One application, giving sales people access to the most relevant business information and processes, for efficient and successful management of customers and sales.

The SAP Business One Sales is available on iOS since March 2016 and now also on Android mobile operating system.

Key features of SAP Business One Sales:

  • Cover the entire sales pipeline, handling of all sales-related documents, including sales opportunities, quotations, and orders
  • Manage customers and leads using analytical information and intelligent outlooks, including a churn probability
  • Arrange daily activities and record all check-ins
  • Monitor sales performance using predefined KPIs
  • Check inventory levels and get product details


  • SAP Business One 9.2, version for SAP HANA PL3 or higher
  • Android 5.0 or higher
  • Service Layer, SAP Business One Analytics, and App Framework
  • Supported license types: Professional, Limited CRM, Starter Package, and Mobile Sales users (new)

Note: Use of SAP Business One Sales with your business data requires SAP Business One 9.2, version for SAP HANA as your back-end system. You can try out the app first using a demo logon. Software Download and Supporting Materials:

SAP Business One Material Requirements Planning (MRP) manages MRP through a wizard-based process. This process enables users to define a planning scenario in five easy steps and predict demand based on forecasts.


Material Requirement Planning (MRP) in SAP Business One Enterprise Resource Planning (ERP) and business management application creates recommendation for purchase orders and production orders based on the current status of transactions in the system.

Essentially, Material Requirement Planning (MRP) works like an expert system, which determines how much should be purchased for a purchase item and produced for a manufactured item at a particular point in time. This allows you to automatically create production orders and purchase order based on the Order Recommendation Report. If need be items can be easily outsourced by converting a production order to a purchase order. In addition, it’s simple to consolidate individual vendor PO’s into a single order to further streamline the purchasing process.

The application does not place orders automatically, but instead suggests them. These orders can then be improved after inspection by purchasing professionals or production managers who may have special knowledge that goes beyond what can be captured in an MRP application. For small and midsize businesses, this architecture provides just the right balance between automation and hands-on control.

SAP Business One MRP Features

  • MRP Wizard – helps you plan and optimize future material requirements and then both manage and execute purchasing and manufacturing recommendations and exceptions
  • Recommendations – To make the appropriate recommendations, SAP Business One considers various supply and demand sources, including existing stock levels, planned production orders, open purchase orders, actual sales orders, forecasted orders, master data like BOMs, and planning data like lead times and minimum stock levels
  • MRP results – exceptionally clear MRP results, recommendations, and exceptions screens allow you to sort, filter, and drill down through MRP pegging information to actual  receipts and requirements (forecasts or sales orders) and edit, individual purchase order line quantities
  • Modelling – MRP can be run at any time and used for modelling and ‘what if’ purposes

SAP Business One MRP Benefits

  • Reduce errors – SAP Business One MRP replaces informal, ad hoc, error-prone production scheduling based on the instincts of one or two people with a more structured process that allows more people to participate using better information
  • Reduce direct costs – SAP Business One MRP helps reduce costs by considering both minimum order quantities and order multiples and helping users take advantage of purchase pricing quantity breaks or standard production batch sizes
  • Focus on strategic management – procurement managers can focus on strategic procurement, rather than worrying about inventory accuracy
  • Reduce stock levels – Reduce safety stock or multiple PO’s for the same item by different warehouse or purchasing managers. Move towards just-in-time stocking




This blog aims to explain cases when bank software may reject the XML file generated from SAP Business One for SEPA based on the existence of BOM, but can be extended to any other electronic format based on EFM (Electronic File Manager)


The system format for banking SEPA, generate XML files that includes BOM (the processing instruction related to encoding)

In XML files, the encoding is declared at the beginning in root processing instruction, but never the less in standard Microsoft files, this is as well included as a hidden character.


The software that may receive the bank, may not accept that hidden character (you will not see it unless you have  text processor that shows the hidden code)


With the Add-on EFM you can change the encoding to eliminate the BOM




This example is based on the standard SEPA for Credit Transfer 'CT' from SAP note 1963295


View of the file before change encoding, note in target the property 'encoding' with value UTF-8 , this will generate file including BOM



You can change it in the drop down list to the encoding 'UTF -8 Without BOM' , this will generate the file without the BOM


Then you can save it and upload it in your customer database.

Hi all,


Now you can look up User Guides and additional information for the sales apps in the SAP Help Portal:



On YouTube there's also the SAP Business One Sales - Feature clip.


Best, Peter

Reviewing the SAP Business One 9.2 PL 02 documentation found a new feature, which by the way is very interesting for reference between documents.


To illustrate the functionality will describe a possible scenario, it is possible that in some countries does not make sense, but anyway ...


Your company makes a sale, the seller undertakes to deliver the product without shipping costs to the customer, then hire a company to make the delivery. In this case elaborates the sales order to process the sale to the customer and in parallel creates a purchase order for the procurement of delivery.


How would you do to make this connection? Create user fields to signal the link? Describe this in the comments of the documents?


From now will not be necessary to find an alternative functionality to this, because through this note a new feature was created:

2273995 - Offline Document Linking




Step 1 - Create the sales order




Step 2 - Create the purchase order for the freight


When creating a purchase order, after entering the item and content data, the user clicks the "Accounting tab"



In accounting tab, click on the "Referenced document" in the form presented enter the sales order data, saves the information in all forms.



By accessing the relations map, a new option is available for selection "Marketing Document: Referenced Documents".


Using this option you can view the link by a dashed line in red, at one end there is an arrow indicating where the reference was made, on the opposite side of the arrow you can see the referenced document.



Some important information is:


Even PL03 in locating United States, you can perform the reference both in the creation of the document as to update a document.

In Brazil location, it is not possible to make reference when updating the document, only to create and the information is used in another "Taxes" tab.


Referenced Document consists of two tabs:

- Documents Referenced To – to specify documents to be referenced by the document

- Document Referenced By – to see which other documents are referencing the document


The following list of the documents that can be referenced includes External Document which does not represent a business object created by SAP Business One: Sales Quotation, Sales Order, Delivery Notes, Return, Down Payment Incoming, A/R Invoice, A/R Credit Memo, A/R Correction Invoice, Purchase Quotation, Purchase Order, Goods Receipt PO, Goods Return, Down Payment Outgoing, A/P Invoice, A/P Credit Memo, A/P Correction Invoice,

External Documents.


There is no restriction on the document type or Business Partner when documents are being selected for reference, however authorizations for the documents are taken into the consideration.


"Copy to" functionality does not copy the links as they are specific for each document.




I hope you enjoyed the information.


Give your feedbak.


Note: My native language is Portuguese, so there may be something written incorrectly, if so sorry.



Rodrigo da Costa Feula

Jamie Bates

Data Transfer Workbench

Posted by Jamie Bates Jun 28, 2016

Data Transfer Workbench

The DTW supports the automatic transfer of data into the system, designed specifically for the initial transfers. The Functions of the DTW compile of:

  • Administration & Organisation of Data Transfer Projects.
  • Tools for analysing required SAP structures.
  • Integration of standard data transfer programs.
  • Registration & Integration of your own data transfer/help programs.
  • Various techniques for loading data.
  • BAPI Interface/
  • Batch Input
  • Data Input (DINP)
    • Data conversion using the Legacy System Migration Workbench (LSMW).

Essentially, this is the ‘pipeline’ for the system – the route between the data and the database systems.


Data Source

A data source for the Data Transfer Workbench will be, most commonly, a Microsoft Excel Document containing two rows at the top of the sheet, a Source row and a Target Row, with data beneath. To save this as a relevant document, when saving you must change the file type to .CSV (Comma Delimited) in order to use that file to import via the Data Transfer Workbench.


Importing to SAP

1.     Open the “Data Transfer Workbench” and log into the Company you are aiming to import data into.


2.     Select “Import” once connected and choose the data type in relation to the information you’re attempting to import via the DTW, selecting “Next” upon completion.


3.     Specify the type of Operation and select “Next”, choosing the Business Object you want to import and proceeding.


4.     Choose the Data Source, this must be a CSV (Comma Delimited) file and continue. On the “Map Object Fields” page, ensure the information provided, including mapping rules, source data and target data, is all correct.


5.        Follow the process until the end and click “Import” for the process to commence. Upon completion, you’ll be notified of any errors or if the data was successfully transferred.


6.     Open SAP Business One and locate the data once successfully


Dear All,


I have Installed HANA ED1.0_Ver.10 in Linux system with SAP B1 9.2 PL0  and i have done initialization of companies databases successfully under analytic services.


But while login with SAP Client to access the Interactive analysis report designer under Tools(Menu) getting the error...Contact your system administrator!


Please do let me know if i need to do any setups or prerequisites to access with the report designer.


Thank you in advance.


look forward to your reply




Now it is released !!!


We of the community who are users of SAP Business One we were waiting for this date !!!


On 15/06/2016 the 9.2 version of SAP Business One received the status of "Released for unrestricted use" with this all companies are prepared and interest can update your settings for this new version.


Since its launch in 12/15/2015 in the old program of "Ramp-up" now called "Early Adopter Care Program", the new version of the pointed to good news, as the "Project Management" and "Browser Access" eliminating the need for installation of clients in addition to several other features.


Information on the release is published in PAM - Product Availability Matrix, an affordable platform via S-USER which contains the information about the products: https://apps.support.sap.com/sap/support/pam the date release, status, date to support, links to downloads, software technical support information for the release, among others. Go and see !!!






A very important detail is that with the release of a new "Minor Release" the previous version no longer have updates, what does that mean?

With the release of 9.2 will not be released new PLs to 9.1, this is evidenced by the print below, which shows that 9.1 out maintenance on 06.30.2016 (this month !!!).


In summary, if you are using an earlier version to 9.2 and find a "Bug" the fix will only PL to 9.2 (exceptions may exist depending on the severity, but would not be the default).






Rodrigo da Costa Feula

Have you ever:

  • Had trouble installing an add-on?
  • Maybe had more trouble on a 64-bit client?
  • Needed administrator rights on every computer for the installation?
  • Pulled your hair out over the old add-on installation process?
  • Had to make sure an add-on, such as Intercompany, works smoothly on 150+ computers?


SAP Business One's new installation mechanism (since 9.1) can help you!


Here's how to solve the crisis quickly and effeciently:

  • Complete the installation of the add-on in both 32 and 64 bits on any client computer, making sure it runs correctly in both modes.
  • Use the Extension Packager from the SAP B1 SDK installation to create a package with both executable files. Here are the relevant screenshots for the Intercompany Add-on:






  • After you package the add-on as an extension, I suggest you remove the old add-on installation from SAP Business One (Add-On Administration window), ideally even eliminating it from the registration (SBOCOMMON).


  • Then use the "Manage Extensions for Lightweight Deployment" link to upload and assign the extension to the required company databases.


  • In the end, the add-on (now called extension) should be smoothly installed by the SAP Business One Client Agent on each machine upon logon. The only reason I have encountered so far that could cause this process to fail, is that the file is actually in use during installation. For that reason I have changed the name from "Intercompany" to "IntercompanyLW" so that it actually installs to a different path on each client computer.



Let me know if you find this useful! For my part I would have wished SAP delivered that install method out of the box, since the latest version of Intercompany is compatible only with Business One 9.1+ anyhow.



In the past six months, my friend based on the current cloud environment to prepare document, configure the company, etc...


But the B1 cloud administrator guide is not detail, not enough, not clear.


Also the SAP support is not enough.


My friend is facing the following problems

1.The mobile apps still not configure successfully. He ask few question, SAP support reply or ask 1 question, progress is slow.

2.The certificate will be expired but no software can update the certificate. He need reinstall whole environment when the certificate expired.

3. Extension is not work, no source, no idea. If have the sample source to connect the SQL server or any connection, that can improve his progress.

4. On premise add-on (XL reporter) cannot run or support on cloud. The reply is, use sap hana which has analysis tools or use crystal report but have limitation.


Anyone who have any problems or solutions, would you mind to share to improve the setup, configuration,implementation?




Hi experts,


one of my customers is using continuous stock with moving average method at warehouse level.

the stock open balances were registered in january with many errors in quantities and values.

Now they want to correct those values.

we try to use revaluation function, but it seems not useful due it consider always the current stock.


if we use good receipts, we can increas quantities and value but we change the item cost too.

if we use good issues, we can reduce quantities but the value depends on the current cost.


can you help me?


In this video, Aether Consulting Senior Implementation Consultant Ellen Maier shows us the capability of SAP Business One for companies that need to break out their financials by company/division/branch and just as easily view them at a consolidated level in a single database.  Ellen provides implementation tips by diving into the application to show segmented chart of accounts, cost centers, and branches in SAP Business One 9.1.


Link to video:  https://youtu.be/Og731bL4qAA


You can also run multiple companies in SAP Business One, which would have a separate database for each company.  Then you would use other methods to consolidate the companies into a single financial statement.  But this presentation focuses only on financial setup options when using a single database.


Business Scenario

- For companies that purchased SAP Business One but have not implemented yet
- The business has multiple companies/divisions/branches that you need to manage financially in the software and want to do so in one database
- The business wants to produce consolidated financial statements
- The business wants to drill into the detail of revenues and expenses by branch, division, and department


Segmented Chart of Accounts

- Determine account segments based on business processes and financial reporting needs

- Use the 4 default account segments, or define up to 10

- Segments can represent divisions, departments, regions, lines of business, entities, branches etc.

- Once created, you cannot change the length or type of a segment later on


Cost Centers

-  Prevalent financial method used in Europe

-  Reduces the number of general ledger accounts that need to be maintained

-  Use dimensions to group cost centers together

-  Use distribution rules to allocate direct and indirect costs and revenues to cost centers



-  Create sales and purchasing transaction for a dedicated branch

-  Reporting by branch, e.g. profit and loss statement per branch

-  Warehouse management per branch

-  Restrict usage of business partners by branch

-  All financial transactions will be separated by branches



SAP Business One brings incredible power and flexibility to companies that need to easily break out their financials by company/division/branch, etc., and just as easily view them at a consolidated level. About Aether Consulting:  Aether is an SAP Business One value-added reseller in Goodrich, Michigan.  We sell, install, implement, train and support our customers on SAP Business One.


Filter Blog

By author:
By date:
By tag: