Margin report including return credits

[gpayne (Greg Payne)]

I started with this one from @hkeric.wci that addresses those issue already.

Anyone Have Sales Gross Margin Dashboard?

The Epicor Sales Gross Margin Report and the Homepage Query have flaws. I spent a solid 1 month trying to balance the BAQ out to the Sales Journal, SGM Report, Trial Balance, Chart Tracker etc… I can’t recall all the flaws but what I learned is that on an Invoice all things go into “seperate journals” or “GL Accts” and the SGM Report out of the box will exclude numbers and throw you off. For example: Discounts go into a seperate bucket Credit Memos Deferred Revenue Misc Charges Taxes Adv Les…