GST Collected not Reconciling

Hi,

the business I work for reports GST on a cash basis, quarterly.

We generate orders and require a part payment. This order is then changed in to an invoice when delivery takes place. As we have accepted a part payment with a GST component, we have found MYOB is not picking this up in the GST Collected control account until the order is changed to invoice.

Hence the GST Cash report and the Trial balance GST Collected GL are not reconciling.

Does anyone know if there is a report to run that shows all orders changed to invoices during the current reporting BAS period that would have received funds in a previous BAS period?

Thank you.