Skip to main content

GP 2010 - Security Upgrades (Part 2)

In previous versions, users would be able to view the module's Navigation Pane regardless of whether it was used or not.

In GP 2010, Administrators control which Navigation Panes are available to users and which are not.  Unnecessary navigation buttons can be limited at the user or at the company company level.

Again, join WebSan in our upcoming GP 2010 Webinar!

PS ... For Analytical Accounting users, user security can now be assigned on-the-fly!  No more setting up segments & then waiting for approval to use them.

  7532 Hits

Using Dynamics GP on the Go

Want to access Microsoft Dynamics GP data on your mobile device?  Upgrade to Business Portal!

Through Business Portal, users can access data from Microsoft Dynamics GP without logging into the system.  Instead, the data lives on-line, making it accessible through mobile devices such as a Blackberry.  Simply configure your mobile device to access your company VPN & your off!  You don't have to be chained to that desk anymore!

  8095 Hits

Checklinks

As a Microsoft Dynamics GP implementer, I run into a number of issues that the everyday user never sees.  One such issue can occur when mass loading data, updating the system through the database (not recommended!) or just through normal business processes.  Errors happen!  Sometimes, the best intentions don’t go unpunished.

Why?  When data is entered in GP, multiple tables are populated with the data, not just one.  Everything is linked.  That’s the beauty of an ERP system.  But sometimes, wires cross & fixes are needed.

The Checklinks tool helps examine the links between related information, helping to restore any damaged data.

Even before problems arise, Checklinks can be used for general clean up.  Be sure to make a backup of your data prior to using the functionality, just to be safe.

  8692 Hits

Emailing Customer Statements

I am constantly searching for ways to help my clients save money & improve performance.  Often the answer includes automating a particular process.  One of such process includes Emailing Customer Statements.  For clients with a large number of customers, the savings can be extensive.  Clients save on paper, ink, wear & tear on printers, envelopes, postage & most importantly, employee time.

Automating the customer statement process is very simple to setup.  First, enter the Customer Maintenance window & click Options.  Enter the email contact for the customer in the ‘To’ box in the bottom right corner of the screen & check the ‘Send Email Statements’ check box.  Now, when creating customer statements, check the ‘Send Email Customer Statements’ under the Email Options heading.

The return on users’ time investment will be realized after the first statement run.   So automate the process of sending customer statements & free up your time for more important tasks.

  16482 Hits

FRx Calculations

For more advanced FRx users, I thought I would cover some calculation formulas that are available for use in FRx.  Much of FRx is fairly self explainable & easily learned with a little exploration.  One topic I had a little trouble with when first learning the system was Calculation Formulas on Row Formats. 

Simple adding & subtracting are fairly self-explanatory.  Simple take the columns to add & place a plus sign between them.  For example, B + C. 

However, did you know FRx can perform complex calculations such as adding & multiplying all at once.  The formula (A+((B+C/2)+(C*.8)/2))+(F TO H) is a valid entry.

IF/THEN/ELSE Statements are another handy tool.  These allow one to build logic into the column.  For example, the formula "IF B>1000 THEN B ELSE C*2" translates to:

If the amount in column B is greater than 1000, place the value from column B in the CALC column. If the value is not greater than 1000, multiply the value in column C by 2 & place the result in the CALC column.

Continue reading
  15623 Hits

Year End Procedures

Year-End can be a hectic time for all & it is fast approaching.  In many instances, we are tired from or preparing for the holidays.  Everyone is out of their routine & sometimes, performing tasks they only think about once a year.  Here is a brief summary of performing year-end in any ERP system.

Prior to performing year-end tasks:
1 - Post all receivables, payables & financial transactions.  Future dated transactions should be held off if possible until after the year has closed.
2 - Perform a stock count, send out customer statements & complete all reconciliations
3 - Make any adjusting entries needed.
4 - Print necessary reports to maintain in the companies permanent records for audit trail purposes
5 - Make a backup of company database before starting the year-end processes.

Ensure all users are out of the system when performing year-end processes.  Additionally, users are often given the opportunity to purge obsolete records during the year-end processing.  One should consult company policy & ensure local law reporting laws are followed prior to deleting any records.  Once complete, it is good practice to close old fiscal periods from posting to prevent any accidental postings.

  7076 Hits

Year End Timeline

Here is a brief timeline I have put together to help users determine when to process Year-End closing routines.

  6849 Hits

Printing Reconciliation Report

Do you often find yourself canceling reports that automatically print after you have posted a document?  Or even changing the default destination of these reports?  Well, one can set the default destination of these reports or even stop them from printing all together.

Try entering  the Posting Setup screen (Microsfot Dynamics GP > Tools > Setup > Posting > Posting).  In this screen, you can select whether or not a specific report will print by selecting or de-selecting the checkbox in the Print column.  Also, one can specify destination for a report by making the appropriate selection in the Send To column.

See the attached screenshot below & save yourself all that extra clicking when you next post a transaction.

  8153 Hits

Printing Invoices (Quickly!)

Next time you are printing Sales invoices, try this time-saving alternative:

Select Options > Quick Print, or simply CTRL + Q on your keyboard

This will print your invoices according to the settings in the Quick Print Setup screen (also under the Options menu).  Default can be created for:

· Orders
· Invoices
· Packing slips
· Picking tickets

Select a print Destination & number of copies to be printed.  Print options available for documents are:

Continue reading
  7486 Hits

Checklists

Lots of us make checklists for a variety of tasks from grocery shopping to complex projects.  Microsoft Dynamics GP offers built in checklists in the Routines section of every module that can help walk users through a diverse range of topics.

Once you have accessed the appropriate Checklists window, ensure the frequency is appropriate for the checklist you are about to create.  Click Add to create a link to a Microsoft Dynamics GP window.  Name the checklist item & select the appropriate in the Command (Dynamics GP window).  Once your list is complete, order the items appropriately by using the Up & Down buttons.  Now every time a user performs this particular task, all they are required to do is click the checklist item in order & populate the fields with new data.

Checklists are particularily beneficial when turnover is an issue or roles require extensive training.  Two tasks I recommend clients create checklists for are performing payroll & completing year-end.  Mistakes made performing either of these functions can have wide-reaching effects.  In my next blog, I will cover a few tasks that should be on your year-end checklist.

  9174 Hits