Sale Required Product Qty Forecast Report
Sales Required Product Qty Forecast Report
Geminate comes with a feature to provide forecasting of inventory based on future sale order with product qty. it enables you to upload your future sales data and export forecasting product data in excel format. it works on a bill of material with 2 levels with the main kit product and its component of the kit product. second level of bill of material of component of the kit product with its raw materials.
Benefit of this feature is that you can predict your future sales fulfillment based on your future inventory forecasting. if forecasted qty is negative ( 0 ) then it means we need to manufacture OR generate a purchase order to satisfy the sale order qty. If the forecasted qty is positive ( > 0 ) then it means we have that number of remaining qty after we fulfill the sale order qty by manufacturing.
Watch Video Tutorial
Exciting Features
Provides excel format inventory forecasting report.
Works on two levels of bill of materials.
Forecast qty based on future sale order data with order qty.
Easy to upload excel format sale data with predefined import template.
Easy to decide how much we need to manufacture in house or place an order to the vendor in advance.
Easy to manage any future sales order based on advance prediction methodology.
Easy to use and very quick.
Note: Extensively Tested on Odoo Vanilla with Ubuntu OS
Screenshots
Go to Inventory -> Operations -> Sales Forecast.
Click on 'Sales Forecast' to open sales forecast popup.
When clicking on the 'Print' button, it will compute all forecast data for main product, component product and their raw material components to fulfill future sale order qtys and export in 'Excel' format report.
Sales Forecast Overview
Main Kit Product
Component of Kit Product
Raw Materials of Component Product(s) of Kit Product
Note: 1. If forecasted qty is negative ( 0 ) then it means we need to manufacture OR generate purchase order to satisfy sale orde qty.
Note: 2. If forecasted qty is positive ( 0 ) then it means we have that number of remaining qty after we fulfil the sale order qty by manufacturing.
GeminateCS Odoo Services
GeminateCS Suggested Apps
Contact / Support
