Report Designer - Customer Day Books Report - Delivery Address

I work on Sage 50cloud. I want to add delivery address to the 'Day Books: Customer Invoices (Summary)' report as we want to be able to filter invoices by the delivery location.  Everything I have tried is just bringing up the main account address.  What variable would I have to use the get this to work?

  • 0

    Did you try adding  a Group Header and Footer with something like  SALES_LEDGER.DEL_NAME as the grouping field ?

    Otherwise please elaborate on exactly what you have tried 

  • 0 in reply to Ken Starnes

    Hi Becca,

    Batch Invoices don't have a delivery address associated with them. You would only be able to show the customer's main address or a delivery address but not the address of where that actual invoice was despatched too.

    If you want a report that will show invoices with delivery address, you'd need to build it from within Invoice and Credits, the limitation here is you can't speak to the transaction ledger, only the invoice ledger.

    Kind Regards,

    Ian