SageForum for UK versions of Sage 50- Help and support.

Hello

I want to make a report that will find a sales invoice by the customer's order number. In Report Designer I have only been able to find one field for Order Number which is within the fields listed under 'Project'. I believe this field takes the order number from the Details page of the project. I don't use this field as I invoice over and over against the same projects using different order numbers. I use the order number field on the Order Details tab of each sales invoice I raise, but I can't find this field within Report Designer.

I'm sure it is possible as when I googled it I found a link to the Sage website where they had made a report doing exactly that but it is only available to customers who sign up for the extra cover which I don't.

Any ideas anyone?

Thanks,

Debbie

debbiem wrote:I use the order number field on the Order Details tab of each sales invoice I raise, but I can't find this field within Report Designer.

That field is called CUST_ORDER_NUMBER and is on the INVOICE table.

John