Upload Stand Alone Orders | Open Market Box Inventory

On this module its possible to post Stand Alone orders from Unosof to Komet Sales.

This Komet Sales Bridge allows Unosof users to post Stand-Alone Orders (Box Inventory Miami) from Unosof to a Komet Sales Account.

OPEN MARKET INVENTORY INTEGRATION

Generate Komet Sales Token and grant access to the APIs

Token with the following API permissions are required:

carrier.list boxtype.list vendor.list customer.list product.list purchaseorder.order.list prebook.list prebook.details.list purchase.order.mixed.create purchase.order.create purchase.order.item.delete inventory.list inventory.openmarket.list inventory.delete

Map Data

It's necessary to map your stock customers and products.

Create Stock Customers in UNOSOF

• Create or identify the Stock Billing or Shipping Customer in Unosof.

• This Customer will be related to the Komet Sales Account or Location to post OM boxes.

It's possible to manage multi-locations in Komet sales. Assigning each Stock Shipping Client to the correct Komet Location is necessary if that is the case. For this process, it's necessary to contact UNOSOF and identify & instruct very clearly which Stock Shipping Client belongs to which Komet Location ID.

Product Mapping

Revise Integration Requirements: Data Mapping b) product and c) mixed box section.

Post Stock Orders from Unosof to Komet

To access this module, go to:

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

Select the option Komet Orders from the drop-down menu. This page helps to manage the posting of orders to Komet.

Please use the date filter to look for a specific date. Then, click on Search Report.

The page will show all the POs assigned to the Stock Customer to be posted to Komet. Locate the button UPLOAD under the column UPLOAD, and click on it.

Note that only invoiced orders in Unosof will show up.

Once the PO is uploaded correctly, the report updates and turns the PO line to green.

1. FARM: the app where the PO is going to be posted from

2. UNOSOF DATE: the PO date in UNOSOF

3. KOMET DATE: the date the PO was posted

4. REF PO ID: the Customer PO

5. PO ID: PO in UNOSOF

6. KOMET ID: PO in KOMET

7. UNOSOF CUSTOMER: Customer in UNOSOF

8. # BOXES: total of boxes in UNOSOF

9. # BOXES MAPPED: total of boxes posted to KOMET

10. AMOUNT UNOSOF: total value of the PO in UNOSOF

11. AMOUNT KOMET: total value posted in KOMET

Posting Issues: how to fix?

Revise below different cases you can face while posting your order.

Komet Product IDs are not mapped.

A PO cannot be posted if there are products in UNOSOF without a Komet ID. The system does not have the complete information to post the PO to KOMET.

It will provide you with a list of non-mapped products, while the button to upload the PO does not appear.

Not mapped products

Please, follow the steps of the section Product Mapping.

Once the correct IDs are mapped, go back to the Komet Orders Page and hit the green button LOAD PRODUCTS on the upper right of the report. It updates the codes you just mapped.

Re-post orders deleted in Komet.

Note that if you delete a PO in Komet, you should unlink the Komet order ID to be able to repost the order to Komet once again.

Please click the red button CLEAR KOMET ID to wipe out the deleted ID Komet linked to the PO, and enable the button UPLOAD.

Then, you would be able to post the order again.

Post AWB from Unosof to Komet

The second part of the integration is to post the AWB to the Komet platform. Consider the following points before going through the steps of posting AWBs.

• The UNOSOF PO needs to exist in Komet, i.e., the PO must have been posted from UNOSOF to Komet.

• The PO must be confirmed in the Komet Platform. This process sends Komet Box IDs back to UNOSOF to enable the posting of AWB.

The AWB posting is managed on the same page as the posting of POs, the Komet Orders report in the Accounting Reports module.

We will focus on the following columns:

• AWB: Number of boxes with AWBS assigned in UNOSOF.

• AWBS POSTED: Number of boxes with AWB posted to Komet.

• MAPPED BOXED: Number of Komet box IDs received from Komet and match with UNOSOF box IDs.

Map Boxes Manually

The columns AWBS and MAPPED BOXED need to match between both systems.

If the columns AWB and MAPPED BOXED do not match, we need to map the boxes manually.

For example, PO ID 151493 has only 14 boxes mapped out of 15.

Please locate and click on the MAP BOXES button.

It will open a new page with two tabs, one with the Unmapped IDS and the other with the Mapped IDs.

Map Boxes process

The tables in the tab Unmapped IDS display all boxes that need to be mapped manually. On the left hand, it shows the UNOSOF box details while the table on the right hand shows the box detail of Komet. ID BOX corresponds to the UNOSOF box ID and the BOXCODE corresponds to the Komet box ID.

Copy the UNOSOF box ID from the field ID BOX and enter it into MAP TO. It will auto-save.

Reload the report by clicking on the Generate Report button. Revise the columns AWB and MAPPED BOXED again; the numbers will match now.

Post AWB

Finally, hit the POST AWB button.

It will pop up a new page, Post Komet AWBS, showing details of the AWB posted to Komet.

Reload the report by clicking on the Generate Report button. If the AWBs were posted correctly, the column AWBS POSTED (15) will match the numbers of the columns AWB (15) and MAPPED BOXED (15).