I modified the Customer Statement in Report Writer to sort by Bill-to Address and I was able to get my Customer Statements from GP sorted by this Bill-to Address from the Sales Transaction History file. Great, but the Bill-To address will not display on the statement. I have the Customer Master Address file linked by Customer and Bill-To Address Code to the Sales Transaction history, but the Bill-To Address code or address will not display on the statement. Microsoft has told me that this is because this report is based on a Temp table. So close, but yet so far.
Has anyone created a Customer Statement by Bill-To Address where the Bill-To Address displays in any report program (they don't have Crystal)?
*This post is locked for comments