Integration Manager error when running a Sales Order Processing integration

Microsoft Dynamics GPI created an integration recently using Integration Manager for a client to import sales invoices into Microsoft Dynamics GP. It worked fine when I was developing it, logged in as DYNSA, and for one of the finance teams managers, but produced an error for the user:

Integration manager error log
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 2 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 3 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 4 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 5 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 6 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 7 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
Integration Failed
Integration Results
7 documents were read from the source query.
7 documents were attempted:
0 integrated without warnings.
0 integrated with warnings.
7 failed to integrate.

I toggled the Integration Manager ini file parameters so I could see what was happening with the windows to get an indication of the problem. The first window opened was Sales Order Processing Setup; why tis opened I’m not sure, but the user didn’t have permissions for this window. I did a quick test by copying the users security to a test account and added access to that window and the integration ran through without a problem.

This seems to be an operating as designed thing, but it seems odd that the SOP Setup window needs access.

Switch off SOP/Invoicing warning in Microsoft Dynamics GP

Microsoft Dynamics GPI often end up creating test, demo or upgrade requirements and have a number of scripts I run against them to make changes. The script below can be used to change the settings for the message displayed when both SOP and Invoicing are both installed.

The script is set up to leave the message enabled for Invoicing, but switch it off for Sales Order Processing (the comments include the setting for switching the other way).

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
UPDATE IVC40100 -- Invoicing Setup (IVC40100) SET IVCDSTCK = 0x01000040 -- set to 0x00000040 to switch off warning GO UPDATE SOP40100 -- Sales Setup (SOP40100) SET IVCDSTCK = 0x00000000 -- set to 0x01000000 to switch on warning GO

Hands On With Microsoft Dynamics GP 2018 R2 New Features: New Sort Options in Sales Order Processing Item Inquiry Window

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 twentieth new feature is New Sort Options in Sales Order Processing Item Inquiry Window. The Sales Order Processing Item Inquiry window has a new Sort By option available; this lets users quickly find the information they are looking for because now they can sort, either ascending or descending, by the following fields:

  • Document Number
  • Document Type
  • Item Number
  • Document Date
  • Customer ID
Sales Order Processing Item Inquiry

This feature builds on the new sort options introduced to Payables and Receivables, by making the aame options available in the Sales Order Processing Item Inquiry window. This is a good addition as users are often asking the ability to sort by date; I hope to see it introduced in additional windows in future versions.

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: New SmartList for Deposits on Unposted Sales Transactions Has Been Created

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 ninth new feature is New SmartList for Deposits on Unposted Sales Transactions Has Been Created. This feature adds a new Deposits on Unposted Sales Transactions favourite to the Sales Transactions SmartList object:

Deposits on Unposted Sales Transactions SmartList Favorite

When the feature of the day post was announced, I expressed some skepticism as to the value of it. It is basically a copy of the default favourite with two columns removed and the Deposit Received column added; very quick and easy to create if it is needed.

I’ve not really changed my mind. It might save you 20 seconds once to create the favourite if you wanted it, but nothing more.

I’d have been happier if it was a new SmartList Object, such as a Budget SmartList, instead of just a new favourite.

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: Transaction Level Post Through General Ledger

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 seventh new feature is .When transaction posting is enabled, this feature allows users to perform posting through the General Ledger at a transaction level. The following is a list of supported transactions for this feature:

  • Invoice Entry
  • Receivables Apply Doc.
  • Receivables Cash Receipts
  • Receivables Sales Entry
  • Sales Deposits
  • Sales Trx Entry
  • Voided Trx Maintenance (Sales)
  • Payables Trx Entry
  • Payment Entry
  • Purchasing Invoice Entry
  • Purchasing Prepayments
  • Receivings Trx Entry
  • Returns Trx Entry
  • Assembly Entry
  • Transaction Entry (Inventory)
  • Transfer Entry
  • Manual Checks (Payroll)
  • Project Accounting Transaction windows except Project Closing

To enable post through for transactions, open the Posting Setup window (Administration area page » Setup » Posting » Posting), and mark the Post Through General Ledger checkbox below the Allow Transaction Posting one:

Posting Setup

In theory this is a great addition to Dynamics GP, as many clients want to do transaction level posting, although more these days are wanting to use workflow for approvals which still requires batches.

However, in my testing so far, all Sales transactions which I post using post through work fine, but nothing on Payables posts through at transaction level regardless of the settings.

I need to do additional testing, but so far this feature isn’t looking good.

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: Print Invoices in Functional Currency from SOP 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 sixth new feature is Print Invoices in Functional Currency from SOP Navigation List. This feature of the day is one I requested back in 2014 on behalf of a client; it is the ability to print an invoice in Functional, by changing the Currency to Print drop-down, from the navigation:

Sales Transactions navigation list

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Print Invoices in Functional Currency from SOP Navigation List”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Print and E-mail Sales Order Processing Documents

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 fifth new feature is Print and E-mail Sales Order Processing Documents. This feature changes the printing behaviour of the Sales Document Print Options window, accessible via Sales Transaction Entry (Sales area page » Transactions » Sales Transaction Entry) to both print and email the sales document:

Sales Document Print Options

When it was announced, I wondered if, in some way, this was related to the print remaining documents functionality, but I tested with 2018 RTM and that was how that version worked. This new feature goes against the 2013 R2 feature in that selecting both boxes will then both print and email the sales document.

I’m not sure what the use case for this feature is. If you have an email address, you’d want to email the document, otherwise you would want to print it. This is exactly what the previous versions would do.

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

MDGP 2018 R2 Feature of the Day: New Sort Options in Sales Order Processing Item Inquiry Window

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The twenty-third Feature of the Day is new sort options in Sales Order Processing Item Inquiry window.

The Sales Order Processing Item Inquiry window has a new Sort By option available; this lets users quickly find the information they are looking for because now they can sort, either ascending or descending, by the following fields:

  • Document Number
  • Document Type
  • Item Number
  • Document Date
  • Customer ID
Sales Order Processing Item Inquiry

This is a good addition as being able to sort by Document Date is a very common request.

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

MDGP 2018 R2 Feature of the Day: New SmartList for Deposits on Unposted Sales Transactions Has Been Created

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The ninth Feature of the Day is a new SmartList for deposits on unposted Sales Transactions has been created.

Deposits on Unposted Sales Transactions is a new favorite under Sales Transactions so you can quickly see customers that have put a deposit on a sales transaction but the sales transaction hasn’t been posted; no more searching through the sales records to see the deposits, now you have a new SmartList to view the details:

New SmartList for Deposits on Unposted Sales Transactions Has Been Created

Continue reading “MDGP 2018 R2 Feature of the Day: New SmartList for Deposits on Unposted Sales Transactions Has Been Created”

MDGP 2018 R2 Feature of the Day: Transaction Level Post Through General Ledger

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The seventh Feature of the Day is transaction level post through general ledger. This feature is a new posting option in the Posting Setup window (Administration area page » Setup » Posting » Posting); when Allow Transaction Posting is marked, a new checkbox for Post Through General Ledger Files is now available:

Posting Setup

Continue reading “MDGP 2018 R2 Feature of the Day: Transaction Level Post Through General Ledger”