Margin report including return credits

[bbriscoe (William Briscoe)]

Our auditors are asking for a margin report (sales my invoice line) for 2024 that ties to our TB revenue. Since the native Epicor margin report only gives positive sales and excludes credits, how would we go about running all the credits by invoice # in the same format?

[JMPCONJ (John Magee)]

Probably can do a BAQ against InvcDtl…cost/sales info should get you over the hump. And I feel your pain…“auditors” is a trigger word for me.

[bbriscoe (William Briscoe)]

I hear you.
A related question. We do have some queries like this already we can probably edit, but how do we handle revenue recognition events? Some of our invoices are from customer advance billings so they should not show up as revenue when invoiced but when the shipment or rev rec event is resolved. How is this handled in Epicor?

[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…

[JMPCONJ (John Magee)]

@bbriscoe

…revenue recognition events? Some of our invoices are from customer advance billings so they should not show up as revenue when invoiced but when the shipment or rev rec event is resolved.

Can’t help you on this one unfortunately. Our invoices are 100% “order cycle”…order/ship-from-our-warehouse/invoice, or sales-order/dropship-PO-to-supplier/invoice.