Invoice fields in report

[welshal]

Hi.

I want to amend a PRDHIST report to add the name on the invoice to the report of stock movement in a given month.

I don't know what the field name is though.

Can anyone tell me what the field name is and where it can be found please?.

Thanks.

Alex.

[brucedenney]

There is no easy way to do this.

The item reference could be an invoice number or a purchase order number or a sales order number so you need to link it to the invoice table manually.

I am not sure if that would work because there may be issues with one of the fields being a number and the other being text.

Then you need to do something to deal with the issue that the ref might relate to a purchase order or a sales order or nothing at all. So the join need to be a parent outer so in these cases data still gets returned for the stock transaction.

Then you have the issue that you might have a ref that relates to a Purchase order but there happens ot be a sales invoice with the same number so you get the name off the sales invoice appearing.

It may be that based on transaction types and other things you might be able to do it. The mixed data types might require you to do it externally in Excel.