Scheduled Payments do not display in the Post Payables Scheduled Payments window in Microsoft Dynamics GP

SYMPTOMS


Scheduled Payments that fall within the Due Date Cutoff do not appear in the Post Payables Scheduled Payments window in Microsoft Dynamics GP.


CAUSE


In the PM20400 table, the PM Scheduled Payments Header table, and the PM20401 table, the PM Scheduled Payment LINE, the Status of the transaction is set to 2. A Status of 2 means that the transaction has already been posted; a Status of 1 means the transaction is unposted.


RESOLUTION


Use SQL Server Management Studio to determine the Status of the transactions that are not showing.

1. 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 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 2: 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.

   Method 3: For SQL Server 2008

   If you are using SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
   
   Type your Login Name and Password and then click OK. Then, select your company database.
2. Type the following select statement, click to affect the selected Company database, and then click Execute (F5):
   
   
   

   Select * from PM20400

3. If the transactions in question show a Status of 2, type the following update statement, click to affect the selected Company database, and then click execute (F5):
   
   
   

   Update PM20400 set Status = '1' where DEX_ROW_ID = 'X' 
   
   (where X =theDEX_ROW_ID)

4. For the second table, type the following select statement, click to affect the selected Company database, and then click Execute (F5):
   
   
   

   Select * from PM20401
   

5. If the transactions in question show a Status of 2, type the following update statement, click to affect the selected Company database, and then click execute (F5):
   
   
   

   Update PM20401 set Status = '1' where DEX_ROW_ID = 'X' 
   
   (where X =theDEX_ROW_ID)

This article was TechKnowledge Document ID:34197