Bill Wise Vendor Pending Payment

[former_member645084]

Hi

How to get Vendor bill wise pending payments due query

Thanks

[Former Member]

Hello,

You can use Supplier Ageing Report.

[former_member645084]

Hi Taseeb

That's ok . If we want to create query what tables should be used. Bill Wise Pending Details

Thanks

[Former Member]

Hello J S,

You can use "OPCH" and "PCH1" tables to get Pending Due Invoices with Due Amount , you can group the report on Supplier and Bill No.

Regards,

Taseeb Saeed

[former_member645084]

Hi Taseeb

Which is the field for getting Due Amount

Thanks

[Former Member]

Hello,

Updated query

select 
T0."CardCode"
,T0."CardName"
,T0."DocEntry"
,T1."Account" 
,T1."ShortName"
,T1."Debit"
,T1."Credit"
,T0."DocTotal" - T0."PaidToDate" "Balance Due"
from "OPCH" T0
left outer join "JDT1" T1 on T0."TransId" = T1."TransId"
where T0."DocStatus" = 'O'

[former_member645084]

Hi Taseeb

My requirement is numatcard wise . Vendor Bill wsie . In above query there is no reference

Thanks

[Former Member]

Hello,

You can select the NumAtCard in the query.

select 
T0."CardCode"
,T0."CardName"
,T0."DocEntry"
,T1."Account" 
,T1."ShortName"
,T1."Debit"
,T1."Credit"
,T0."DocTotal" - T0."PaidToDate" "Balance Due"
,T0."NumAtCard"
from "OPCH" T0
left outer join "JDT1" T1 on T0."TransId" = T1."TransId"
where T0."DocStatus" = 'O'