Finance | Project Operations, Human Resources, ...

Vendor ageing report

(0) Share

Report

Posted on by RJ123

Hi Guys,

I have a question regarding the vendor ageing report. Is there a way to get on the report the vendors that have 0 as balance but with open entries (Entries that are not settled)

At the moment if we include vendors with balance at 0, we get all vendors even with those with no open entries.

Thanks in advance.

I have the same question (0)

All responses (10)

Answers (0)

huijij 19,811 on at

Like (0)

Report

Hi RJ123,

Did you try to add additional filter fields and query criteria by clicking on the filter?

Was this reply helpful? Yes No
RJ123 10 on at

Like (0)

Report

Please advise what additional filter I should apply to display open entries with zero balances and query criteria ?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi RJ123,

Have you tried to run the report as follows?

Was this reply helpful? Yes No
RJ123 10 on at

Like (0)

Report

Hi Alireza Eshaghzadeh, Yes tried as same. My question is At the moment if we include vendors with balance at 0, we get all vendors even with those with no open entries. Is there a way to get on the report the vendors that have 0 as balance but with open entries (Entries that are not settled)

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Do you mean vendor trans that are partially settled (Balance is not zero) or just vendor trans that are fully settled (Balance is zero)?

Was this reply helpful? Yes No
RJ123 10 on at

Like (0)

Report

Hi, In vendor ageing report the vendors that have 0 as balance but with open entries (Entries that are not settled) but equal to zero .

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi again,

Can you elaborate with a screenshot about vendors that have 0 as balance but with open entries? Do you mean zero invoices?

Was this reply helpful? Yes No
RJ123 10 on at

Like (0)

Report

Hi Again, please refer the screenshot for your reference.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi agian,

Thanks for the screenshot, It seems that you have not done the settlement of vendor invoices against the payment. Please try to perform the settlement, then when you run the report again you will not see the vendor trans with balance zero by activating alternative "Exclude zero balance accounts"

Was this reply helpful? Yes No
Nancy_6939 5 on at

Like (0)

Report

Invoices due in future report may be what you need. It shows:

*Invoices due in future

*Invoices due in future details

*Invoices due in future per company

*Invoices due in future per vendor group

*Invoices due in future by cash discount date

*Invoices due in future by due date

Was this reply helpful? Yes No