Can't find invoices for the Vendor/Customer consolidation

(0) Share

Report

Posted on by DominicBeland

330

Hello, one of my client is trying to clean VEndor/Customer transaction. however, it's not listing all of the transaction of the customer.

when I look how the list is populated, Dynamcis Runs this:

BEGIN DECLARE @stored_proc_name char(27) DECLARE @retstat int DECLARE @param6 int set nocount on SELECT @stored_proc_name = 'SOI.dbo.papQueryOpenRecords' EXEC @retstat = @stored_proc_name 'RMPMXFR sa', 'OPTOPLUS', 'OPTOPLUS', 'OPTOPLUS', '2018.10.19', @param6 OUT SELECT @retstat, @param6 set nocount on END

When looking into the papQueryOpenRecords, if I run the first select statement for customer OPTOPLUS, it pulls out the missing invoices. So I'm kinda at a loss as to why those records are not inserted where they should be.