Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel Filter by label (Content by label)showLabels


Excerpt

This report allows company users to keep track of their sales by product type, including sales in boxes, units, and hard-goods. 

Instructions

The "Sales by Item Summary Report" report can be generated in Excel or PDF format. This report includes items in boxes, units, and hardgoodshard goods.  To generate this report, follow the steps below:

Ui steps
sizesmall


Ui step

Go to Reports

>

>> Product Report.


Ui step

Specify the Order Date From and Order Date To.  You can also filter by Salesperson, Category, 

Product

Product or

Order

 Order Type.


Ui step

Click on the PDF or Excel icon to generate

the

the Sales by Item Summary report.

Image Removed

This report includes the following columns:

  • Category: Product category
  • Variety:  Product variety
  • Grade: Product grade.  Does not apply to hard good items.
  • FBE: Full box equivalent. Does not apply to hard good items.
  • Total Units: Total Units Sold
  • Unit Type:  Stem or Bunch. Does not apply to hard good items.
  • Amount: Total amount sold
  • Sales %:  Percentage that it represents in the total sales.
  • Average Price:  Average unit price.
  • Cost: Total Cost
  • COGS: Cost of goods sold.
  • AWB Freight:  AWB Freight. Does not apply to hard good items.
  • Average COGS: Average cost of goods sold.
  • Gross Profit:  Total gross profit.
  • GPM %:  Gross Profit Margin.

 

 

Relevant Articles


Ui step

Download an example of this report.






Panel
titleRelated Articles

Filter by label (Content by label)
false
showLabelsfalse
max10
showSpacefalse
sorttitleshowSpace
cqllabel in ( "reports" , "sales" , "sales-report" , "sales-summary" )
labelsreports, sales by item

 


We've encountered an issue exporting this macro. Please try exporting this page again later.