web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Manual Checks Remitance
Microsoft Dynamics GP (Archived)

Manual Checks Remitance

(0) ShareShare
ReportReport
Posted on by SvetKanev 370

when we post manual payment, for some reson it creates additional remitence transaction for $0  i know in my old company where we used GP it never happened is there some sep up that i need to change ?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi,

    Perhaps the following knowledge base article can help?

    Best regards, Ian.

    Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

    INTRODUCTION

    This article discusses how to prevent zero dollar remittances from printing in Payables Management in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.

    Note To prevent zero dollar remittances from printing, you must have administrator access to Microsoft Dynamics GP and the instance of Microsoft SQL Server.

    For more information about how manual payments appear on the check stub and when they are removed from the PM20000 table and from the PM20100 table, click the following article number to view the article in the Microsoft Knowledge Base:
    860395 Information about how manual payments appear on the check stub and when they are removed from the PM20000 table and from the PM20100 table when you run the Select Checks process in Microsoft Dynamics GP
    For more information about how payments that have amounts of zero are treated in Payables Management, click the following article number to view the article in the Microsoft Knowledge Base:
    861276 How payments that have amounts of zero are treated in Payables Management in Microsoft Dynamics GP

    MORE INFORMATION

    To prevent zero dollar remittances from printing, follow these steps.

    Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
    1. Use the appropriate method:
    • If you are running Microsoft Dynamics GP 10.0, on the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Purchasing, and then click Payables.
    • If you are running Microsoft Dynamics GP 9.0 or Microsoft Business Solutions-Great Plains 8.0, on the Tools menu, point to Setup, point to Purchasing, and then click Payables.
    2. In the Payables Management Setup window, click to clear the Print Previously Applied Documents on Remittance check box.
    3. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

    Method 1: For SQL Server Desktop Engine

    If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.

    Method 2: For SQL Server 2000

    If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.

    Method 3: For SQL Server 2005

    If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
    4. Run the following statement against the company database to remove the zero dollar remittances in Payables Management.
    /* The following code is used to remove zero dollar remittances for a specific vendor. */ 

DELETE PM20100 
WHERE VendorID = 'VendorID' 
AND KeySourc = 'REMITTANCE'

/* The following code is used to remove all zero dollar remittances. */ 

DELETE PM20100 
WHERE KeySourc = 'REMITTANCE'
    Note In the code, the VendorID placeholder represents the actual vendor identifier.

    After you do this, the batches of checks that were created before you ran the statement are also updated.
    APPLIES TO
    • Payables Management, when used with:
        Microsoft Dynamics GP 10.0
        Microsoft Dynamics GP 9.0
        Microsoft Business Solutions–Great Plains 8.0
    Back to the top Back to the top
    Keywords: 
    		 kbinfo kbexpertisebeginner kbhowto kbexpertiseinter kbmbspartner kbmbsmigrate KB855957

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans