Message Image  

Open Forum

Manual Check/Payment Entry - Status H

  • 1.  Manual Check/Payment Entry - Status H

    Posted 08-29-2017 05:59 PM
    ​​I entered a Manual Check, but did not print the check before exiting the batch.

    The batch is showing on the AP Batch Register with a status of H.

    The Batch does not show up using F3 on any of these screens:
    Manual Check/Payment Entry
    AP Check Update
    Edit/Select Documents for Payment

    Batch doesn't show up in:
    AP Eraser
    Void Check
    Release AP Batches

    or in GL - Post Transactions.

    I can't find the batch in order to print or even void the batch.

    I've been using Dynamics for 4 years and have I've never experienced this before.

    Any help will be appreciated.

    Lynn Johansen


    ------------------------------
    Lynn Johansen
    Mojave Air & Space Port
    Mojave CA
    ------------------------------


  • 2.  RE: Manual Check/Payment Entry - Status H

    Posted 08-30-2017 09:47 AM
    ​In Accounts Payable menu. Under the processes tab you should see an option to click "AP Check Update (Post)" this should take your Manual check off hold and then allow you to go to check registers and print of the summary of that manual check. Let me know if that works.

    ------------------------------
    Kaleb DeJager
    WELSCH READY MIX, INC.
    OAK FOREST IL
    ------------------------------



  • 3.  RE: Manual Check/Payment Entry - Status H

    Posted 08-30-2017 11:40 AM
    ​I did try the AP Check Update. It doesn't show when I use F3 and when I manually type in the batch number it says it's invalid.

    ------------------------------
    Lynn Johansen
    Mojave Air & Space Port
    Mojave CA
    ------------------------------



  • 4.  RE: Manual Check/Payment Entry - Status H

    Posted 08-30-2017 09:50 AM
    ​Also if you are doing a manual check nothing is going to print because I take it that you hand wrote out the check or you made an online payment of some sort. You first need to make a voucher and then tie the check # to the voucher in the "Manual Check / payment entry screen"

    ------------------------------
    Kaleb DeJager
    WELSCH READY MIX, INC.
    OAK FOREST IL
    ------------------------------



  • 5.  RE: Manual Check/Payment Entry - Status H

    Posted 08-30-2017 11:53 AM
    ​The manual check selection is so I can post an electronic payment to a voucher that is already entered.

    These manual checks (electronic payment) are printed.

    I exited the batch before printing, now I can't get back into the batch.  It now has my vouchers locked up.

    ------------------------------
    Lynn Johansen
    Mojave Air & Space Port
    Mojave CA
    ------------------------------



  • 6.  RE: Manual Check/Payment Entry - Status H

    BRONZE CONTRIBUTOR
    Posted 08-31-2017 09:25 AM
    I've not ever used this method, so forgive me if I am too far off base - but does the batch show up when you F3 under the Checks (03.620.00) Report to pull there and print? We use Payment Selection first, then go to the Checks report to print. Just wondering if somehow it made its way there for you!

    ------------------------------
    Kristen Hillger
    Financial & Administrative Manager
    Eco-Drip Irrigation Supply
    Garden City TX
    ------------------------------



  • 7.  RE: Manual Check/Payment Entry - Status H

    SILVER CONTRIBUTOR
    Posted 09-01-2017 06:53 AM
    Lynn,

    I don't know what version you are on but there was a bug in SL2011 and there should still be a hot fix on the web site for that.  If you have access to SQL and are somewhat technical, you may be able to identify the culprit and change the status field on the BATCH or APDOC tables.  This script was published in 2014

    H or B status batches do not show in batch PV list in Manual Check/Payment Entry screen if there apdocs with T status

    Run this  SQL script on app DB(s)

    alter Proc 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
               order by BatNbr

    Load  a file like this in the "possible values import" screen

    File name 25892.csv

    "Select_03030_Batch","","","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 order by BatNbr DESC, EditScrnNbr","Batch","Batch.BatNbr;Batch Nbr;0;0","Batch.EditScrnNbr;Screen;0;0","Batch.Status;Status;0;0","Batch.PerPost;Period to Post;114;0","Batch.PerEnt;Period Entered;114;0","Batch.CtrlTot;Control Total   ;0;0"

    Just a few areas to look:
    From the front end of the application, if the check is not "printed", does it appear in the check preview?  If not,
    can you select the voucher you are trying to associate with the electronic payment in Edit and Select Documents for Payment (screen 03.050.00)?
    If you run a batch register report for that period (choose summary), is both the voucher batch and the payment batch listed and what is the status on each?  I have seen the manual payment batch be voided "V" status when releasing the voucher prior to the check print screen initializing.


    Reply


    ------------------------------
    David Callery
    Consultant
    Coe & Company, LLC
    New Orleans LA
    ------------------------------



  • 8.  RE: Manual Check/Payment Entry - Status H

    Posted 09-11-2017 12:35 PM
    ​Thanks for all the input.

    It's fixed now.

    ------------------------------
    Lynn Johansen
    Mojave Air & Space Port
    Mojave CA
    ------------------------------



  • 9.  RE: Manual Check/Payment Entry - Status H

    BRONZE CONTRIBUTOR
    Posted 10-29-2018 11:03 AM
    ​Does anyone know if this is still an issue with SL 2015 CU1?  I just had a client who experienced this issue.
    Thanks,
    Lucille

    ------------------------------
    Lucille Pileggi
    Project Manager/Consultant
    Intellitec Solutions LLC
    Wilmington DE
    ------------------------------