# Future Availability Sheets

To start with this new process, please go to the **Inventory Futura Availability** module located inside the View Inventory module.

![Inventory Futura Availability](/files/-MWUet76CSq2kgiCsft9)

Select in the upper right sub-menu the **Future Availability Sheets** option located in the Projection Future Availability Builder catalog.

![Future Availability Sheets](/files/-MWUfUDi8jcLnAEveXNt)

![](/files/-MWV8UcfbYjs_l9YN-ME)

### How to create a Future Availability Sheets

Please follow these steps to create a new Future Availability Sheet.

#### 1. Check projections

First is really important to revise that you have projections inputted in the system, for the week that you are going to generate the Sheet.

{% hint style="warning" %}
If projections are not inputted in the system, the Future Availability Sheet module will generate the sheets without any data.
{% endhint %}

To check the projections data, please go to the Production / Production Data / **Projections**

![Projections module](/files/-MWUt8BpbKya64RfrGFk)

In this case, this farm has projections in the system so is good to go with the Future Availability Sheet generation.

#### 2. Revise filters

After accessing this module, please select the correct filters.

![](/files/-MWUjyMKK2mr1GZj6Zst)

For this module is only necessary to use the **Start Week** filter, this filter is located in the upper right side of the filter section. 

{% hint style="warning" %}
Once you selected the desired week, the system will show the data for 4 weeks in advance
{% endhint %}

![Start Week Filter](/files/-MWUlrKVb00X_8rJFOcg)

After selecting the desired week, please hit the **Search** button to proceed.

![Search button](/files/-MWUo5Oc-_kOCZ6ww3Vs)

#### 3. Generate the Master Projection Sheet

Once the search is performed the system will show the list of the **Generated Projection Sheets.**

![](/files/-MWUorLU6yxaRR9TGhda)

No please hit the **Generate** button to create a new **Master** projection sheet.

{% hint style="warning" %}
After any modification being made to the projections, is necessary to generate a new Master Projection sheet.
{% endhint %}

![](/files/-MWUsCWBs15ABMCpAjsA)

The **Master** projection sheet is needed to create the **Children's** projection sheets. 

{% hint style="info" %}
Please be patient when you are generating the sheets, it takes time to generate them because of the amount of data that the system is looping through. 
{% endhint %}

![Generated Master Sheet](/files/-MWVEKG45xCK5FEGDeZa)

## Generate Children Projection Sheet

The Children Projection Sheets are the most important part of this process because these Sheets are the ones that you need to modify so they can be sent to the customers.

To generate this new Children projection Sheet please locate the **Clone** button to create the new sheet.

![Clone button ](/files/-MWVGJjWlZzFrE_A4sjZ)

{% hint style="warning" %}
The generation of the Chill projection sheet is faster than the Master, but please wait a bit because this generation takes its time.
{% endhint %}

The new Child Sheet will be shown below the **Master** projection sheet.

![](/files/-MWZy2PzoF6EkrQ-qvCs)

Now with the Children Projection Sheet, you can start modifying the data to show the projections to your customers.

#### 1. Get inside the Projection sheet.

To start modifying the Children Projection sheet please locate the Column **ID**, and click on the Blue ID # button to access it.

![](/files/-MW_EALVPTGmIel4oesc)

{% hint style="success" %}
Each Sheet has a unique **ID #**, so it can be searched and we can keep track of the generations.
{% endhint %}

Now a new screen will appear with the information of the existing varieties so it can be modified.

![](/files/-MW_FuwEp-msMG1y5QCE)

This new Children projection sheet shows information of the search week that was selected in the Master Projection sheet, and also shows information of 4 weeks in advance.

![In this example we show info until the week 16, of the current year.](/files/-MW_hH_lFKy0pRhNczLG)

#### 2. Use the filters to set up the Projection Sheet

Now that the sheet is correctly created, is necessary to set up what you will like to show to your customers using the filters.

![](/files/-MW_nF_uBVvpRoq0oczL)

In this step, you first need to apply the filters to save the Projection sheet. So Using the Search button in the form of a loop is really important to use.

![This button is important to search the data before saving.](/files/-MWaEBAuOP-aQTOu4MLo)

Initially, all the products are set to active, this means that at the beginning you are showing all the projections to your customer.

![Active column shows all the products as active in this example.](/files/-MWa8xDkwyHjvaWbBjzG)

The filters **OVER** and **OVER** affect the results in the **ORG REMAINING** column.

![](/files/-MWa9q8lMtRXvey1J0sz)

So if you use the filter **OVER** and input the value of 100 stems, the system will show data only for varieties that have more than 100 stems.

![In this example we see all the varieties OVER 100 stems](/files/-MWaDPLsJzU9UA7YaAQ8)

And if you use the filter **UNDER** and input the value of 100 stems, the system will only show data for the varieties that have less than 100 stems.

![In this example we see all the varieties Under 100 stems](/files/-MWaEq8xWSjQgwBd4UHh)

Now for this example, we are going to activate only the Varieties that are available with more than 100 Stems, so we are going to use the **OVER** filter.

So we input 100 in the filter **OVER** and then hit the **Search loop** marked in green.

{% hint style="info" %}
Using the OVER filter is appropriate if you wish to create a Projection Sheet without negatives.
{% endhint %}

 Now that we only show varieties available with more than 100 stems, please hit the **Save** button that has the green disk.

![Hit the loop button to save](/files/-MWaINBccMXpL-d6XApn)

After saving the Projection sheet please go back to the **Future Availability Sheets** module to finish with the parametrization.

Is really important to select the **Price sheet** that will be shown in this new Projection Sheet.

The **Box** type that you will like to link to the sheet.

And the **Format** you will like to show to your customer.

![](/files/-MWaLaCRamtoFG6oPUW-)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://manual.unosofbooks.com/inventory/future-availability/future-availability-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.