商品銷售排名表(分店明細)
從報表可查看商品排名及展出各店經營的數據,方便一目瞭然每個商品在各店的銷售狀況
點選【連鎖模組】左邊功能列【合併報表】,開啟【商品銷售排名表(分店明細)】
開啟後會預設當月及依金額排序為條件,確認要查看的條件後,請按【查詢】查看資料
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143134202311271431411228.png)
即可看到依金排名由第1名到最後1名的商品銷售報表,每個商品的數量、金額、毛利狀況,並從報表中也會計算毛利率及銷售金額的佔比,將各店的數據也同時展出
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143351202311271434013288.png)
報表可用銷售【數量】排名
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143444202311271436012940.png)
或用【毛利】進行排名,需留意因毛利=售價-成本,而系統的成本是以【月加權平均成本制】運算而得,即當月依月平均公式計算每個商品的平均成本,故建議若要以毛利查看,可先確認已執行【成本計價】作業至當月
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143519202311271435325787.png)
提供【列印】產生PDF報表資料,或轉出Excel,可選擇【轉出查詢格式】或【轉出報表格式】
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143706202311271437547791.png)
PDF檔
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143831202311271438415110.png)
![](https://cloudworker2013.blob.core.windows.net/upload/20231127143914202311271439258893.png)
【轉出】Excel【轉出報表格式】
![](https://cloudworker2013.blob.core.windows.net/upload/20231127144135202311271441453479.png)
The End