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 [...]
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 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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]