Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-243507 - Dashboard written|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-243507]
Unable to save panel with this syntax.
*SELECT *
* dtmDate*
* , strPeriod*
* , strCode*
* , strBatchId*
* , A.strTransactionId*
* , strUserName*
* , strDescription*
* , dblDebit*
* , dblCredit*
* , dblDebitUnit*
* , dblCreditUnit*
* , strUOMCode*
* , dblDebitForeign*
* , dblCreditForeign*
* , strReference*
* , strDocument*
* , strComments*
* , * FROM vyuGLDetail A *
*INNER JOIN tblGLTrialBalance B ON A.intAccountId = B.intAccountId*
* AND A.strTransactionId = B.strTransactionId *
*INNER JOIN tblGLFiscalYearPeriod C ON B.intGLFiscalYearPeriodId = C.intGLFiscalYearPeriodId*
* AND A.dtmDate BETWEEN C.dtmStartDate AND C.dtmEndDate*
*WHERE ISNULL(A.strTransactionId,'') <> ''*
* AND ISNULL(B.strTransactionId,'') <> ''*
* AND @DATE@*
Even if I removed the lines of the script, the result didn't change.
*ISNULL(A.strTransactionId,'') <> ''*
* AND ISNULL(B.strTransactionId,'') <> ''*
|