Below is an old tip from one of the GP Reports Viewer monthly newsletters . In the past few months I have had to look this up several times, because I just cannot seem to remember the syntax, so I thought I would put it on my blog, where it will be easier for to find for everyone, including me. :-) The situation where I last needed this was when I was creating a Crystal Report and wanted to hide a date field if it returns ’1/1/1900′, the equivalent of a NULL in Dynamics GP data
I have made it to Fargo, North Dakota, the home of Microsoft Business Solutions and the Microsoft Dynamics GP Product team.
Rolling twelve month reports are not always very easy to create, and I have been seeing more requests for them, so I thought I would show an example of one way to do this. The view below is a variation of my sales by item by month view , however instead of specifying all months in a year, this will return the last 12 months, not including the current month. Note that this will be using the current date on the SQL server, not the user date specified in GP
Below is a view that will return a list of the distribution and breakdown accounts for all active variable allocation accounts in your Dynamics GP. Nothing fancy, but sometimes it is easier to have a report of these rather than have to look at them on the screen, specially since you have to click on each distribution account one at a time to see what breakdown account they are using. Related code and table information: General Ledger tables GP Reports (there is a section for General Ledger reports under Dynamics GP SQL Sripts) create view view_Variable_Allocation_Accounts as — ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ — view_Variable_Allocation_Accounts — Created on Aug
What a second week it’s been! Inside Microsoft Dynamics GP has been releasing some really cool Microsoft Dynamics GP 2013 features, which promise to be all the good for customers looking to increase their system utilization. If you haven’t gotten through Week 1′s features, I have them all compiled for you in the following article: Microsoft Dynamics GP 2013 “Feature of the Day” – Week 1 Digest Now here are this week’s 5 features: Feature of the Day: User Defined Fields on Customer Address New configuration options in RM to add user-def fields to Customer Address Maintenance window Original article: Feature of the Day: User Defined Fields on Customer Address Link to Presentation: GP2013 FOD Rename User Defined Fields on Customer Address.ppsx Learning Script: N/A Feature of the Day: Tolerance Handling New configuration options in Purchase Order Processing Setup and Item Purchasing Options Maintenance window Original article: Feature of the Day: Tolerance Handling Link to Presentation: GP2013-FOD-Tolerance-Handling.ppsx Learning script: GP2013 Tolerance Handling Learning Script.docx Feature of the Day: 3 New Year End Close Features New settings in Unit Account Maintenance and Year-End Closing windows Original article: Feature of the Day: 3 New Year End Close Features Link to presentation: GP2013-FOD-Year-End-Close-Options.ppsx Learning script: N/A Feature of the Day: Ship To Address Changes Original article: Feature of the Day: Ship To Address Changes Link to presentation: GP2013 FOD Ship To Address.ppsx (link not working) Learning script: GP2013 Ship To Address Learning Script.docx Feature of the Day: Inactive Items New ‘Inactive’ setting on Item Maintenance window Original article: Feature of the Day: Inactive Items Link to presentation: GP2013-Inactive-Items.ppsx Learning script: N/A The combined total of features released so far? 9! Keep them coming guys.
Trying to generate an early bound class in CRM 2011 online?? If yes is the answer this post will definitely help you out in meeting the requirement.