Author Archives: Natalie

Reporting for SAP Business One – what standard reports are available?

SAP Business One offers several reporting options – Crystal Reports for SAP Business One, SAP Business One queries, SAP Business One Drag and Relate, pivot tables and Dashboards. Let’s not forget that there are a number of pre-defined reports available in SAP Business One including:

Finance Reports  

  • Aging reports
  • Profit and loss
  • Balance sheet
  • Trial balance
  • Cash flow reporting
  • Budget reports
  • Bank reconciliation reporting
  • Comparison reports (compare one period to another)

Dashboards  

  • Cash Flow Forecast
  • Customer Receivables Ageing
  • Purchase Quotations
  • Sales Analysis
  • Service Call

Sales Opportunities Reports  

  • opportunities
  • Stage analysis
  • Pipeline
  • Opportunity forecast and forecast over time
  • Won and lost opportunities
  • Open and closed opportunities
  • Lead distribution over time

Sales and Purchasing Reports  

  • Open item list
  • Sales analysis (by customer and or by item)
  • Purchase analysis (by supplier and or item)

Business Partner Reports  

  • Activities overview
  • Inactive customers
  • Collection history

Production Reports  

  • Open works order
  • Bills of material

Service Reports  

  • Service calls
  • Service calls by queue
  • Response time by assignee
  • Average closure time
  • Service contracts
  • Customer equipment report
  • Service Monitor
  • Service calls
  • Open service calls
  • Overdue service calls

Inventory Reports  

  • Item list
  • Last prices
  • Inactive items
  • Inventory posting list by item
  • Inventory status
  • Inventory in warehouse
  • Inventory valuation
  • Serial number transaction
  • Batch (lot) number
  • Stock turnover analysis

Most SAP Business One reports offer you a number of choices per report. As an example look at the Sales analysis reporting – selection criteria below. You can run this report based on a number of different criteria – by customer, items or sales employee. The report can be run for different date ranges, with or without grouping, by salesperson and to include or exclude various properties. One standard report with a number of reporting options and criteria available for the user.

In summary – SAP Business One offers standard reports with multiple selection criteria and the opportunity to write your own reports using the SAP Business One Query Generator, Crystal reports for SAP Business One and Pivot tables.

SAP Business One Implementation – getting it right every time

If you are considering an implementation of SAP Business One let me start by congratulating you on your choice of product. SAP Business One is one of the best SME products on the market today. As you are reading this blog you might be at the early investigation stage for new business management software or you might be about to finalise your plans for the implementation of SAP Business One and you are searching the web for some implementation advice. The question we want to answer is – “I have a budget for implementation services – how do I ensure that I deliver on a budget”. What areas of the proposal should I focus on to ensure that I can best manage the implementation to a budget?

In my experience, the areas of implementation of any business management solution that causes the most budgetary scope creep are: data conversion, user acceptance testing, reporting and development.

It sounds obvious but let’s not forget that a good scope of work is critical to managing any implementation.

Areas of focus for this scope of works should include all areas of functionality but let’s focus our discussion on the areas of greatest potential scope creep:

  1. Data conversion – the team at Leverage has written a blog dedicated to data conversion so I won’t repeat what has already been written. The type of data conversion that you decide on together with your ability to provide good clean data from your legacy system will have a substantial impact on pricing and will help contain any scope creep.
  2. User acceptance testing – this is a critical component of any good implementation methodology. When the pilot system is installed it is critical that your users test the system in a “day to day working environment”. Don’t underestimate the need for a comprehensive user acceptance testing plan – what functionality will be tested by which users on what days?
  3. Reporting – SAP Business One has lots of really good reporting options – SAP Crystal Reports, SAP Business One standard reports, SAP Business One Query Manager, SAP Business One Dashboards, SAP Business One Excel Pivot tables etc. More than any other business management solution on the market today SAP Business One gives you a number of reporting options – this is one of the real advantages of partnering with the world’s largest provider of ERP (Enterprise Resource Planning) software. Even with all of these options available, reporting will require careful planning. What reports are required and in what format (mobile, printed, web) can have a substantial impact on implementation pricing.
  4. Development – SAP Business One offers some great development tools – the SAP Business One SDK (Software Development Kit) and the SAP Business One Integration Framework. There is a Solution Developers Network – where SAP Business One development teams can go online and share their experiences and ideas. Development for customers can range from simple add-on solutions to comprehensive integration and modular development projects. Development and integration work to any business management solution should be carefully scoped and tested.

Let’s not forget that when implementing a business management solution the involvement of the customer is critical – in fact, there are several areas where the customer can assist to reduce implementation costs.

A good implementation methodology, a solid scope of work and the commitment of your team and a good SAP Business One partner will ensure success every time.

SAP Business One Implementation Success – what resource is required?

When implementing SAP Business One or any other business management solution the question I often get asked is “what resource is required to ensure a successful implementation?”.

These are the key areas of implementation that customers should focus on to ensure implementation success:

  • Internal project management – your SAP Business One partner will provide project management resource to guide you through the project. Do not underestimate the importance of having your own internal project manager to manage budget, expectations, co-ordinate training and user feedback, track and follow up on user acceptance testing and report on progress to senior management.
  • Super users – make sure that you appoint super users to each functional area of your SAP Business One implementation (finance, sales, logistics etc.). Super users will take responsibility for co-ordinating training, user testing and feedback in their department.
  • Admin super user – SAP Business One has been designed for small to medium sized businesses. The total cost of ownership is relatively low when compared to other mid-market business management solutions. You can ensure a low cost of ownership by training one of your more technical users as a systems administrator. The systems administrator will take responsibility for day to day SAP Business One administrative tasks – setting up new users, basic support for user queries, user authorisations and reporting.
  • Senior management participation – all good implementation methodologies refer to the fact that buy-in from senior management is required for a successful implementation of business management solutions. I would argue that you need more than senior management buy-in – you need senior management input into some key design phases of the implementation. The amount of senior management participation required will depend on the size of your organisation. In smaller companies where the senior management are actively involved in several day to day business activities you will definitely want to make sure that the senior team is involved in the more strategic design workshops. If you do not involve senior management you might spend time configuring your solution only to find out that the end result is not what management want.
  • Get organised – a basic requirement that cannot be overlooked. SAP provides an implementation methodology for SAP Business One which includes templates for project plans, project minutes and step by step guides to assist with your implementation.
  • Scope of works – make sure that you and your SAP Business One implementation partner put together a comprehensive scope of works. The scope of works should include data conversion, reporting requirements, functional footprint and integration / development requirements. Once again the SAP Business One implementation methodology provides some good scope of works templates which can be very useful.
  • Phased implementation approach – depending on your timeframes and resource availability you might want to consider a phased implementation approach. Implement your critical business processes in phase one and include some of the nice to have aspects in a second stage implementation.
  • Set realistic goals – make sure that your go live date and implementation plans are realistic. Give yourself time for user acceptance testing and training.

The team at Leverage Technologies have successfully implemented more than 140 SAP Business One sites across Australia – if you want any additional implementation advice feel free to call us on 1300 045 046.

SAP Business One Dashboards – KPI Reporting when and where you want

SAP Business One offers Dashboard Reporting standard in the version 8.8+ SAP Business One Cockpit. SAP Business One delivers a number of standard dashboards and you can also write your own user defined SAP dashboards. The dashboards present graphical KPI (Key Performance Indicator) information. Dashboards currently available include:  – customer receivables ageing,  – cash flow forecast,  – sales analysis,  – purchase quotations and  – service call reporting.

The dashboards have been available for some months now and we are getting some really positive feedback from customers who are using standard (SAP delivered) and their own user defined (developed by the reporting team at Leverage) dashboards. SAP Business One users have been especially impressed by the use of the dashboards with mobility (iPhone and iPad). This has provided our customers with the ability to check sales, finance and other operational KPI information when travelling, from home or at a customer site. All from the iPad or iPhone.

Imagine the power of dashboards delivered to your mobile phone. When you are travelling inter-state and you have an hour free at the airport you can check up on your latest sales figures or debtors ageing. Then create an activity using SAP Business One CRM for a team member back at the office to follow up on. SAP Business One mobility, dashboards and CRM – working together to make your life easier.

 

SAP Business One implementation pricing and success – don’t ignore data conversion

Implementation pricing for SAP Business One will depend on a number of factors including data conversion. What data is being imported from legacy systems could have a substantial impact on implementation pricing. “Master data” and or “transactional data” is a defining question when it comes to data conversion. Master data refers to the importing of debtor and creditor/business partner information, item master etc. Transactional data import refers to accounts receivable and payable invoices, sales orders etc. The good news is that SAP Business One offers a DTW (Data Transfer Workbench) – which is very useful for importing of legacy data. The Data Transfer Workbench provides Excel-based templates for the data import from all key business areas including finance, purchasing and sales. The data transfer workbench can be used for importing both master and transactional data into SAP Business One.

The type of data that you need to import into SAP Business One will depend on many factors – the industry within which you operate (for example traceability in the medical device industry might dictate that you have to keep several years’ history on file), sales reporting requirements and service/warranty requirements for equipment that you have sold. Data conversion and the associated SAP Business One implementation pricing can be defined in three broad categories:

  1. Simple data conversion – master data converted from the legacy system to SAP Business One. Use is made of the SAP Business One Data Transfer Workbench. As the customer, you will need to export data from your legacy system into Excel Spread Sheet formats which are pre-defined in the Data Transfer Workbench. Your SAP Business One implementation partner will check the data with you and will then upload the data into SAP Business One.
  2. Typical data conversion – includes the above-mentioned master data conversion plus current open documents – for example at the time of go-live all open purchase orders, sales orders, accounts payable and accounts receivable invoices are imported into SAP Business One. You might also want to include a user-defined table which holds historical summary transactional information. This will allow you to run prior period comparison reports for example sales analysis and profit and loss comparing a current period (running SAP Business One) Vs a previous period (running your legacy system). In this scenario, transactional data is not imported at a detail level (only summary information is available). Information like equipment cards and previous warranty information could also be imported into SAP Business One for tracking of warranty, project services and equipment services.
  3. Total data conversion. This would involve the importing of full detail transactional data and master data from legacy systems. As an example, this would allow you to drill down to invoice and line item detail level for invoices several years old (from your legacy system). Whilst it is certainly possible to get this level of detail from legacy systems the costs can outweigh the benefits. If you still have access to your legacy systems then it would be more cost-effective to simply access the old system if you need to re-print an old invoice.

Whether you choose the simple, typical or total data conversion type will depend on your specific requirements but here are a few tips and tricks to help you get the most from your data conversion.

  • Ask your SAP Business One implementation partner for the pre-defined SAP Business One Data Transfer Workbench templates so that you know what data needs to be exported from your legacy systems. This will also assist with formatting into SAP Business One.
  • Before requesting a data conversion make sure that you understand exactly what information you want to be converted and why.
  • Assist your SAP Business One implementation partner to check all data before and after the data conversion. Nobody knows your company data better than your in-house users – get your team involved in checking the data through user acceptance testing.
  • Do a trail conversion first.
  • Accept that some data might be better manually entered. If at go-live date you only have a low volume of purchase orders then it would be easier and more cost-effective for a user to enter the purchase orders directly into SAP Business One. This is a great way for new users to get experience with the new system.
  • Scope of works – discuss your data conversion requirements with your SAP Business One implementation partner and make sure that you agree with a scope of works for data conversion.

In summary – SAP Business One provides some great tools to assist with data conversion. Plan ahead, be as organised as possible, get involved in testing and you will reduce your implementation pricing and will ensure a smooth transition to go live.

SAP Business One Drag and Drop from MS Outlook

In SAP Business One  – all marketing documents now come with a new “attachment” tab. With this users can now “drag and drop” MS Outlook mail to this attachment tab in marketing documents. This link is saved automatically in the attachment tab and the documents are saved in the attachment folders (that you specify under General Settings).

Documents can be attached to most data areas – for example business partners and products.

SAP Business One 8.81 Attachments

As well as attachments on all marketing documents you can also use attachments for:

  • AR / AP Quotes, Orders, Deliveries, Returns, Invoices, Credits
  • Inventory – Receipts, Issues
  • Production – Receipts, Issues
  • Service calls

 

To create an attachment from MS Outlook you simply drag and drop from MS Outlook into the marketing document.

SAP Business One 8.81 attachments

Prerequisites include – SAP Business One 8.81 patch level 8+, MS Outlook and configuration of the attachments folder in SAP Business One. (Administration – System Initialization – General – Settings – click on the “path” tab and set up the attachments location. More great functionality from the team at SAP……..SAP Business One 8.81…….

SAP Business One workflow and approvals

SAP Business One offers built in workflow and approvals. You can use the SAP Business One workflow templates to manage your workflow in several different areas – purchase orders, sales orders, inventory movements and outgoing payments. You can use the SAP Business One standard workflow templates or create your own workflow.

The approval procedures functionality includes: – Approval stages – how many stages are required in the approval process? – Approval templates – use the SAP Business One approval templates to quickly configure approvals. – Reporting – approval status report and approval decision report.

A typical scenario might be approvals required for all purchase orders above a certain value or approval required if the document total is a deviation from budget. These approvals are very easy to configure using the SAP Business One approvals template. Simply decide who the originator should be, the relevant documents that will require approval, how many stages you want in your approval process and the terms.

When a user enters a document (for example a PO above their authorisation limit) the PO will be saved as a draft and a message will appear notifying the user that the document requires authorisation. The user can enter their remarks for the authoriser.

The approver receives a notification that there is a document which requires approval. The approver can either approve or decline the request.

Available reports include an approval status report to review the status of approvals based on pending, generated, approved, generated by authoriser, rejected and cancelled status.

Some scenarios where you might find approvals in SAP Business One useful include : – Purchase orders above a certain value, – Sales quotations and / or sales orders below a certain % gross profit, – Deviation from budget, – Deviation from credit limit.

The team at Leverage has also created an on-line demonstration of SAP Business One workflow.