majormajor

/Complete Software

About Complete Software

This author has not yet filled in any details.
So far Complete Software has created 99 blog entries.

Microsoft Excel Tip #7

  Tip #7 - Calculating Difference in Time   To calculate the difference between hours, use: =(End Time - Begin Time)*24   To calculate the difference between days, use: =End Date - Begin Date   To calculate the difference between work days, use: =NETWORKDAYS(Begin Date, End Date)   To calculate the difference between months within the [...]

Microsoft Excel Tip #7 2017-08-02T13:58:01+00:00

Microsoft Dynamics GP Tips and Tricks

  Article #3 Find information using the Any Field in SmartList. SmartList allows you to search an “Any Field” option.  Open your SmartList, go to Search, and use the lookup button on the field filter.  Make sure the Columns window is set to “All Columns” and search for the “Any Field” field name. Once selected [...]

Microsoft Dynamics GP Tips and Tricks 2017-08-02T13:58:01+00:00

Microsoft Excel Tip #6

  Microsoft Excel Tip #6 In this blog we will discuss multiplying arrays. First, set up your arrays with the data to be used. Then, you will want to select the 4x4 box (in this example) where you would want the matrix result to end up.         In the formula bar, you [...]

Microsoft Excel Tip #6 2017-08-02T13:58:01+00:00

Microsoft Dynamics GP Unable to Print to PDF

  Are you having a problem printing to a PDF file in GP? If so, we may have a solution that will help. When you attempt to print to PDF, review your file name. Have you included any invalid characters such as commas, slashes, quotations, etc.? If so, remove the invalid characters from your file [...]

Microsoft Dynamics GP Unable to Print to PDF 2014-06-20T20:51:20+00:00

Microsoft Excel Tip #5

  Tip #5 An IF formula is one of the most useful terms in Excel. It’s a conditional formula that allows you to calculate one way if something is true and another if something is false. =IF(condition, [value_if_true], [value_if_false]) The condition is the value that you want to test.  The value_if_true is the value that [...]

Microsoft Excel Tip #5 2017-08-02T13:58:01+00:00

Microsoft Dynamics GP Tips and Tricks

  Article #2 Bank Reconciliation – Reconcile to GL Did you know that in Microsoft Dynamics GP 2013, Microsoft has added a “Reconcile to GL” function for Bank Reconciliation?  In GP 10.0 they introduced the Reconcile to GL functions for AP and AR – and they’ve always been a huge time saver.  Now with Reconcile [...]

Microsoft Dynamics GP Tips and Tricks 2014-06-13T13:39:28+00:00

Microsoft Excel Tip #4

Tip #4 In order to generate a list of worksheet names: Open the workbook you would like a list of worksheet names for. Insert a new worksheet to hold the list of sheet names or navigate to the worksheet you want them to be listed on. Chose Formulas | Define Name to display the New [...]

Microsoft Excel Tip #4 2014-06-09T14:02:29+00:00

Simplifying the Geek Speak Series

Week #5 Welcome back to our new series of blog posts, Simplifying The Geek Speak!  Thanks for continuing to tune in.  For those of you just joining us…this blog is setting out to simplify the overly complicated. Recently I was helping a client with their computer.  The reason I was there was because the computer [...]

Simplifying the Geek Speak Series 2017-08-02T13:58:01+00:00

Microsoft Excel 2013 Tip #3

  Tip #3 Welcome Back to our Excel Tips Series. This week's tip has us pretty excited over here at Complete Software! Do you need to know the number of unique item combinations in a given set of data? You’ll be happy to know that Microsoft has added distinct count of values to Pivot Tables [...]

Microsoft Excel 2013 Tip #3 2014-06-02T18:13:44+00:00

Crystal Reports Shutting Down

  Are you having trouble running Crystal Reports? Are you attempting to print a report and finding that it fails and Crystal shuts down? If you are using Server 2012, it may be that you will need to re-install Crystal Reports and run it as administrator. To do this, you should first log on as [...]

Crystal Reports Shutting Down 2014-05-30T19:09:15+00:00