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
 

‘Microsoft Dynamics’ Category

Microsoft Dynamics NAV – Resources Around The Web

Monday, April 2nd, 2012

Comprehensive links and resources for Microsoft Dynamics NAV

 

We ran across a great post on a Microsoft blog site.  These links point to some of the worlds most popular Dynamics NAV (Navision) blogs and resources from around the web.

Click below to jump to the posting.  From there you can find the various sites.  Among them include tips & tricks, documentation, support etc.

We hope you find this useful.

Increase Customer Service and Profitability through Business Alerting

Tuesday, March 27th, 2012

Often when speaking to our clients, we hear of manual daily business processes that could easily be improve by becoming more automated.

After assessment of daily business processes to ensure the companies effectiveness in their usage of the ERP software; there is still an additional approach to unequivocally confirm the company is operating at maximum efficiency.

This approach is called KnowledgeSync Business Activity Monitoring

KnowledgeSync allows automating tasks and notifications including but not limited to:

  • Automatically create, fax or email invoices.
  • Monitor A/R aging and email/fax customers overdue statements.
  • Alert salespersons and schedule a call from A/R customer service.
  • Notify the purchasing departments of low inventory levels.
  • Automatically create PO’s based on inventory minimum requirements.
  • Track overdue deliveries.
  • Help the service department detect bottlenecked support calls assigned to individual technicians.

These are just a few of the many capabilities provided by this Business Activity Monitoring application.

Essentially KnowledgSync allows you to easily create alert conditions that can be automatically executed while watching for changing conditions in your business environment.

These Alerts are designed for distribution to the responsible personnel in real time. Multiple communication options allow for the most appropriate response via email, cell phone, fax or PDA.

KnowledgeSync can talk to your ERP applications like Sage MAS 90, MAS 200, ERP 100, ERP 500, Microsoft Dynamics NAV, AX or SAP Business one. It can simultaneously talk to any ODBC compliant database and combine data from multiple systems to determine when and how to fire alerts.

Simply stated… KnowledgSync works as your silent partner to help you run your business as smooth as possible in these times when every minute counts.  Call us if you would like to know more or see a demonstration.

How to use Pivot Tables in Excel

Monday, March 26th, 2012

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)
  • Epicor 9
  • 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…)

SaaS vs. Cloud ERP vs. On Premise Computing. Will 2012 be the big breakout year?

Sunday, March 25th, 2012

imageAccording to Panorama Consulting Group, a respected mid-market ERP think tank, they are starting to think so.  Eric Kimberling and I actually seem to have a pretty parallel feeling on the market.  Both of us felt the solutions were seriously overhyped.  However, based on more recent surveys, the various leads I’m seeing cross my desk, etc, I’m starting to think I may have ‘misunderestimated’ the growth.

Now, I want to be clear, I still think it will be a relatively small part.  In my opinion, less than 15% of all deals.  The survey says large numbers are considering ‘the cloud’ but I also have found many folks consider it because of the hype but when the run the numbers, realize that on-premise is often far less expensive over a 10 year cost calculation.  Read on for more.

(more…)

Adding a Field to a Form in Microsoft Dynamics AX

Monday, March 12th, 2012

How to add fields to forms in Dynamics AX (Formally Axapta)

The purpose of this blog is to give a brief overview of the process by which a user can add a field, whether it is a database field or a method, to an AX form. In this example, we will make two very simple modifications: We will add the Base Sales Price from the Price/Discount Tab to the grid in the Overview, and we will add a new check box to the grid that will indicate whether the item is a Web Store Item. Since “Web Store Item” is not an existing AX field, it will also need to be added to the database. AX2009 will be used and it is assumed that the user will have development rights in AX, and we will be placing the modification in the USR layer.

Let’s begin.

First, we’ll add the Base Sales Price to the grid. To do this, create a new project, and add the InventTable Form from the AOT to the Project. Once the form is in our project, we can create a copy of the existing Base Sales Price and add it to the grid.

clip_image002

(more…)