Contact us today: (866) 4-WEBSAN (932726)  Support

Microsoft Dynamics GP

Microsoft Dynamics GP (70)

Friday, 26 July 2013 12:00

Have a Dynamics GP Suggestion?

Written by

Do you have a suggestion for an improvement to Dynamics GP.  Let Microsoft know via Microsoft Connect:

connect.microsoft.com/default.aspx

Adam MacIntosh is  a Senior Project & Account Manager with WebSan Solutions Inc.

Wednesday, 31 July 2013 06:06

Excel Based Journal Entries

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Most office staff today perform a lot of analysis in Excel.  Staff are comfortable in Excel & familiar with its various functions.  As a result, staff may prefer to upload general journal entries through an excel based template.  Many times, large entries, such as those to a payroll clearing account, may need to be calculated in Excel before they can be entered in the system.  When staff already have the entry in Excel, its very convenient to be able to directly upload into GP.  As such, WebSan offers it's clients an Excel based Journal Entry upload tool capable of handling multiple journal entries spanning as many lines as required.

All customers should ensure their ERP partner / VAR offers the same baseline functionality in their system.

 

GL Upload

 

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Friday, 02 August 2013 12:16

Why Doesn't my GL Match my Sub-Ledger?

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Many times, usually around month-end, I will get a call from a client that has a mis-match between their sub-ledger balance & their General Ledger.  The first thing I will ask them is whether or not all batches in their Financial Series Post are posted.  You can see from the screenshot below that GP will automatically create a number of batches in the Financial module after transactions have been posted in the Sales or Purchasing modules.  Company configurations can vary, however, in general, a transaction posted individually in a subsidiary ledger will have to also be verified & posted in the Financial Series Post before it will affect the GL.  Most transactions that are saved in the Financial Series Post have already affect the appropriate sub-ledger but NOT the General Ledger.

I advise clients to clear out all entries in the Financial Series Post daily to ensure accurate reporting and to be able to deal with any issues as they arise.

[caption id="attachment_1323" align="aligncenter" width="300"]Financial Series Post Financial Series Post[/caption]

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Wednesday, 07 August 2013 01:00

New Installation Tip - Invoice Alert

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Dynamics GP allows users to enter invoices through a number of different methods.  When first accessing the invoicing windows in GP, users will often encounter a system alert warning them of the fact that they have multiple windows with which to enter the data.  Without intervention, this warning will always appear for users moving forward.

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, the warning will be gone forever.

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Sunday, 11 August 2013 06:30

Using Checklists in Dynamics GP

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

In October 2009 I wrote a blog about using Checklists in GP.  I find this blog is still useful today as I have clients wherein turnover has forced the need to document processes within the system.  Checklist are the perfect tool to allow these processes to be documented.  See my blog below:

 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.

Payroll Checklist

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Friday, 13 September 2013 07:59

Source Document / Batch ID Naming in Dynamics GP

Written by

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

When a user posts an individual transaction in GP, that transaction will likely display in the Financial Series Post, saved to a batch with an odd, automated ID.  These IDs are auto-created by Dynamics GP & are based on the source document / originating module from which the transaction was posted.  Generally, the first 2-3 characters of the these Batch IDs are based on the module, with 3 or so more characters to identify the transaction type.  this is or course followed by a numeric counter.

If one reviews the Source Document listing in GP, that will generally tell them what all the abbreviations represent.  For those more technical, source documents can be found in SY00900 in the database.

Below, I have listed a number of the more common prefixes to an automated Batch ID and have noted the module which they represent.

 

CM Chequebook Management
CPY Canadian Payroll
DP Depot Management
FA Fixed Assets
IV Inventory
MC Multi-Currency
MFG Manufacturing
PA Project Accounting
PM Payables Management
POP Purchase Order Processing
RMA Return Materials Authorization
SC Service Call
SOP Sales Order Processing
UPR US Payroll

 

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Winner.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Often, clients will ask why a particular Cash Receipt is not displaying in the Bank Reconciliation when it comes time to close the month.  Many times, users will forget that a Bank Deposit is required before the transactions will display in the Chequebook subledger.  This is an important security step as the same person receiving funds should not be the same person depositing those funds into the bank.  Further, cash receipts are often grouped together when deposited into the bank, thus, making one single large bank transaction instead of many small transactions which may need to be reconcile.

To complete a Bank Deposit, navigate to Transactions > Financial > Bank Deposit.  In this window, you will find three Types:  Deposit with Receipts, Deposit without Receipts, Clear Unused Receipts.  We recommend all clients use only Deposits with Receipts as this forces users to perform Cash Receipts from a Customer in order to deposit funds into the Bank.  Depositing without Receipts can cause differences between the General Ledger and the Chequebook subledger due to the fact that the Bank Deposit Entry window does not have General Ledger distributions associated with it.  Clear Unused Receipts only applies to situations where a Cash Receipt should not be deposited in the Bank which can also lead to differences between the General Ledger and the Chequebook subledger.

[caption id="attachment_1518" align="aligncenter" width="300"]Bank Deposit Bank Deposit[/caption]

Adam MacIntosh is a Senior Account & Project Manager with WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Winner.  Adam can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 213.