Gross Margin Report

I am looking for a Gross Margin report that uses the Item Fulfillment for it’s cost and not the Est.Cost from the Gross Profit Feature. We have found those to be inaccurate and do not work with Assemblies.

I haven’t found a way to link the Invoice and Item Fulfillments together to get this info. The applied to and applying fields don’t link these document type together.

Rookie Asked on December 10, 2019 in Reports.
Add Comment
1 Answer(s)
Best answer

Your best bet is to do a saved search that includes invoices and item fulfillments and separate it out into columns with formula columns like

decode({type},'Invoice',{Amount},0))

 

This will take some trial and error to get right, and may involve multiple case or decode statements to get just the right combination.

Advanced Answered on December 15, 2019.

I don’t know much about decode yet but this will give me a good start. Thank you for you help.

on December 17, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor