PS query
Hello,
I'm adding a field I.NAME2 (this field resides in PS_VENDOR 1 to the existing query, but when i do that i do not get AP data in the result. When i remove I.NAME2 i get AP data. I'm also adding this field to the Top query as an expression.
Not sure why just adding another field is not fetching AP data.
Could someone please throw light what i missing?
Thanks
Below is the sql.
SELECT A.JRNL_HDR_STATUS, A.BUSINESS_UNIT, A.JOURNAL_ID, A.DESCR, A.LEDGER_GROUP, A.SOURCE, A.TRANS_REF_NUM, A.ACCOUNTING_PERIOD, (CONVERT(CHAR(10),A.JOURNAL_DATE,121)), B.ACCOUNT, C.DESCR, B.DEPTID, B.PROJECT_ID, B.JRNL_LN_REF, B.LINE_DESCR, ROUND( B.MONETARY_AMOUNT, 2,1), A.OPRID, '', '', '', '', '', '', A.DTTM_STAMP_SEC
I'm adding a field I.NAME2 (this field resides in PS_VENDOR 1 to the existing query, but when i do that i do not get AP data in the result. When i remove I.NAME2 i get AP data. I'm also adding this field to the Top query as an expression.
Not sure why just adding another field is not fetching AP data.
Could someone please throw light what i missing?
Thanks
Below is the sql.
SELECT A.JRNL_HDR_STATUS, A.BUSINESS_UNIT, A.JOURNAL_ID, A.DESCR, A.LEDGER_GROUP, A.SOURCE, A.TRANS_REF_NUM, A.ACCOUNTING_PERIOD, (CONVERT(CHAR(10),A.JOURNAL_DATE,121)), B.ACCOUNT, C.DESCR, B.DEPTID, B.PROJECT_ID, B.JRNL_LN_REF, B.LINE_DESCR, ROUND( B.MONETARY_AMOUNT, 2,1), A.OPRID, '', '', '', '', '', '', A.DTTM_STAMP_SEC
0