MAY
07

GP 2010 - Negative Cash Receipts

Cash receipts may now be entered as a negative currency value within GP 2010.  This will subsequently decrease the deposit amount of the cash receipt by the value entered in the Amount field.  Furthermore, the posted receipt will show up as a deposit with a negative amount.

The negative cash receipt can be applied similar to any regular cash receipt, except the outstanding amount of the invoice will increase, instead of decrease.  Users experiencing returns, bad debt or miscellaneous fee issues will undoubtedly love this new feature.

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at Adam.MacIntosh@WebSan.com or at 416-499-1235 ext. 213.

  15039 Hits
MAY
10

GP 2010 - Security Upgrades (Part 1)

System Administrators will find setting up new users in GP 2010 much quicker.  User Security setting can now be copied from the security of another user.

In order to help reduce the likelihood of incorrectly assigning permissions, Administrators can filter security windows in order to view only the selected:

  • Operations assigned to tasks
  • Tasks assigned to roles
  • Roles assigned to users

Adam MacIntosh is the Senior Implementation Lead with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems and Supply Chains. You can contact Adam at Adam.MacIntosh@WebSan.com or at 416-499-1235 ext. 213.

  6537 Hits
MAY
12

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.

  6705 Hits
NOV
30

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!

  7344 Hits
OCT
23

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.

  7907 Hits
OCT
02

WebSan Solutions certifies Microsoft Dynamics GP interface for CSA Software Solution

WebSan assisted Mercury E-Portal Solutions Inc. in certifying a Microsoft Dynamics GP standard interface to it's CSA Software Solution.

See the full blog press release here : Mercury E-Portal Solutions Blog

The press release is on PRWEB here : PRWEB MEPS Press Release

  5924 Hits
OCT
28

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.

  15362 Hits
NOV
02

Exporting FRx Statements

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

FRx is the standard financial reporting tool utilized by most Microsoft Dynamics GP users for financial reporting.  FRx links directly into the general ledger to allow the creation of endless types of reports.  These report are then viewed in the FRx DrillDown Viewer.  Users I have spoken to in the past have expressed that they are more comfortable viewing reports in Excel.

To take your FRx financial report & export to excel:
1 - Generate the report
2 - In the DrillDown Viewer, select File > Export > Worksheet File > Formatted Excel
3 - Save the report to its desired location

This quick & easy trick should save you time & energy in attempting to convert your reports.

 

Continue reading
  7881 Hits
NOV
05

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
  14579 Hits
DEC
03

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.

  6230 Hits
DEC
07

Year End Timeline

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

  5960 Hits
NOV
11

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.

  7318 Hits
NOV
19

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
  6738 Hits
SEP
24

Aging Documents

Everyone is different.  The same goes for clients, who often asked me how to modify aging periods.  Most Dynamics GP users stick with the standard 30/60/90 day aging periods for both receivables & payables.  However, many businesses have the requirement to insert a 45-day break into the aging process.  This is a two-step process wherein users often forget the second step.

Begin in the Setup menu, selecting either Purchasing & then Payable or Sales & then Receivables. You will find the ability to add up to a total of seven aging periods.  One can adjust aging periods here as desired.  The second (and more difficult) part of the process involves modifying your reports.  Standard GP reports only display four aging periods.  If your company inserts a fifth period, the last period will populate with the report but will not be printed.  If you have experience in Report Writer, you should be comfortable changing the necessary layouts.  If not, try contacting WebSan.  We are experienced in helping companies with this very issue.

  6692 Hits
OCT
06

System Alerts

“Corporate Accounts Payable, Nina speaking, just a moment.”  If you’ve ever seen Office Space, you know how annoying THAT person can be.  What if your system did that same thing?

Dynamics has a small quirk that can annoying to those in Accounts Receivable.  Since invoices can be entered in multiple windows.  Both the Sales Transaction Entry & the Invoice Entry windows perform the same essential function of populating sales invoices.  As such, Dynamics warns users when entering these windows.  Well, that warning can become annoying after viewing it for the 463rd time.  To get rid of this warning, run your GP Utilities (from your Start menu).  In the Additional Tasks window, select the ‘Remove SOP and Invoicing message’.  Proceed to uncheck ‘Warn in Sales Order Processing’ & ‘Warn in Invoicing’.  When complete, your little annoying warning will be gone forever.

  6552 Hits
OCT
08

Setting the Default Company in Business Portal

Earlier this week, I talked about annoying configuration that can be found in Dynamics GP.  I tried to show that users don’t have to be annoyed because they are the ones that control what the system does.

A similar situation exists in Business Portal.  Recently, I was watching a client access Business Portal & every time they entered the system; they had to change the Company ID.  I explained to them that this is easily configurable in the system.

To set your default company, select the Welcome drop-down menu from the top right corner of the screen while in Business Portal.  Select My Business Portal Settings & adjust your default company as desired.

  8808 Hits
SEP
29

Write-Off Documents

Take a penny; leave a penny.  I think these are the greatest invention.  Personally, I don’t carry change.  When offered 2 cents change, I usually tell the clerk to keep it.  The only time this comes back to hurt me is when I’m short a cent or two.  That’s where the beauty of the ‘take a penny; leave a penny’ system shines.  It helps people avoid breaking a bill only to receive a bunch of coins. 

The worlds of ERP & accounting have their own ‘take a penny; leave a penny’ jar.  Writing-off immaterial amounts of money is a common practice that occurs when small over or under payments are made.  To access the Write Off Documents window in Dynamics GP, look in the Sales Routines.  This window will create debit or credit memos that are then posted & applied to the documents you’re writing off.

Using this window is fairly simple for most novice GP users.  Select the Write-off Type, Write-off Limit & other restrictions as appropriate.  I advise using the Preview button as it provides a listing of documents to choose from.  Click Process when you are ready. 

Note:  This screen does factor in Maximum Write-off from the Customer & Vendor Options.

Maybe you have an inactive customer that has a very small balance remaining on their account or you accidentally underpaid a one time bill by a small amount … write-off these documents & clean up your system.

Continue reading
  10302 Hits
OCT
13

Correcting Entries

Normally, once an item is posted, it is in the system.  Posting is the be-all & end-all.  It is kind of like writing with pen.  And let’s just say, there is a reason they invented whiteout.

Dynamics GP does have an exception to the posting rule in the form of Correcting Entries.  The one caveat is that only open year General Ledger entries can be corrected.

To make a correcting entry, select Transactions > Financial > Transactions.  Click the Correct button.  Select an Action of:

Back Out a Journal Entry
Or
Back Out a Journal Entry and Create a Correcting Entry

Select the appropriate journal entry to correct using the lookup feature & select OK.  Remember, only general journal entries can be reversed.  Review the Batch ID in the lookup window to determine if an entry is a general journal entry.

Continue reading
  6284 Hits
OCT
01

The Future of Dynamics GP

Last week, I wrote about the major benefits of upgrading to Version 10 of Dynamics GP.  This had me thinking about future releases of GP & what they would have in store.  Peering into their crystal ball, Microsoft let their Partners know what exactly they foresee for the future of Dynamics GP.

SP4 for Version 10 is the last service pack users will be seeing for a while.  This is because in the second quarter of 2010, Microsoft will release Version 11 of Dynamics GP.  Highlights include Role Tailored Business Intelligence & further integration with Microsoft Office.  Then around 2012 or 2013, Version 12 of Dynamics GP will be released.  The focus of this release will be on improving user productivity & the simplicity of the system.  This is all in an effort to further target mid-market buyers of ERP software; a market Microsoft feels they have a competitive advantage in with Dynamics GP.  Lastly, 5-6 years down the road, Microsoft will release Version 13.  This version will have a revamped user interface as well as incorporate the next generation of Microsoft technologies, potentially a large shift for many users.

As always, if you require assistance, WebSan has years of Dynamics GP expertise & (Microsoft Certified) knowledge to help clients with both upgrades & implementations.  Feel free to contact us with your support issues.

  6102 Hits
OCT
15

Editing Posted Documents

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Following with the theme from my last blog, I will continue my discussion on correcting posted transactions.  Both Receivables & Payables documents can have certain information edited after they have been posted.  Documents can have the following four fields edited after they have been posted:

  • Discount Date
  • Due Date
  • PO Number
  • Description

To access these screens, select Edit Transaction Information under either Sales or Purchasing Transactions windows.  Select the appropriate vendor or customer document to edit & make the necessary changes.  This tool is handy for those that base collections, payment or other information on these details.  Just ensure only the appropriate parties have access to modify this data.

  7205 Hits

Multi-Award Winning

Gold Microsoft Partner

Microsoft Partner of the Year

Dynamics 365 Business Central

Microsoft Canada Impact Award

Business Applications

Microsoft Inner Circle

Business Applications

© Copyright 2023 WebSan Solutions Inc.WEBSAN is a trademark of WebSan Solutions Inc. Registered in Canada and other countries.