SQL Script Linking Purchase Orders to Purchase Requisitions

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPI have been doing a lot of work recently on Purchase Order Processing and Workflow 2.0. One of the requests I had was for a SmartList report which allowed the purchase order (PO) to be compared back to the purchase requisition (PR) it originated from. I had to take a few minutes to investigate as I knew the link from PR to PO was maintained within the system, but I wasn’t sure of the table.

It took me a little longer to determine which table held the link as I was expecting a company table, but instead found that the link was stored in the SOP_POPLink table (SOP60100). One fairly quick view later and I have the basis for the required report, and probably for some others in future too.

Continue reading → SQL Script Linking Purchase Orders to Purchase Requisitions

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

You Cannot Print An Unauthorized Purchase Order

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe below error message was reported to me by a user performing UAT (User Acceptance Testing) on an implementation of Purchase Order Processing and Workflow 2.0:

Microsoft Dynamics GP - You cannot print an unauthorized purchase order

Microsoft Dynamics GP

You cannot print an unauthorized purchase order

This error was somewhat surprising as it was produced when trying to print a purchase order (PO) which had been converted from a purchase requisition (PR). There was a workflow process on the PR, which had been final approved and the PO created, but there was not a workflow on the PO.

I double checked to make sure that the old Purchase Order Enhancements (POE) Approvals functionality was disabled (it was) as the customer had previously been using this.

It was when I was checking for POE Approvals, that I realised that, as part of the project, we had enabled the PO Commitments part of POE.

The warning message was being produced as the PO line had exceeded the commitment budget value. Loading the PO, clicking the save button, accepting the override of the commitment budget value, reloading the PO and clicking the Print button successfully printed the PO.

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Purchase Order Approval Workflow Automatically Rejected

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPA client reported a problem with their PO Approval Workflow process failing whenever a PO was submitted for approval. As soon as the Submit button was pressed, the document was rejected, but did not show a user:

Purchase Order Entry

Continue reading → Purchase Order Approval Workflow Automatically Rejected

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Nothing Happens When Submitting A Purchase Requisition For Approval

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPI was onsite with a client to start a project implementing Workflow 2.0 for Purchase Requisition Approval and ran into a problem while doing training on how to interact with the workflow.

Everything had been fine until this point, but after creating a simple example approval workflow, I clicked the Submit button on the Purchase Requisition Entry window and nothing happened; I tried again through the navigation list, again without success.

I promised to figure out the issue in the next break and moved onto discussing other ways of interacting and then called the break.

It occurred to me that this might be another manifestation of an issue I have encountered previously, but without the visible error message.

I ran the script against the system database which redeploys the .NET Assemblies used by Workflow:

exec wfDeployClrAssemblies

It took a few minutes to run through, but I was then able to approve the requisition without further problem.

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: POP To FA Link Includes Taxes

● Ian Grieve ●  ● 3 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The thirteenth Feature of the Day I am going “hands on” with is POP to FA Link to Include Taxes.

This feature will be popular with some of our clients who deal with non-recoeverable VAT (VAT is a UK sales tax charged at a standard rate of 20%) as non-rec VAT means they would need to depreciate the gross value of the asset including VAT where in previous versions the asset would be created net and need to be amended.

To use this feature, the Include Tax in Acquisition Cost checkbox on the Fixed Assets Company Setup window (Financial >> Setup >> Fixed Assets >> Company) under the Purchasing Options:

Fixed Assets Company 	Setup

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: POP To FA Link Includes Taxes

● Categories: Dynamics, Fixed Asset Management, GP, Microsoft ● Tags: , , , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Hands On With Microsoft Dynamics GP 2016 R2: Cancel A Purchase Order Linked To A Purchase Requisition

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The third feature I’m going to take a look at is the Cancel Purchase Orders Linked To A Requisition. For those doubting why this feature was needed, in previous versions of Microsoft Dynamics GP, when yuo tried to cancel a quantity on a purchase order you would receive a message if the remaining quantity didn’t cover the requisition quantity:

Microsoft Dynamics GP: The quantity can

Continue reading → Hands On With Microsoft Dynamics GP 2016 R2: Cancel A Purchase Order Linked To A Purchase Requisition

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Enabling Workflow Approvals For Both Purchase Requisitions & Purchase Orders

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPWorkflow 2.0 has workflow types for both purchase requisitions (PRs) and purchase orders (POs). When Workflow 2.0 first came out there was a bit of talk about how you could only use one or the other, but not both.

This is not true; you can have approval workflows enabled for both PRs and POs at the same time without having to approve at both stages.

This is done by building up a condition on a workflow step which include the PO line origin. Microsoft have a blog post which covers how to do this step-by-step. There is only one problem; the blog post is incorrect in one critical point:

Workflow MaintenanceWorkflow Maintenance image from the Dynamics GP Support and Services Blog

The problem with the blog, is that Microsoft show the Purchase Order Line field Line Origin being set to Manual. However, Line Origin is a numeric field which does not allow a word like Manual to be entered.

But, all is not lost; you can follow Microsoft’s blog post, but check for the numeric values for Purchase Order Line.Line Origin:

  • 1 = line manually entered on a purchase order
  • 10 = line created from a purchase requisition.

This information has come in very handy recently for two different clients where we assisted them in creating workflows which required approval of purchase requisiitons and purchase orders where lines had not come from a purchase requisition.

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2016 R2 Feature of the Day: POP to FA Link to Include Taxes

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The thirteenth Feature of the Day is POP to FA link to include taxes.

An option to include tax as part of the acquisition cost when adding a capital item in Fixed Assets from a purchase receipt.

The first change is to the Fixed Assets Company Setup window which sets the default value:

Fixed Assets Company Setup

Continue reading → MDGP 2016 R2 Feature of the Day: POP to FA Link to Include Taxes

● Categories: Dynamics, Fixed Asset Management, GP, Microsoft ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2016 R2 Feature of the Day: Requisition Inquiry Icon

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here

The fifth Feature of the Day is Requisition Inquiry Icon:

Purchase Requisition Entry Inquiry

This Feature of the Day is a fairly simple one. The Purchase Requisition Entry Inquiry window will show a different icon if the purchase order created from the requisition has been updated so the requisition quantity will not be fully updated. The usual chain link icon is replaced with one which has a line striking through it.

Click to show/hide the MDGP 2016 R2 Feature of the Day Series Index

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

MDGP 2016 R2 Feature of the Day: Cancel PO Linked To A Requisition

● Ian Grieve ●  ● 0 Comments   ● 

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The third Feature of the Day is the ability to Cancel a PO Linked To A Requisition. The Purchase Order Entry (Purchasing area page >> Transactions >> Purchase Order Entry) window shows a chain link icon on a line from a purchase requisition. This feature allows the user to enter a Cancelled Quantity on these lines:

Continue reading → MDGP 2016 R2 Feature of the Day: Cancel PO Linked To A Requisition

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●