# Monthly Order by Customer (Qty)

Step 1. Buka menu **Intelligence**.

Step 2. Pilih menu **BI**.

Step 3. Pilih menu **Sales** **Report**.

<figure><img src="https://1936324811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMsbbXMQxBVcIuCn-j4%2Fuploads%2FhmE40nmbfXlAqwnFLvUH%2Fimage.png?alt=media&#x26;token=19e93aa9-1011-4f72-bf62-6b52ef1caf5f" alt="" width="563"><figcaption></figcaption></figure>

Step 4. Pilih Tab **Monthly Order by Customer (Qty).**

<figure><img src="https://1936324811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMsbbXMQxBVcIuCn-j4%2Fuploads%2FgZwBYk8kxAcBnwjYBGbn%2Fimage.png?alt=media&#x26;token=8c551160-e210-4200-a344-4c20a318227d" alt=""><figcaption></figcaption></figure>

Pada menu **Monthly Order by Customer (Qty),** Anda dapat mengetahui data berikut:

<figure><img src="https://1936324811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMsbbXMQxBVcIuCn-j4%2Fuploads%2FnQsyfIe2GpNdD4faMmzg%2Fimage.png?alt=media&#x26;token=38794ed3-8adf-485d-b64b-55f5592f26a1" alt=""><figcaption></figcaption></figure>

> **Contoh** : Pada bulan Desember, pelanggan dengan kode 0000003\_1 memiliki 120 item produk terjual dalam bentuk SO (Sales Order), 120 item produk terjual dalam bentuk DO, dan 120 item produk terjual dalam bentuk SI (Sales Invoice) khusus brand BestFood. Jika ditotal dari bulan Januari - Desember keseluruhan produk dengan brand BestFood terjual sebanyak 180.556 item produk dalam bentuk SO, 179.045 item produk dalam bentuk DO, dan 157.667 item produk dalam bentuk SI. \
> Hal ini bisa terjadi ketidaksinkronan data apabila pesanan pada SO tidak keseluruhan diproses hingga ke bentuk DO dan SI atau masih dalam status Draft, Verified dan To Invoice.&#x20;

{% hint style="info" %}

* **Customer Code:** Kode pelanggan
* **SO** : Sales Order (Pesanan Penjualan)
* **DO** : Delivery Order (Surat Jalan)
* **SI** : Sales Invoice (Faktur Penjualan)
  {% endhint %}

<figure><img src="https://1936324811-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MMsbbXMQxBVcIuCn-j4%2Fuploads%2FYYMR7o60Yi7aAh3PUpoD%2Fimage.png?alt=media&#x26;token=860a7aaf-5621-401f-b9a8-4f44aaa1b08e" alt="" width="563"><figcaption></figcaption></figure>

> **Contoh** : Produk 02 CTHWEEE terjual sebanyak 549.903 pcs dari total keseluruhan produk terjual atau sekitar 41,24%.

{% content-ref url="../cara-export-excel-data-bi" %}
[cara-export-excel-data-bi](https://panduan-dms.simplidots.id/website-backoffice/dms-distribution-management-system/intelligence/bi-business-intelligence/cara-export-excel-data-bi)
{% endcontent-ref %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://panduan-dms.simplidots.id/website-backoffice/dms-distribution-management-system/intelligence/bi-business-intelligence/sales-report/monthly-order-by-customer-qty.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
