Big thanks to
Mike Lee for the help! Thank you for everyone else the helped!!!
He ran ALTER To and took care of my issue.
USE [SIVApplication]
GO
/****** Object: StoredProcedure [dbo].[Select_03030_Batch] Script Date: 2/11/2019 9:00:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
--- DCR added 5/6/98
--- DCR removed status = 'V' 12/17/98
ALTER Proc [dbo].[Select_03030_Batch] @parm1 varchar(10), @parm2 varchar ( 10) as
Select * from Batch
where CpnyID = @parm1
and ((EditScrnNbr = '03030' and status in ('B','C','H','P','S','U'))
OR (EditScrnNbr = '03620'and status in ('C','P','U')))
and module = 'AP'
and BatNbr like @parm2
-- and BatNbr not in (Select BatNbr from APDoc where Status = 'T')
order by BatNbr
GO
------------------------------
Maurice Shallow
Chief Financial Officer
Association of Illinois Electric Cooperatives
Springfield IL
------------------------------
Original Message:
Sent: 02-08-2019 10:10 AM
From: Lucille Pileggi
Subject: Electronic Payment
It sounds like a bug (bug 25982) where a manual check batch is on hold and the quick check field is set to yes. It is an issue )with the PV. Please look at this article. https://community.dynamics.com/sl/f/35/t/139628
manual check batch gone missing - Microsoft Dynamics SL Forum Community Forum
Dynamics |
remove preview |
 |
manual check batch gone missing - Microsoft Dynamics SL Forum Community Forum |
I am unble to find a manual check batch I created with one manual check in it. I can clearly see it looking in reports such as "AP Batch register" and "unreleased AP Batch", with document status "t" and batch status "H". But I can not F3 in the manual batches and find it. |
View this on Dynamics > |
|
|
------------------------------
Lucille Pileggi
Consultant
Intellitec Solutions LLC
Wilmington DE
Original Message:
Sent: 02-07-2019 02:50 PM
From: Maurice Shallow
Subject: Electronic Payment
Trying to record an electronic payment and have been unable to release.
I can see the batch is on hold. I have no idea what Status T is.
I am unable to find the batch or check #072662 any where to release it. Vendor Maintenance is still showing balance due of $55.83.
Nothing is showing up in Release AP Batches. Check number 072662 is showing as Missing in the Check Register.
Thank you,
------------------------------
Maurice Shallow
Chief Financial Officer
Association of Illinois Electric Cooperatives
Springfield IL
------------------------------