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

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Here are some of the new exciting General Ledger features that Microsoft Dynamics GP has to offer in its new release GP 2013 R2:

Dynamics GP users will now have the option to reverse the General Ledger Year-End Closing Process in order to open one or more previous historical years, whereas in previous releases one was not able to perform this, according to Andy Sather, member of the Microsoft Dynamics GP Community.

This feature will be very helpful in troubleshooting year-end closing issues as well as allowing users to post transactions to previously closed years. Remember to make restorable backups both before and after re-opening each year in case there are any issues. Be cautious, though, because this process will clear all Balance Brought forward records from the previous year and new records will be created once the year is re-closed.

Also, users will now be able to quickly copy data from Excel sheets into the Financial Transaction entry form. Validation rules exist and if any errors pop-up they can be easily corrected. This new system capability will be a great time saver for those Dynamics GP users who prefer to save their entries in Excel files first. Note that for now this feature is only available in the General Ledger Transaction Entry window.

Register for our FREE webinar Top 10 New Features in Dynamics GP 2013 R2 on August 28th at 11 am EST

to learn more about how to utilize these features to its full potential and decide when you need to upgrade.

Doriana Kote, Web Marketing Coordinator, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013

Published in Microsoft Dynamics GP
Monday, 17 March 2014 10:00

Tracing Transactions Account Entries

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

A common issue in Dynamics GP processing is determining whether transactions originating in your sub-ledger (Sales/Purchasing Modules) have actually created a subsequent Journal Entry in financials for the specified distributions.  Clients often will post a transaction in purchasing not belonging to a batch and assume it has posted to their General Ledger. Since transactions are only posted through to the GL when belonging to a batch that has been posted, confusion often follows as to whether the correct accounts have been posted to. Perform the following steps to help reconcile and trace transaction account entries.

1) Depending on the transaction (Sales or Purchasing) document, navigate to the appropriate module in GP. For this example we will use the Sales Module

2) Upon entering the Sales module, select the Transaction by Customer option to open the Receivables Transaction Inquiry – Customer window as shown below:

Receivables Transaction Inquiry - Customer

 

 

 

 

 

 

 

3) Enter the Customer ID for the transaction which will bring up a listing of all transactions for the customer. Alternatively, you can then filter for a specific document number to narrow down your search results:

Receivables Transaction Inquiry - Customer 2

 

 

 

 

 

 

 

 

 

 

4) Once you find the document in question, select the document line such that it is highlighted and click the Document Number hyperlink (Column Title) to bring up the Sales Transaction Inquiry Zoom as shown below. Here you can view further information relating to the document (Note the date of the document for reference purposes).Once you have this window open, select Distributions:

Receivables Transaction Inquiry - Customer 3

 

 

 

 

 

 

 

 

 

 

 

Receivables Transaction Inquiry - Customer 4

 

 

 

 

 

 

 

 

 

 

 

5) The Sales Distribution Inquiry Zoom window will open and provide further details as to what accounts were hit for the specific documents. You should make note of these account numbers for the next step in the tracing process (In the example below, 00-1200-00 and 00-1300-00 are the two accounts affected):

Receivables Transaction Inquiry - Customer 5

 

 

 

 

 

 

 

 

 

 

 

 

6) Once you have noted down the account numbers, you can verify these accounts were affected by checking the specific account entry details within the Financial Module. Select Financial from the left navigation pane  and click Summary within the Inquiry window and enter one of the account numbers previously noted:

Receivables Transaction Inquiry - Customer 6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7) You will now be presented with a summary of entries for this specific account by month. Select the month in which the document was posted (For this example, the document was posted in November). Once the month is highlighted, select any of the four hyperlinks (Debit, Credit, New Change or Period Balance) to drill further into that month and view specific entries:

Receivables Transaction Inquiry - Customer 7

 

 

 

 

 

 

 

 

 

 

 

 

 

8) From here, you will notice the $300 that was debited to 00-1200-00 on November 20th, 2013 based on the original sales document being posted. This is confirmation the appropriate amounts were affected for the specific transaction

Praveen Parameshwaran, Application Specialist, WebSan Solutions, This email address is being protected from spambots. You need JavaScript enabled to view it.

Published in Microsoft Dynamics GP

We are proud to announce the new features released with our Time and Expense Management System version 4.3. Expense group uploads, General Ledger uploads and overriding default supervisors are a few of the new enhancements that have been added to our system.

Expense Group Uploads

This feature will enable the upload of multi-user expense files. That is, specified users set in the security options have the ability to upload expenses for submission on behalf of other users. So if your department is responsible for submitting expenses, you can now gather all the expense sheets and submit them at once.

General Ledger Uploads

Upload journal entries through a downloadable template and synch them to your Microsoft Dynamics GP General Ledger.

Overriding Default Supervisors

Another new option in the User Management/ Security is the ability to set specific supervisors for users by document type.

WebSan Solutions offers a robust Time and Expense Management System to track your time and expenses hassle-free improving your employees’ productivity and your company’s profitability.

If you are interested in learning more or have any questions regarding our new features, please contact This email address is being protected from spambots. You need JavaScript enabled to view it.

Doriana Kote, Web Marketing Coordinator, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013

Published in Microsoft Dynamics GP
Thursday, 15 August 2013 09:00

Who said Corporate Training has to be Boring

Wouldn't you like to look sharper than your competitors? Then training is what makes your employees stay within your company or stand out from those at another.

Corporate training is an extremely valuable resource because it gives your employees a sense of empowerment. Once you invest in programs to help them enhance their skills and boost their knowledge they will feel better about working for your company. In turn, this fact will improve company retention rates and is an excellent motivational tool.

WebSan University is taking corporate training to a whole new level by offering live, instructor - led online courses. For more information on WebSan University and our upcoming course Microsoft Dynamics GP General Ledger, visit our website or contact us here.

Doriana Kote, Marketing Assistant, WebSan Solutions Inc., a Channel Elite Awards Finalist for 2013

Published in Dynamics GP
Friday, 02 August 2013 12:16

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

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.

Published in Microsoft Dynamics GP