Open Forum

Electronic Payment

  • 1.  Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 07, 2019 02:50 PM
    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
    ------------------------------


  • 2.  RE: Electronic Payment

    SILVER CONTRIBUTOR
    Posted Feb 07, 2019 04:04 PM
    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
    ------------------------------



  • 3.  RE: Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 08, 2019 08:35 AM
    Michael,
    Thank you for responding.
    Nothing on hold.

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



  • 4.  RE: Electronic Payment

    Posted Feb 07, 2019 10:15 PM
    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
    ------------------------------



  • 5.  RE: Electronic Payment

    SILVER CONTRIBUTOR
    Posted Feb 08, 2019 06:42 AM
    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
    ------------------------------



  • 6.  RE: Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 08, 2019 08:34 AM
    Jonathan,

    Thank you!!!

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



  • 7.  RE: Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 08, 2019 11:10 AM
    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
    ------------------------------



  • 8.  RE: Electronic Payment

    SILVER CONTRIBUTOR
    Posted Feb 08, 2019 11:13 AM
    Please ask your Dynamics SL consultant to make the alterations I described.

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



  • 9.  RE: Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 08, 2019 11:34 AM

    Thank you for your assistance!

     

    Thank you,

     

    Maurice

     






  • 10.  RE: Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 08, 2019 10:10 AM
    ​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
    ------------------------------



  • 11.  RE: Electronic Payment

    BRONZE CONTRIBUTOR
    Posted Feb 11, 2019 10:16 AM
    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
    ------------------------------