💻
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
  • Generate KN User and Password
  • Data Mapping
  • Delaware Valley Order Creation
  • Box Information for the Unified S3 Label
  • Box Label Error Fixes

Was this helpful?

  1. Integrations (API)

Delaware Valley

Here, we explain a Buyer Integration between Delaware Valley and Unosof.

PreviousOrder CreationNextKomet Sales

Last updated 1 year ago

Was this helpful?

Unosof has integrated with the customer Delaware Valley via the Kuehne&Nagel system:

  • Purchase Order Integration (Komet --> Unosof)

  • Box Information for the unified dispatch label (S3)

Generate KN User and Password

For this integration with KN, it is necessary to enable a username and password to access the data.

The API services we will call are:

  • Purchase Orders WS - Get Session

  • Purchase Orders WS - Get Labels by Date

Data Mapping

a. Customers

It's necessary to map Billing Customers and Shipping Customers. Currently, we mapped Delaware Valley - DV Flora and Delaware Valley - Grower Direct.

b. Products

To map products, we use the Mixed box Module.

To create mixed boxes, please follow the described steps in the following link.

Mix Box Management // create mix box

Once the box is created, you can map out the mixed box IDs from Komet with those created boxes in UNOSOF.

Insert:

  • Mix Name:

  • Delaware product ID in the option Product Code, and the

Choose the Stock Client by selecting the corresponding billing and shipping client.

Delaware Valley Order Creation

To access this module, go to:

Reports / Accounting Reports

https://farm.unosof.com/index.cfm?event=Accounting.Report

Select the "DWV Orders (Delaware)" option in the dropdown menu.

Select a date on the "Start Date" filter and hit "Generate Report" (Green Button). It's not possible to select more than one day range.

This search will show you all orders created in KN for Delaware Valley on that date.

Image

In this table, you will find all the information Kuehe & Nagel send to Unosof via the API (JSON File).

To synch and create the order in Unosof, click on the "S" Button under the Synch Column and click again on the "Generate Report" button to refresh the page.

The order gets created in Unosof.

The table gives a general overview of the PO created (Date, PO ID, # Boxes, # Mapped Boxes, and amount in $).

Important: The box content should be mapped to synch an order from Komet to Unosof. We consider a box to be mapped when it relates one or more products from DV to SKUs in Unosof. We use a box code or reference for every box recipe.

Box Information for the Unified S3 Label

Once Unosof receives the Purchase Orden information from kn, it's also necessary to get the Box information to generate the Unified S3 label with all the info.

The user should generally do the process in Station 3 to print the box stickers.

This sticker is only enabled for the Delaware Valley Orders.

There are two different label formats for DV-Flora and Growers Direct.

Box Label Error Fixes

it can happen that a box label comes in with an error, like this:

  • To fix these errors: Go to Accounting reports, hit mapping, and check the unpalled values. you shall find these kind of examples, in where the code indicates 125st, but the box that created contains 100st. Because of the mismatch, we show an error on the box label. Basically, the description has to match the product discription. On the label we show 100st, the API 125st. On the order creation, the 100st box got a 28863 code assigned, that we show on the customer label.

What looks different? The 28863 is assigned to Rose Rd Freedom 40cm sc 125. however the box was created with 100st, and should be 125st. meaning, that the content of the box is incorrect.

in the XML file, comes a product description and an item_product to map the boxes of today ---> boxes in the XML file

Out of that, we create the PO content, in where we show for each box the fields: C: field should match the item_product BN: field should match the description when those don't match, we cannot link the box data in the XML to the correct PO data. Sometimes this data gets populated late in the afternoon meaning, the XML, in that case nothing shows up until that time... logically: we can only map when there is data.

https://exmasterdev.unosof.com/views/scratchpad/DW/getPurchaseorders.cfm?dt_start=12-06-2023&dt_end=12-06-2023&order_no=SW000727921
Mixed Box Module
DWV Orders
DV FLORA LABEL
Error Delaware Box Label
28863, been pulled and assigned to a box in UNOSOF, as Customer Box label.
comparison mapping report.
https://www.knfreshcolombia.com/exportaciones/services/PurchaseOrdersWS?method=getSession&user=&user=____&password=____www.knfreshcolombia.com
https://www.knfreshcolombia.com/exportaciones/services/PurchaseOrdersWS?method=getLabelsByDate&sesionID=ID____meters=2022-04-22DELA]]%3Ewww.knfreshcolombia.com