Custom Reports

Sales Forecast Report

Report is meant to show Forecasted Tonnage vs Ordered Tonnage vs Delivered Tonnage of the Finished Product in the allocated Forecast Period

TransTypes involved - Sales Forecast (ID 72) , Sales order (ID 2) , Delivery Notes (ID 5)

Required Fields

• Date - Transaction Date

• Product Name - Finished Product list added onto the Sales Forecast module

• Budget Tonnage - Item Qty from the Sales Forecast module

• Ordered Tonnage - Item Qty from Sale order module

• Delivered Tonnage - Item Qty from Delivery Note

• Item Price - Item Unit Price from Sales Forecast module

• Total Price Budget- Item Unit Price * Budget Tonnage

• Total Price Delivered - Item Unit Price * Delivered Tonnage

NB: Report to be continuously developed

Forecast Sheet Being Currently Used