Wednesday, June 28, 2017

Mekorma Upgrade Notice for Dynamics GP


Mekorma released this upgrade notice with their June Newsletter.  The bulletin is reprinted, below, in its original form.
*Important Upgrade Notice*
Mekorma has found that the latest Microsoft Windows .Net 4.7 Framework Update is causing an issue with the Mekorma MICR Software functionality. Even if you are not currently experiencing these issues, it is highly recommended that you upgrade your software now to avoid the issue before it occurs.
The two common behaviors you may encounter exhibiting this problem include:
  • Security warning stating users are not authorized to print out of checkbooks.
  • Warning: Unhandled object exception: The parameter is incorrect.
Note: Not all Windows programs lists that have these KB's installed name the .Net 4.7 Framework. Regardless, if any of the following KB's are installed, the guidelines below for upgrading due to .Net 4.7 incompatibility would still apply:
  • KB3186497
  • KB3186505
  • KB3186539
  • KB3186568
The current builds on our website resolve these issues and support Windows 10 and .NET Framework 4.7. Please go to our download page and install the build of Mekorma that matches the GP version you are currently on. If you are on an earlier version of GP 2013 prior to R2, please contact support@mekorma.com  for a special build. You will need to run the Mekorma table update after upgrading. Please ensure all Mekorma workstations are upgraded to the same build. If you have any questions, please contact support@mekorma.com or call 888-MEKORMA option 2.
We appreciate your patience and understanding and your support of Mekorma products.
Please contact us for more information on updating your Mekorma install or contact us about  how we can help you with a Dynamics implementation or upgrade.
Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.
Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst
www.dynamicsmct.com










Tuesday, June 27, 2017

Year-end closing procedures for Receivables Management in Microsoft Dynamics GP

Several clients have asked for detailed steps for closing the Receivables Management module in Dynamics GP.

The information below comes from Microsoft Support, Article ID: 857444, updated September 16, 2016. We hope this helps with the Receivables year end close.

-----------------------------------------------------------------

Year-end closing checklist

You can use this checklist for the end of the fiscal year and for the end of the calendar year. 

Note Although Receivables Management is date sensitive, the following items are updated based on the closing of Receivables Management:

  • The SmartList objects
  • The Receivables Management summary reports
  • The Amounts Since Last Close view in the Customer Summary window
Therefore, we recommend that you follow these steps so that the SmartList objects, the Receivables Management summary reports, and the Amounts Since Last Close view contain the correct information:
  1. Post all the sales and receivables transactions for the year.
  2. Make a pre-year-end closing backup.
  3. Close the year.
  4. Close the fiscal periods. (This step is optional.)
  5. Close the tax year.
  6. Make a post-year-end closing backup.
Step 1: Post all the sales and receivables transactions for the year
Post all the sales and receivables transactions for the year before you close the year. If you want to enter any sales and receivables transactions for a future period before you close the year, create a batch that contains the transactions. Next, save the batch. Then, post the batch after you close the year.

You must close the year because some areas of Microsoft Dynamics GP are not date sensitive. If you do not close the year after you enter all the current year transactions and before you enter transactions for the next year, these areas will contain incorrect information. However, if you have to change the information, you can change the information in the Amounts Since Last Close view in the Customer Summary window and in the Customer Finance Charge Summary window. The following areas are the areas of Microsoft Dynamics GP that are not date sensitive.

  • The Amounts Since Last Close view in the Customer Summary window
    --To open the Amounts Since Last Close view in the Customer Summary window, follow these steps:
    1. On the Cards menu, point to Sales, and then click Summary.
    2. In the Customer Summary window, type a customer ID in the Customer ID box.
    3. In the Summary View list, click Amounts Since Last Close.
  • The Customer Finance Charge Summary window
    To open the Customer Finance Charge Summary window, follow these steps:
    1. On the Cards menu, point to Sales, and then click Summary.
    2. In the Customer Summary window, type a customer ID in the Customer ID field.
    3. Click Finance Charges.
  • The SmartList objects
    To view the SmartList columns that are affected, follow these steps:
    1. In Microsoft Dynamics GP, click Columns on the Microsoft Dynamics GP menu, click SmartList, expand Sales, expand Customers, and then click Add.
    2. Select the following items in the Available Columns list.
      Note The items that are flagged with an asterisk are affected by the calendar year-end close. All the other items are affected by the fiscal year-end close.
      • Average Days to Pay - Year
      • Finance Charges CYTD*
      • Finance Charges LYR Calendar*
      • High Balance LYR
      • High Balance YTD
      • Number of ADTP Documents - LYR
      • Number of ADTP Documents - Year
      • Number of NSF Checks YTD
      • Total # FC LYR*
      • Total # FC YTD*
      • Total # Invoices LYR
      • Total # Invoices YTD
      • Total Amount of NSF Check YTD
      • Total Bad Debt LYR
      • Total Bad Debt YTD
      • Total Cash Received LYR
      • Total Cash Received YTD
      • Total Discounts Available YTD
      • Total Discounts Taken LYR
      • Total Discounts Taken YTD
      • Total Finance Charges LYR*
      • Total Finance Charges YTD*
      • Total Returns LYR
      • Total Returns YTD
      • Total Sales LYR
      • Total Sales YTD
      • Total Waived FC LYR*
      • Total Waived FC YTD*
      • Total Writeoffs LYR
      • Total Writeoffs YTD
      • Unpaid Finance Charges YTD*
      • Write Offs LYR
      • Write Offs YTD
    3. Click OK.
    4. Click OK.
Step 2: Make a pre-year-end closing backup
Create a backup before you close the year. Put the backup in safe, permanent storage. This backup makes sure that you have a permanent record of the company's financial position at the end of the year. You can restore information from this backup if you have to. For example, this backup would let you quickly recover if a power fluctuation or another problem occurred during the year-end close procedure.
To create a backup in Microsoft Dynamics GP, follow these steps:
  1. In Microsoft Dynamics GP, point to Maintenance on the Microsoft Dynamics GP menu, and then click Backup.
  2. In the Back Up Company window, select the company name in the Company Name list.
  3. Change the path of the backup file if it is required, and then click OK.
    Note We recommend that you name this backup PreYearEndClosingBackup20XX. (Enter the year for the XX placeholder.)
Step 3: Close the year
  1. In Microsoft Dynamics GP, point to Tools on the Microsoft Dynamics GP menu, point to Routines, point to Sales, and then click Year-End Close.
  2. If you are closing both the fiscal year and the calendar year at the same time, click All. If you are closing only the calendar year, click Calendar. If you are closing only the fiscal year, click Fiscal.
  3. Click to select the Print Report check box, and then click Close Year.
    Note We recommend that you keep a paper copy of the year-end report together with the permanent year-end audit records.
Calendar year details
The calendar year-end process in Microsoft Dynamics GP clears the following fields in the Customer Summary window:
  • Finance Charges CYTD
  • Total # FC YTD
  • Total Finance Charges YTD
  • Total Waived FC YTD
  • Unpaid Finance Charges YTD
The calendar year-end process updates the amounts in the following fields:
  • *Finance Charges LYR Calendar
  • *Total # FC LYR
Fiscal year details
The fiscal year-end process in Microsoft Dynamics GP clears the following fields in the Customer Summary window:
  • Average Days to Pay - Year
  • High Balance YTD
  • Number of ADTP Documents - Year
  • Number of NSF Checks YTD
  • Total # Invoices YTD
  • Total Amount of NSF Check YTD
  • Total Bad Debt YTD
  • Total Cash Received YTD
  • Total Discounts Available YTD
  • Total Discounts Taken YTD
  • Total Returns YTD
  • Total Sales YTD
  • Total Writeoffs YTD
  • Write Offs YTD
The fiscal year-end process updates the amounts in the following fields:
  • High Balance LYR
  • Number of ADTP Documents - LYR
  • Total # Invoices LYR
  • Total Bad Debt LYR
  • Total Cash Received LYR
  • Total Discounts Taken LYR
  • Total Returns LYR
  • Total Sales LYR
  • Total Writeoffs LYR
  • Write Offs LYR
Step 4: Close the fiscal periods (This step is optional)
To prevent users from accidentally posting transactions to the wrong period or to the wrong year, use the Fiscal Periods Setup window to close all fiscal periods that are still open for the year. Before you close fiscal periods, verify that you have posted all the transactions for the period and for the year for all modules. If you must later post transactions to a fiscal period that you already closed, you can return to the Fiscal Periods Setup window to reopen the period so that you can post the transactions.
To close a fiscal period, follow these steps:
  1. In Microsoft Dynamics GP, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Company, and then click Fiscal Periods.
  2. Click to select the Sales check box for the period that you want to close.
Step 5: Close the tax year
Note Follow these steps only after you complete the year-end closing procedures for all the sales and purchasing modules.
To close the tax year, follow these steps:
  1. In Microsoft Dynamics GP, point to Tools on the Microsoft Dynamics GP menu, point to Routines, point to Company, and then click Tax Year-End Close.
  2. Click to select the Close Year check box, and then click to select the Print Report check box.
  3. Click Process.
    Note We recommend that you keep a paper copy of the year-end report together with the permanent year-end audit records.
Step 6: Make a post-year-end closing backup
Create a backup after you close the year. Put the backup in safe, permanent storage. This backup makes sure that you have a permanent record of the company's financial position at the end of the year. You can restore information from this backup if you have to. For example, this backup would let you quickly recover if a power fluctuation or another problem occurred during the year-end close procedure.
To create a backup in Microsoft Dynamics GP, follow these steps:
  1. In Microsoft Dynamics GP, point to Maintenance on the Microsoft Dynamics GP menu, and then click Backup.
  2. In the Back Up Company window, click the company name in the Company Name list.
  3. Change the path of the backup file if it is required, and then click OK.
    Note We recommend that you name this backup PostYearEndClosingBackup20XX. (Enter the year for the XX placeholder.)
Year-to-date finance charges on customer statements for December and for January
Year-to-date finance charges are not automatically printed on customer statements for December and for January.
December statements
To add the year-to-date finance charges to the December statements, follow these steps:
  1. In Microsoft Dynamics GP, point to Tools on the Microsoft Dynamics GP menu, point to Customize, and then click Report Writer.
  2. In the Product list, click Microsoft Dynamics GP, and then click OK.
  3. Click Reports.
  4. Use the appropriate method:
    • If you have not previously modified the statement form, click the statement form that you print in the Original Reports list, click Insert, and then click the statement form in the Modified Reports list.
    • If you previously modified the statement form, click the statement form in the Modified Reports list.
  5. Click Open.
  6. In the Report Definition window, click Tables.
  7. In the Report Table Relationships window, click RM Customer MSTR, and then click New.
  8. In the Related Tables window, click Customer Master Summary, and then click OK.
  9. Click Close.
  10. Click Layout.
  11. In the resource list in the Toolbox box, click Customer Master Summary.
  12. In the field list, drag Finance Charges CYTD to the layout of the report. You can position this field in any section of the report.
  13. On the File menu, click Microsoft Dynamics GP. When you are prompted to save the changes, click Save.
  14. If you have not previously modified this report, you must grant security to the report. To do this, use the steps below:
    1. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Systems, and then click Alternate/Modified Forms and Reports.
    2. In the ID box, enter the user ID.
    3. In the Product list, click
      Microsoft Dynamics GP.
    4. In the Type list, click Reports.
    5. Expand Sales, and then expand the node of the modified form.
    6. Click Microsoft Dynamics GP (Modified).
January statements
To add the year-to-date finance charges to the January statements, follow these steps:
  1. Follow steps 1 through 11 in the "December statements" section.
  2. In the field list, drag Finance Charges LYR Calendar to the layout of the report. You can position this field in any section of the report.
  3. Follow steps 13 and 14 in the "December statements" section.

Please contact us for more information on managing your year end close or contact us about  how we can help you with a Dynamics implementation or upgrade.

Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Monday, June 26, 2017

Dynamics GP–Combine Multiple Budgets into a Master Budget

image
Figure 1 – Budget Maintenance window in Dynamics GP
You can combine multiple General Ledger budgets into a single, master budget, one budget at a time. The master budget can be completely new and have its own budget ID, or it can be one of the two original budgets. This feature is helpful when multiple departments in your organization create their own budgets, which must then be consolidated. The new Combine Budgets window simplifies this process.
image
Figure 2 – Combine Budgets window in Dynamics GP
After you have completed the Combine Budgets process, you can use the Budget Selection window (Financial >> Cards >> Financial >> Budgets) to view all budgets in the system, including budgets created in Excel and imported into Microsoft Dynamics GP.
For more information on Dynamics GP or to ask questions about how we can help you with a Dynamics ERP implementation, send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.
Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst
www.dynamicsmct.com

Thursday, June 22, 2017

Tool Tip - Calculate How Many Working Days and Public Holidays For HR and Payroll

image

Figure 1 – Screen shot of Calendar for "How many working days and public holidays from date to date"

If you ever have to figure out the number of working days and public holidays from one date to another, the website http://www.workingdays.ca/Alberta.htm#aepd is the perfect tool to use to come up with the correct number of days. 

This window has multiple uses:

1. Use it to calculate a payout for an employee that is leaving

2. Use it to calculate the number of days and vacation for budgeting for the next fiscal year – it goes out to future years

3. Use it to fix the public holiday dates for sending out the notice for the upcoming year statutory days

4. Use it to check statutory days between Canada and the United States for planning purposes when the company works in both countries

5. Use it for planning weekend shifts for manufacturing shifts and for retail shifts

Using the Calendar function is much faster than counting the days manually on a calendar.

For other tips and tool tricks, keep reading this blog. 

Please contact us for more information on Dynamics ERP capabilities or to find out how we can help you with a Dynamics implementation.

Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Tuesday, June 20, 2017

Free Tool - Back Up Dynamics GP to Azure Server


image

Figure 1 – Slide showing that you can backup the GP database to Azure

Backing up data is one of the most important functions that companies can do on a daily basis. Most companies will back up their data to a local server on premises.  If there is a major issue such as fire or flood, that backup may not provide the safety net that companies believe that they have.

Many Dynamics GP users do not realize that they can backup their Dynamics GP directly to an Azure server thereby having a secure copy of their backup in the cloud.

Here is how it works.  Only the system administrator can open the Back Up Company window to make backups. The Back Up Company window is only available when using a Microsoft Dynamics GP installation on the SQL Server.  The administrator may choose to back up either the Company database or the System database.

image

Figure 2 – Back Up Company Window from Dynamics GP 2015 R2

Here is a list of the data that should be backed up.

image

Figure 3 – Dynamics GP files and databases that should be part of the backup

Please contact us for more information on managing back ups or contact us about  how we can help you with a Dynamics implementation or upgrade.

Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Thursday, June 15, 2017

What Does The Purchase Order Status Mean In Dynamics GP?

image

Figure 1 – Purchase Order window in Dynamics GP showing a PO Status of New

We all know that we can use the Purchase Order Entry window to enter purchase orders and to modify purchase orders with New, Released, and Change Order statuses. You also can delete or void purchase orders with a New status (purchase orders that have never been printed or sent to the vendor).

However, GP users often ask what the purchase order statuses mean, and they ask what the status does in the system.  Here is the explanation of all of the status notices on a purchase order.

The different types of purchase order statuses are as follows.

1. New
A purchase order is assigned a New status when it is saved for the first time, and before it has been released to the vendor. A new purchase order can exist without line items. If you change a new purchase order, the purchase order still has a New status. The inventory quantities are not adjusted when the new purchase order is entered. The inventory quantities are adjusted when the purchase order line status changes to a Released status.
2. Released
A Released status indicates that the purchase order has been sent to the vendor. A new purchase order is assigned a Released status if at least one purchase order line changes from a New status to a Released status. Or, a new purchase order is assigned a Released status if a receipt is posted. If a change order purchase order is printed, it changes the status to Released. Additionally, this change results in at least one released purchase order line. This change also results in no remaining change order purchase order lines.
When a purchase order has a Released status, the following amounts increase for any purchase order lines that change to a Released status:
  • Inventory on Order Quantity
  • Item/Vendor on Order Quantity
  • Vendor on Order Currency
3. Received
A purchase order is assigned a Received status if there are no quantities remaining to receive, and if there are quantities that remain to be invoiced. A purchase order that has a Received status can have a combination of the following line items:
  • Received
  • Canceled
  • Closed
4. Change Order
A Change Order status notifies users that the original order is no longer valid. If a purchase order that has a Released status is edited in a manner that affects the vendor, the purchase order is assigned a Change Order status, and the revision number increases. Use the revision number to make sure that you and the vendor refer to the same order. The revision number does not increase if you change a purchase order that already has a Change Order status.
5. Canceled

A Canceled status indicates that the purchase order will not be processed any more. A purchase order is assigned a Canceled status if all the line items have been canceled, and if no amounts have been received against the line items.

To change a Canceled status, change at least one of the canceled line items to a New status or to a Change Order status.
You can transfer a purchase order that has a Canceled status to history. To do this, use the Remove Completed Purchase Orders window. You can remove the purchase order by using the Remove Purchasing History window.

6. Closed

A purchase order is assigned the Closed status if all the line items have been closed, and if there are no remaining quantities to receive or to match to invoices. A purchase order that has a Closed status can also have canceled lines.

Contact us if your company has questions or issues with purchase orders.  The team at Dynamics MCT Consulting  provides a full range of Microsoft Dynamics services.  For more information on Dynamics GP or to ask questions about how we can help you with a Dynamics implementation, send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Tuesday, June 13, 2017

Jet Reports 2017 R2 Has Been Released With New Features

image

Figure 1 –  Income Statement by Month from Jet Reports

Jet Reports 2017 R2 represents significant enhancements for how you can manage, run and view your business reports in Jet Professional and Jet Enterprise. 

The following information comes from the Jet Reports publication on the new features in release 2017 R2.

New Features Available in Jet Reports 2017 R2

image

Figure 2 – Jet Web Portal Scheduler

Web Scheduling - Jet Professional 2017 R2 introduces a web-based scheduler for reports. Jet Web Portal users can now easily set
their Jet reports to run on a monthly, weekly, daily, or even more frequent basis and be distributed via email.  Users can create a schedule, and then set up one or multiple reports to be run and distributed via email.  The scheduling capability is quite flexible, and makes it easy to set up schedules for:
• The last day of the month
• The first Monday of the month
• Every hour between 8am and 5pm
• And much more

New Drilldown Features… 

Drilldown Available in Web Portal Reports -   When a user downloads a report from the Jet Web Portal they can now click on a cell to see the underlying data.

Drilldown for Dynamics GP GL function - Dynamics GP users can now drilldown into their GL queries to see the underlying financial transactions. This allows users to quickly get a deep understanding of their finances.

Report Options tool

Designers can use a new Report Options tool to quickly create and manage user-selectable parameters/filters on their reports. This speeds up report creation and makes it easier to learn how to the report options window feature.

No longer do you need to add tags for ‘title’, ‘value’, ‘option’ etc. to create a report options window. A simple tool now takes care of this for you.

Does your finance team have an interest in Jet Reports?  Contact us.  The team at Dynamics MCT Consulting  provides a full range of Microsoft Dynamics services.  For more information on Jet Reports or to ask questions about how we can help you with a Dynamics implementation, send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Thursday, June 8, 2017

How To Use The Purchasing All-in-One View in Dynamics GP 2015/2016

image

Figure 1 – Purchasing All-in-One View in GP 2015 R2


One of the new features in GP 2015/2016 is the ALL-IN-ONE VIEW. It is a nifty tool that can save a user a lot of look up time because all of the information is in one place.

The Purchasing All-in-One View window is  available for locating vendor records and displaying related purchasing documents in the same window.  That makes life easier!

When you open the Purchasing All-in-One View window from Purchasing >> Inquiry >> All-in-One View, or Home >>
Quick Links >> All-in-One View, the window opens without any data. You can specify the vendor and the details of the information to display in the window. Mark the checkbox in the upper right corner of the document to display only the related documents as in Figure 2 below.

image

Figure 2 – The blank Purchasing All-IN-ONE VIEW

For example, suppose a vendor calls asking about a specific payment. You can use the Purchasing All-in-One View window to select that vendor and then view all documents related to the payment, such as
the PO, receipt, invoice, credits, miscellaneous charges and finance charges, and payment to assist you in responding to your vendor ’s inquiries.


You can access the Purchasing All-in-One View window from the following windows and navigation lists:
• Your home page
• Vendor Maintenance
• Purchase Order Processing Document Inquiry
• Vendor Inquiry
• Payables Transaction Inquiry - Vendor
• Payables Transaction Inquiry – Document
• Purchase Order Processing Document Inquiry
• Purchase Order Processing Item Inquiry
• Navigation Lists and any views of these lists
 Vendors
 All Purchasing Transactions
 Payables Transactions
 Purchase Order Transactions

The icon for the Purchasing All-in-One View window is available only if a single record is selected in the navigation list. The data that’s displayed in the Purchasing All-in-One View window depends on your selection in the navigation list. For example, if you select only a vendor record in the navigation list, the vendor ID and name information are displayed in the Purchasing All-in-One View window. If you select a transaction in the navigation list, the vendor ID, name and
transaction information are displayed.

Use the Filter Icon to select additional information as in Figure 3 below. The clear filters icon will reset the filters back to the default selection.

image

Figure 3 – The Filter Icon is available on each column for Purchase Orders, Receipts, Invoices, Payments, and Returns.

Does your team need some one-on-one training on the tool.  Contact us.  The team at Dynamics MCT Consulting  provides a full range of Microsoft Dynamics services.  Please contact us for more information on capabilities or how we can help you with a Dynamics implementation.

Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Tuesday, June 6, 2017

Five Reasons To Keep The Vendor (Supplier) List Clean

image

Figure 1 – The push broom used to keep shop floors clean

Most organizations have a safety policy in place.  High on the list of safety is keeping the premises clean and tidy.  An extension of this "clean and tidy" practice should be to keep the vendor list clean in the ERP system.

Why? Here are five reasons to keep the vendor list clean.

  1. The longer and messier that the vendor list is, the more likely coding errors will happen. 
  2. This increases the chances of the wrong vendor being paid for an invoice assigned to them in error.
  3. Now, there are two voids to process, one for the cheque payment, and one for the invoice.
  4. If Vendors have not been used in the last two years, inactivate them to reduce the risk that invoices will inadvertently be assigned to them. (In Dynamics GP, for example, run a SmartList to show vendors that have not received payment for the last two years, and then inactivate them.)
  5. Managing the vendor list and reviewing it quarterly or semiannually will help to minimize the occurrence of fraudulent vendors, that is, vendors who submit the same invoice under different names.  You will catch these errors  because  you are watching.

The team at Dynamics MCT Consulting has been implementing Microsoft Dynamics ERP Business Solutions for more than 15 years and provides a full range of Microsoft Dynamics services.  Please contact us for more information on capabilities or how we can help you with a Dynamics implementation.

Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com

Thursday, June 1, 2017

Free Job Close Assist Report for Key2Act and Dynamics GP

image

Figure 1 – The banner at Implementation Specialists showing the two free report tools available

Job cost closing can sometimes be a time consuming process.  Often, the job that we should be able to close does not show on the Job Cost Closing window, and then we have to figure out what is going on with the job.  Wouldn't it make life easier if there was a report that told the user what transaction is holding up the job from closing?

wsTools

Well, the folks at Implementation Specialists (www.iscorp.biz/solutions/wstools/) have created this report.  And, they are offering it for free, along with their PTO Liability Report. To provide some background, the team at Implementation Specialists have created a set of wsTools that provide a quick solution to job cost and service tasks.  The two free reports are part of the wsTools.

PTO Liability Report

About the PTO Liability Report -  It is only available for the US Payroll module.  It provides an easier way to sum up employee sick time and vacation time accruals by department that’s been formatted to copy/paste into GL.

Job Cost Close Assist Report

About the Job Cost Close Assist Report - For KEY2ACT Job Cost users, save time and avoid the frustration in trying to figure out why a job will not close. "Job Cost Close Assist" will show you in one simple report, the items that are preventing you from closing a job.  The report is an SSRS report that runs for an individual job, and produces a report like the one in Figure 2 below.

image

Figure 2 – Sample of the Job Closing Report

You can look at all of the tools available at Implementation Specialists by checking the wsTools library at www.iscorp.biz/solutions/wstools/.

To get your free copy of the Job Close Assist Report or to see a demo of any of the other wsTools, you can contact us  at Dynamics MCT Consulting.   Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP Senior Financial Analyst

www.dynamicsmct.com