Open Forum

AP - SL Crashed During Check Print

  • 1.  AP - SL Crashed During Check Print

    BRONZE CONTRIBUTOR
    Posted Dec 05, 2019 05:24 PM
    One of our AP processors was printing a check and during that time her SL crashed. The check printed however the batch is not released and it is in a status of T with a doctype of VC.  I looked in AP Check Update but the batch wasn't there to Keep All and the batch is not in Release AP Batches to release.  I can't seem to see it anywhere to update it.  Has anyone had this situation before?  What can we do to get this released and posted?  We are on SL2018 CU1.  Any advice is appreciated.

    Thanks,

    ------------------------------
    Valerie VanAntwerp
    ERP Associate
    MCKenney's, Inc
    Atlanta GA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: AP - SL Crashed During Check Print

    GOLD CONTRIBUTOR
    Posted Dec 06, 2019 06:31 AM
    Valerie,

    In SQL on the company database, check the APCheck and APCheckDet tables.  If the data is still in these tables and the proper check number is associated with the transactions, you should be able to update the status on the Batch in the Batch table to 'K' and it will show in the Check Update process and you can post.

    update batch set status = 'K' where batnbr = XXXXXX and module = 'AP'

    ------------------------------
    David Callery
    Consultant
    Coe & Company, LLC
    Jefferson LA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: AP - SL Crashed During Check Print

    BRONZE CONTRIBUTOR
    Posted Dec 06, 2019 09:19 AM
    All the records were there, so that worked perfectly.  Thank you!

    ------------------------------
    Valerie VanAntwerp
    ERP Associate
    MCKenney's, Inc
    Atlanta GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: AP - SL Crashed During Check Print

    TOP CONTRIBUTOR
    Posted Dec 06, 2019 08:45 AM
    Dynamics SL was designed to handle the situation where the check process crashes during check printing.    The check printing process leaves the check document with a status of "T", and that should mean you can fix the problem within standard SL functionality.

    I'm guessing that what happened in this case is that the user never got as far as the "Keep/Delete" option for the batch.    The AP Check Update screen (03.620.20) can be opened separately.where you can pull up the proper period to post and batch number, and then do our Keep/Delete process.

    If you can't find the screen in order to open it, you may be able to search for it in the search area on the top right of the main menu using the screen number (0362020).   Make sure you have focus on "Home" when searching.   Failing that, and if you're familiar with the menu functionality, you can do what we did which was to add this screen to our check processing menu.

    If that doesn't work, then you may need to resort to SQL but for us, this works 95% of the time.  You shouldn't need to use SQL to fix this.    We only use SQL as a last resort.

    Best regards,


    ------------------------------
    Gail Jones-Nemeth
    Financial Systems Analyst
    Creative Associates Int'l
    Washington DC
    ------------------------------

    Academy - Online Interactive Learning from Experts