Any views contained within are my personal views and not necessarily Microsoft policy or the policy of Sta-home Health & Hospice, Inc.All posts are provided "AS IS" with no warranties, and confers no rights.
In Recovery by Paul RandalSQL Skills by Kimberly Tripp
Creating an EDW for CBI SeriesGetting Data from Point A to Point B
As you saw in my previous post I create an EOY Document for all of our users. The main purpose is to keep everyone on the same page and to insure that one department doesn't get ahead of another department and do something to "blow up" the overall EOY process. As an example it would not be good if AP got completely finished with their part of the EOY and started entering non-recurring batches for 2011 before Payroll finished with 2010. So, to make doubly sure (yes, I'm paranoid) I added a column to the document labeled order. The basic idea is that all order 1 items must be completed by all departments before anyone can move on to any of the order 2 items. So let's get our some of our resource documents which were listed under Resources in the previous post. First there's Year-end closing procedures for Payables Management in Microsoft Dynamics GP. Notice that on the first page Item 4 is "Install the Payroll year-end update (optional). This then becomes a divider between items on my list. Anything before this is considered Order Level 1. Once Accounts Payables gets to that point they then notify me and wait for me to tell them to proceed with the next set of items. On the document Year-end closing procedures for Microsoft Dynamics GP Payroll notice that on the first page Item 5 is "Install the Payroll Year-End Update". This then becomes the divider between items on my list as Order Level 1 and Order Level 2. Now in the GL Year-end closing procedures for General Ledger in Microsoft Dynamics GP there is not a line about the Year End Update but if you notice Item 4 on the first page is "Close the last period of the fiscal year" and our fiscal year is the same as our calendar year. Then GL can not do that until after AP and Payroll have completely finished with most of their stuff. While payroll is pretty much done posting before you install the EOY update AP has the items "Close the Year", "Close the fiscal periods", and "Close the tax year" listed as Items 9, 10, 11. So, I hold up GL at item 3 until AP gets to that point. So in my list GL has some Order 1 things to do, but no Order 2 items. Then once Payroll and AP have finished their Order 2 Items all three can start on their Order 3 items. So, while AP, GL, and Payroll are mulling over the document I gave them let's get some testing out of the way.Check out how my testing goes on my next post. John
As you saw in my previous post I create an EOY Document for all of our users. The main purpose is to keep everyone on the same page and to insure that one department doesn't get ahead of another department and do something to "blow up" the overall EOY process. As an example it would not be good if AP got completely finished with their part of the EOY and started entering non-recurring batches for 2011 before Payroll finished with 2010.
So, to make doubly sure (yes, I'm paranoid) I added a column to the document labeled order. The basic idea is that all order 1 items must be completed by all departments before anyone can move on to any of the order 2 items. So let's get our some of our resource documents which were listed under Resources in the previous post.
First there's Year-end closing procedures for Payables Management in Microsoft Dynamics GP. Notice that on the first page Item 4 is "Install the Payroll year-end update (optional). This then becomes a divider between items on my list. Anything before this is considered Order Level 1. Once Accounts Payables gets to that point they then notify me and wait for me to tell them to proceed with the next set of items.
On the document Year-end closing procedures for Microsoft Dynamics GP Payroll notice that on the first page Item 5 is "Install the Payroll Year-End Update". This then becomes the divider between items on my list as Order Level 1 and Order Level 2.
Now in the GL Year-end closing procedures for General Ledger in Microsoft Dynamics GP there is not a line about the Year End Update but if you notice Item 4 on the first page is "Close the last period of the fiscal year" and our fiscal year is the same as our calendar year. Then GL can not do that until after AP and Payroll have completely finished with most of their stuff. While payroll is pretty much done posting before you install the EOY update AP has the items "Close the Year", "Close the fiscal periods", and "Close the tax year" listed as Items 9, 10, 11. So, I hold up GL at item 3 until AP gets to that point. So in my list GL has some Order 1 things to do, but no Order 2 items. Then once Payroll and AP have finished their Order 2 Items all three can start on their Order 3 items.
So, while AP, GL, and Payroll are mulling over the document I gave them let's get some testing out of the way.Check out how my testing goes on my next post.
John