We ran into an interesting issue where the numbers in Management Reporter did not match what was in Dynamics GP. We did the standard first step of re-creating the data mart and integration, but the numbers were still off.
Upon further investigation, the beginning balances were missing from the report. We looked in GP, and the trial balance looked right, but the MR numbers were still off.
Then we noticed that the Source Document for the beginning balances was not the standard "BBF"; it was "BF". It appeared that something had happened to GP during the year end close, so they created a journal entry to replace it then altered it in SQL to change the transaction date.
We had to update the Source Document in SQL and gave it an Original Transaction Source of "CLOSE". After re-creating the data mart, all was well in the world.
Friday, April 10, 2015
Thursday, April 2, 2015
Time Log Excel Spreadsheet
As a consultant, I need to keep track of my day to make sure our company bills our customers for the appropriate hours I spend. If I'm working on one customer all day, it is pretty easy to enter my time into our billing system at the end of the day. On the other hand, when I'm working on several customers throughout the day and being interrupted by other customers and other consultants via meetings, e-mails, and phone calls, I need a spreadsheet where I can track every minute of the day - and is easy to see what I worked on for each external or internal customer when I'm entering my time into the billing system.
A colleague of mine had created the basic format, but it was very static. Always trying to improve and streamline, I changed it into a dynamic interface. Plus, I really wanted it to be easy to see all the work I did throughout the day for one particular customer and project.
I have been trying to ween myself off VBA in Excel whenever possible, so this spreadsheet contains no VBA macros - it is all Excel formulas and conditional formatting. The sheet is protected to keep data entry in the designated places, but there is no password if you want to poke around and see how it works.
Shoot me a comment if you find the spreadsheet useful.
Subscribe to:
Posts (Atom)