web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics GP DexLog SQL...
Finance | Project Operations, Human Resources, ...
Unanswered

Dynamics GP DexLog SQL Query different on Server and Client

(1) ShareShare
ReportReport
Posted on by sandipdjadhav 18,306
Hello Team,
On Vendor Open Void Transaction screen when I run the Dex Log on server and client I get two different "Where Clause" and because of that on Client machine the results are different.
 
 
SELECT TOP 25 VCHRNMBR,VENDORID,DOCTYPE,DOCDATE,DOCNUMBR,DOCAMNT,CURTRXAM,DISTKNAM,DISCAMNT,DSCDLRAM,BACHNUMB,TRXSORCE,BCHSOURC,DISCDATE,DUEDATE,PORDNMBR,TEN99AMNT,
WROFAMNT,DISAMTAV,TRXDSCRN,UN1099AM,BKTPURAM,BKTFRTAM,BKTMSCAM,VOIDED,HOLD,CHEKBKID,DINVPDOF,PPSAMDED,PPSTAXRT,PGRAMSBJ,GSTDSAMT,POSTEDDT,PTDUSRID,MODIFDT,MDFUSRID,
PYENTTYP,CARDNAME,PRCHAMNT,TRDISAMT,MSCCHAMT,FRTAMNT,TAXAMNT,TTLPYMTS,CURNCYID,PYMTRMID,SHIPMTHD,TAXSCHID,PCHSCHID,FRTSCHID,MSCSCHID,PSTGDATE,DISAVTKN,CNTRLTYP,NOTEINDX,
PRCTDISC,RETNAGAM,ICTRX,Tax_Date,PRCHDATE,CORRCTN,SIMPLIFD,BNKRCAMT,APLYWITH,Electronic,ECTRX,DocPrinted,TaxInvReqd,VNDCHKNM,BackoutTradeDisc,CBVAT,VADCDTRO,TEN99TYPE,
TEN99BOXNUMBER,PONUMBER,Workflow_Status,InvoiceReceiptDate,LNGDESC,DEX_ROW_TS,DEX_ROW_ID 
FROM BBKX.dbo.PM20000 WHERE (VENDORID = 'VC072' AND DOCTYPE BETWEEN 1 AND 6 AND DOCNUMBR BETWEEN '' AND 'Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’Û’' AND DOCDATE BETWEEN '19000101' AND '99991231') 
ORDER BY VENDORID ASC ,DOCTYPE ASC ,DOCNUMBR ASC ,DOCDATE ASC ,DEX_ROW_ID ASC 



SERVER QUERY-------------

SELECT TOP 25 VCHRNMBR,VENDORID,DOCTYPE,DOCDATE,DOCNUMBR,DOCAMNT,CURTRXAM,DISTKNAM,DISCAMNT,DSCDLRAM,BACHNUMB,TRXSORCE,BCHSOURC,DISCDATE,DUEDATE,PORDNMBR,TEN99AMNT,
WROFAMNT,DISAMTAV,TRXDSCRN,UN1099AM,BKTPURAM,BKTFRTAM,BKTMSCAM,VOIDED,HOLD,CHEKBKID,DINVPDOF,PPSAMDED,PPSTAXRT,PGRAMSBJ,GSTDSAMT,POSTEDDT,PTDUSRID,MODIFDT,MDFUSRID,
PYENTTYP,CARDNAME,PRCHAMNT,TRDISAMT,MSCCHAMT,FRTAMNT,TAXAMNT,TTLPYMTS,CURNCYID,PYMTRMID,SHIPMTHD,TAXSCHID,PCHSCHID,FRTSCHID,MSCSCHID,PSTGDATE,DISAVTKN,CNTRLTYP,NOTEINDX,
PRCTDISC,RETNAGAM,ICTRX,Tax_Date,PRCHDATE,CORRCTN,SIMPLIFD,BNKRCAMT,APLYWITH,Electronic,ECTRX,DocPrinted,TaxInvReqd,VNDCHKNM,BackoutTradeDisc,CBVAT,VADCDTRO,TEN99TYPE,
TEN99BOXNUMBER,PONUMBER,Workflow_Status,InvoiceReceiptDate,LNGDESC,DEX_ROW_TS,DEX_ROW_ID 
FROM BBKX.dbo.PM20000 
WHERE (VENDORID = 'VC072' AND DOCTYPE BETWEEN 1 AND 6 AND DOCNUMBR BETWEEN '' AND 'ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ' AND DOCDATE BETWEEN '19000101' AND '99991231') 
ORDER BY VENDORID DESC ,DOCTYPE DESC ,DOCNUMBR DESC ,DOCDATE DESC ,DEX_ROW_ID DESC
 
Client Windows Version: 
 
 
Any help on this is highly appreciated.

Thanks much
Sandip
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 14,095 Most Valuable Professional on at
    I would recommend checking your ODBC settings on both machines and ensuring that none of the checkboxes are selected.

    The code you have highlighted is a range on any value for Document Number.

    Starting with the minimum (cleared) value, which is an empty string.
     
    Ending with the maximum (filled) value, which is the maximum character value 255 padded to the length of the field. Inside Dexterity and on a binary sort order SQL system this is the y with the dots on top (ÿ) character.
     
    On a non binary, DOCI (document order case insensitive) sort order SQL system this character is usually (þ) which is character value 254.
    The maximum character for the current SQL system's sort order is identified using the SQL command below:
     
    exec master.dbo.smDEX_Max_Char
     
    I don't know what your system has identified the (Û’) character.
     
    What is your SQL Server Sort Order/Collation set to?  Is it one for the sort orders actually supported by Microsoft Dynamics GP?
     
    Hope this helps.
     
    Kind regards
     
    David
     
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at
    Hello David, 
    Much appreciated for your reply.  Let me get the sql sort orders and other details asap. 
     
    FYI- Customer local client machine does have arabic enabled.  This can be issue. Need to check the regional setting in Server and Client computers too.
     
    Thanks much
    Sandip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans