Smartlist Excel Report Builder

(0) Share

Report

Posted on by babubaskaran@outloo...

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

T2.[POPRCTNM] = T1.[DOCNUMBR]

where T1.[CURTRXAM] <> '0.00'

Thanks,

Babu

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Smartlist Excel Report Builder

You are absolutely right, the current transaction amount is what you need to consider. Although, you may want to consider the following SQL views by MVP Victoria Yudin;

SQL view to show AP apply information in GP

SQL view for Payables payment apply detail in GP

Hope this helps,