1 2 3 12 Previous Next

SAP Business One Application

175 Posts

If you didn’t make it to the last SAP Business One Special Interest Group meeting on March 11th, here is what you missed. We had a good turnout of over 20 SAP Business One users who met at SAP UK near Heathrow Airport. We would like to thank SAP for their continued support and use of a very smart meeting room including AV equipment.

 

Delegates arrived from 9.30am for coffee and a catch up with acquaintances. We also welcomed 2 new members to the group who were quickly made to feel at home by the other members. We’re a friendly bunch!

 

The first session was a presentation about running B1 on Hyper-V by John Wager, IT Manager at SAP Business One user Saddleback. John spoke with first-hand experience about his experiences of running SAP on the minimum spec recommended by SAP and the benefits they have found by giving SAP it’s own dedicated virtual server. There were comments from the floor and everyone agreed it is best to give SAP it’s own Server and the benefits of Hyper-V are clear.

 

After John we had Mads Madsen from SAP Accredited and award winning Add On Partner Boyum IT. Mads was giving a hands on session on the Boyum Usability Pack and some of the cool features. This was far from a  “Sales Pitch” and more of a How To session focussing on configuring B1 to suit our users’ needs. Mads showed how to add function buttons and User Defined Fields in minutes. How to make fields mandatory or read only for certain users. He also looked at the integration with the Mail Chimp API which increases the CRM capability of B1 and also the Business One Budget module.


The group welcomed Andrew Fox back again to speak about Analytics for Business One customers. Andrew looked at the out of the box Dashboards that come with B1 and concluded they are very dull! They are also not configurable but the end user. We looked at the other options available from SAP starting with the free tool called Lumira which can be linked to the SQL data source for approx. £900. For the B1 customers who want to design their own Dashboards you will need to look at Excelsius / Crystal Dashboard Designer which costs circa £2,000 for a 25 user site and is a real advance to the standard dashboards. If you really want to push the boat out and demand high quality live dash boards Andrew suggested the cleverly named product called “Dashboards”. This is a Business Objects product and really s the Rolls Royce of analytics for B1 users but the price may put people off!


 

Our next speaker made a special effort to fly in to London as he is usually based in Atlanta USA. Zal Parchem is a lover of all things Business One and his SQL writing skills are excellent. Zal also worked on the famous book by Gordon Du (Mastering SQL Queries for SAP Business One). Zal went over the basics of SQL, where to find table information, what an inner join is, outer join etc and showed us where to find instructional info. Zal also gave us a template to store all our own SQL. Most of us have written over 50 queries that are saved in the B1 system but Zal said to copy them to word and lay them out in a format so everyone can understand what they are for. He also said to include a brief intro as to what the report is used for and who by including version control.


Zal worked on some live queries from the audience and got them working. He also gave everyone his stash of top 20 SQL queries we all took and use in our live systems. These queries would have cost several thousands of pounds if a SAP B1 partner had done them at the usual rate! Zal ran on for over an hour as the audience fired more questions at him. Everyone said it was an excellent session and Zal is happy for the attendees to contact him for advice if they have had a good go at a query but can’t get it to work. This sort of help makes users less dependent on their VARs and empowers them to learn themselves.


One of the benefits of the SIGs is meeting fellow SAP Business One users and chatting over lunch. Over the months many relationships have formed this way with users sharing experiences. The next SIG is planned for July 16th and we have another great line-up. We are also working on some exciting plans to grow our numbers so watch this space.


If you are not a member of UKISUG and want to join click here. If you are a member and want to sign up for next time click here

Have you ever used SAP Business One Test Composer to automate your add-ons testing?

 

Take some minutes and have a look at it, we have just now released a new version 9.1 mainly fixing some limitations found in our previous 2.4 version. This version has been compiled for SAP Business One 9.0 version.

 

SAP Business One Test Composer is an automation testing tool for SAP Business One. It provides a simple way for mainly record/replay scenarios for testing purposes but can also be employed in many other use cases. This tool leverages on the well known and established SAP Business One SDK, on the .NET platform and on Microsoft Visual Studio .NET environment.

 

You can see detailed information about B1TC and download it from this link.

 

You can find the complete list of fixed issues as a comment in our previous blog post at:

http://scn.sap.com/community/downloads/blog/2012/08/09/new-sap-business-one-test-composer-b1tc-release-24

 

You can also use this blog to give us your feedback: do you find it useful, do you think something important is missing?

 

Please give us your opinion:

Do you find it useful? User friendly?

We are really interested in hearing your ideas.

SAP Business One 9.0, version for SAP HANA PL10 is already available, take the opportunity to upgrade to the latest patch of SAP Business One 9.0 version for SAP HANA and take advantage of the latest new features.

 

SAP Business One 9.0, version for SAP HANA PL10 is synchronized with :

  • SAP Business One 9.0 patch Level 10
  • SAP HANA SP06 Rev 69.
    Please don't use any other HANA revision in conjunction with SAP Business One 9.0, version for SAP HANA unless stated here or in the corresponding overview note for the specific version.

 

Note: If you are running SAP Business One on Microsoft SQL Server, you must first upgrade it to SAP Business One 9.0 PL09 and migrate the databases from the Microsoft SQL Server database to the SAP HANA database. Then you can upgrade it to SAP Business One 9.0, version for HANA PL10.

 

Please check the corresponding central note for more details :

1975407 - Overview Note for SAP Business One 9.0, version for SAP HANA PL10 (S-user required)

 

Main new features

 

Check the PL10 overview note for details about the new features and fixes included offered by SAP Business one 9.0 PL10, version for SAP HANA:

 

1975407 - Overview Note for SAP Business One 9.0, version for SAP HANA PL10 (S-user required)

  

How to perform a schema backup

How to import a schema with a different name

 

Important Notes


HANA Rev 69 important notes:

 

1983931 - Customized SAP HANA models disappear from the "Interactive Analysis" menu

Info.xml file format has changed (new property IAEnable added), follow this note to understand the right format required for importing SAP HANA models into B1.

 

1943067 - Recommended configuration setting when you upgrade HANA to version 67 or higher (S-user required)

To avoid possible statistics server problems (e.g. running out of memory), we recommend that you change some configurations in SAP HANA before upgrading to SAP HANA Revision 67 or any higher version.

 

1950647 - XSEngine does not send any response (S-user required)

If you experience problems with XSEngine after installing/upgrading B1H please check this HANA note.
This problem has been fixed with SAP HANA SP7 Revision 70.

A bit about myself.

 

     I'm an SBO Implementation Consultant with 7 years of experience and i've implemented in over 15 companies. Throughout my years implementing I've always used XL Reporter to build Financial Reports as an alternative to SBO's layouts. Its easy to use and you can build General Balance & Profit and Loss reports very fast. Combining month vs previous months vs YTD previous year vs actual budget grouped by DIM1 in the same report, for example, was a piece of cake.

 

Now.....as we all know, in SBO 9.0 and above, XL Reporter is not compatible with Excel 2013 and above. And we cant expect the customer to stick with excel 2010 or below just to enjoy the functionality. ENTER CRYSTAL REPORTS (CR)!!! For the past 3 years I've used CR but mostly to make sales, purchase and banking reports or to make printing layouts for documents but never for financial reports. I've tried to modify the standard CR Layout for the General Balance and P&L and also make the layout based on my own query but making the report and grouping the accounts the way the customers wants it has been a headache!! to say the least. Combining budgets grouped by projects and dimensions in a P&L in CR has proved very complicated.

 

So my question is, is there an easier alternative for financial reporting or has anyone build a template others can use as a base for financial reporting. Any help would be greatly appreciated.

From experiences sometimes with the changes in the SQL and T-SQL there is a need to downgrade the compatibility of the SQL Server. The trade-off is not having access to the newest features.

 

Has any experienced problems like this?

Having used Business One for years I have notice every few patches new features are added even though small they can make a difference in an organization. I remember in 8.81 that at PL9 the additions of the attachment tags and the ability to drag drop files into a window. This addition minimizes the need for UDF and improves business process flow. Also something simple as the addition of a checkbox for active employees in the HR Manager was a welcomed addition in 8.81 or 8.82 even not mentioned in any documentation it makes reporting efficient.

 

The issue is having management allowing these continuous upgrades. With 8.8 and up having simplified upgrade processes it is still a challenge to upgrade. Does anyone have stories or cases that help with the continuous upgrade in an organization.

# About me:-

I have total 10 to 11 months of experience in SAP Business one.

I am gaining lots of knowledge from SAP forum,

I want to say "Thank you very much.." by hearts to all experts peoples who always encourage new comers in SAP.

here i tried to write a small blog on Production module.

 

# Purpose of this Blog :-

 

In this blog i am going to elaborate default production process in SAP Business one

 

# Contents of this Blog are :-

 

1) What is Bill of Material (BOM).

2) What is Component Item(Child Item).

3) What is Finish Item(Parent Item).

4) How to set Bill Of Material.

5) How to start production

  •       Types of Production Order
    • Standard
    • Special
    • Dis assembly

6) How to complete production

  • Issue Methods.
    • Manual
    • Back-flush
  • Types of Status
    • Planned
    • Released
    • Closed

7) How to Disassemble a production order.

8) What is Multiple BOM & How to set Multiple BOM.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1) What is BOM (Bill Of Material):-

  •     In simple language,BOM is a list of raw material which is required to produce a finish good.


2) Component Item (Child Item):-

  •   Component item are item which are use to produce finished item.
  •   Component item are physical items.

            Example:-

            Component Item->Bat,Ball,Bells,Stumps,Leg pads,Helmet,hand gloves & shoe are components to produce

            finished  goods i.e Cricket kit.

 

3) Finish Item (Parent Item):-

  •   In a Production process a component items are turn into finished items.

            Example:-

            Finished good->Cricket Kit set.

 

4) How to set BOM (Bill Of Material).


          1) Choose finish item (with quantity) from list of Header level field Product No.

                Example:-

                            select Cricket kit(for 1 set) item in header level of BOM.

Parent Item.png

          2) Choose component items (required quantity to complete FG) in row level

              Example:-

                                    ITEMS                QTY      UOM

                                ------------------------------------------------

                                    Bat                          1      Nos

                                    Ball                        1      Nos

                                    Bells                      4      Nos

                                    Stumps                  6      Nos

                                    Leg pads                2      Nos

                                    Helmet                  1      Nos

                                    Hand gloves          2      Nos

                                    Shoe                      1      Set

BOM_Component.png

 

    3)  After adding details of Bill of Material (BOM) click on Add Button in bottom of form.

          Now BMO will add to database.

 

5) How to start production.


    NOTE:-

                a) TO START A PRODUCTION ORDER WE MUST HAVE TO SET BOM FOR PARENT ITEM I.E FINISHED

                    GOODS.

 

                b) COMPONENT ITEMS ISSUE METHODS MUST BE MANUAL FOR ISSUE ANY RAW MATERIAL FOR

                    PRODUCTION .

                    (TO SET ISSUE METHOD CHOOSE ITEM MASTER DATA OF ITEM)


  1)  Create Production Order:-


            1.1) Select Finish good (Product No.) from list.Default BOM set for that item will display in

                    production order row level.& Fill Planned Quantity i.e. production quantity of that item.

           

            1.2) Select Type of Production Order.

 

                    Their are 3 types of Production Order

                      i>  Standard

                      ii> Special

                      iii>Dis-assembly

 

          i) Standard:-

      • If all Component items are include in production order process as per BOM set then Type of Production

                          should be Standard.

      • Default BOM automatically display for production order
        • Example:-

                                    For One set of Cricket kit, BOM is as below,

 

                                  Item No.                  Quantity

                                  ---------------------------------------

                                  Bat                              1

                                  Ball                            1

                                  Stumps                      6

                                  Bells                          4

                                  Leg Pads                  2

                                  Helmet                      1

                                  Hand Gloves              2

                                  Shoe                          2

BOM_`Standard.png

 

          ii) Special :-

      • If Component items in Production order process are not as BOM set then Type of Production Should be Special.
      • In In Special production order we have choose component items manually.


        • Example:- 

                                    If few customer ordered Cricket kit set with Bat,Ball,Bells & Stumps only.

                                    In this case BOM will change & Production order will be special.


                        Default BOM:-                |    Special BOM (AS PER CUSTOMER REQUIREMENTS)

                      -------------------------------------------------------------------------------------------------------------                     

                        Item No.      Quantity      |    Item No.      Quantity

                      ---------------------------------|--------------------------------------------------------------------------

                        Bat                    1          |      Bat                  1

                        Ball                   1           |     Ball                  1

                        Stumps            6           |     Stumps            6

                        Bells                 4           |     Bells                4

                        Leg Pads          2          |

                        Helmet              1          |

                        Hand Gloves     2          |

                        Shoe                   2        |

BOM_Special.png

  iii) Dis-assembly :-

  • This option is available for Disassemble a production order which is not closed yet.
  • Disassemble option can be use when we want to sale a separate parts of Finished Goods
    • Example
      • Disassemble a Set of Cricket kit in to child items & sold it. 
      • If the customer is return back the "Cricket Kit" because of some damage in BAT.

                            In that case you can use this type for return back the component items into stock.

                            then do Inventory transfer to scrap warehouse of damage items and good items to Component warehouse

 

 

2)  Enter Planned Quantity i.e Production Quantity of item.

      Values of planned quantity in row level will change according to value of planned quantity in title level.

        It is done on the basis of base quantity values set in BOM for that item.

 

3)  After filling details of Production Order click on Add Button in bottom of form.

      now production order will add to database.

 

6) How to complete production.


          CONCEPT OF ISSUE METHODS :-

 

            i) Manual:-

        • When Issue method of item is Manual then only you can Issue Raw material for production i.e Issue For Production step will done.

                                Production Steps are,

                                  a) Production order

                                  b) Issue for Production

                                  c) Receipt from Production

                                  d) Close.

 

          ii) Back-flush:-

        • You can not Issue Raw material for items who have Back-flush issue method.
        • When Issue method of Item is Back-flush then Issue for production step will skip

                      Production Steps are,

                        a) Production Order

                        b) Receipt from Production.

                        c) Close.


Their is simple  5 steps to complete production,

 

  i)  Create & Add Production Order

  ii) Change Planned status to Released status.

  iii) Issue for Production

  iv) Receipt from Production.

  v) Change Released status to Closed status.

 

i)  Create & Add Production Order.

  • Create production order as explain in above i.e. in 5th Point.
  • After successfully creating & adding production order document, initial status of  production order is Planned.

Planned_Status.png

 

ii) Change Planned status of production order to Released status & Update production order.

Released_Status.png

  • Their is 3 type of status in Production Order
    • Planned
    • Released
    • Closed.
      • Planned  :-
          • After adding production order its initial status is Planned status.
      • Released :-
          • After changing planned status of production order to Released then only we can do next steps of production
      • Closed :-
          • After changing production status Released to Closed.Production order can not be change.

 

iii) Issue for Production order.

 

          Note :- Component items Issue Method must be Manual.

                       To setup Issue Method as a Manual open Item master data of that Item.

 

  • In this step production order actually released on shop floor for production.
  • We can do Issue for production only when production order is i released state.
  • issue a material for released status production order.
  • Steps in Issue for Production is as below,
    •   Right click on production order select "Issue components" option from list

Issue_For_Prod.png

    •   If Required change Quantity in "Issue for Production Order"
    •   Click Add Button at bottom of Issue for Production form

Issue_For_Prod_2.png

  •   After  adding Issue for production production order will look like,

After_Issued_Mat.png

iv) Receipt from Production.


  •   After completing a production process production order come in this step.
  •   Complete Quantity & Rejected Quantity of Finished good is enter in this step.

 

  ->Right click on production order select "Report Completion" option from list

Receipt_From_Prod.png

  ->Enter Complete & Reject Quantity of finished good.

  ->Click Add Button at bottom of Receipt from Production form.

After_Rec_FormProd.png

  • After  adding Receipt from production production order will look like,

After_cmplting_rec.png

V) Close Production Order:-

  • Change Released Status of production order to Closed Status.
  • Once production order close then we can not change production order again.
  • Update Production Order by clicking Update button.

Close_Prod.png

7) How to Disassemble a production order.

 

              Note:-Production order can be disassemble only when it is in open status.

 

              There is few steps to Disassemble Production Order.

 

    •   Create Duplicate Production Order of production Order which you want to Disassemble Press Ctrl+D.
    •   Change type of Duplicate production order (Standard) to Disassemble & update Production Order. 
    •   Change status of Duplicate production order(Planned) to Released & update Production Order.
    • D2.png
    •   Open Issue for production
    •   Click & select Disassemble order.

                      D3.png

    •   Add Issue for Production order.

                    D4.png

    •   Open Receipt from production
    •   Click & select Return Component.

                    D5.png

    •   Select Items to be return from given list & click "OK".

                    D6.png

    •   Add Receipt from Production order.
    •   Now Check Stock of all item which we select in Receipt from Production->Return Component.

                    It will increase by quantity we return.

    •   Change Released Status of production order to Closed Status & Update.

                    D7.png

8) What is Multiple BOM & How to set Multiple BOM.

  • Multiple Bill of Material:-
    • It is BOM which contain another BOM,
    • Example:-In Cricket kit their is 2 BOM.

      Cricket kit contain

                  Bat, Ball, Bells,Stumps,Helmet,Hand gloves,leg Pads & Shoe set.

      FGBOM.png
    • Shoe kit contain:-

      Shoe,Laces & Socks

      SemiBOM.png
  • How to set Multiple Bill of Material:-
    • In Multiple BOM 1st set BOM for Semi finish goods & then for Finish goods.
  • Example:-

  •         BOM For Shoe (Semifinished Goods)                        BOM For Cricket kit (Finished Goods)

            ------------------------------------------------                         ------------------------------------------------

            Item       Quantity    UOM                                             Item          Quantity         UOM

            Shoe         2             Nos                                              Bat                     1           Nos

            Lays         2              Nos                                              Ball                    1           Nos

                Sox           2              Nos                                             Stumps             6           Nos

                                                                                                     Bells                 4            Nos

                                                                                                     Helmet              1            Nos

                                                                                                     Hand Gloves     2            Nos

                                                                                                     Leg Pads          2            Nos

                                                                                                     Shoe                 1            Set

               Multi_BOM.png

  • Do the production process as above for Semi finished goods first then do the production process for Finished goods.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

          Any Question or suggestions for me please post below,

Hi all,

 

We have released an updated SAP Road Map for SAP Business One.


The Road Map Q1 2014 is available for SAP customers and partners on http://service.sap.com/roadmaps (Solution Road Maps -> Cross Topics).

 

 

Attention:
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.

 

 

Best regards,
Peter, SAP Business One Solution Management

Hi,

 

I need a query that I'll be able to show a client a break down of one supplier within a certain period. It should show item description, quantity sold, total value of sales,gross profit and gross profit in percentage.

 

I hope someone can assist me with a query to solve this problem.

 

Regards,

 

Kibunja

The next UKISUG Business One Special Interest Group (SIG) is scheduled for the 11th March 2014 at SAP UK Clockhouse Place, Bedfont near Heathrow Airport and we have an excellent line up:



John Wager from Saddleback Ltd (B1 User) will discuss Real world hardware requirements and moving to a virtualised environment. A look beyond the SAP and Microsoft recommended hardware requirements into what works in a real end user site.

  • What SAP recommend
  • Running it on minimum spec
  • Beefing it up (new virtual server)
  • Costs / Backup /Network / Internet connection
  • Overview of how their system is configured for 25 users including Virtualisation and Backup


Zal Parchem an SQL Expert and Freelance Consultant will give a practical session showing you how to get the most out of SQL Queries. Zal will look at the essentials for SQL Query writing then look at some of the users queries and suggest improvements. There will also be an electronic hand out for everyone to copy and paste SQL in to their own installations based on the top 10 SQL Queries for Business One users. Zal was involved in the book on SQL by Gordon Du.


Mads Madsen from SAP Add On Partner Boyum will give a session on "Get more out of the Boyum Usability Pack". A practical session with demonstrations showing you some of the useful functions of the Boyum Usability tool. We’ll be looking at some real life scenarios and ways to make using your B1 installation quicker and easier.


Andrew Fox from iTelligence will present SAP Business One comes with Dashboards and analytics functionality but what if this isn’t enough for your business? Andrew is a Business Objects expert and will show you some practical examples of what you can get our of your SAP Business One data with the Business Objects tool. He will also talk about the practicalities of implementing this and basic costs involved


There will be some excellent food provided and the chance to catch up with fellow users of SAP Business One. To register for the event click here

 

If you are not a member and would like Free Trial Membership please click here

 

The Business One section of The User Group is growing [rapidly and our members report that being part of a community really helps them get the most from their SAP installation.

I have Installed SAP 9.0 PL08 in Server and there is 6 Add-ons and All Add-ons Working Properly in Server But In Client Machine not a Single Add-on Is Working.

 

It Gives an Error -131 TAO NT Naming Services not Started in Licence Server. and Then Add-on Gives an Error For Send to Microsoft.

 

What is the Actual Problem i Can't Understand. So, Please Give Solution Which is Perfect to Solve the Problem.

SAP Business One 9.0, version for SAP HANA PL09 is already available, take the opportunity to upgrade to the latest patch of SAP Business One 9.0 version for SAP HANA and take advantage of the latest new features.

 

SAP Business One 9.0, version for SAP HANA PL09 is synchronized with :

  • SAP Business One 9.0 patch Level 08 and 09
  • SAP HANA SP06 Rev 69.
    Please don't use any other HANA revision in conjunction with SAP Business One 9.0, version for SAP HANA unless stated here or in the corresponding overview note for the specific version.

 

Please check the corresponding central notes for more details (A Hotfix has been released and provides some fixes to PL09, check the Hotfix note here below for details):

1968247 - Overview Note for SAP Business One 9.0, version for SAP HANA Hotfix 01 PL09 (S-user required)
1951776 - Overview Note for SAP Business One 9.0, version for SAP HANA PL09 (S-user required)

 

Main new features

 

Check the following links to learn more about the new features offered by SAP Business one 9.0 PL09, version for SAP HANA:

 

 

Several interesting and attractive new features are available from B1H 9.0 PL09. Here you have some of them but more information can be found in the

central note 1951776 - Overview Note for SAP Business One 9.0, version for SAP HANA PL09 (S-user required).

Test them all!!!

And some others not listed here...

 

How to perform a schema backup

How to import a schema with a different name

 

Important Notes

 


HANA Rev 69 important notes:

 

1983931 - Customized SAP HANA models disappear from the "Interactive Analysis" menu

Info.xml file format has changed (new property IAEnable added), follow this note to understand the right format required for importing SAP HANA models into B1.

 

1943067 - Recommended configuration setting when you upgrade HANA to version 67 or higher (S-user required)

To avoid possible statistics server problems (e.g. running out of memory), we recommend that you change some configurations in SAP HANA before upgrading to SAP HANA Revision 67 or any higher version.

 

1950647 - XSEngine does not send any response (S-user required)

If you experience problems with XSEngine after installing/upgrading B1H please check this HANA note.
This problem has been fixed with SAP HANA SP7 Revision 70.

I started out as a relative novice to SQL a few months ago. Now I use SQL queries in Business One almost daily. I wanted to share with you some of my most frequently used queries and why I like them. Just copy and paste these in to your own Query Generator

 

If you like SQL want to learn more we'd love to see you at the next Business One User Group at SAP UK: UK and Ireland SAP User Group - Developing, Benefiting and Serving the SAP User Community

 

We are on SAP 9.0 PL07

 

Open Invoices Not Emailed:

This query shows all AP Invoices added to SAP that are Open but have not been sent. It's easy to forget to send invoices and this report has helped us be more efficient. Please note we are using Boyum Print and Deliver module:

 

SELECT t0.DocEntry, t0.CardCode, t0.CardName, t0.DocDueDate as 'Due Date', t0.DocCur, t0.DocTotal

 

FROM OINV t0

 

WHERE t0.DocStatus = 'O' and (t0.Printed = 'N' and (SELECT count(*)

 

FROM [dbo].[@BOY_85_DEL_LOG]  s0

 

WHERE s0.[U_BOY_id]  = t0.DocEntry and  s0.[U_BOY_OBJECTID]  = '13' and  s0.[U_BOY_ACTION]  = 4) = 0)

 

Partial Stock Take

We needed a way to list items in stock AND items not in stock for stock taking so we can run an inventory report between locations. The Bin Locations Content report in SAP only shows items in stock:

 

select t0.ItemCode, t1.ItemName, isnull(t3.OnHandQty,0) as 'In Stock', t2.BinCode, t2.SL1Code, t2.SL2Code from OITW T0

inner join OITM t1 on t0.ItemCode = t1.ItemCode

inner join OBIN t2 on t2.AbsEntry = T0.DftBinAbs

left outer join OIBQ t3 on t0.ItemCode=t3.ItemCode and t0.WhsCode = t3.WhsCode

where t2.BinCode between [%0] and [%1]

order by t2.SL1Code, t2.SL2Code, t0.ItemCode

 

Items with No Default Bin Location

We want to report on all items in SAP not assigned a Default Bin Location. This has helped our Warehouse Manager to ensure ALL stock has a Default Bin:

 

SELECT T0.[ItemCode], T0.[WhsCode], T0.[DftBinAbs] FROM OITW T0 WHERE T0.[WhsCode]  = 'main' and  T0.[DftBinAbs]  is null

 

 

Purchase Invoice Analysis

The SAP Purchase Analysis report is in System Currency, mine is GBP. No use to me when I buy in EUR. This report shows all AR Invoices for a set period for a particular Business Partner in the currency on the Invoice (FC):

 

SELECT T0.[DocEntry], T0.[CardCode], T0.[DocDate], T0.[DocTotalFC]

 

FROM OPCH T0

 

WHERE T0.[DocDate] BETWEEN [%0] AND [%1]  AND T0.[CardCode] =[%2]

 

If you want to run the same report but on Purchase Orders, simply substitute OPCH for OPOR

 

Top 10 Customers (Thanks to Zal Parchem for this)

 

SELECT TOP 10 T0.CardCode, MAX(T0.Cardname) as Customer,  SUM(T0.doctotal) as "Amount(LC)"

FROM dbo.OINV T0

WHERE t0.docdate BETWEEN [%0] AND [%1]

GROUP BY T0.CardCode

Order by SUM(T0.doctotal) DESC

 

Sales History by Item Group

Yes I know this exists in Sales Analysis reports but I prefer my layout:

 

SELECT T0.[DocEntry], T0.[DocDate],T0.[CardName], T2.[ItmsGrpCod], T2.[ItemCode], T2.[ItemName], T1.[Quantity]

 

FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode

 

WHERE T2.[ItmsGrpCod] = [%0] AND T0.[DocDate] BETWEEN [%1] AND [%2]

 

Sales Orders with no SLP Code

Some of our Sales People forget to enter their name when adding a Sales Order. This handy report helps me identify these quickly and easily

 

SELECT T1.[DocNum], T1.[CardName], T1.[DocDate], T0.[SlpCode]

 

FROM OSLP T0  INNER JOIN ORDR T1 ON T0.SlpCode = T1.SlpCode

 

WHERE T0.[SlpCode] = '-1'

 

ORDER BY T0.[SlpCode]

 

If anyone has any suggestions on how to improve these, or you would like to share some of your own SQL Queries please feel free. It's good to share!



Re: Sales Process for the B1 Sales – A/R module

 

 

A default Sales Process in SAP B1 typically involves these stages within the Sales – A/R module:


Creation of a Sales Quotation for the customer. To begin the sales process in SAP Business One, you first need to create a Sales Quotation for the customer. The sales quotation contains the price your company offers for each of the products that the customer might be interested in. This helps the customer decide which products / services to purchase.

Creating a Sales Order.
When the customer decides to purchase the products from your company, you need to create a Sales Order. The sales order should contain the quantity and price that the customer has agreed to. Creating a sales order is an important part of the sales process, as it serves as a base for your company’s own Purchase and Production Orders too.

Entering the details of a Delivery Notice.
After the sales order has been successfully processed, your company should create a Delivery Notice in B1 to indicate that the product has been shipped and delivered to the customer. It should contain the necessary details of the product delivered to the customer.

Invoicing and billing to the customer.
Your company then needs to bill the customer by creating an A/R Invoice. This document is legally binding between the customers and your company. It provides the details of the products delivered, the amount of the customer owes for them. The data in this document is also updated and reflect in the Profit And Loss Statement of your company.

Accepting the incoming payment from the customer.
In this final stage of the sales process, the customer remits payment based on the invoice your company has previously sent out to that customer.



The following is a screenshot of the Sales – A/R module and the default Sales Order window:

 

AR SALES screen.jpeg

 

Hope that this document can provide some insights on the Sales Process in SAP B1 within the Sales – A/R module.

 

 

Regards,
Owen





Re: SAP Business One 9.0 Installation

 

Here is a demonstration of the installation steps of SAP B1 9.0 on Win 7 Enterprise as a standalone server:

 

  • The folder attributes of SAP B1 9.0 PL05 (51046461) consist of 2,988 Folders and 12,617 Files with a file size of 6.04 GB (6,496,952,172 bytes).

 

  • The SQL database version is: MS SQL Server 2008 R2.

 

  • The OS of this standalone server comprise of an Intel(R) Core(TM)2 Duo CPU P8600 @ 2.40GHz (with 4.00GB RAM).

 

For the first time new user, the Installation Wizard (autorun.exe) is recommended. The installation sequences are as follows:

 

Step 1. Server.

Step 2. Client.

Step 3. Integration Component.

 

Accordingly, run the autorun.exe to open the SAP B1 9.0 installation wizard and installing them as such.

 

Here are a few tips that you may want to bear in mind when you install the Server Tools component within Step 1:

 

  • If you have more than one Firewall software enabled on your server, it is recommended to disable them all.
  • When you enter the SQL Server name, do not enter any IP address, you must enter the server name and the instance name (e.g. SAPB1\SQLINSTANCE).
  • You must ensure that the SQL Server Browser service is active and set to automatic. If not, adjust the settings of the service, restart the server and re-install the SAP Business One again.
  • Ensure that the TCP/IP protocol is enabled for the SQL Server; double check it as such, do not assumed that it is always enabled by default.
  • When you are prompted to enter your SQL credentials, enter the SQL account credentials directly, do not populate it with your windows or network credentials.

 

Here are a few tricks that you may want to bear in mind when you install the Client within Step 2:

 

  • With the major Release 9.0, 32-bit and 64-bit versions of the SAP Business One client are available. You must install each version separately. You can install and run both versions on the same machine.
  • When referring to 32-bit or 64-bit versions of the SAP Business One Client Application, the 32-bit and 64-bit is only indirectly related to the Operating System on which the Clients are installed. On 64-bit Operating Systems both Client Applications can be installed.
  • One some workstations you might decide to install the 64-bit SAP Business One Client Application, on other workstations the 32-bit SAP Business One Client Application. On the server, you might decide to install both, the 32-bit SAP Business One Client Application and 64-bit SAP Business One Client Application.
  • When you run SAP Business One, you can use only SAP Business One add-ons valid for the version of the application you are running. If you are using the 32-bit version of the SAP Business One client, you can install and run only 32-bit add-ons. If you are using the 64-bit version of the SAP Business One client, you can install and run only 64-bit add-ons.
  • If you work with 32-bit and 64-bit SAP Business One Client Applications, you need to install both versions of the add-ons.
  • When you install SAP Business One Client (32-bit), the DI API (32-bit) is also installed together.

 

-----------------

 

If encountering an unsuccessful installation on the first try, follow this cycle and be persistent:

 

  • Document the entire installation process including the steps performed.
  • Disable all Firewall software and Anti-virus programs.
  • Enable the TCP/IP Protocol on the SQL Server.
  • Set the SQL Browser service to Auto Start.
  • Completely uninstall previous SAP B1 and any trace of current B1 residuals.
  • Delete the C:\Program Files (x86)\SAP folder.
  • Delete all SQL data files (.mdf /.ldf) that were associated with preceding SAP B1 installations.
  • Perform a few times of Registry Clean with system reboots thereafter.
  • Cold boot your system at least once.
  • Reinstall SBO 9.0 again!
  • Consider not using the Installation Wizard this time, start from the Packages Folder. Install the Server tools, then the SBO server, and then other components.
  • For password problems, open the SQL Management Studio, locate the list of server names in the server name column. Then, click Browse more and select the Network Server. Find the name of the server that you provided from installation. Select that Server and SQL user ID and password. After that, try the installation with new Server name.

-----------------

 

Follow these tips to handle the "... could not create database ..." errors:

 

  • Never attempt to install and concurrently running 2 or more versions of B1 on the same machine!
  • Always start with a 'clean' database for installation.
  • Always start a clean and new installation when encountering the same database errors!
  • Make sure removed all old database with the same name. Check with the SQL Server Management Studio to see whether there is any database with same name; if so, delete it within the SSMS. Also, Make sure deleted the SBO Common Database completely. After that, try to re-install SAP B1 again.
  • In case of .mdf and .ldf file names conflicts, login to the SQL Server Instance for SAP and locate the database "SBO-COMMON" and detach it by renaming its .mdf and .ldf files (or preferably delete the entire database completely). To make sure this step is done thoroughly, in the Object Explorer, right-click a Server and click Properties; in the Left Panel, click the Database Settings page; and in the Database default locations, view the current default locations for new data files and new log files that have been created -- locate files named: SBO-COMMON.mdf and SBO-COMMON_log.ldf, then rename them! Then, re-install SAP B1 again.
  • Check out SAP Note #1332369 for "...Could not create Database..." errors.
  • This is a helpful documentation for resolving installation errors.

-----------------

 

Follow the screenshots below as a guide to complete the installation:

 

32-bit-windows-7_4.jpg

 

B. Server components.jpg

 

C. Client components.jpg

 

D. Integration component.jpg

 

E. System Landscape Directory_2.jpg

 

Keep your b1siteuser password for requesting a license in the partner portal or customer portal.

 

When installation is successfully accomplished, you should be able to see your SAP Business One client with the new gold interface like this one:

 

F. SBO 9-Gold-Interface_3.jpg

 

Hope that this document can provide you with some insights on how to properly install the new release of SAP Business One 9.0!

 

Regards,

Owen

Actions

Filter Blog

By author:
By date:
By tag: