Page 11 of 22« First...78910111213141516...Last »

MVP for another year!

 

I like that feeling when receiving the same mail from Microsoft! Informing me about the MVP award renewal.

Glad that I made it, thank you all for your support.


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Continue Reading:
MVP for another year!

April 3, 2012 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 241

Free Stuff for GP!

You read that correctly!  Microsoft has decided to change the way they work with some of their utilities and tools.  Previously there were charges to get access to tools or utilities like Customer Modifier and Customer Combiner (and Vendor, Account, Item etc.).  On the partner side, we had to purchase those outside of the normal ordering processes (they weren’t “modules” like ordering something like Integration Manager was).  They want to streamline that to eliminate some of their Direct Billing policies and that means Dynamics GP customers win!

What’s Free?

Well here is a list of what I know of, and it’s effective March 1, 2012.  Keep in mind this has only recently been announced so don’t be surprised if your partner doesn’t know all of the details about it yet – the information is just trickling out now and not everything on Partnersource is yet updated for us.

Professional Services Tools Library

All of it, some of the tools were already free, now all of the tools will be free.  There are so many tools in this library, it’s impossible to explain them all here!  Here is a quick list of the ones that in my opinion are AWESOME to have available for free.  More information on all of the tools and what they do is here (this is the general GP2010 installation guide download page – look in the list for ProfServicesToolsLibrary.pdf).

  • System tools: Database disabler for maintenance, Shortcut copy, Update user date
  • Financial tools: Account modifier/combiner, Chequebook modifier, Fiscal Period modifier, GL master record triggers, Fixed Asset modifier
  • Sales tools: Customer & Territory modifier/combiner, Salesperson modifier, RM transaction unapply from history, RM master record triggers
  • Purchasing tools: Vendor modifier/combiner, Select Cheques combiner, PM master record triggers
  • Inventory tools: Item Number and Site modifier/combiner
  • Payroll tools: Employee modifier (TBD if this is for US payroll only or Cdn Payroll too)
  • Misc tools: Doc date verify (not more bad dates outside of fiscal years!), Default “add item” in SOP/POP, Company copy (copy setup to another company)

AutoDim

Utility allows you to launch Great Plains and run one or more integrations or integration groups and have Great Plains exit upon completion of the integrations. This product also supports integrating into several different companies.

AutoPost

A COM dll that can be called from IM or an outside application to post some types of Dynamics Batches.  Currently the application supports posting of SOP, GL Trx Entry, IV Trx Entry and RM Cash Receipts batches. NOTE: Because this application uses the Continuum API, the Great Plains client must be running and a user logged into a company for this application to work.  The posting process would then use that user & company to post the desired batch.

NoteFix

More information to follow.

Payroll Detailed Activity Tracking

The Payroll Detailed Activity Tracker will track changes made to employee records (US Payroll only).  This tool is available for SQL users.  This was essentially a tool that was available prior to introducing the Audit Trails product.  It creates triggers to track changes to payroll records in various US Payroll tables.

PO Returns

When invoicing a receipt in POP, this customization will check the previous quantity invoiced and the quantity returned for the line item. The maximum quantity allowed to be invoiced is based the following formula: Quantity Shipped minus (Previous Quantity Invoiced plus Quantity Returned). This customization will not allow invoicing of more than this amount.

POP Over Receipt Tolerance

Utility that allows a receipt tolerance percentage for quantities.  A setup window allows the user to enter a tolerance percentage, that percentage is then used when a Purchase Order is received.  The highest quantity that can be received is the original quantity ordered plus the percentage amount.  For example, a Purchase Order is entered for a quantity of 10.  A tolerance percentage of 20% is entered.  The highest quantity allowed to be received would be 12.

RM Auto Apply Utility

This application will allow the user to Mass Apply posted RM Credit Documents to posted RM Debit Documents.  The user can select a range of Customer, Debit Document Dates, Credit Document Dates, and a Credit Document Type restriction if desired.  The credit documents will apply to the debit documents in the order specified in Receivables Management Setup window which is the same order that Dynamics Apply Sales Documents Auto Apply button uses.

Shipment Notification

Will allow drop ship sales orders to be transferred to invoice prior to invoicing the purchase order. 

SOP Default Site per Line

This customization changes the site that is defaulted on line items.  Instead of pulling the site from the Default Site on the SOP Entry window, if there is a default site assigned to the item in Cards>Inventory>Qtys/Sites, then that site will default for that line item  If there is no default site id for the item, then the customization will default the first site that is assigned to the item.

SOP Sort Line Items

This utility allows the user to define custom sorting options to display line items in Sales Order Processing.  For example, a sort could be defined by Item Number and then the currently selected SOP Document would display the line items in Item Number order instead of the standard by order entered.  This utility does not physically reorder the records in the underlying tables; it only displays them differently in the Sales Order Processing window.  This application also does not affect the way that sales documents print. (SQL database only)

SOP to POP Line Reordering Utility

 This utility will reorder the line items of Purchase Orders generated by the SOP to POP transfer process to be in the same order as they originally were on the Sales Order document(s).  The preview report will still show an alphabetical list, but on the actual Purchase Order document the line items will maintain their correct sequence. This is critical for companies who rely on matching up PO printouts to Packing Lists or Picking Tickets in SOP.

SOP Tax Schedule Roll down

More information to follow.

How do I get these tools?

If you are an existing Dynamics GP partner, ask your partner.  They are via the partner channel only at the moment, that may change but right now distribution is through your partner.  Partners, the PSTL keys will need to be on a request basis until Partnersource is updated with a master key for free use for anyone.  The information I have is to contact ProfessionalServices@Microsoft.com to obtain a key in the interim.

In the next release of GP, Dynamics GP2013, the PSTL will be on the CD as well.

 

View article:
Free Stuff for GP!

March 23, 2012 · jen@kuntzconsulting.ca · One Comment
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 730

Convergence 2012 Sessions I’m Presenting

This year at Convergence, I’ll be presenting three sessions, two on GPUG’s DayOne and one at Convergence on both Monday and Tuesday.  Here are the links to and descriptions of the sessions in the Convergence Session Catalog -

DayOne – 13 Classic Underused Features in GP

 
DayOne – Word Up! Using Word Templates and Email in GP 2010


Ask the Experts: Financials for Dynamics GP

Hope to see you there!

More:
Convergence 2012 Sessions I’m Presenting

March 9, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 296

Mass Item/Vendor Link

 

I got a request from one of my customers to have the ability to link multiple items with a vendor without the need to add them one by one and I have created this using the .Net toolkit, the screen will look like the below:

image

The user can filter items from the list on the left panel, click on insert and process! The system will link the selected items with the selected vendor!

I am willing to publish this tool soon, will update the article with the download link once doing some fine tuning on the utility.


Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Read the original post:
Mass Item/Vendor Link

February 28, 2012 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 298

Field Level Security is not working!?!?

 

Few months back, one of my clients reported an issue with the field level security module in Dynamics GP that it only works for “Sa”, and this morning I noticed a question in the community reminding me to post about this issue! Below are the circumstances:

1. Only the sa user can see the module on GP even by giving the power user to other users.

2. The restrictions made on the field level security module are applied only to sa user.

Solution clearly shows that this is not an issue with the application and it is an issue with database privileges, simply go to “C:Program FilesMicrosoft DynamicsGP2010SQLUtil” and locate a script called “Grant.SQL”, the script will grant the DYNGRP role in SQL the access on all objects in the database and will resolve your issue, below the script if needed:

/*Count : 1 */

declare @cStatement varchar(255)

declare G_cursor CURSOR for select 'grant select,update,insert,delete on ' + convert(varchar(64),name) + ' to DYNGRP' from sysobjects
where (type = 'U' or type = 'V') and uid = 1

set nocount on
OPEN
G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC
(@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE
G_cursor

declare G_cursor CURSOR for select 'grant execute on ' + convert(varchar(64),name) + ' to DYNGRP' from sysobjects
where type = 'P'

set nocount on
OPEN
G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC
(@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE
G_cursor

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

See the original post:
Field Level Security is not working!?!?

February 18, 2012 ·  · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 361

Microsoft Dynamics Mayhem!!

Packt Publishing is crowning February, Microsoft Dynamics Mayhem, and celebrating its range of Dynamics books/e-books with exciting discounts.
As the leading publisher of Microsoft Dynamics books/e-books and a multitude of bestsellers on NAV, AX, GP and Sure Step, not only do these titles excel in terms of quantity, but in quality, with each book garnering numerous positive reviews. 
To celebrate this achievement, Packt has slashed cover prices by up to 30%, so go mad, go crazy and make the most of this mayhem.
Recent Dynamics publications include:
  • Microsoft Dynamics CRM 2011 New Features
  • Microsoft Dynamics CRM 2011 Dashboards Cookbook
  • Microsoft Dynamics NAV 2009 Professional Reporting
Throughout 2012, Packt will continue to build-upon this success, with a focus on branching into different forms and formats such as a Dynamics Certification series.
For further information on Microsoft Dynamics Mayhem in February, visit:
https://www.packtpub.com/news/microsoft-dynamics-mayhem 

More:
Microsoft Dynamics Mayhem!!

February 10, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 377

What happens with Landed Cost when you perform a Returns Transaction in GP2010?

This question popped up on the Microsoft Dynamics Community today so I thought I’d share the answer here.  
The new functionality in GP2010 that edits the original PO for a purchase return (or creates a new one if the original is closed) is awesome.  Not sure why it took this long to add that functionality but it is what it is.  However, there is no facility in the Returns Transaction to reverse the Landed Cost on the original receipt, so GP writes the value of the Landed Cost to Purchase Price Variance.  Not the ideal way to handle it but at least it doesn’t leave that cost sitting in inventory, if the return is an inventory item.

 *click image to enlarge

P.S. not sure what the image above is displayed washed-out but if you click on the image to enlarge it, it displays properly.

View original post here:
What happens with Landed Cost when you perform a Returns Transaction in GP2010?

February 5, 2012 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 792