It’s been reported that Office 2010 has reached the release candidate stage and is in the hands of testers. Techradar also is reporting that the release date will be June 2010.
Blogs
Office 2010 release date June 2010
Wednesday, February 3rd, 2010Select Payable Checks using Dates
Tuesday, January 26th, 2010Computer Checks – Select Payables Checks
Select Due Date and Discount Date Cut-offs Overview
The Due Date Cutoff and Discount Date Cutoff are used to determine what invoices to include in the check run.
If Due Date is selected in the Due Date Cutoff field, all the vouchers for the selected vendors that are due on or before the date specified are included in the batch. To not use a cut-off date, select None. If None is selected, all the vouchers within the vendor and document range selected are included.
If a due date cut-off is selected, the Discount Date Cutoff field becomes available. If Discount Date is selected as the discount cut-off date, all vouchers for the selected vendors with a discount date on or before the date specified are included in the batch. If All is selected, all vouchers with discounts available are included in the batch.
The Apply Date and Non-Qualifying Discounts
Apply Date – of the invoices selected using the Due and Discount Date Cutoff, the Apply Date determines what discounts to apply. All invoices selected that have valid discounts on this date will be paid at the discount amount.
Take Non-Qualifying Discounts – this selection override the Apply Date and takes all discounts on the invoices selected.
Sample – Select Payables Checks Using Various Dates and Options
The following sample invoice was used to demonstrate the resulting check amount using various date selections in the Select Payable Check window.
Sample Invoice
| Invoice Amount | $1,000.00 |
| Terms | 2% 10 Net 30 |
| Discount Available | $20.00 |
| Invoice Date | Jan 1 |
| Terms Discount Date | Jan 11 |
| Due Date | Jan 31 |
Results using different date combinations:
|
Due Date Cutoff |
Discount Date Cutoff |
Take Non-Qualifying Discounts |
Apply Date |
Results Check Amount |
| None | None | No | Jan 11 | $980.00 |
| None | None | No | Jan 10 | $980.00 |
| None | None | No | Jan 12 | $1,000.00 |
| Jan 11 | None | No | Jan 12 | $0.00 |
| Jan 11 | None | No | Jan 11 | $0.00 |
| Jan 31 | None | No | Jan 11 | $980.00 |
| Jan 31 | None | No | Jan 12 | $1,000.00 |
| Jan 11 | Jan 11 | No | Jan 11 | $980.00 |
| Jan 11 | Jan 11 | No | Jan 12 | $1,000.00 |
| Jan 11 | Jan 12 | No | Jan 11 | $980.00 |
| Jan 11 | Jan 12 | No | Jan 12 | $1,000.00 |
Use Take Non-Qualifying Discounts on all scenarios above will override the discount amount used as follows:
| None | None | Yes | Jan 12 | $980.00 |
| Jan 31 | None | Yes | Jan 12 | $980.00 |
| Jan 11 | Jan 11 | Yes | Jan 12 | $980.00 |
| Jan 11 | Jan 12 | Yes | Jan 12 | $980.00 |
Microsoft Hyper-V for Free
Tuesday, January 26th, 2010Hyper-V is Microsoft’s virtualization technology. It comes available in two forms; as part of Windows Server 2008 R2 and as a free download. In previous versions, the free version had limited capabilities compared to its bigger brother. However; now the difference has been greatly reduced. Hyper-V server now supports > 32 GB of RAM and > 4 processors. The disadvantage? No graphical user interface (GUI) and host management.
That means installation is very simple but lacks the GUI of a full Windows installation. To actually deploy virtual servers you have to install Hyper-V management tools on a local desktop or server.
I’m familiar with Windows Server 2008 R2 with Hyper-V so I thought I would give Hyper-V a “shot”. First you can download it here from Microsoft’s site. You must have a processor that supports 64 bit operating systems and hardware virtualization. Be sure and check out more information at the Hyper-V site.
After downloading and burning the DVD I began the install. Even though it doesn’t have a GUI it starts out looking a lot like a Windows 7 install.
After formatting the drive, copying the files, installing Hyper-V, you reboot and get presented with this interface:
Looks like fun doesn’t it?! It’s actually not as bad as it looks. You can configure:
Domain
Computer Name
Add local administrator accounts
Run Windows Update
Turn on Remote Desktop
TCPIP settings
Just enough to get the system functioning. If you remote into the system using RDP you get the same interface. How do you install 3rd party drivers? Good question. How do you create a virtual server? Another good question.
3rd party drivers, you’re out of luck. If you have Windows 7 or a Window Server 2008 machine you can download the Administrator Tools and install the Hyper-V management tools. That is the only way to manage the server. It sounds easy but there are tricks to get the tools to run on Windows 7. There are a number of threads out there about it, go to John Howard’s blog for configuring the tools and you can download them from Microsoft here.
In the end I decided to go back to a full blown Windows 2008 R2 install with Hyper-V. However; Hyper-V server itself has advantages; it’s free, uses less resources for the host and if you already have a Hyper-V manager or System Center Manager then I think the choice is even better. The main thing is that you have options and you can have a mixture of servers depending on your requirements and budget.
Social Networking Tips
Monday, January 25th, 2010Microsoft Tablet?
Wednesday, January 6th, 2010That’s what we’re starting to hear. Supposedly Steve Ballmer will reveal a Microsoft Tablet manufactured by HP at tonight’s CES keynote. Will Microsoft try and beat Apple to the punch? We’ll have to wait and see. If you want to see it live tonight, check this page out at Microsoft.
Child Care Payments and other recurring garnishments in Dynamics GP
Tuesday, January 5th, 2010Setup Dynamics GP to maintain your Account Payable Child Care Payments and other garnishments in a recurring batch with the appropriate frequency. The Check’s remittance advice will list Employee Name, Case #, and Amount.
First, in the Payables Management Setup Window, select Allow Duplicate Invoices Per Vendor: Recurring Transactions Only, Tools>>Setup>>Purchasing>>Payables.
Create a recurring batch for all garnishments with the appropriate frequency, weekly, monthly, etc..
In the Payables Transaction Entry window, enter an invoice transaction for each garnishment using the Employee Name in the Description field and the Case # in the Document Number field. Save each transaction to the recurring Batch ID for garnishments.
When you print checks, the remittance will have the Employee Name, Case # and Amount for each garnishment. You may need to modify your check form to align the fields to print properly on the remittance.
The batch will maintain all payments and you can add or remove employees as needed.
Allowing Duplicate Invoices Per Vendor for recurring transactions keeps the Case # from changing for each payment posting.
Month End Receivables Processes in Microsoft Dynamics GP
Friday, December 18th, 2009Dynamics GP has developed a number of routines to help companies with their month end receivables processes. These routines can be modified to reflect the exact process that your company uses. To utilize these routines in MS Dynamics GP 10 you would go to Microsoft Dynamics GP | Tools | Routines | Sales. There you will see all of the receivables activities that Microsoft found companies may do at month end. Two activities that all companies should do monthly is age there receivables and remove paid transactions to history. Below is an example of the routines that are available for the sales series.
Month End Closing using Routines on Microsoft Dynamics GP
Friday, December 18th, 2009Routines have been available in Dynamics since version 1.0 but is one of the most under utilized features of the system. Most companies only utilize the receivables aging and remove paid transactions routines.
Routines were designed to a allow a company to have a set of procedures that are followed each month, period, quarter or year and document that they have been followed with the person’s login ID and date and time.
Routines can open a MS Dynamics GP Window, perform an external task (like open a specific file with Excel and run a macro) or run a MS Dynamics GP Macro. With a MS Dynamics GP Macro you can perform almost any task within Dynamics.
You can get to Routines in MS Dynamics GP by going to MS Dynamics GP | Tools | Routines and then selecting the series that you wish and selecting “Checklists”. Then press the “Add” button to add a routine.
Below is an example of a period end routine to close the month and produce the monthly reporting package with all the reconciliations and analyses.
Processing NSF Checks in Microsoft Dynamics GP (Great Plains)
Thursday, December 17th, 2009Dynamics GP has a very sophisticated process for dealing with NSF (Not Sufficient Funds)
checks. You select the Receivables Maintenance Posted Transaction screen by going to
Transactions | Sales | Receivables Maintenance Posted Transaction. Enter the customer ID.
Then select the type of transaction, in this case “payment” and then select the payment
number that you want to mark as NSF. Press the “NSF” button. Auto Post NSF Debit Charge
screen will open and you can enter the NSF charge amount
Then click the OK button. Dynamics GP voids the payment and adds a NSF fee.
See below where the payment is voided as indicated by the * next to Open on PMT line
and posts a debit memo for the $15.00 NSF fee to the customer account.
So in this example, the customer now owes a total of $114.75, $99.75 for the original
invoice and $15.00 for the NFS fee.
![clip_image002[8]](http://www.unifiedbiz.com/wp-content/uploads/2009/12/clip_image0028.jpg)
Year-End Closing Procedures for Dynamics GP
Friday, November 20th, 2009When it comes to Year-End Close the first thing many Dynamics GP users do is a search in Knowledge Base on CustomerSource for “Year End Close”. They get 100’s of results like, “Error message when you try to post a transaction in General Ledger in Microsoft Dynamics GP after the year is closed: "Year-End Close is still in process and batches cannot be posted"”. Good to know but not exactly what they were looking for. That’s because Knowledge Base is focused on closing errors and issues, not the proper Year-End Closing processes and procedures.
Next, users open each functional area manual, great Holiday reading, and they find specific closing procedures but scattered throughout and not in order. What do you close first and what does the close actually do to the data?
Save time and confusion, order your Year-End/Period-End Processing manual by Accolade Publications today from Unified Business Solutions, $45.00, Contact Us!
Properly closing a year in Dynamics GP is necessary to maintain not only accurate financials but a number of important business metrics. The procedures provided by Microsoft effect the proper closing for the software but do not always provide a solid financial accounting close.
This manual provides complete closing procedures for Dynamics GP modules GL, AR, AP, SOP, POP, IV, and PR. It also includes complete explanations of the processes being performed, the proper sequence in which to perform the closings, and when each module should be closed.
Year-End Closing Procedures for Dynamics GP 8, 9 and 10!