Problem with Customers statement ( Unpaid invoices) report

Hello Mr @lubos can you help us to put Customer statement (unpaid invoices) report for a specific period like someone can be able to see unpaid invoices for the period of May only or one week and others.

Hello @Matembe,

Although you must have your reasons for this unusual request, but a statement by definition should add up to the total receivable amount as of date.

This means that the report you are asking for is not a Customer Statement.

Don’t fret, however, the report you ask for can be done using Advanced Queries done on Sales Invoices:

Thank you Mr @Ealfardan this report is what I mean to have a specific period report but also can you help me how to Disable negative inventory sale because it is a very big challenge to my business I don’t want to sale negative inventory stock.

IMG_20260602_144443