1 2 3 14 Previous Next

SAP Business One Application

200 Posts

SAP Business One 9.1 PL04, version for SAP HANA has been released and is now in unrestricted shipment.

 

More details can be found at the overview note: 2086542 - Overview Note for SAP Business One 9.1 PL04, version for SAP HANA

 

SAP Business One 9.1 PL04, version for SAP HANA is synchronized to and contains all the bug fixes in the following versions:

  • SAP Business One 9.1 PL04
  • SAP HANA Platform Edition 1.0 SPS 07 REV 74.3
  • SAP Business One 1.1 analytics PL05 powered by SAP HANA

 

Note: 
You can upgrade your SAP Business One 9.1, version for SAP HANA to PL04 from any of the previous patch levels of this version.

  • If you are using SAP Business One 9.0, version for SAP HANA, you can upgrade to this patch level directly.
  • If you are using SAP Business One 8.82, version for SAP HANA, upgrae to SAP Business One 9.1 PL00, version for SAP HANA, then you can upgrade to this patch level.
  • If you are running SAP Business One 9.0 PL14 and lower on Microsoft SQL Server, upgrade the database to SAP Business One 9.0 PL15 first, then migrate from Microsoft SQL Server database to SAP HANA database. Then you can upgrade to this patch level.
  • If you are using SAP Business One 9.1 PL03 or lower, you must migrate the database to SAP HANA server, then upgrade it to SAP Business One PL04, version for SAP HANA. Migration from SAP Business One 9.1 PL04 to SAP Business One 9.1 PL04, version for SAP HANA is not supported.

 

Important Notes


  • 2111036 - Please check this note if your SLES system is NOT set as English (US) and your product package (installation or upgrade package) is SAP Business One 9.1 PL04, version for SAP HANA.

eLearning

Access the SAP Business One  9.1 Clips on YouTube or the SAP Business One Academy to learn about the new release.



SAP Business One 9.0, version for SAP HANA PL15 has been released. More details can be found in the following note: 2083447 - Overview Note for SAP Business One 9.0 PL15, version for SAP HANA


Patch Installation Options:

SAP Business One 9.0 PL15, version for SAP HANA  is synchronized to:

  • SAP Business One 9.0 PL15
  • SAP HANA Platform Edition 1.0 SPS 07 Rev 74.3
  • SAP Business One 1.1 analytics PL05 powered by SAP HANA

Upgrade Path:

  • Migration between SAP Business One 9.0 PL15 and SAP Business One 9.0 PL15, version for SAP HANA is not supported.
  • If you are running SAP Business One 8.82 PL02, version for SAP HANA  and lower, install the SAP Business One 9.0 PL14, version for SAP HANA installation package first, then you can upgrade to this patch level.
  • If you are running SAP Business One on the Microsoft SQL Server, upgrade the database to SAP Business One 9.0 PL14, then migrate from the Microsoft SQL Server database to the SAP HANA database. Then you can upgrade it to SAP Business One 9.0 PL15, version for SAP HANA.

 

The Backup Service of B1H company schemas is available since PL14, an introduction video clip is available here:


New features included in PL15 are:

  • Option to configure the backup service after installation directly from SLD.
  • Menu to select the backup to recover from.
  • You can run backup service operations on different company databases simultaneously.
  • etc.


Important Tips:

          2072868 - Backup service for SAP HANA best practices and known limitations


 

Important Notes

Hi,

 

Have you already seen the new Workbench widget part of SAP Business One 9.1, version for SAP HANA?

 

Workbench widget standardizes and visualizes the most common business processes. It not only simplifies the complex functions by grouping common functions together according to different business purposes, but also provides you with a consolidated entry to perform various kinds of jobs.

 

Workbench_screencapture.PNG

In SAP Business One, version for SAP HANA, we provide 4 standard templates. However, the standard templates may not precisely meet the business requirements of your company.

 

In order to enhance the customized functionalities of the workbench widget, Workbench Editor is introduced. With Workbench Editor, you can customize the standard templates from SAP based on your own business requirements. However, you are not able to create a new Workbench process template at the current version.

 

There is a YouTube video that shows the abilities of the tool step by step

                      

 

The editor promotes the efficient performance of the Workbench widget. It enables you to do the following:

• Flexibly create, edit and delete entities

• Freely change the layout of the entities in the working pane

• Focus on your responsibilities with customized information

 

You can download Workbench Editor from SAP Note 2097429 - You can now customize standard workbench templates with Workbench Editor.

Just check the note and customize the out of the box Workbench widget provided.

And don't forget to give us feedback!

 

Hope you will find it useful for your customers!

Trinidad.

Hi all SAP experts,

     Some days before i needed a Transaction Notification to Block the Receipt of final product whose actual issued quantity is not equal to planned quantity in production order. So first of all i tried to find on SCN and some other B1 sites but did not find any solution,then after that  i made  a Store procedure which i am sharing with you all.

 

IF @object_type='59' AND @transaction_type = 'A'

Begin

IF EXISTS(SELECT  B1.DocEntry

FROM             OWOR A INNER JOIN

                         WOR1  A1 ON A.DocEntry = A1.DocEntry INNER JOIN

                         IGN1 B1 ON  A.ItemCode = B1.ItemCode AND A.DocNum=B1.BaseRef

                                         WHERE  A1.PlannedQty<>A1.IssuedQty and a.ItemCode=B1.ItemCode

                                           and B1.DocEntry = @list_of_cols_val_tab_del

                                         GROUP BY A.DocNum,B1.ItemCode,A1.ItemCode,A1.PlannedQty,A1.IssuedQty,b1.DocEntry

                                         )

BEGIN

SELECT @Error = 1, @error_message = 'Actual Issued must be  equal to planned quantity'

END

END

 

Hope this will help to block the Transaction.

 

 

Thanks & Regards,

Manish

When I transfer a multi line item from quotes to orders, I can only delete one line at a time.

Sometimes the quote might be 50 line items and they only order 10 and I have to delete

each item one at a time, which is very time consuming

SAP Business One 9.1 PL03, version for SAP HANA has been released.

More details can be found at

2065330  - Overview Note for SAP Business One 9.1 PL03, version for SAP HANA

 

Note: SAP Business One 9.1 PL03, version for SAP HANA is a ramp up version.

 

SAP Business One 9.1 PL03, version for SAP HANA is synchronized to and contains all the bug fixes in the following versions:

  • SAP Business One 9.1 PL03
  • SAP HANA Platform Edition 1.0 SPS 07 REV 74.3
  • SAP Business One 1.1 analytics PL05 powered by SAP HANA

Note: SAP Business One 9.1 PL03, version for SAP HANA contains the integration framework (B1iF) version 1.20.6.

 

Upgrade Path

  • You can upgrade your SAP Business One 9.1, version for SAP HANA to PL03 from the previous patch level of this version.
  • If you are using SAP Business One 9.0, version for SAP HANA, you can upgrade to this patch level directly.
  • If you are using SAP Business One 8.82, version for SAP HANA, upgrade to SAP Business One 9.1 PL00, version for SAP HANA, then you can upgrade to this patch level.
  • If you are running SAP Business One 9.0 PL13 and lower on Microsoft SQL Server, upgrade the database to SAP Business One 9.0 PL14 first, then migrate from Microsoft SQL Server database to SAP HANA database. Then you can upgrade to this patch level.
  • Migration from SAP Business One 9.1 PL03 to SAP Business One 9.1 PL03, version for SAP HANA is not supported. If you are using SAP Business One 9.1 PL02 or lower, you must migrate the database to SAP HANA server, then upgrade it to SAP Business One PL03, version for SAP HANA.

 

Important Notes

User1 Sap

Service module

Posted by User1 Sap Nov 10, 2014

Hi all,

when i create a service call and when i enter the serial number of the serialized item, the service contract number automatically doesnt comes in the field. it says "No valid contract exists for the customer". when i check in the item master i have a contract there and when i see the customer equipment card, it also has a contract. Please help?

To comply with the new legal regulations regarding the Electronic Accounting Statements in Mexico, among other changes new Journal Entry report (JE report further) has to be submitted on monthly period effective from January 2015. It includes obligation to report via JE report also documents created within transition period July - December 2014, retrospectively including new information about electronic number UUID.

 

The UUID information is a 36 characters unique electronic number (CFDI and CFD) available in generated XML which represents electronic invoice in Mexico and it is provided by the SAT authority. UUID information is currently not available for created Purchasing documents (AP side) in SAP Business One application, Sales documents (AR side) already contains this information. All Purchasing invoice type documents created in transition period due to this legal change therefore must contain UUID information in order to be reported via new JE report.

 

In order to automate process of importing UUID information for existing Purchasing documents from XML into SAP Business One application Tool was developed and is available via link below. Purpose of the Tool is to track and identify appropriate document existing in DB, based on specific parameters and create bridge/reference between XML and document that enables to transfer UUID information from XML into a document, in a batch run. In order to transfer UUID information recommended is to create new UDF for Purchasing documents where this information will be stored.

 

References:

  • The How To Guide document available via Note 2048577 describes in step by step scenario process of importing UUID information for relevant documents, direct link to HTG v2 HERE
  • For all further details please see SAP Business One Note 2048577
  • Please notice, link to short recorded video for UUID solution is attached for your convenience here, and also in Note 2048577. Please follow the process according to steps in HTG in order to automate transfer of UUID information into the DB
  • Tool XMLReader is available HERE

 

 

Important notice on 27.11.2014


Since 27th of November 2014 updated HTG, version 2 is available. It contains updates of queries providing import of UUID information. HTG v2 can be found as an attachment in Note 2048577, very soon it will be also directly available from this blog.

 

HTG v2 includes:

  • Additional step added in order to indentify XML files not matching with an existing A/P documents of Invoice type
  • Queries include also Credit memo and Debit memo
  • No change on XML Reader Tool side

 

 

In case of any question or comments please do not hesitate to contact me here or via martin.pavlinsky@sap.com.

Hello,

 

I’m Torben Sliwka and I’m a consultant at wOne Consulting, a SAP Business One partner located in northern Germany.

 

Today, I want to share with you my experience with the Ramp-up project of the new Release SAP Business One 9.1 at our customer Engel GmbH. Engel GmbH is a German producer of natural textiles and manufactures a complete program of clothes for babies, children, and adults. Engel works with SAP Business One 9.1 since August 2014 using the following modules: purchase, sales, inventory management, and CRM.

 

New options to customize user interfaces easily and flexibly

 

One of the major improvements in Release 9.1 is the flexible and easy customization of the system user interface. These new customization capabilities are one of the main reasons that Engel joined the Ramp-up Program.

 

Engel had a particular interest in the new feature “UI Configuration” that allows customizing the user interface by changing the positions of the system fields - to remove them from the screen when setting them inactive or reactivate them by setting them as activate when required.

 

Customization of the field positions can easily be done using Release 9.1 by simply dragging and dropping items with the mouse. Due to these individual adjustments, users are able to do their daily work much more efficiently.  

 

Recording of mass orders via direct Microsoft Excel import

 

Another key aspect for Engel was to implement the new capability that allows import of data via MS Excel. A major Engel customer regularly enters mass orders with hundreds of individual item positions. These mass orders are submitted to Engel via an MS Excel document. 

 

The new Release 9.1 offers the capability to integrate this order via an external MS Excel document into the SAP System in a seamless manner. The items in the MS Excel document can be maintained quickly and easily and can then be copied into the SAP Business One System.

 

Using the new Release 9.1, Engel is now able to handle those mass orders in a better way by using the enhancements in import data from MS Excel into SAP Business One where they can be further processed.

 

Participation in the Ramp-up program, nomination and implementation

 

The nomination of the project at Engel was submitted via the SAP online registration form for Ramp-up participation, and it took me about 20 minutes to fill in all necessary information. A few days later, we received the confirmation, that Engel has been nominated as an official Ramp-up customer.

 

The upgrade from SAP Business One 9.0 to Release 9.1 was done shortly before going live, and it all went well without any issues. SAP Business One 9.1 is productive at Engel since the beginning of August 2014. An extensive training for the end users was not necessary.

 

Torben Sliwka
Consultant, wOne Consulting GmbH

Hello all,

 

In my day to day job, I create a lot of Business One test and demo environments.

Over the years, I have accumulated a few tips & tricks that I am now sharing in this blog - http://scn.sap.com/blogs/bagoftricks

 

Most of these tips and tricks are going to be system/setup related, but I still hope they help anyone around!

 

Aurélien

SAP Business One 9.0, version for SAP HANA PL14 has been released. More details can be found in 2058370 - Overview Note for SAP Business One 9.0 PL14, version for SAP HANA

 

The Backup Service of B1H company schemas are now available in the SLD with graphical user interface, which simplify the backup and recover process of B1H company schema with automation. An introduction video clip is available here.


The features are highlighted as below:

  • Configurable scheduler for automatically periodical backup.
  • Interactively backup a selected company with a button click.
  • Configurable maximum size backup folder.
  • Recover the backup with rename. Only allow to recover the latest backup in PL14 right now.
  • Only one backup can be running at the same time.
  • etc.


Important Tips:

 

Version Information:

SAP Business One 9.0 PL14, version for SAP HANA  is synchronized to and contains all bug fixes in the following versions:

  • SAP Business One 9.0 PL14
  • SAP HANA Platform Edition 1.0 SPS 07 Rev 74.3
  • SAP Business One 1.1 analytics PL05 powered by SAP HANA

Note:

  • Migration between SAP Business One 9.0 PL14 and SAP Business One 9.0 PL14, version for SAP HANA is not supported.
  • If you are running SAP Business One 8.82 PL02, version for SAP HANA  and lower, install the SAP Business One 9.0 PL13, version for SAP HANA installation package first, then you can upgrade to this patch level.
  • If you are running SAP Business One on the Microsoft SQL Server, upgrade the database to SAP Business One 9.0 PL13, then migrate from the Microsoft SQL Server database to the SAP HANA database. Then you can upgrade it to SAP Business One 9.0 PL14, version for SAP HANA.

Important Notes

Dear SAP Business One Consultants/Partners/Customers/Co-ordinator

 

To start off this discussion (not a serious one )


I want to know the journey of  the people (of their respective SAP Business One Career)who are active in our area of SAP Business One particularly. So it could be helpful for people looking into an SAP Career via SAP B1

 

To start off, i will tell my journey since i have started it.(no need of mentioning company names)

 

Well  i started my career as a sales employee(BDE) selling IT Products after doing B.E(C.S)(even though i didn't have a clue about it )

But the reason being i wanted to learn both technical and management so i  completed my M.B.A (Sys&Mktg).

 

I wanted to make use of both my Technical & Management knowledge to be productive in my career. I had heard of SAP during my M.B.A period but when i joined for an institute(unauthorized -only came to know later) to learn the course there was no mention of SAP Business One any where.


If you want to enter SAP career, you can only do by doing the following course SAP FICO/SD/MM/CRM(All R/3) cause R/3 consultants make huge bucks of money . So happily i completed my SD course in an institute (but later came to know only doing course is not enough have to do certification .Thought of completing that also but there is no Guarantee of getting job after paying huge amount  as END TO END implementation experience is required.(this i have heard n number of times whenever i tried applying for an SAP R/3 Job)

 

Somehow joined a Startup company which gave an opportunity to work as SAP Business one consultant provided you get some business to them (expected startup company have to compromise).But the good thing was that i got introduced into SAP Business one which a product specifically designed by SAP for SME'S .In that duration i got chance to go to SAP company got  training on B1 technical by Yatsea Li   and  some how journey continued. Got to know that B1 consist of all modules in one single software so worth of doing degrees was somehow accomplished   .

 

Later on i wanted more knowledge in SAP B1 hence joined the course specifically on SAP B1 in an Authorized institute(this time with proper information) . Later got chance to work in a Customer company and became active member in this awesome community of SCN. Both through my exposure to issues in the company and issues posted in SCN forum  helped me a lot in completing my certification in B1.

 

 

So though this blog people looking for  an SAP Career keep you eyes and years open, there is not only R/3 required to enter into SAP but there are many other modules like B1 which doesn't ask for any END- End implementation experience, provided you have thorough subject knowledge .

 

the SAP Business one DEMO videos posted by Richard Duffy is really helpful for people looking to get a good SAP B1 subject knowledge and SQL queries for SAP Business book by Gordon Du is helpful to get a proper SQL skillset .I also got guidance from Prasanna s in my sap b1 journey .I would like to thank everyone for all their direct and indirect help..

 

I kindly request people to share their SAP B1 Journey so it would be worth full for the  community and people looking specifically in our B1  community.

 

Thanks&Regards

Darshan Desai

SAP Business One 9.0, version for SAP HANA PL13 has been released, available as base installation and upgrade patch.

 

SAP Business One, version for SAP HANA 9.0 PL13 is synchronized to:

  • SAP Business One 9.0 PL13
  • SAP HANA Platform Edition 1.0 SPS 07 Rev 74.3 (Since HANA Rev 70, you can install any HANA Rev directly without a base revision installation, hereby you can install HANA Rev 74.3 directly without Rev 70 installation.)
  • SAP Business One 1.1 analytics powered by SAP HANA PL05

Note:

  • Migration between SAP Business One 9.0 PL13 and SAP Business One 9.0 PL13, version for SAP HANA is not supported.
  • If you are running SAP Business One 8.82 PL02, version for SAP HANA  and lower, you can upgrade it to SAP Business One 9.0 PL13, version for SAP HANA directly.
  • If you are running SAP Business One on the Microsoft SQL Server, upgrade the database to SAP Business One 9.0 PL12, and then migrate from the Microsoft SQL Server database to the SAP HANA database. Then you can upgrade it to SAP Business One 9.0 PL13, version for SAP HANA.

 

As of PL11, SAP Business One 9.0, version for SAP HANA supports both SuSE Linux Enterprise Server 11 SP2 and SP3 If you use SAP Business One 9.0 version for SAP HANA and want to upgrade the operating system to SPS3, you must first upgrade SAP Business One to PL11 and then upgrade the OS.


Please check the corresponding PL13 central note for more details : 2046092 - Overview Note for SAP Business One 9.0 PL13, version for SAP HANA


Important Notes

SAP Business One 9.1 PL01, version for SAP HANA is currently synchronized to and contains all bug fixes of the following base versions: 

  • SAP Business One 9.0 PL12, version for SAP HANA
  • SAP HANA Platform Edition 1.0 SPS 07 Rev 74.3

Note: SAP Business One 9.1 PL01, version  for SAP HANA contains the integration framework (B1iF) version 1.20.0 and SAP Business One analytics 1.1 PL05 powered by SAP HANA.

 

Please check the Overview Note for more details:

2046045 - Overview Note for SAP Business One 9.1 PL01, version for  SAP HANA (S-user required)

 

Upgrade Path

  • Migration between SAP Business one 9.1 PL01 and SAP Business one 9.1 PL01,  version for SAP HANA is not supported.
  • If you are running SAP Business One 8.82 PL02, version for SAP HANA and  lower, upgrade it to SAP Business One 9.1 PL00, version for HANA, then you can  ugrade it to this patch level.
  • If you are running SAP Business One 9.0 PL12, version for SAP HANA and  lower, upgrade it to SAP Business One 9.1 PL01, version for HANA directly.
  • If you are running SAP Business One 9.0 PL11 and lower on Microsoft SQL  Server, upgrade the database to SAP Business One 9.0 PL12, then migrate from the  Microsoft SQL Server database to the SAP HANA database. Then you can upgrade it  to SAP Business One 9.1 PL01, version for SAP HANA.

 

Important Notes

 

SAP Business One analytics 1.1 PL5 powered by SAP HANA is synchronized with:

  • SAP Business One 8.82 patch level 7 and higher
    SAP Business One 9.0 patch level 3 and higher
    SAP Business One 9.1
  • SAP HANA Platform Edition 1.0 SPS 07 Rev 74.3

 

Please check the corresponding central note for more details:

2036585 - Overview Note for SAP Business One analytics 1.1 PL5 powered by SAP HANA (S-user required)

 

Other interesting notes are:

1914461 - SAP Business One Analytics Portal (S-user required)

2036802 - You Can Now Use Semantic Layers Provided by SAP Business One analytics powered by SAP HANA (S-user required)

Actions

Filter Blog

By author:
By date:
By tag: