Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Preparing monthly tax returns are often dreaded as the thought of pulling backup, reconciling transactions, and preparing reports is time consuming and takes a lot of effort.  Microsoft Dynamics GP has a Value-Added Tax (VAT) Daybook tool that will prepare the detailed and summarized reports needed for tax filings.

VAT is the taxes on goods and services used throughout various countries.  A VAT Report will produce a summarized tax report that can be used to remit taxes.  It will summarize the total taxes charged on sales and total taxes paid to vendors.  It will also produce a finalized tax return form used to remit.

Traditionally, users use the general ledger and/or trial balances to remit taxes.  However, with the VAT Daybook, it can now automatically produce the report without manual updates/manipulations to prepare a tax return report.

The advantage of using a VAT daybook is that it will capture any transactions posted to prior periods that were not remitted in the tax return.  It will eliminate reporting errors when a user reports using the general ledger.

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:

WebSan Solutions has launched the Project Accounting Webinar Series, aiming to take your skills to the next level, whether you are a total beginner or an advanced user in Microsoft Dynamics GP.

Why do you need Project Accounting?

By taking an ordered and logical approach to your project accounting and training methods, you will be able to cut financial costs to your overall business activity.

Also, through logical project accounting and fundamental organisation techniques, you will be able to quickly see a marked improvement in expenditure and customer satisfaction.

Each month our Project Accounting Webinar Series will cover one of the following topics:

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

It is essential to promptly prepare your Bank Reconciliation and reconcile the transactions of your bank statement to the transactions in your General Ledger. In this way, you will match your cash balance in the bank with your company’s financial records. Bank reconciliation usually occurs at the end of the month; however some smaller companies might perform it daily.

What happens though if you want to edit or delete a transaction that has already been entered and posted in Bank Reconciliation? You should use the Bank Transaction Entry window to void the transaction. The following steps will show you how to void a bank transaction:

• First, open the Bank Transaction Entry window by going to Transactions-Financial-Bank Transactions
• Then choose Void Transaction
• Type or select the checkbook ID for the particular transaction you want to void
• Select or type the transaction number to void and make sure the transaction has been distributed
• Select Void to void the transaction. Now the checkbook has been updated and the distributions have been posted to GL
• Exit from the Bank Transaction Entry window. Notice that the Bank Transaction Posting Journal has been printed. An asterisk (*) will indicate which Transactions have been voided since you opened the window

If you want to learn more about Bank Reconciliation, join WebSan University, WebSan’s comprehensive e - Training solution for Microsoft Dynamics GP. This month’s course on November 28^th, focuses on Bank Reconciliation in Microsoft Dynamics GP. Videos, tests and a lot more of interactive documentation will help you understand and apply procedures easily in the convenience of your own time and place.

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

As 2013 comes to a close, we are all considering our New Year’s Resolutions to make 2014 the best year ever. This is a great opportunity to consider last minute adjustments for fine-tuning your business. Remember to follow all the recommended year-end procedures so that all associated systems are ready for the challenges of the New Year.

• Reconcile all your books - Prepare your Balance Sheet, Profit and Loss Statement, Statement of Cash Flows and Statement of Retained Earnings.
• Complete the posting procedures and the closing procedures for all relevant modules.
• Post the final adjusting entries in General Ledger.
• Make a backup.
• Print any year-end financial statements that are required.
• Set up a new fiscal year.
• Close the fiscal year.

Another thing to verify as part of the year-end closing process is the company’s backup procedures. Many organizations have poor or non-existent backup procedures. If there is a hardware failure, the organization may not have a secure offsite copy of its business data to ensure things can pick back up quickly. WebSan provides top cloud security with our Hosted Dynamics GP solution, maintained in our state-of-the-art SAS 70 certified data centre located in Toronto

If you want to learn more about year-end procedures in Microsoft Dynamics GP, join our webinar on Thursday, December 19^th, at 11:00 am EST and learn how to successfully close your books.

We help you make it a success every year!

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

WebSan Solutions, largest Canadian Cloud Dynamics GP Partner, has been named a 2013 VAR Star by Bob Scott’s Insights magazine. http://bobscottsinsights.com/

The Top 100 are chosen from organizations specializing in the sale and implementation of Enterprise Resource Planning and accounting software.

The selection of mid-market accounting software resellers for Bob Scott’s VAR Stars rest on one basic principal: quality, not revenue, as the deciding factor in picking the 100 businesses that are selected for this honor.

A variety of criteria go into the definition of quality including including awards resellers have received from vendors, such as the Microsoft Dynamics President’s Club and Inner Circle, Million Dollar Club and Chairman’s Club of Sage North America. Other factors involved in the selection include performance, contribution to the industry and reputation.

“We are pleased to be recognized as a Top 100 VAR” said Andrew King, Managing Director. 

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Cloud computing has become the rule and not the exception for applications in today’s business world. It is with no doubt the default IT platform and the reality is a lot of organizations use multiple cloud environments delivered within different platforms.

The challenge of managing these cloud environments in a consistent way has created the need for what is known as cloud brokerage. That is, a third-party, vendor-neutral business that serves as a single point of contact when working with multiple providers. Cloud service brokers help users benefit from best-in-class offerings from different providers, while keeping the back end simplified.

Another trend is to certify trustworthy cloud providers. Certified clouds will lead to better take up and wider use of different services with the assurance they bring. After the NSA revelations, there has been an increasing need for cloud security in the business world that can be reassured by cloud certifications. WebSan Solutions has already amplified the importance of security by maintaining its hosted Dynamics GP solution in its state-of-the-art Tier II SAS70/SSAE16 certified data centre located in Toronto, Canada.

Finally, cloud - based applications are gradually gaining ground against on-premise software. Taking into account there is a Google or IOS application for almost everything in today's business world, people can work on one device, either it is a desktop, tablet or mobile and then stop and pick up right where they left off on a different device in another location.

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.

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Users should keep in mind that all banking transactions need to be processed through a Chequebook ID in order to display in that bank subledger & that one should NEVER post a general journal entry to a bank GL account.  When we look at the Bank Transaction window, there is only a single Chequebook ID to allocate the transaction to.  This is the account to which this transaction will apply.  You will see in the lower portion of this window, you must explicitly state the other half of the GL portion of this entry.  This should NOT be a bank GL account as a general journal entry to that bank GL will not affect that bank’s subledger.

A transfer of funds from one account to another should be completed through the Bank Transfer Entry window where possible.  You will see on this window that there are two Chequebook IDs that must be identified.  Thus, this transaction will affect two separate bank subledgers.  One can only use this window wherein one of the account currencies is the functional currency (this is due to how GP treats the entries and is a restriction of the system).  When you need to enter these types of transactions, you will have to enter TWO separate bank transactions. One will be an Increase Adjustment to the ‘to’ account, the other a Decrease Adjustment to the ‘from’ account while using a clearing account to flow the funds through.

Purchase Orders, widely known as POs, is vital for keeping track of your orders and inventory as well as for both forecasting and reporting purposes. As far as small businesses are concerned, they consider Purchase Order Processing (POP) a hassle or an accountant’s concern. Well they need to realize that POP is an essential part of any retailer’s or wholesaler’s day to day operation. Even if you use your supplier’s B2B portal, it is important to enter the same information into your system as well. Not only does it help streamlining internal buying procedures but also it provides management information about costs.

Here are some of the reasons why you should consider implementing a POP module, if you haven’t already:

1. Cut time - intensive activities and increase efficiency. A single centralized system is linking all departments together and there is no need for paperwork. This also speeds up the movement of documents within and outside the company, because everything is in electronic format and staff can circulate the documents to each other instantly via e-mail and the internet.
2. View your costs instantly. POP allows you to have information about your committed costs concerning Purchasing prior even to receiving the relative invoice. That is, when an order is placed in the system upon a specific supplier, you can view your costs immediately in the form of a Purchase Order, without waiting to receive an invoice and key it in the system. Therefore, at the same time POP allows you to have better control over your expenditures.
3. Improve your cash forecasting. Recording Purchase Orders in your system and being able to define your future costs, enables you to predict your future cash flows more effectively.

WebSan Solutions offers Purchase Order Processing for Microsoft Dynamics GP to help you improve your vendor relationships and minimize your costs. For more information, join our webinar on Purchase Order Processing on October 17^th.

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

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

I was recently deploying a number of GP customizations in the model of Forms and Reports with VBA, when I encountered the following error during package importing:

I had never seen this error before but upon review of the customized form, I realized that my VBA code failed to import along with the form itself. All users had logged out of the current environment and the customizations had been tested successfully in a test system. I was stumped. One common IT phrase came to mind when deciding on the next troubleshooting step: “Have you tried turning it off and on again?”

Although I did not restart the terminal server, I took to a similar strategy: I wiped all customizations and started clean. This step has worked in the past when users were navigating through customized GP windows, where the application would suddenly crash without warning. The following entry was logged in EventViewer on the server:

You can probably guess that GP Sales Order Processing is used to enter, print and post sales orders. But did you know that you can also enter quotes, invoices, back orders and returns individually or in batches?

Are you aware that Sales Order Processing in Dynamics GP allows you to transfer sales documents from one type to another? For example, when goods or services are delivered to a customer, you can transfer the order to an invoice. The price the customer will pay and your cost will be calculated automatically.

Here are a couple of points you need to keep in mind, before transferring a document:

• Make sure there are actual quantities to transfer to an order, invoice, or back order
• Verify that the appropriate transfer options are marked for the type ID in sales setup
• Enter a batch ID for the document
• Approve the document, if required

For more information about Sales Order Processing in Dynamics GP, join our webinar on November 14 and learn how to cut lead times and speed up your transactions.

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

If you have a lot of data that doesn’t quite fit into one of Dynamics CRM 2011’s existing entities, you may decide to create your own custom entity and fields to house that data of yours.  If you take this route, don’t waste your time building the entity and creating all of your fields ahead of time!  Instead, you can use CRM 2011’s Import Data Wizard, which allows you to create entities and fields on the fly as you import the data for this new entity.

After selecting the file you want to import in the Import Data Wizard, you will reach the Map Record Types step of the Wizard – here, you can select to “Create New” Dynamics CRM Record Type, which will prompt you for more information to create the new entity within the Wizard.  Next, you’ll reach the Map Fields step – here, you can dynamically create new fields for each column in your import file (or ignore fields that you don’t want to bring into CRM).  While doing so, it even defaults the Field Name to match the column header from your import file, so all you really have to do is select the type of field that it is.  And if that wasn’t enough – if you select “Option Set” as the field type, the Wizard will automatically create values for your option set based on the unique values in that column of your data file!  The only thing left to do at this point is to set any additional options on your new entity as necessary and configure the entity form that will be used to manage the data – both of which can be done through the usual customizations window.

So if you find yourself needing to create a new entity along with having to import your data into this new entity, save yourself some time by combining both steps into one using this helpful trick in the Microsoft Dynamics CRM 2011 Import Data Wizard.

Rahim Jiwani is an Implementation Lead at WebSan Solutions Inc, a Microsoft Dynamics GP Silver Partner & 2012 Microsoft Impact Awards Finalist. Rahim can be reached at This email address is being protected from spambots. You need JavaScript enabled to view it. or 416-499-1235 ext 217.

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

It's a Friday afternoon, 3pm, going into a long weekend. You are already going to hit traffic heading up to the cottage if you leave now, however it won't be as bad as in a couple of hours. You just finished a modified SOP Blank Invoice Form and would like to import it into your client's production environment. As you click the import button in Customization Maintenance, your heart starts to race as you cross your fingers and pray that the REPORTS.DIC file is not locked by any users....and you get the "Unable to open customizations dictionary" message. The afternoon sun will have to wait until tomorrow.

When importing customized reports through Customization Maintenance, users accessing the reporting dictionary will need to log out of Dynamics GP to have the report import successfully. This can be a pain and a scheduling nightmare for users and yourself alike. "There has to be a better way!" Well, luckily, there is. If you have access to the REPORTS.DIC file found in the "Microsoft Dynamics/GP/Data" directory, then you can import the modified report straight from this dictionary file using Report Writer (this is assuming that you developed the report in a test environment and would now like to push it through to production). To do this, follow the steps below:

Step 1: Copy the REPORTS.DIC file from your test environment to a local or network shared drive that is accessible from the production server.

Step 2: Log into the production environment with 'POWERUSER' access and launch Report Writer (Microsoft Dynamics GP menu >> Tools> Customize >> Report Writer).

Once a project is finished, user should close out that project within Dynamics GP.  This helps to avoid errant postings to the project & ensures accurate reporting.

To close a project within Microsoft Dynamics GP, first set the status of your project to Completed within the Project Maintenance window.  Then, navigate to  Project > Transactions > Project Closing to access the Project Closing window.  Within this window, select the Contract Number that the completed project belongs to.  All the completed projects for that contract should then appear in the listing below.  To close a project, check the box under the Close column & select Process.

Users should note that even though a project is set to status of Completed, there may be additional transactions that may need to be completed prior to closing the project.  If additional transactions are required, the box under the C* column will be blank.  To obtain a listing of the transactions yet to be completed for a 'Completed' project, select the blue arrow beside the Project number field within the Project Closing window.  This will open the Project Closing More info window wherein users are presented with a check list of all the tasks required prior to closing the project.

[caption id="attachment_1505" align="aligncenter" width="300"] Project Closing[/caption]

There are times when users may have completed check list items, but they do not display within GP as completed.  If this occurs, it is good practice to run the PA Reconcile Utility.  This utility will search through the GP transaction tables to verify what activities have truly been completed.  To access this window, select Project > Utilities > PA Reconcile.  Select a data set to reconcile and then click Process.  The utility is fairly quick depending on the volume of data within your Dynamics GP environment.

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Our clients will often have the need to attach supporting documentation to transactions within Dynamics GP.  These might be for odd / correcting entries, entries required by auditors, or large dollar value entries.  Further, it is good practice to attach supporting documentation for transactions if possible.

To attach supporting documentation to a transaction within GP, select the yellow paper icon beside the transaction number within the entry window for that transaction.  This icon is also available within master data setup widows & essentially every other window within GP.  Once within this window, select the paperclip icon at the bottom of the window (Note:  Your system admin may have to enable this functionality to have this icon appear).  This will open a new OLE Container window wherein one can select Edit > Insert New Object.  From here, the process is as simple as selecting the file & clicking Attach within the note window.

WebSan has found this feature very helpful to our clients whenever they need to track down the supporting documentation for a transaction.  As transactions move throughout there life-cycle in Dynamics GP, they will maintain the supporting documents attached to them, making audits a breeze.

[caption id="attachment_1510" align="aligncenter" width="300"] Attaching Documents[/caption]

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[/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.

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Printers get jammed!  It happens ... sometimes even when you are printing a cheque.  Fear not, there is a solution.  If your GP environment does not allow Duplicate Cheque Numbers (as per the Chequebook Maintenance window), you can simply add (or subtract) a leading zero from the Next Cheque Number field & voila, its a new, UNIQUE cheque number for GP to use.

[caption id="attachment_1524" align="aligncenter" width="300"] Chequebook Setup[/caption]

Andrew King, Managing Director at WebSan Solutions shares 10 different tips and tricks about Microsoft Dynamics GP. Watch the following video to learn more:

WebSan Solutions offers an online (SaaS) hosted-enterprise business software solution, leveraging the vast capabilities of Microsoft Dynamics GP. For more information, please contact us.

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

Setting up EFT (Electronic Funds Transfer) to make payments within Dynamics GP 2010 is a useful feature many clients aspire to take advantage of. As with any organization from a small to large scale, manually writing cheques to make vendor payments is both time consuming and not efficient. As such, Microsoft has made the EFT process easily accessible for setup and processing to save time and make payments easier. Setting up and generating EFT at a high level requires the following setup within GP:

• Specifying a file format for EFT Files (The file format to follow is provided to you by your financial institution and defines a layout of the file GP will produce to eventually upload to your online banking website
• Setting up vendor cards and chequebooks in GP (This is completed within the Purchasing Module in GP and involves specifying specific banking details to transfer EFT Payments to)
• Entering and posting payables transactions in GP representing payments to be made to specific vendors
• Conducting an “EFT Run” similar to a “Cheque Run” in GP. This involves specifying which transactions to include in the EFT payment
• Once completed, users can generate an EFT file for upload to their financial institution

Important Notes for EFT Setup:

• EFT setup in GP requires minimal interaction with your financial institution (Certain setup instructions are provided by them and require tests before activation)
• Multiple chequebooks can be setup for EFT processing within GP (Note: Financial institutions generally charge service fees based on the number of accounts with EFT processing enabled)
• GP 2010 allows users to print and keep records of all payment remittances

For more information on EFT processing within Dynamics GP including setup & configuration, contact This email address is being protected from spambots. You need JavaScript enabled to view it.

By: Praveen Parameshwaran, Application Specialist, WebSan Solutions Inc, a Microsoft Dynamics GP Partner and 2013 Canadian Channel Elite Awards Finalist