Report Designer: How can I pull a COMAPNY D_NAME variable by using a STOCK_TRAN REFERENCE?

I'm trying to setup a new report under Products & Services to match the requirements of one of our suppliers: what the supplier would like is to know the customer account name rather than the default reference to the invoice number within the vanilla Product Activity report.

Is it possible to get the delivery name from the stock_tran reference or is this made impossible by the modular nature of Sage 50?

Hopefully someone can help me with this. If I've not made myself clear enough I can always provide more information.

Thanks in advance!

  • Hi Kieron,

    To bring through Invoice information (including the name) onto a Stock Report, you will need to create a Join
    to bring through the INVOICE table and link it to the STOCK_TRAN table.

    You will need to link STOCK_TRAN.REF_NUMERIC to INVOICE.INVOICE_NUMBER as a Parent Outer join.

    For help with using the join editor, please view the following help guide

    support.sage.co.uk/default.aspx

    If you have any questions around this, please let me know.

    Regards,

    Adam
    Sage GB

    Sage Business Community Team