Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes

Microsoft Dynamics GPI’ve been receiving an error in the Fabrikam Sample Company database when trying to create a new Financial Calendar for a while and finally had the time to track it down.

The error appears when you enter a new year and click the Calculate button:

Error when calculating a new year

Microsoft Dynamics GP
[Microsoft][SQL Server Native Client 11.0][SQL Server[Violation of PRIMARY KEY constraint 'PKSY40100'. Cannot insert duplicate key in object 'dbo.ST40100'. The duplicate key value is (0, 2021, 0, 2 ,General Entry ).

Continue reading “Error Creating Fiscal Calendar In Fabrikam Caused by Audit Trail Codes”

Run Application Error Generating Remittances

Microsoft Dynamics GPI was onsite with a client a while ago helping them create new Citrix XenApp Gold Build Servers. When users were testing, they encountered the following error when generating remittances:

Run application error message

RUN APPLICATION ERROR

"C:UsersTEMP~1.FLAppDataLocalTempCheck Remittance~2.docx" '
returned 5

Continue reading “Run Application Error Generating Remittances”

Is there a POP Historical Received Not Invoiced Report Available?

Microsoft Dynamics GPI’ve had a couple of people recently ask if it is possible to get a historical version of the Shipments Received but not invoiced* SmartList favourite (located under Purchasing » Receivings Line Items).

Within SmartList, this is not possible as the point-in-time calculations required for a historical report are too complex for a SmartList, even one driven by a view.

While historically this report wasn’t available in Microsoft Dynamics GP, this changed in the Microsoft Dynamics GP 2015 R2 release when a Reporting Services Report version of a Historical Received Not Invoiced Report was introduced. It seems though that many people are remain unaware of this new Historical RNI report.

As long as you have the Reporting Services Reports from the Reporting Tools Setup window deployed you can launch the report from the Purchasing series Reporting Services Reports navigation pane:

Historical Received Not Invoiced

This report allows you to enter criteria including a Date as of.

Feature Explained: Invoice Receipt Date

Microsoft Dynamics GPBack in 2017, regulations in the UK changed so that business of a certain minimum size, had to start recording the date an invoice was received. To support this new regulation, Microsoft introduced a new Invoice Receipt Date field to a number of windows in the Purchasing series. This new field was introduced in the July 2017 hotfix.

The presence of this field does not seem especially well-known, so I figured I do a quick post covering where it is and how it would be used.

The Invoice Receipt Date has been added to the Date Entry windows for the three types of transaction:

  • Payables Transaction Entry (Purchasing area page » Transactions » Transaction Entry)
  • Receivings Transaction Entry (Purchasing area page » Transactions » Receivings Transaction Entry)
  • Purchasing Invoice Entry (Purchasing area page » Transactions » Enter/Match Invoice)

Taking Payables Transaction Entry as an example, to access the Payables Date Entry field, click the expansion arrow next to the Doc. Date field:

Payables Transaction Entry

Continue reading “Feature Explained: Invoice Receipt Date”

What Are The GP Elementz Portals?

ISC Software SolutionsAs I mentioned in a previous post, I have joined ISC Software Solutions, a UK headquartered Microsoft Dynamics GP VAR (Value Added Reseller) and ISV (Independent Software Vendor) with an office in Ireland.

The ISV offering from ISC Software includes the GP Elementz add-ons for Microsoft Dynamics GP as well as a set of web portals:

  • ​​CustomerHQProvide your customers secure access to their Dynamics GP receivables account data such as invoices, statements and transaction reports.
  • SalesHQProvide sales teams with the ability to generate quotes, enter orders and invoices and view transactions, from any location via the internet.
  • PurchaseHQExtend your Dynamics GP system and allow purchasing users to manage purchasing from anywhere, via any device all in real-time. Includes integration with Microsoft Dynamics GP’s Document Attachment and Workflow module for approvals.

Key features of all of the web portals include:

  • Access data from anywhere and on any device.​
  • Safe and secure portals using Microsoft Azure.​​​
  • Fast and simple set up​​.
  • The user interface make the portals easy to use​.
  • Your portal can be branded with your own logo and background image.​

All portals are easy to setup and requires no technical skills or additional software or hardware. It is stored securely on Microsoft Azure and data remains in your Dynamics GP system (none is stored on Azure). It uses responsive design so it can be used on any device including cellphones and tablets.

Continue reading “What Are The GP Elementz Portals?”

Payables Management Batch Posting Date Disabled When Workflow Active

Microsoft Dynamics GPA client recently logged an issue whereby the Posting Date on the Payables Batch Entry window (Purchasing area page » Transactions » Batches) in some companies:

Payables Batch Entry with Posting Date disabled

When we investigated the issue, it turned out that the field was disabled in those companies which had a Payables Transaction Approval workflow active; I did additional testing and the Payables Batch Approval workflow does not have the same effect.

Continue reading “Payables Management Batch Posting Date Disabled When Workflow Active”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Skip Displaying New POs When Generating a PO

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

This hands on new feature is, as far as I am aware, an unannounced one which I stumbled across when testing the partial purchase a purchase requisition new feature. When you click the Generate button on the Purchase Order Preview from Purchase Requisition Entry window, a prompt Skip displaying the new purchase orders? will be displayed:

Microsoft Dynamics GP - Skip displaying the new purchase orders?

This is a change of behaviour from the new functionality introduced in Microsoft Dynamics GP 2018 RTM; the purpose of this original new feature was to improve visibility of the created purchase orders.

This was, and remains, a laudable goal, but unfortunately the implementation was somewhat lacking. The new purchase orders were displayed by opening a navigation list, which could be ver slow to open (especially if the Reporting Services Reports had been deployed and the fact pane visible.

The 2018 R2 new feature, to hide Business Analyser for all users would go some way to mitigate this issue, by hiding the fact pane, but this new feature of prompting the user to decide if they want to see the navigation list will go the majority of the remaining way (a global option to disable would have gone all the way).

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email POP PO Other Form

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The twenty-third new feature is Email POP PO Other Form. This feature makes the Purhcase Order Other Form available for email.

My hands on with the feature was somewhat abbreviated when I discovered that there was no default Word Template available. While technically allowing a PO to be emailed using the Other Form, the lack of a default Word Templates means that there is a large amount of effort involved to make it available.

To create a new Word Template, you need to use the Word Template Generator to create a Word Template from the Report Writer XML and then format the resulting template; this is a long, complex and difficult to process to do in order not to break the template so email, or even the Word Template itself, doesn’t get broken.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Purchase Requisition Partial Purchase

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The twenty-second new feature is Purchase Requisition Partial Purchase. You’ve always been able to increase the quatity to purchase, but you were not able to reduce the quantity. This new feature, allows a smaller quantity to purchase to be specified in order to partial purchase the requisition; the remaining quantity will be cancelled:

Microsoft Dynamics GP - The remaining quantity ordered will be cancelled.

The flexibility this offers should be a good thing, but I have concerns around users being able to change the purchasing quantity here if an approval workflow is being used. That said, I already had these concerns about users being able to increase the quantity post approval.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Mass Update Master Records from Navigation List

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The nineteeth new feature is Mass Update Master Records from Navigation List. This feature today is the ability to mass update a group of master records from the Navigation Lists; you can now inactivate and reactive multiple records at the same time for the following master record types:

  • Accounts
  • Checkbooks
  • Customers
  • Vendors
  • Items
  • Employees
  • In addition, the vendor navigation list allows you to mass update the temporary status; a visual indicator quickly lets you know the status of these records:

    Vendors navigation list

    With one caveat I like this new feature. Since they were introduced in Microsoft Dynamics GP 10, clients have been making more and more use of navigation lists; more interactivity can only be a good thing and the indicators make it easy to see the status of creditors.

    My caveat, is the presence of the option to toggle Temporary status. This is used by almost no clients and is very risky as temporary creditors can be deleted, regardless of history.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index