Microsoft Dynamics GP

/Microsoft Dynamics GP

Security Tips in Microsoft Dynamics GP

By |November 13th, 2015|Blog, Microsoft Dynamics GP|

Since security has become more complicated in Dynamics GP, there are times when it becomes difficult to figure out what tasks a user needs assigned in order to access a certain window. In the beginning of this blog post, we will show you the detailed information and how we previously did this. In the later half [...]

Management Reporter Tips and Tricks – 49. P&L Check Figure

By |November 10th, 2015|Blog, ERP Events, Microsoft Dynamics GP|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on P&L Check Figure. Ever wonder if you are pulling all the GL accounts and your formula is working correctly in your P&L row definitions? Add a check figure to validate and warn you if there are accounts missing, duplicated, or if the formulas are wrong. [...]

Management Reporter Tips and Tricks – 48. Web Viewer Default

By |November 1st, 2015|Blog, ERP Events, Microsoft Dynamics GP, Microsoft Dynamics SL|

Here's this week’s Management Reporter tip for Microsoft Dynamics ERP: Do your reports keep opening up in the web viewer like below? Change your default to the MR Report Viewer in the Reporter Designer under Tools. This will have a few more options available that the Web viewer does not have. This tip, and many [...]

Management Reporter Tips and Tricks – 47. Wrap Text

By |October 27th, 2015|Blog, ERP Events, Microsoft Dynamics GP, Microsoft Dynamics SL|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on the Wrap Text feature. Wrap Text – This feature is in the column definition and prevents the row description from being cut off, as illustrated below. Column Definition: This tip, and many more, are covered in our Management Reporter training class held each month. [...]

Management Reporter Tips and Tricks – 46. Renumber Row Option

By |October 20th, 2015|Blog, ERP Events, Microsoft Dynamics GP, Microsoft Dynamics SL|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on the Renumber Row Option. Renumber Row Option – Found in the Row Definition Edit/Renumber rows. It will also renumber formulas. The Renumber Row Option is a very nice feature for those accountants that like good organization in their reports. Before: After: This tip, and [...]

Pumpkins, Piercings and the Paranormal: 10 Scary Ways States Apply Sales Tax

By |October 15th, 2015|Blog, Microsoft Dynamics GP, Microsoft Dynamics NAV, Microsoft Dynamics SL|

Reposted from Avalara Bwaahahaha! Is that the ghostly laugh of a Halloween haunt — or the auditor reviewing your sales tax returns? Dealing with sales tax can be a ghoulish task. And for businesses with compliance obligations in multiple states, it can be frighteningly difficult to know which rules apply. Take pumpkins, for example. Nothing [...]

Management Reporter Tips and Tricks – 45. Zero Value Override

By |October 13th, 2015|Blog, ERP Events, Microsoft Dynamics GP, Microsoft Dynamics SL|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on Zero Value Override Text. Zero Value Override Text – Allows you to override a zero value in the format of a row or column with a text such as “N/A”.  This is very useful if your report is set to show blanks for zero, [...]

Management Reporter Tips and Tricks – 43. Column Restrictions for Rows

By |September 29th, 2015|Blog, ERP Events, Microsoft Dynamics GP, Microsoft Dynamics SL|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on Column Restriction for Rows. Column Restrictions for Rows – Restrict data and formats to specific columns on the report as illustrated below. Row Definition:             Result: This tip, and many more, are covered in our Management Reporter training class [...]

Management Reporter Tips and Tricks – 42. Dynamic Headers with CALC

By |September 22nd, 2015|Blog, Microsoft Dynamics GP, Microsoft Dynamics SL|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on Dynamic Headers with CALC. Dynamic Headers with CALC – If you want the auto text to populate in the column header for a calculated column, you will need to define the Fiscal Year and the Period, as highlighted in the illustration below. Column Definition: [...]

Management Reporter Tips and Tricks – 41. Calculations on Hidden Columns

By |September 15th, 2015|Blog, ERP Events, Microsoft Dynamics GP, Microsoft Dynamics SL|

This week’s Management Reporter tip for Microsoft Dynamics ERP is on calculations on hidden columns. Calculations on Hidden Columns – When using non-printing rows that you want to be included in the calculation you need to specify the columns individually B+C+D. When you want a total for only the rows displayed on the report use [...]