Automated solutions are available for the Distribution series in Microsoft Dynamics GP

INTRODUCTION

This article describes the automated solutions that may be available for the Distribution series in Microsoft Dynamics GP 9.0 and GP 10.0. All automated solutions are not available for all product versions. You can use automated solutions to simplify certain tasks that typically require the following things:

• Knowledge of the SQL query language
• Access to SQL query tools
• Access to the Support Administrator Console



MORE INFORMATION

How to obtain automated solutions

Visit the following Microsoft Web site to access the automated solutions for the Distribution series in Microsoft Dynamics GP.


Customers

https://mbs.microsoft.com/customersource/northamerica/GP/support/support-news/AutomatedSolutions

Partners

https://mbs.microsoft.com/partnersource/northamerica/support/support-news/AutomatedSolutions

 

List of automated solutions for the Distribution series

The following automated solutions are available for the Distribution series in Microsoft Dynamics GP.

Module

Automated Solution Name

Description

Purchase Order Processing

Auto-Receiving Interruption

This automated solution deletes the receipt from a Purchase Order Processing table so that the auto-receiving task can be processed again.

Purchase Order Processing

“Purchase order being edited by another user” error

This automated solution resolves a problem in which you receive a “Purchase order being edited by another user” error message. The automated solution clears the following tables: ACTIVITY, SY00800, SY00801, DEX_LOCK, and DEX_SESSION.

Sales Order Processing

“This document is being edited by another user” error

This automated solution resolves a problem in which you receive a "Sorry, this document is being edited by another user" error message when you enter Sales Order Processing transactions or when you try to perform the reconcile process. The automated solution will clear any invalid user sessions.

Sales Order Processing

Duplicates in Sales Order Processing

This automated solution will search the Sales Order Processing tables for duplicate records so that you can delete them.

Sales Order Processing

“Document has already been posted” error

This automated solution searches for duplicate records in the Sales Order Processing tables. It also verifies the status of Sales Order Processing documents. Changes are made to enable you to post the document.

APPLIES TO

Microsoft Dynamics GP 10.0

Microsoft Dynamics GP 9.0

Microsoft Business Solutions–Great Plains 8.0

Sales Order Processing

Purchase Order Processing

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS. 

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×