💻
UNOSOF MANUAL
User Guidelines EN
User Guidelines EN
  • UNOSOF MANUAL
  • TAXONOMY DEFINITIONS
    • Products
      • Species
      • Varieties
      • Non-Real Varieties
    • Bunches
      • Solid Bunches
      • Rainbows
      • Bouquets
    • Boxes
      • Solid Boxes
      • Mixed / Assorted Boxes
      • Bouquet Boxes
      • Consumer Box
    • Product Definitions
      • Farm Products
      • Importer
    • Floricode
      • Floricode Schema
        • f_products
        • f_genus
    • Farm Workflow
    • Cultivation Management
    • Additional sources
  • Accounting
    • Account Transactions
      • Make Deposits
        • Commission Management
      • Retention
      • View Deposits
        • Move Unapplied Deposit Values
    • Accounting Administration
      • Company Info
      • Account info
      • Inventory Info
      • Holland Info
      • Sales Info
      • Consumer Invoices
      • Statements
      • Truck Invoices
      • Bouqueteria
      • Remote
      • Provides IDs
      • Bruto Variables
      • Sales Definitions
      • Flor de Baja
      • Alianza API
      • Projections
    • SRI Electronic Transfer
      • Invoices / Guia / Credits / Debits
        • SRI Generate/Sign/Send
        • Pre-Authorization Modifications
        • AWB Weights
        • Zip SRI Invoices
        • Email SRI Invoices
        • Invoices Used Outside UNOSOF
        • Unused (Skipped) Invoices
        • SRI Report (Check Post vs. Generated)
      • SRI Cases
      • SRI Status Comprobation
      • SRI Documents Annulment
      • SRI Blocking Messages
    • Workforce Managment
      • Manage Employees
      • Manage Departments
      • Daily Timecard
    • Accounts Management
      • Chart of Accounts
      • Manage Accounts
  • Customers
    • Customer Info
      • Customer Account Overview
        • Statement PDF Formats
        • Set Default Statements Message
      • Manage Customers
        • View Customers
        • Create a customer
          • Customer Form // Customer Info Tab
          • Customer Form // Contact Info Tab
          • Customer Form //Addresses
          • Customer Form // Accounting Tab
          • Customer Form Invoicing
          • Coface
          • Api Providers
          • Refresh Billing Customer Table and Customer Credit
        • Manage Customer Tips
      • Manage Markets
    • Customer Service
      • Email Multiple Invoices
      • Search Invoices
      • Rollback Customer Invoice
      • Send Statements
      • Manage Invoice Footers
      • Customer Credits
    • Fair Trade Management
      • Reporting
      • Invoice Format
      • Recommendations
  • Sales
    • Search Purchase Orders
      • Mass Change PO Date
      • PO's Color Codes
      • Minimum Pricing Check
      • Create PO Page Group
      • Priority Packing // Box Confirmation
      • Mass Swap Module
    • Purchase Order
      • Sales Practical Tips
      • Create a Purchase Order (V-next
        • Edit Boxes
      • Create a Purchase Order
        • Edit Boxes
        • Move boxes
        • Delete Purchase Orders
        • Box Labels
    • Invoice Purchase Order
      • Invoice Cases
    • Availability Builder
      • Create New Dispo
      • Modify pricing and box #
      • View Dispo
      • Send or Post Dispo
    • Standing Orders
      • Create Standing Orders
      • Modify Standing Orders
    • Supermarket Order Generation
    • Returned Boxes
    • Customer Mass Invoice
    • Mass Rollback Orders
    • Transfer PO
    • MIAMI
      • Delete boxes in MIAMI application
  • Pricing
    • Upload Customer Pricing
    • Upload Minimum Pricing
    • Incoterm Pricing
  • Exportations
    • LAG Integrations
    • Airway Bills
      • Commercial and Customer Invoice Mass Print Options
        • Exportation documents for Colombia
        • Exportation Documents Ethipia
    • O.E / DAE
    • Incoterms
      • Incoterm Freight By Box
    • Drivers
    • Manage Boxes
    • Cargo Agencies
    • Truck Companies
    • Truck Invoice
  • Dashboards
    • Sales Dashboard
  • Post Harvest
    • Station 1: Harvest Receiving
      • View Post Harvest Receiving
      • Field Plan Cutter Management
    • Station 2: Inventory Packing
      • View Inventory Packing List
      • Consumer Bunches
        • Generate Consumer Bunches
        • View Consumer Bunches
        • Assign Consumer Bunches
    • Station 3: Inventory Shipping
      • Scan Bunches into a Box
      • Auto-Pack Function
      • Unpack Boxes
      • Mass Print Box Labels
      • Bouquet Station 3
    • Station 4: Weight & Boxtype
    • Station 5: Truck Invoice
      • Return Box Module
    • Defections: Flor National
  • Inventory
    • Inventory Variables
    • View Inventory
      • Reading the Inventory
    • Future Availability
      • Projections
      • Future Availability Management Settings
      • Future Availability Sheets
      • Future Availability Reports
    • Inventory Management
      • Inventory Shoot
      • Inventory Prefrío Shoot
    • Inventory Packaging Boxes Scan
    • Manage Transfers Bunches
    • Manage Transfers Mallas
    • Mixed Box Management
      • Mix Box Management // create mix box
      • Mix Box Management // Recipe Management
      • Mix Box Management // S3 - Mix Box packing
      • Mix Box Management // Fix Problems
    • Exit Inventory
      • View Inventory Exits
    • Reprocess Inventory
      • Flor de Baja management
      • Manage Reprocess Inventory
      • S2 Process Downgraded Inventory
      • Report Reprocessing Inventory
    • Inventory Priority
      • Inventory Priority List
      • Priority Management
    • Post Harvest Practical Tips:
    • Box Inventory
    • Inventory Hotroom
      • Manage Hotroom
      • Hotroom Entrance
      • Hotroom Exit
  • Remote Inventory Management
  • Purchases
    • Purchases
  • Production
    • Production Management
      • Manage Products
        • Create SKU's GYP
        • Manage Product Api Mappings
    • Production Data
      • Double Life Cycle Bunches
      • Product Inventory Life
      • Daily Input Page
  • Bouquetteria
    • Bouquet Product Management
  • Reports
    • Reports
    • Production reports
    • Warehouse Reports
    • Accounting Reports
      • Customer Behaviour
      • Last Payment / Balance
      • Customer Account Review (Method)
      • Compare Reports for Multi-App Companies
        • Accounting Cases / Compare Reports for Deposits
        • Accounting cases / Compare Invoices
  • SITE MANAGER
    • Manage Locations
      • Create a New Warehouse
      • Maintain the Field Plan
      • Mass Edit Beds with Excel
    • Users
    • Users Permissions
    • Select Options
  • System Administration
    • Properties
    • Synch data
  • Vendors
    • Vendors
    • Manage Vendors
    • Requisition of Material
      • Search Purchase Requests
    • Vendor Purchase Orders
      • Search Vendor Orders
    • Order Receiving
      • View Order Receiving
    • Consignment
      • Consignment Cases
  • Alianza Logistik
    • Alianza Logistika API
    • Alianza Box Label Configuration
  • Integrations (API)
    • FreshPortal
    • Migros
    • UNOSOF API's
    • Accounting Migration Files
      • Venture
    • Cut Flower Trader (CFT)
      • Inventory Posting
      • Order Creation
    • Delaware Valley
    • Komet Sales
      • Integration Requirements
      • Load Orders from Komet to Unosof
      • Upload Stand Alone Orders | Open Market Box Inventory
      • Sunburst Farms Integration
      • Upload Bunch Inventory to Komet
    • FTD
    • Blumen Gali
    • Shopify
  • Hardware & Network & Infrastructure
    • How to Setup - PRINTER
    • How to Setup - Scale
    • Hardware Requirements
    • Network & Infrastructure Requirements
    • Tips, Optimize Network & Infrastructure.
Powered by GitBook
On this page
  • Projection
  • Excel File to upload Projections

Was this helpful?

  1. Inventory
  2. Future Availability

Projections

Here we explain how to input your projection data in UNOSOF.

PreviousFuture AvailabilityNextFuture Availability Management Settings

Last updated 2 years ago

Was this helpful?

Projection

Please go to: Production / Production data / Projections.

The information that needs to be managed in this module is the bruto amount of stems per block being counted in the field. At most 4 weeks ahead of time, it's possible to estimate with the naked eye how many weeks it takes for a flower to be cut-stage ready. Therefore, our projection module can be managed with a projection of a maximum of 4 weeks out. To input a projection, please follow these steps.

Tip: Tip: anything further out than the week of the projection, has to insert in each following week in column 0 only.

In that way, projections have NO limit on how far out we can give a commercial estimation to sell from.

Step 1) Establish the week of the projection, this defines when was the projection being made. It's efficient to also use the other filters to shrink your search selection, such as the warehouse, block, species, and variety filters.

Step 2) Analyze the bruto production levels from the previous weeks. That information is a good guide to see where you came from and will help to make an accurate projection for the upcoming weeks.

Step 3) Because of the weather conditions (more sun, more rain), to estimate 4 weeks ahead of time when a flower is cut-stage ready, is more difficult than 1 week ahead of time. Therefor, as we get closer to the reality of a projected week, we get every time a more accurate projection.

That is the main reason why we'd like to project the same upcoming week, multiple times. example: week 9 gets projected 5x.

In week 5, we projected week 5-6-7-8-9 In week 6, we projected week 6-7-8-9-10 In week 7, we projected week 7-8-9-10-11 In week 8, we projected week 8-9-10-11-12 In week 9, we projected week 9-10-11-12-13

The given example can be read as follows: The projection for week 9 is made in week 9 and being projected 4 weeks out, we call that 5+4. In week 6 a projection was also made for week 9, we call that 6+3 in week 7, another projection was made for week 9, 7+2 week 8 is one week ahead of week 9, that projection we call 8+1 and in 9 itself, we projected the week again to make sure we got it accurate, 9+0

Its good to see what the previous projections were for week 9, meaning, week 8+1 (shown in -1), week 7+2 (shown in -2) and week 6+3 (shown in -3), those weeks we show in the following part:

Step 4) Insert the projection in the following input field.

As being explained, week 9+0 = week 9 itself. week 9+1 = the projection for week 10 week 9+2 = the projection for week 11 week 9+3 = the projection for week 12 week 9+4 = the projection for week 13

Step 5) Save projections.

We suggest managing the projections per block, and not per variety.

In that way, compliance reports can be made as we can compare the projections with the received production.

Excel File to upload Projections

Projections can also be uploaded through an excel file. Please, follow the next steps.

Click on the option XLSX Manage located on the upper right-hand of the page. Then, choose the option Download Filtered.

It will download an excel file.

Open and edit the excel file. Save your modifications, and go back to UNOSOF.

On the same page of projections, please, use the option called Upload Filtered.

The following option will pop up, click on Choose File.

Once you attach the file, please, press on OK button.

The system will present a preview page of the projection data before it gets uploaded into the projections itself.

You can still edit you projections in this preview.

Once the data is revised, hit the button Save Projections (Week X).

The message Success will appear once the projections are loaded correctly into the system.

Search again to see your projections.

Projections Module
Use the WEEK filter to input further weeks +4
The projection made in which week
Bruto production from the previous 3 weeks.
Previous projections made for the week itself.
Projections input format
Save Projections
Projection - Excel File
Edit and enter your projections
Upload you projections
Preview of the loaded file
Success Message