x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 13 subscribers
  • Views 602 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
4
replies
General Discussion
1k
topics
2k
replies
Sharon McCann

Hiding Invoice Delivery Address

Posted By

Hi,

I'm trying to put a delivery address on my invoice in Report Designer.

I'm using the following variables:

  • SOPInvCredAddresses.C_AddressLine# - invoice address 
  • SOPInvCredDelAddresses.C_AddressLine# - delivery address

I want to put in a conditional format so that the delivery address is hidden when these are the same.

What field populates the SOPInvCredDelAddresses.C_AddressLine# variables and is there a potential problem with a one-to-many relationship here?

Any table IDs or better ways to do this?

Thanks!

  • 0
    It depends on SOPOrderReturns.UseInvoiceAddress: Suppress Printing on the SOPInvCredDelAddresses fields if SOPOrderReturns.UseInvoiceAddress=1.
    If you've started with the standard layout, SOPOrderReturns will already be included in the joins.
  • 0
    If they are the same, then standard Sage 200 layouts should already suppress them.

    Also bear in mind that the C_ variables are programatically designed to eliminate any blank lines in the address.

    As Geoff suggested, the suppression will work if you use the conditional format something like this:

    SOPOrderReturns.UseInvoiceAddress = 1 then suppress

*Community Hub is the new name for Sage City