You’re offline. This is a read only version of the page.
12
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)
on
T2.[POPRCTNM] = T1.[DOCNUMBR]
where T1.[CURTRXAM] <> '0.00'
Thanks,
Babu
*This post is locked for comments
I have the same question (0)
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,
Share
Report
All responses (
Answers (
