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.

Editions Supported

1. Community Version

2. Enterprise Version

Note: This module is developed, designed and tested on odoo vanila.

Available Key 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.

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 (

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.

Our Services

Odoo Customization

Odoo Implementation

Odoo Integration

Odoo Support