Outstanding Customer Documents- Outstanding Invoices Report

We are do consignment sale so we are using three-stage invoicing. Stock is issued first and customer invoices are processed based on what the client has sold (of the consignment issued to them). The Outstanding invoices report must help us to see how much of the consignment is still to be invoiced (expected income from the consignment). The issue on this report is that it does not account for customer goods return (CGR) when a credit note is processed against a GIV. This will result in the report showing incorrect outstanding invoice value. We suggest that you incorporate goods returns in the calculation. If you compare the report attached and the unprocessed tax invoice, you can see what we are referring to. The unprocessed invoice shows the correct values whilst the report shows the value of the original quantity issued without adjusting for good returned.