Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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



     

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


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. 

↑ Back to the top


Keywords: kb, kbnosurvey, kbinfo, kbMBSPartner, kbMBSMigrate, kbExpertiseInter, ATDownload, BemisKB935383

↑ Back to the top

Article Info
Article ID : 935383
Revision : 1
Created on : 3/23/2017
Published on : 3/23/2017
Exists online : False
Views : 195