Sage 100

 View Only

  • 1.  AP Check Date and Bank Code greyed out

    Posted 05-28-2019 12:10
    We have a client who recently upgraded to Sage 100 2018 Advanced (PU5).  Since the upgrade, the client cannot change the Check Date or Bank Code fields when printing checks in AP.  When trying to use the ALE for these two fields, the system returns the following message:
      Query Sub-system
       Sorry...There is no query available for this input field.

    Replacing the Advanced Lookup Engine (ALE) query files did not resolve the issue.  The issue presents regardless of workstation or user.  We also tested copying the data to a test company, but the issue present for all companies, new and old, as well.  Reinstalling the DSD multi-currency enhancement also did not resolve the issue. 

    We noticed a similar post on Sage City from 2014, but it showed no posted resolution.  Nonetheless, it seems like an issue that has occurred elsewhere and for some time, so we are hoping for some guidance.

    Any thoughts??

    Cheers,

    ------------------------------
    James O'Curran
    CMS | Computer Management Services
    Essex, CT
    860.399.4215 x202
    ------------------------------


  • 2.  RE: AP Check Date and Bank Code greyed out

    Posted 05-28-2019 12:25
    SWAGS

    Trying running in MAS90 mode?
    Try user with full access role?
    What did DSD offer?

    Problem is Sage tech support won't offer any assistance once you say there is an enhancement involved....

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: AP Check Date and Bank Code greyed out

    Posted 05-28-2019 12:42
    We've been asked this a few times and I'm 99% sure this is how Multi-Currency works.  You set the bank code and date when starting a batch, not on the fly while printing checks.
    That error is what shows when using a lookup on a read-only field.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: AP Check Date and Bank Code greyed out

    Posted 05-28-2019 12:50
    There's batches in AP check printing?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, and Cagney
    Beth Bowers
    269-445-1625
    ------------------------------

    Original Message


  • 5.  RE: AP Check Date and Bank Code greyed out

    Posted 05-28-2019 12:54
    One batch at a time... unless you have an enhancement.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: AP Check Date and Bank Code greyed out

    Posted 05-30-2019 11:47
    With DSD assistance, we were able to resolve a known issue.  Using DFDM, we located the batch number field in a the multi-currency file for the problem bank code (AP234_APMC_CheckDateEntry.m4t).  It was set to a null value rather than carrying a required last or initial value.  We changed the value was changed to "00001" using DFDM, and the check date was subsequently available for selection during check printing.  Issue resolved!​

    ------------------------------
    James O'Curran
    Computer Management Services
    Essex CT
    ------------------------------



Related Content