When running a sales analysis report by sales rep it is showing the invoice total even when there is a Line Item on the invoice that does not post to sales for the company as a whole.
We are a printing company and Postage is a pass through expense so when invoicing item #TP posts to a Current Asset account that the money has already been prepaid out of to the USPS. Since by law we cannot adjust the postage this does not count toward sales - basically a type of escrow.
Does anybody have any idea of how to get the sales analysis report to show the same total that the sales account shows for this invoice? Since we base sales compensation off this report it is a major problem - I can't pay commission on $71,000 in postage on one job when I do not make anything on it.
