1 2 3 18 Previous Next

SAP Business One Application

265 Posts

I'm writing this blog out of desperation and to inform any other SAPB1 customers thinking of moving to v9.1 of a known Bug with a VERY serious impact on the use of the software.


We are running v9.1 PL09 (32Bit) on SQL and ever since we moved from 9.0 we have had problems. Major issues involving client machines crashing the B1 application and the user having to restart their machine to get back in. For some users this happens several times per day and has been happening since we upgraded at the end of 2015. More recently we have staff on the sales team unable to respond to inquiries as their systems crashed several hours ago and they have still not re gained access, obviously this is going to be costing us money in lost opportunities!


So what's happening? We have reported the crashes to our VAR who, after a lot of time and effort explained it was due to a known bug with SAP Note: 2079526 and also more recently SAP Note: 2247727 which is all to do with the SAP Business One Suggest. This function is a bit like predictive text and we, like many users, have become reliant on it when adding marketing docs to sap or posting transactions etc. This function was working in v9.0 so why oh why is it causing so many issues in 9.1?


I've been in contact with some senior people at SAP who said the issue is with the "Critical Solution Desk which is the point of highest visibility for any issues.  Please rest assured that the issue is being investigated thoroughly." The problem for me is I have a team of people getting very angry as they can't do their jobs properly and I'm potentially losing business as we're not able to respond to request for quotations quickly due to SAP crashes.



We pay a lot of maintenance to SAP, I thought it was to fund future functionality and develop better and more productive software however it seems v9.1 is actually a downgrade of v9.0!


We are in the process of sending Dump Files form client machines to SAP each time this occurs but, as I'm sure any small business will tell you, this is time consuming not always possible.


So, SAP have been working very hard getting 9.2 into Ramp Up, personally I wished I had waited for this as 9.1 has been a disaster for my business and I've lost a lot of faith in SAP and their ability to deliver  market leading software.

Hi all,


We have just changed the approach to provide you with current information about planned and delivered patches in SAP Business One area.

Occasion was a significant simplification by merging all relevant information at a central location and to ensure that information is really up to date. We also wanted to simplify the access for customers and partners, allowing a uniform and direct access.


The former “SAP Business One Patch Delivery Schedule” and “List of Delivered Patches” have been merged into SAP note 2267770 - Patch Delivery Schedule for components related to SAP Business One.


When delivering or changing planned dates for components related to SAP Business One we will update the relevant information (delivered/planned) in that note.

In case of updates, the editing process may result in a brief unavailability of the SAP note. In such cases, please try again after a few minutes.


You have the following options to be actively informed on planning changes or deliveries:

  1. Subscribe to SAP note 2267770. In general, you can subscribe to any SAP note and be notified automatically when the SAP Note has been updated. Please see SAP note 2268826 - How to subscribe to an SAP Note and receive notification for updates or watch this video on YouTube for details.
  2. Receive information on delivered patches via E-Mail and RSS push. You can subscribe to that service via this Email Subscription Request (Thanks to Darius!)


Best regards,




I am Gabriela La Torre and I am a consultant at DreamTech S.A., a SAP Business One silver partner located in Panama.



Today, I would like to share with you my experience with the upgrade of one of our customer to SAP Business One 9.2.



Overall, it really worked well. Actually it worked that well that we could get the first customer live already January the 4th, just 2 weeks after the Early Adopter Care program started for the new release.



Some information about the customer


The customer upgraded to SAP Business One 9.2 is a company located in Panama City, with several branches throughout the whole country of Panama (e.g. in Penenome, Aguadulce, Santiago, David, and other locations). The customer sells their products as a Wholesaler to supermarkets and similar businesses. They also sell directly to end customers as they have their own stores.



What drove the customer to initiate the upgrade?


It was because of the browser access. The customer has several branches throughout the country of Panama and with release 9.2 all branches can securely connect with SAP Business One directly via Browser Access – thus without need of other products as e.g. Remote Desktop or Citrix and without need to install and upgrade client software.

Other new features in SAP Business One 9.2 – important to the customer - were: Approval Procedure, Job Service, Fixed Assets Enhancements, Price Lists, and Production Enhancements.



Some information about the upgrade process to SAP Business One 9.2


The customer was upgraded from SAP Business One 9.1 to release 9.2 and they are working productively on the latest since January 4th, 2016. The upgrade process was smooth and could be completed in a couple of hours. An extensive training for the end users was not necessary.



Gabriela La Torre

Consultant, Dream Tech, S.A

CMR SAP query.PNGBeing a part of a multinational company sometimes it is hard to keep track of returns. I had written a query that take a list of return numbers and generates results of items not in the system.

declare @myString varchar(100)='123,RTV0267111,RTV0269188,RTV0284929,RTV0284782'  
cte AS
( SELECT CAST(N'' +Replace(@myString,',','') + '' as XML) AS vals )
SELECT s.a.value('.', 'NVARCHAR(50)') as num
FROM cte CROSS APPLY vals.nodes('/H/r') S(a) 
select DISTINCT NumAtCard from ORIN
WHERE FatherCard = 'GTHead' AND DocType = 'I' AND CANCELED = 'N'  ORDER BY NUM;

Managing items by serial or batch numbers? SAP Business One can calculate for you the actual cost of each serial or batch number. This can help you determine the profitability of each and every batch or serial number.

You can apply the serial/batch valuation method either to the entire company, by selecting the option “Serial/Batch Valuation Method” in Company Details > System Initialization. Alternatively, you can apply it to selected items by choosing the option “Serial/Batch” in Item Master Data:


To view the cost details of given serial number or batch, generate the Batches and Serials Inventory Audit Report (Inventory > Inventory Reports):


The serial/batch valuation method is only applicable to companies where perpetual inventory is managed.

Available since SAP Business One 9.1, version for SAP HANA PL04 and SAP Business One 9.1 PL04.


We recommend our SAP Business One customers to create your 2016 posting periods now if your fiscal year is the same as the calendar year (and it has not already been done).

Bear in mind the following important caveats:

  • The beginning of the fiscal year can only be the first day of the month
  • Once created and transactions are posted, a posting period cannot be removed.  The date ranges can change, but it can't be removed.


Here is an example of setting up the 2016 posting periods based on the calendar year:  Go to Administration > System Initialization > Posting Periods.  Review your posting periods to see if 2016 has been created.


If you do not have any 2016 period codes, click on the New Period button.  The dates, start of the fiscal year, and fiscal year will all fill in automatically as shown below.


Enter the information that is shown below.  When it is correct, click on Add.


Review your posting periods.  You should now see 2016 in your list:


Aether Consulting is a SAP Business One value added reseller, providing new sales, implementation, re-implementation and support services to customers.  Contact us at sales@aetherconsulting.com.

Hi all,

On December 16th 2015, along with release of SAP Business One 9.2, we published a revised product road map for SAP Business One.

See what’s ahead – including functions to meet new business needs, technologies, and expanded coverage:

Be aware that the SAP Road Map for SAP Business One presentation is NOT public, its content must not be published.
Please note the legal disclaimers.

I will keep this blog up-to-date with relevant info on the product road map for SAP Business One.

Best regards,
Peter, SAP Business One Solution Management

Anil Lokam

Restore All Users Licenses

Posted by Anil Lokam Dec 17, 2015

Hi All,


I going to explain about how to restore users licenses.

This is my experience in client place.




Some times we will lost some user licenses, means it will show us different number of licenses in available and in assignment tab it will show us different numbers. this will mostly happens when the client having 2 or more databases in one server.



If we delete any user mistakenly ,but that user having license in another database.




  1. Logout all clients.
  2. C:\Program Files (x86)\SAP\SAP Business One ServerTools\License
  3. In the above folder we will find "B1Upf.xml"  remove this file from that folder and save it in another place.(this is the file created by SAP when you are allocating the user licenses.)
  4. stop and start license manager
  5. open you sap business one with manager or super user credentials.
  6. you can see all your licenses. just allocate to the users.

If you have any doubts , please feel free to ask in this blog

Thank you,



Dear All,


I have learnt so many things from this SAP SCN blogs, documents and also from the experts who are supporting SAP Business one Consultants,


Thanks for


Mr. Kennedy T

Mr.  Andakonda Ramudu




I have written some transaction notifications, hope this will help you .





------Cannot Add Good Receipt PO without Purchase Order (FOR only item type)-----------



IF @object_type = '20'

         AND @transaction_type IN ('A', 'U')


          IF EXISTS(

                 SELECT t1.docentry

                 FROM   opdn t1

                        INNER JOIN pdn1 t2

                             ON  t1.docentry = t2.docentry

                 WHERE  @list_of_cols_val_tab_del = t1.docentry

                        AND t2.BaseType<>'22' AND t1.DocType='I'



              SET @error = -1


              SET @error_message = 'You Cannot Add Good Receipt PO without Purchase Order'






------Cannot Add Good Return without Goods Receipt PO (FOR only item type)-----------




IF @object_type = '21'

         AND @transaction_type IN ('A', 'U')


          IF EXISTS(

                 SELECT t1.docentry

                 FROM   orpd t1

                        INNER JOIN rpd1 t2

                             ON  t1.docentry = t2.docentry

                 WHERE  @list_of_cols_val_tab_del = t1.docentry

                        AND t2.BaseType<>'20' AND t1.DocType='I'



              SET @error = -1


              SET @error_message = 'You Cannot Add Good Return without Goods Receipt PO'









   IF @object_type = '18'

         AND @transaction_type IN ('A', 'U')


          IF EXISTS(

                 SELECT t1.docentry

                 FROM   opch t1

                        INNER JOIN pch1 t2

                             ON  t1.docentry = t2.docentry

                 WHERE  @list_of_cols_val_tab_del = t1.docentry

                        AND t2.BaseType<>'20' AND t1.DocType='I'



              SET @error = -1









------Cannot Add Delivery Note without Sales Order (FOR only item type)-----------




IF @object_type = '15'

         AND @transaction_type IN ('A', 'U')


          IF EXISTS(

                 SELECT t1.docentry

                 FROM   odln t1

                        INNER JOIN dln1 t2

                             ON  t1.docentry = t2.docentry

                 WHERE  @list_of_cols_val_tab_del = t1.docentry

                        AND t2.BaseType<>'17' AND t1.DocType='I'



              SET @error = -1


              SET @error_message = 'You Cannot Add Delivery Note without Sales Order'






------Cannot Add Return without Delivery Note (FOR only item type)-----------



IF @object_type = '16'

         AND @transaction_type IN ('A', 'U')


          IF EXISTS(

                 SELECT t1.docentry

                 FROM   ordn t1

                        INNER JOIN rdn1 t2

                             ON  t1.docentry = t2.docentry

                 WHERE  @list_of_cols_val_tab_del = t1.docentry

                        AND t2.BaseType<>'15' AND t1.DocType='I'



              SET @error = -1


              SET @error_message = 'You Cannot Add Return without Delivery Note'






-- BLOCK SALES INVOICE WITHOUT Delivery Note (FOR only item type)----



   IF @object_type = '13'

         AND @transaction_type IN ('A', 'U')


          IF EXISTS(

                 SELECT t1.docentry

                 FROM  oinv t1

                        INNER JOIN inv1 t2

                             ON  t1.docentry = t2.docentry

                 WHERE  @list_of_cols_val_tab_del = t1.docentry

                        AND t2.BaseType<>'15' AND t1.DocType='I'



              SET @error = -1


              SET @error_message = 'You Cannot Add SALES INVOICE WITHOUT DELIVERY NOTE'








Thank you

Anil Lokam

Copy System(PLD) Layout

Posted by Anil Lokam Dec 15, 2015

Here is a simple way to copy PLD from one Company to another Company

Please follow these steps to copy PLD from one DB(Test DB) to another DB(Live DB)


1. Login to the Test DB and open the PLD. Click on menu 'Print Layout Designer' and select 'Display Hidden Fields'

2. Goto Edit Menu and select 'Select All'

3. Copy All the fields (select copy from Edit Menu)

4. Click on Administration and select Choose Company and login to the Live DB. Note: Donot Logoff from the Test DB)

5. Open the PLD in Live DB. Click on menu 'Print Layout Designer' and select 'Display Hidden Fields'

6. Goto Edit Menu and select 'Select All'

7. Delete All the fields

8. Now Paste the fieds which you copied from 'Test DB'.


Note: Ensure that the Document Properties like Width, Height, Top Margin, Left Margin etc.., are same before pasting in 'Live DB'

My Journey form Account Assistant to Manager IT/ SAP Administrator

I want to share my journey from Account assistant to Manager IT/ SAP Administrator. I started my professional carrier from 2010 in a private organization as Account Assistant. I like computers and especially Microsoft Excel, all day I was working on Microsoft excel. My company director give a task for upgradation its software, that time company used only inventory IN/ OUT, Director give me the task to improve software and design Financial, Store and production in the ERP.

This task is very hard and difficult for me without hardworking and struggle, so I accept this challenge and starting designing and improving the software. I used the following steps in designing and improving our software;


From the very beginning I started analysis of the previous system which was excel and manual entries like in Stores & Spares and finance, and make a document defining all processes and requirement in the current system.


From my document I design the format of the process in excel for each and every step just like BBPs. And then started developing from the software house and improving our software.


When a form is developed I will test it with the documents and on each angle and scenarios. Made some changes or modifications if required


I give the training to users and  take a UAT (user acceptance Testing), some modifications and changes required according to users.


I change my previous designed document according to the new and modified form and process which users accept.

I found some great things during development and designing, Visual FoxPro give me the step into software or ERP, I learned the basic structure and designing processes from this software. I also learned the business process for our organization.

With the passage of time the users and data are increased we expand our network and users from 10 to 50 users in two years, the software result gone down and speed and accuracy are too low I tried many times to solve these challenges but visual FoxPro didn’t do this for me.

After that we meet and decided that we are shifting our software to a new structure and interface and for that we selected PHP & MySQL. I was totally disagree with development because the above steps are required and I know that in development bugs and errors are not completed.

One of my friend give me the idea about SAP (not SAP Business One) and again I meet with management and convincing them to implement SAP. So we call a vendor and take a brief demonstration and proposal but he give us a proposal 4 times high from our budget.

Actually that was not SAP business One that SAP all in one, I again trying to ask from some friends and companies who work on SAP, after some struggle one my friend suggest me SAP Business one and give the vendor contact number.

I called him and take a brief demonstration and proposal (unofficially, because management didn’t want to discuses SAP any more). They give us proposal 50% high from our budget.

I again start convincing my management on SAP business one and approve it within two weeks with the following conditions;

  1. 1. If project is not successfully and SAP didn’t meet our requirements you will responsible.
  2. 2. You will make all master data and process for SAP business one

I accept all conditions as a challenge and starting implementing SAP Business one in our organization. I take 9 days paid training from vendor academy before starting and see some good things in SAP Business one. When we start configuration I have too much difficulties in collecting master data for which I hired two person ells as internee.

Now I am here at our organization as Manager IT/ SAP Administrator and the management are happy from the reporting and result of SAP business one.

Thanks @SAP


Everyone knows the admin guides and overview notes where you could 'easily' find the HANA revisions compatible with the SAP Business One version and patch you want to install. Knowing the HANA revision could also mean an upgrade of the OS (SUSE Linux). Especcially now we are entering the ramp up of 9.2 and the introduction of SLES 12, the end of maintenance for version 9.0 it becomes a bit misty in the SAP Business One version for SAP HANA world. To make it more clear I created the attached pdf in the hope this may clear the mist! This post will be updated frequently when new versions comes out!

[20151215] Minor change in GIF. SLES 11 SP3 is also supported with 9.2 PL02 and 9.1 PL11

[20151217] Changed RU in EAC (=early adopter care) and Pl10 available

[20151221] Add remark about different setups (like High availibility)

[20160104] Upgrade of some libraries already needed for HANA Rev 97.03

Levan Kajaia

New Potential Partners

Posted by Levan Kajaia Dec 13, 2015

Thanks SAP for the opportunity for new Partners!

Anil Lokam

Item Master Creation

Posted by Anil Lokam Dec 2, 2015

Item Master Creation Procedure


• To Create Item Master, at first we have to open SAP Business one client Icon from desktop.

• Enter Valid User ID and Password, only Super users can add master data in SAP.

• To create Item Master data in SAP


     Go to Main Menu--> Modules -->Inventory -->Item master data.


• You can search also existing record SAP by ‘Find’ option from tool bar.

• You add new master record details in SAP by clicking ‘Add’ in tool bar.

• After Clicking on add function from tool bar it goes to add mode, in add mode You can add master record details in SAP.

• In general tab you can add general details of that item and you can define active / in active details also.

• You can select type of the item like Inventory item / sales item / purchase item also.

• If the item is Purchase Item, You can add purchase item details like UOM (Unit of measure), specifications of the item in ‘Purchase Data’ tab.

• If the item is sales item, you can add sales item details like UOM (Unit of Measure) and specifications of the item.

• You can add inventory details of item like Inventory counting UOM, ware house details.

• In planning data tab you can add procurement method, minimum order details.

• If the item is inventory, you can add issue methods and BOM details in ‘Production Data’ tab.

• You can add properties of the Item up to 64 properties in ‘Properties’ tab.

• You can add remarks and Attachments in Remarks and Attachments Tabs.

• You can add attachments by using browser option in Attachments tab.

• After adding all details of the item you have to click on ‘Add’ Button in the bottom of the Item master data wizard for saving the details in SAP.

Anil Lokam

Business Partner Creation

Posted by Anil Lokam Dec 2, 2015

Business Partner Creation Procedure

• To Create Business Partner (Customer / Vendor), at first you have to open SAP Business one client Icon from desktop.

• Enter Valid User ID and Password, only Super users can create master data in SAP.

• To create Customer / Vendor details


     Go to Main Menu Modules -->Business Partner --> Business Partner master data.



• From this screen to add business partner details you have to click on “Add” from the tool bar to Create Business Partner.

• Select Customer / Vendor from drop down.

• You can add the general details in ‘General tab’.

• You add contact person details in ‘Contact Person’ tab.

• You add ‘bill to’ and ‘ship to’ addresses in Addresses tab.

• You can add payment terms and bank details in Payment Terms and Payment Run tabs.

• You add G/L account details In Accounting tab.

• You can define the properties of business partner up to 64 properties.

• You can also add images, attachments and remarks in Remarks, Attachments tabs.

• After entering all details of the business partner, click ‘add’ to save the entered details in SAP.

• You can also find existing business partner details by clicking ‘Find’ option from tool bar.


Filter Blog

By author:
By date:
By tag: