Share
ReportHello There,
I have created a excel report to show the open payable. Since I wanted to have only the open transactions I given the restrictions current transaction amount <> 0. This is working and bringing all invoicing not yet paid but its ignoring the returns and un-applied amounts. Can anyone help on this. The query is as follows.
select
* from ONE..PM20000 T1 with (nolock)
INNER JOIN ONE..POP10306 T2 with (nolock)
on
T2.[POPRCTNM] = T1.[DOCNUMBR]
where T1.[CURTRXAM] <> '0.00'
Thanks,
Babu
*This post is locked for comments
All responses (
Answers (
32,738
