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

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

When a Manufacturing Order (MO) receipt posting is interrupted, it will not allow a user to receive the MO again. If this occurs, one should first check the MO variance (Inquiry > Manufacturing > Order Variance) window within Dynamics GP. The MO variance is always a good indication as to what happened to the goods. If the MO variance has zero quantities or dollars in the consumed column, one would assume they may receive the MO.

Manufacturing Order Variance

 

If Dynamics GP provides an error informing the user that units are not available to be received when attempting to receive the MO, one should check the database. To do this, run the following SQL statement:

select * from MOP1000 where MANUFACTUREORDER_I = 'MO number'

Check if there are quantities in the QTYRECVD and QTYSOLD columns. Since posting is interrupted, it may have created values in the QTYRECD column and hence the MO cannot be received.

mo
Update the MOP1000 table and set the QTYRECVD back to zero. This will allow you to receive the MO.

Katrina She, CMA, Application Specialist, This email address is being protected from spambots. You need JavaScript enabled to view it.

Published in Tips & Tricks

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

Have you considered getting additional users for Microsoft Dynamics GP? Now it's your chance to purchase new licenses. Microsoft has recently made an announcement about increasing Microsoft Dynamics GP user prices across versions and licensing models effective July 1, 2014. So, if you think that you will need more Dynamics GP users in the next 6 to 12 months, we suggest this is the right time to buy those licenses before the prices go up.

The additional charge will not impact the enhancement plan cost of users you have licensed prior to 1 July 2014, subject to the Customer Services and Support Plan Policy.

WebSan Solutions offers a simplified pricing plan for Microsoft Dynamics GP for $250/ user/ month, including all GP modules:


• General Ledger
• Accounts Receivable/ Accounts Payable
• Management Reporter
• Electronic Bank Reconciliation
• Fixed Assets
• Sales Order Processing and Invoicing
• Inventory Management
• Purchase Order Processing
• Project Accounting
• Payroll (US or Canada)
• Human Resources
• Manufacturing


The price also includes training and other useful features such as multicurrency management and multiple companies. Get an instant quote and find out more details about WebSan's pricing plan.

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

Published in Microsoft Dynamics GP

The US Court announced recently that all European Hosting Providers are obliged to hand over ALL their data to the US government. According to US Magistrates court judge James C. Francis, internet and cloud companies must turn over all information to US government agencies on demand, regardless of where the data is held.

This means that even if you use a European Provider to host your services, the law might still apply to your case if the provider's data centers are located in the USA. You can read the full article here.

After the NSA revelations and their surveillance activities, this announcement adds an an additional concern for those companies in the European Union that consider working with a US hosting provider or anyone in their country that utilizes US data centers.

The good news is that Canada is not affected by this announcement and you can securely choose a Canadian cloud hosting provider, without worrying about leaking your confidential information.

WebSan Solutions can help you by offering Dynamics GP Hosting Services through our Partner Program. Also, if you are a Microsoft Partner and only offer Dynamics GP on-premise, we can help you serve new clients efficiently. Plus, WebSan offers you peace of mind by hosting your data securely in our SAS70/SSAE16 certified data centre in Toronto, Canada.

Join our webinar on May 15, 12 pm EST and learn more information about our Microsoft Dynamics GP hosting services and how we can help close the gap between you and your clients.

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

Published in Dynamics GP

Learn more about Dynamics GPView Dynamics GP PricingFree Dynamics GP Training

New fixed assets are often added manually to the fixed assets module. This relies on users to remember to check if new assets are purchased. In Dynamics GP, there is a setup to link the purchase of new assets to the fixed asset module. The setup required is to input the Purchasing Posting Accounts. After the accounts are setup, Accounts Payable will enter their invoices as per the usual procedure and select the general ledger account that is used in the Purchasing Posting Accounts. Once the payables are entered, the purchases will show up in the fixed assets module. The fixed assets accountant will select the purchases and update the fixed asset's information. The fixed assets accountant will never need to remember to add in new assets manually. This eliminates the errors when new fixed assets are purchased but never inputted into the fixed assets module creating an imbalance of the GL versus the fixed assets subledger.

fixed assets

For more information on how to setup the Purchasing Posting Accounts, please email This email address is being protected from spambots. You need JavaScript enabled to view it..

Katrina She, CMA, Application Specialist ,This email address is being protected from spambots. You need JavaScript enabled to view it.

Published in Microsoft Dynamics GP

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:


• Setup and Key Concepts
• Budgeting and Costs
• Transactions
• Inquiries and Reporting
• Billing
• Posting Setup and Control
• Revenue Recognition

Most importantly, these webinars are FREE so everyone can join us on this training journey.


Don't miss this month Part  2– Budgeting and Costs on April 24, 11 am - 12 pm EST.
Coming Next – Project Accounting Transactions

Published in 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
Thursday, 13 March 2014 09:00

VAT Daybook in Dynamics GP

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.

This function also allows a user to review the tax return before submitting.  The draft and finalized reports are easy to follow and for readers that need to review before submitting, the reports generated have a systematic flow and a reader does not need to flip back and forth between pages to find a trail of where figures are coming from.

VAT Daybook

The VAT reports generated will provide all the sufficient details and backup needed to remit taxes.  This tool will definitely save a user’s time when preparing the monthly tax returns.  It will also allow for accurate reporting without the hassle of manual preparations.   What normally takes hours to prepare, the VAT Daybook function is an easy tool to use when preparing tax filings and it only requires a couple of clicks to generate all the reports needed.

For more information on how to setup and use the VAT Daybook function, please email This email address is being protected from spambots. You need JavaScript enabled to view it..

Katrina She, CMA, Application Specialist ,This email address is being protected from spambots. You need JavaScript enabled to view it.

Published in 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
Friday, 10 January 2014 09:26

Cloud Predictions for 2014

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.

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

Published in Dynamics GP

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. 

Natalie Williams, Marketing Coordinator, WebSan Solutions Inc., a Canadian Certified Microsoft Partner

 

Published in WebSan Blog