General Consultant Discussion

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

That's normal functionality with DSD Multi-currency. Here's a link to the manual for APMC which describes this: https://development.dsdinc.com/enh/downloads/APMC600.pdf

------------------------------
Nicole Ronchetti
DSD Business Systems
------------------------------

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