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.

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

https://yourfarmname.unosof.com/index.cfm?event=LocalSalesTax.Form

Generate and Save an API KEY

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: https://farm.unosof.com/index.cfm?event=Venture.MCH&dt_start=10-01-2020&dt_end=10-31-2020

INVOICES:

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

URL added the APIKEY

Venture C/N & D/N CSV

Credits: https://farm.unosof.com/index.cfm?event=Credits.JsonM&dt_start=10-01-2020&dt_end=10-31-2020

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

CREDITS:

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

URL Credits Added APIKEY

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

CSV file

Method 2 - JSON File - Single Specie (Roses)

This method works online JSON file for pass in a webservice

Venture Invoices JSON

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

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

Venture Invoices CSV Zona

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

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:

XML By Specie / Lenght

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

https://yourfarm.unosof.com/index.cfm?event=Deposits.JSON&dt_start=09-05-2016&dt_end=09-05-2016yourfarm.unosof.com

Method 3 - Excel file to Upload in Venture Directly

This method is used in Ecoroses

File is showed for download with this link

https://ecoroses.unosof.com/index.cfm?Event=Venture.TXT&apikey=ce53c182-b70c-4a60-9638-7f5333458bd8&dt_end=02-15-2021&dt_start=02-01-2021ecoroses.unosof.com

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

File to Upload Directly to venture

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

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

Online Data View

ADDITIONAL LINKS to Migrate Specific Data

We have additional links to show and migrate Data as:

CARGO AGENCIES

https://yourfarm.unosof.com/index.cfm?event=Cargo.JSONyourfarm.unosof.com

JSON - Cargo Agencies link

AIRLINES

https://yourfarm.unosof.com/index.cfm?event=Airline.JSONyourfarm.unosof.com

JSON - Airlines Link

PLAN DE CUENTAS / Accounts

https://yourfarm.unosof.com/index.cfm?event=Account.JSONyourfarm.unosof.com

JSON - Accounts Link