# Upload Stand Alone Orders | Open Market Box Inventory

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

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2F5TUoJhV2JxBKDPWRZaEc%2FScreenshot%202023-11-16%20at%2015.33.46.png?alt=media&#x26;token=e7917797-2455-43ec-bdbc-60ba76202697" alt=""><figcaption><p>OPEN MARKET INVENTORY INTEGRATION</p></figcaption></figure>

## Generate Komet Sales Token and grant access to the APIs

{% hint style="info" %}
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
{% endhint %}

## 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.

{% hint style="info" %}
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. &#x20;
{% endhint %}

#### Product Mapping

{% hint style="info" %}
Revise[ Integration Requirements: Data Mapping](https://manual.unosofbooks.com/integrations-api/download-pos-from-komet#data-mapping) b) product and c) mixed box section.
{% endhint %}

## Post Stock Orders from Unosof to Komet

To access this module, go to:

{% hint style="success" %}
Reports / **Accounting Reports**\
<https://farm.unosof.com/index.cfm?event=Accounting.Report>
{% endhint %}

Select the option **Komet Orders** from the drop-down menu. This page helps to manage the posting of orders to Komet.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FQpn2OQQPN72alw8kd3MA%2FScreen%20Shot%202023-01-26%20at%2010.09.00.png?alt=media&#x26;token=49f61b78-1ff8-42ef-8e8d-2d258dadd9cc" alt=""><figcaption></figcaption></figure>

Please use the date filter to look for a specific date. Then, click on **Search Report.**&#x20;

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.&#x20;

{% hint style="danger" %}
Note that only invoiced orders in Unosof will show up.&#x20;
{% endhint %}

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2Fn8NZoe1NKURNxyhj9jLM%2Fimage.png?alt=media&#x26;token=9fd80ec3-66e0-424b-b27a-3d2369aa0715" alt=""><figcaption></figcaption></figure>

Once the PO is uploaded correctly, the report updates and turns the PO line to green.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FBHiEP1ztbupMnJfrHxji%2Fimage.png?alt=media&#x26;token=cce90d37-038f-43ea-bb80-0a8446ac5d3f" alt=""><figcaption></figcaption></figure>

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.&#x20;

#### 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.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FCITAc487QmFr1baeV1kT%2Fimage.png?alt=media&#x26;token=76782b79-879b-41ee-8f13-5e42efce6eb1" alt=""><figcaption><p>Not mapped products</p></figcaption></figure>

Please, follow the steps of the section[ Product Mapping](#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.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2Fgx6DWINCo6cmdoANTsC7%2Fimage.png?alt=media&#x26;token=335fd7af-29ca-478d-8bcc-2ffc203d5c6b" alt=""><figcaption></figcaption></figure>

#### 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.&#x20;

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

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FlRQxAFdzsOry4w4TWtgp%2Fimage.png?alt=media&#x26;token=89cff9c5-c9e0-4e5e-b11b-c8b845300f7f" alt=""><figcaption></figcaption></figure>

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:&#x20;

* **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.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FKaC51V3BCd6D27UQQbZW%2Fimage.png?alt=media&#x26;token=e992829f-da15-4264-b8fe-06feffed8cf9" alt=""><figcaption></figcaption></figure>

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.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2Fp3murB6Mq0h26X9FyCt2%2Fimage.png?alt=media&#x26;token=b255e227-9f10-44fb-b6e9-eb2219979265" alt=""><figcaption></figcaption></figure>

Please locate and click on the MAP BOXES butto&#x6E;**.**&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FQhz3xsS7bnXKqAFcMeKP%2FScreenshot%202023-03-15%20at%2012.21.50.png?alt=media&#x26;token=3f0c948f-0284-4705-bd75-daac9d16c2e1" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FHd4053vrpvML9J3RpITv%2Fimage.png?alt=media&#x26;token=6e478544-c1a6-4a04-b96c-6ce7f11dca52" alt=""><figcaption><p>Map Boxes process</p></figcaption></figure>

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.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FIGyBpputfVOaZo2O50UE%2Fimage.png?alt=media&#x26;token=fc732f95-ea2f-4c02-9f4c-7df34ab43af6" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FoP0RFhvPWKNHm1GerAgQ%2Fimage.png?alt=media&#x26;token=5417b719-5525-482f-8cf5-dbd77bc91176" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FzsLmKbyMWCBNF9yY7SYH%2Fimage.png?alt=media&#x26;token=7036b8d0-999b-4ef3-b41d-2743fe406190" alt=""><figcaption></figcaption></figure>

#### Post AWB

Finally, hit the **POST AWB** button.

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FplRV3IoFmtq1EajMePFL%2Fimage.png?alt=media&#x26;token=3450d905-34ff-4854-b73a-c475d178b048" alt=""><figcaption></figcaption></figure>

It will pop up a new page, **Post Komet AWBS**, showing details of the AWB posted to Komet.&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FMa1M3X3iKrE9ORCZu161%2Fimage.png?alt=media&#x26;token=e82dc239-c57c-486c-b3ad-68c44712a9f4" alt=""><figcaption></figcaption></figure>

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).&#x20;

<figure><img src="https://4099088335-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBi3aNCeQ0YEBUj1LmkHR%2Fuploads%2FGJmVAZU6bbZ1maXIk0a0%2Fimage.png?alt=media&#x26;token=8a56f04e-dba7-4e25-affc-084e1eab5d79" alt=""><figcaption></figcaption></figure>
