INVOICE.CUSTOMER_ORDER_NUMBER is the field you want but you'll have to design a custom report

This Sage help page should help locate field names

Thanks for swift reply, but the 'customer order number'  - see below extract from invoice - doesn't appear to be there?

I'm confused - Can you explain which Customer Order Number you are referring to on that screen shot ?  The one blacked out ?

The bottom right box

That's the one I've given you the field name of so I dont understand what the issue is ?

PeterM1980 said:

I need an excel export of all SIs posted in month including this detail in addition to ref, date, cust detail, amount, etc

If this needs to be report designder - what field do I need to look for?

Ken is correct. It would be the same field in Report Designer or Excel.

I can't see that as an option on the add data field box in report designer?

Is this a custom report or are you trying to adapt an existing one? Have you added the INVOICE table to the joins?

Thanks.  I was trying to add that field to an audit trail detailed report. How do I add the invoice table? Sorry I am a novice at this (Sage report designing, not accounting!). Can I only add that field to certain reports?

You can only add the field if he table is part of the report, which in the case of the 'Audit Trail (detailed)' report it will not be as that is based on the transactions rather than the invoice artefacts. You could add the INVOICE table in to the joins via Report -> Joins but there is no reliable link between the transaction and the invoice artefact. Potentially you could join from AUDIT_HEADER.ISP_REFERENCE to INVOICE.INVOICE_NUMBER but there is potential for clashes where the same number matches with sales/purchase orders so your mileage would vary and it may not end up being practical.