Hello

You can add SOPDespatchReceiptLines table in Join Editor and link that to SOPInvoiceCreditLines by SOPInvoiceCreditLineID which then allows you to add criteria for SOPDespatchReceiptLines.DespatchReceiptDate however you will also need to change the variables on the report as those generating information from SOPInvoiceCreditLines. For example, if a product were despatched at 2 different dates i.e. 01/08/2021 qty 5 and 10/08/2021 qty 3, invoice will still show qty of 8 whether you choose despatch date criteria of 01/08 or 10/08. You will need to change quantities to SOPDespatchReceiptLines.DespatchReceiptQuantity which will show correct info based on your criteria. Remember to amend the values too as those are coming from SOPInvoice table too.

Alternatively, you can use despatch note layout and amend it to create commercial invoice. This will already have the table for SOPDespatchReceipt, you will need to add criteria and expression to calculate the prices (SOPDespatchReceiptLines.DespatchReceiptQuantity * SOPOrderReturnLines.UnitSellingPrice)

You could also get this designed by Sage. I have added the link below for Sage 200 Report Design Service for more info. Sage 200 customers are entitled to 3 free designs per year.

https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112444124 

Hope this helps. 

Kind Regards,