Clients First USA
Clients First knows their software, but they are also astute business people, and they really understand manufacturing and distribution in particular.
Jimmy Witcher, COO, Merrick
Read More
About UsService OfferingsProduct OfferingsIndustries ServedDownloadsBlog
 

Subscribe to our mailing list

* indicates required
    Interested in    
Hot Topics
 

Posts Tagged ‘Accounting software analysis tools’

SAP Business One 8.8 Dashboards

Monday, August 2nd, 2010

SAP recently announced that service update 12 will include a new “Dashboard” feature in the solution.  In this release the ‘Dashboards’ are more for demonstration and testing purposes but it shows you what you will be able to do soon.

They recorded a webinar/video which I have posted in hi-def on youtube.  To check out how the dashboard feature works, see below:

How to use Pivot Tables in Excel

Friday, July 17th, 2009

Here is an ‘oldie but a goodie’ from our original site that we’ve had people ask for often.  This is more relevant for Microsoft Office 2003.  These can be used nicely with all our ERP packages including:

  • Microsoft Dynamics NAV (Navision)
  • Microsoft Dynamics AX (Axapta)
  • Microsoft Dynamics GP (Great Plains)
  • Microsoft Dynamics SL (Solomon)
  • Sage MAS90, MAS200, MAS500 (MAS 90, MAS 200, MAS 500)
  • SAP Business One

PivotTable Reports 101

Let’s suppose you’ve compiled a large list of data – for example, sales figures for every product your company makes. But now you’re ready to distill some meaningful information from the data. For example, you might want to answer the following questions:

· What is the total sales for each product by region?

· Which products are selling best over time?

· Who is your highest-performing salesperson?

For these and other questions, you can create a PivotTable® report – an interactive table that automatically extracts, organizes, and summarizes your data. You can then use the report to analyze the data – for example, make comparisons, detect patterns and relationships, and analyze trends.

pic1

Read on to discover what you can do with a PivotTable report.

(more…)