Open Forum

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
------------------------------

Hi Maurice -

T is a Temporary status in AP.  It is for checks applied to vouchers before the checks are released.  I would look in Manual Check / Payment Entry (03.030.00) and see if the batch is on hold there.  If so, just release it and should be good to go...

Thanks,
Michael

------------------------------
Michael O'Neill
Controller
Eastex Telephone Cooperative
Henderson TX
------------------------------

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
------------------------------

Michael,
Thank you for responding.
Nothing on hold.

------------------------------
Maurice Shallow
Chief Financial Officer
Association of Illinois Electric Cooperatives
Springfield IL
------------------------------

Original Message:
Sent: 02-07-2019 04:04 PM
From: Michael O'Neill
Subject: Electronic Payment

Hi Maurice -

T is a Temporary status in AP.  It is for checks applied to vouchers before the checks are released.  I would look in Manual Check / Payment Entry (03.030.00) and see if the batch is on hold there.  If so, just release it and should be good to go...

Thanks,
Michael

------------------------------
Michael O'Neill
Controller
Eastex Telephone Cooperative
Henderson TX

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
------------------------------

Check the AP Check update screen - click in the batch number field and see if your batch has not been processed

------------------------------
Randy Andrews
Manager - SL Support
RSM USA
Gaithersburg
------------------------------

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
------------------------------

There is a known bug for that exact issue. The fix is to remove a clause in the SQL statements for both the Select_03030_Batch PV and stored procedure used for the Batch field on the Manual Check/Payment Entry (03.030.00) screen. The clause to be removed removed from the below code is

       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​

If you have never altered a stored procedure or PV, ask your Dynamics SL consultant to do this for you.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY
------------------------------

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
------------------------------

Jonathan,

Thank you!!!

------------------------------
Maurice Shallow
Chief Financial Officer
Association of Illinois Electric Cooperatives
Springfield IL
------------------------------

Original Message:
Sent: 02-08-2019 06:42 AM
From: Jonathan Van Houtte
Subject: Electronic Payment

There is a known bug for that exact issue. The fix is to remove a clause in the SQL statements for both the Select_03030_Batch PV and stored procedure used for the Batch field on the Manual Check/Payment Entry (03.030.00) screen. The clause to be removed removed from the below code is

and BatNbr not in (Select BatNbr from APDoc where Status = 'T')

       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​

If you have never altered a stored procedure or PV, ask your Dynamics SL consultant to do this for you.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY

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
------------------------------

I ran the above and there were 0 rows affected.  I ran below and the voucher is there, with the correct CpnyID, .
Select * from batch where batnbr = '010227' and module = 'AP'

Thank you for your assistance.

------------------------------
Maurice Shallow
Chief Financial Officer
Association of Illinois Electric Cooperatives
Springfield IL
------------------------------

Original Message:
Sent: 02-08-2019 06:42 AM
From: Jonathan Van Houtte
Subject: Electronic Payment

There is a known bug for that exact issue. The fix is to remove a clause in the SQL statements for both the Select_03030_Batch PV and stored procedure used for the Batch field on the Manual Check/Payment Entry (03.030.00) screen. The clause to be removed removed from the below code is

and BatNbr not in (Select BatNbr from APDoc where Status = 'T')

       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​

If you have never altered a stored procedure or PV, ask your Dynamics SL consultant to do this for you.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY

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
------------------------------

Please ask your Dynamics SL consultant to make the alterations I described.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY
------------------------------

Original Message:
Sent: 02-08-2019 11:09 AM
From: Maurice Shallow
Subject: Electronic Payment

I ran the above and there were 0 rows affected.  I ran below and the voucher is there, with the correct CpnyID, .
Select * from batch where batnbr = '010227' and module = 'AP'

Thank you for your assistance.

------------------------------
Maurice Shallow
Chief Financial Officer
Association of Illinois Electric Cooperatives
Springfield IL

Original Message:
Sent: 02-08-2019 06:42 AM
From: Jonathan Van Houtte
Subject: Electronic Payment

There is a known bug for that exact issue. The fix is to remove a clause in the SQL statements for both the Select_03030_Batch PV and stored procedure used for the Batch field on the Manual Check/Payment Entry (03.030.00) screen. The clause to be removed removed from the below code is

and BatNbr not in (Select BatNbr from APDoc where Status = 'T')

       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​

If you have never altered a stored procedure or PV, ask your Dynamics SL consultant to do this for you.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY

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
------------------------------

Original Message------

Please ask your Dynamics SL consultant to make the alterations I described.

------------------------------
Jonathan Van Houtte
Architect
XLstatements, LLC
Clifton Park NY
------------------------------

​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
------------------------------

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
------------------------------