💻
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
  • Method 1 - Excel File (CSV File)
  • Create Token
  • Venture Invoices CSV
  • Venture C/N & D/N CSV
  • Method 2 - JSON File - Single Specie (Roses)
  • Venture Invoices JSON
  • Venture Deposits JSON
  • Method 3 - Excel file to Upload in Venture Directly
  • METHOD 4 - TXT to Upload Directly
  • ADDITIONAL LINKS to Migrate Specific Data

Was this helpful?

  1. Integrations (API)
  2. Accounting Migration Files

Venture

These integrations methods pass authorized SRI invoice Invoices, SRI Annulments, Deposits and Credit Notes. However, for Colombian farms, we overrule the authorized status of the invoices.

PreviousAccounting Migration FilesNextCut Flower Trader (CFT)

Last updated 2 years ago

Was this helpful?

Method 1 - Excel File (CSV File)

This method generate an excel file (CSV) with the columns provided by Venture.

This method currently does not support deposit migrations, if thats wished: that has to be asked to Venture to add/develop. That means, if this method is chosen, all deposits have to be applied manually 2x (in Unosof and in Venture).

The nice thing about this method, is that it's easy to manage, at the end of the month (when the month is closed), it's possible to migrate a static result over and it gives a lot of control to avoid any differences between UNOSOF and Venture. Also this migration method is "light", a CSV file is a not a heavy migration file to generate. That keeps UNOSOF up and running smooth vs a web service (depends on how its configured ofourse) that calls all our data every hour.

Create Token

a) Generate an API key in admin

Go to ADMIN section on the system

b) Paste that api key to the end of the link with the following string: &apikey=439b5631-6e12-4464-b390-0044573c5abc

c) The venture files LINK are below for this method. The date should be entry in MM-DD-YYYY format.

Venture Invoices CSV

INVOICES:

Venture C/N & D/N CSV

d) The venture files run with the API key generated (or given by your Farm)

CREDITS:

The excel (CSV file) are downloaded after ran the link

Shows the Columns provided by Venture for this method, as a example show like this

Method 2 - JSON File - Single Specie (Roses)

This method works online JSON file for pass in a webservice

Venture Invoices JSON

We recommend to generate this file in Firefox, for a straight clear JSON format view.

Venture Invoices CSV Zona

Contents a separation and calculation by specie and farm:

Show a total of 116.00, and the composition is:

SPRAY ROSES FRESCAS CALIDAD EXPORTACION TALLOS 60CM

According to the SRI XML:

This same information is shown in the JSON migration link/file separated by spaces, lengths.

Some farms, with to see the results per farm. it's possible to add, but this does bring other complexities. dividing 0.01 cross 2 farms is 0.01 for both farms,... that 1 penny too much. To avoid that from happening, we'd like to work with more decimals, but still... rounding can cause problems.

Venture Deposits JSON

Method 3 - Excel file to Upload in Venture Directly

This method is used in Ecoroses

File is showed for download with this link

Important: The Customer in UNOSOF should be have the Venture customer code for made the integration. This code shows in the first column CLIENTE

The file contents columns specified by venture to upload in the module called VENTAS FLOR or VENTAS GENERAL. Can be different and depend on the farm

METHOD 4 - TXT to Upload Directly

This Method visualice online the preview of the data, next you can download the file to a TXT File

Important: The Customer in UNOSOF should be have the Venture customer code for made the integration. This code shows in the first column codigo_cli

ADDITIONAL LINKS to Migrate Specific Data

We have additional links to show and migrate Data as:

CARGO AGENCIES

AIRLINES

PLAN DE CUENTAS / Accounts

Invoices:

Credits:

https://farm.unosof.com/index.cfm?event=Venture.MCH&dt_start=10-01-2020&dt_end=10-31-2020
https://farm.unosof.com/index.cfm?event=Credits.JsonM&dt_start=10-01-2020&dt_end=10-31-2020
https://yourfarmname.unosof.com/index.cfm?event=LocalSalesTax.Form
https://yourfarm.unosof.com/index.cfm?event=Venture.MCH&dt_start=10-01-2020&dt_end=10-31-2020&apikey=439b5631-6e12-4464-b390-0044573c5abcyourfarm.unosof.com
https://yourfarm.unosof.com/index.cfm?event=Credits.JsonM&dt_start=10-01-2020&dt_end=10-3&apikey=439b5631-6e12-4464-b390-0044573c5abcyourfarm.unosof.com
https://yourfarm.unosof.com/index.cfm?event=Venture.JSON&dt_start=01-27-2021&dt_end=01-27-2021&bo_show=1&apikey=6c040017-46a1-4ded-945d-fc591aeac83yourfarm.unosof.com
https://farm.unosof.com/index.cfm?event=Venture.JSON&dt_start=10-27-2021&dt_end=10-27-2021&bo_show=1&apikey=6c040017-46a1-4ded-945d-fc591aeac830farm.unosof.com
https://yourfarm.unosof.com/index.cfm?event=Deposits.JSON&dt_start=09-05-2016&dt_end=09-05-2016yourfarm.unosof.com
https://ecoroses.unosof.com/index.cfm?Event=Venture.TXT&apikey=ce53c182-b70c-4a60-9638-7f5333458bd8&dt_end=02-15-2021&dt_start=02-01-2021
https://farm.unosof.com/index.cfm?event=Venture.AGF&dt_start=12-31-2021&dt_end=12-31-2021&tx_apikey=7b08e68e-8832-474a-afbb-b3f93d7f8141&bo_debug=1farm.unosof.com
https://yourfarm.unosof.com/index.cfm?event=Cargo.JSONyourfarm.unosof.com
JSON - Cargo Agencies link
https://yourfarm.unosof.com/index.cfm?event=Airline.JSONyourfarm.unosof.com
JSON - Airlines Link
https://yourfarm.unosof.com/index.cfm?event=Account.JSONyourfarm.unosof.com
JSON - Accounts Link
Generate and Save an API KEY
URL added the APIKEY
URL Credits Added APIKEY
CSV file
XML By Specie / Lenght
File to Upload Directly to venture
Online Data View