---
# System prepended metadata

title: JUBILI to QuickBooks Invoice Field Mapping

---

# JUBILI to QuickBooks Invoice Field Mapping

## SaleOrder Map to Invoice

| JUBILI Field            | QuickBooks Field                                                 | Transformation/Logic                                       | Notes (คำอธิบาย)                                     |
| :---------------------- | :--------------------------------------------------------------- | :--------------------------------------------------------- | :--------------------------------------------------- |
| docDate                 | TxnDate                                                          | `=DATE(key.docDate, yyyy-MM-dd)`                           | จัดรูปแบบวันที่เป็น yyyy-MM-dd                       |
| paymentCreditDate       | DueDate                                                          | `=ADDDATE(key.docDate, key.paymentCreditDate, yyyy-MM-dd)` | คำนวณวันครบกำหนดโดยการเพิ่มวันเครดิตเข้าไปใน TxnDate |
| DeliveryDate            | ShipDate                                                         | `=DATE(key.deliveryDate, yyyy-MM-dd)`                      | จัดรูปแบบวันที่เป็น yyyy-MM-dd                       |
| createDate              | Line.SalesItemLineDetail.ServiceDate                             | `=DATE(key.createDate, yyyy-MM-dd)`                        | จัดรูปแบบวันที่เป็น yyyy-MM-dd                       |
| remark                  | PrivateNote                                                      | `=CONCAT(...)`                                             |                                                      |
| createdBy               | PrivateNote                                                      | `=CONCAT(...)`                                             | ถูกรวมไว้ในฟิลด์ PrivateNote                         |
| assignee                | PrivateNote                                                      | `=CONCAT(...)`                                             | ถูกรวมไว้ในฟิลด์ PrivateNote                         |
| saleOrderStatus         | PrivateNote                                                      | `=CONCAT(...)`                                             | ถูกรวมไว้ในฟิลด์ PrivateNote                         |
| leadCode                | PrivateNote                                                      | `=CONCAT(...)`                                             | ถูกรวมไว้ในฟิลด์ PrivateNote                         |
| quotationCode           | PrivateNote                                                      | `=CONCAT(...)`                                             | ถูกรวมไว้ในฟิลด์ PrivateNote                         |
| prospectId              | CustomerRef                                                      | `Lookup via where clause`                                  |                                                      |
| vatTypeText             | TxnTaxDetail.TxnTaxCodeRef                                       | `Lookup via where clause (using CONCAT)`                   |                                                      |
| vatRate                 | TxnTaxDetail.TxnTaxCodeRef                                       | `Lookup via where clause (using CONCAT)`                   |                                                      |
| paymentTerm             | SalesTermRef                                                     | `Lookup via where clause`                                  |                                                      |
| saleOrderCode           | DocNumber, TrackingNum                                           | `Direct Mapping`                                           |                                                      |
| currency                | CurrencyRef                                                      | `Direct Mapping`                                           |                                                      |
| contactEmail            | BillEmail.Address                                                | `Direct Mapping`                                           |                                                      |
| deliveryAddress         | BillAddr.Line1, ShipAddr.Line1                                   | `Direct Mapping`                                           |                                                      |
| deliveryDistrict        | BillAddr.City, ShipAddr.City                                     | `Direct Mapping`                                           |                                                      |
| deliveryProvince        | BillAddr.CountrySubDivisionCode, ShipAddr.CountrySubDivisionCode | `Direct Mapping`                                           |                                                      |
| deliveryCountry         | BillAddr.Country, ShipAddr.Country                               | `Direct Mapping`                                           |                                                      |
| specialDiscount         | Line.Amount (Discount)                                           | `Direct Mapping`                                           |                                                      |
| totalVat                | TxnTaxDetail.TotalTax                                            | `Direct Mapping`                                           |                                                      |
| DeliveryShipment        | ShipMethodRef                                                    | `Direct Mapping`                                           |                                                      |
| companyName             | -                                                                | -                                                          |                                                      |
| quotationId             | -                                                                | -                                                          |                                                      |
| leadId                  | -                                                                | -                                                          |                                                      |
| prospectName            | -                                                                | -                                                          |                                                      |
| projectId               | -                                                                | -                                                          |                                                      |
| projectName             | -                                                                | -                                                          |                                                      |
| projectCode             | -                                                                | -                                                          |                                                      |
| contactName             | -                                                                | -                                                          |                                                      |
| contactPhone            | -                                                                | -                                                          |                                                      |
| cost                    | -                                                                | -                                                          |                                                      |
| vatType                 | -                                                                | -                                                          |                                                      |
| subTotal                | -                                                                | -                                                          |                                                      |
| total                   | -                                                                | -                                                          |                                                      |
| totalExVat              | -                                                                | -                                                          |                                                      |
| grandTotal              | -                                                                | -                                                          |                                                      |
| validDate               | -                                                                | -                                                          |                                                      |
| paymentType             | -                                                                | -                                                          |                                                      |
| lostReason              | -                                                                | -                                                          |                                                      |
| lostReasonDetail        | -                                                                | -                                                          |                                                      |
| paymentDate             | -                                                                | -                                                          |                                                      |
| manufactureTrackingDate | -                                                                | -                                                          |                                                      |
| deliveryTrackingDate    | -                                                                | -                                                          |                                                      |
| receivedTrackingDate    | -                                                                | -                                                          |                                                      |
| convertRate             | -                                                                | -                                                          |                                                      |
| standardRate            | -                                                                | -                                                          |                                                      |
| subTotalConvert         | -                                                                | -                                                          |                                                      |
| specialDiscountConvert  | -                                                                | -                                                          |                                                      |
| totalConvert            | -                                                                | -                                                          |                                                      |
| totalVatConvert         | -                                                                | -                                                          |                                                      |
| totalExVatConvert       | -                                                                | -                                                          |                                                      |
| grandTotalConvert       | -                                                                | -                                                          |                                                      |

<br>

## SaleOrder to Item Map

| JUBILI Field          | QuickBooks Field                       | Transformation/Logic                                   | Notes (คำอธิบาย)                |
| :-------------------- | :------------------------------------- | :----------------------------------------------------- | :------------------------------ |
| itemName              | Line[].Description                     | `=CONCAT(key.itemName, ' (Code: ', key.itemCode, ')')` | ถูกรวมไว้ในคำอธิบายรายการสินค้า |
| itemCode              | Line[].Description                     | `=CONCAT(...)`                                         | ถูกรวมไว้ในคำอธิบายรายการสินค้า |
| quantity              | Line[].SalesItemLineDetail.Qty         | `Direct Mapping`                                       |                                 |
| createDate            | Line[].SalesItemLineDetail.ServiceDate | `=DATE(key.createDate, yyyy-MM-dd)`                    | จัดรูปแบบวันที่เป็น yyyy-MM-dd  |
| amountExvatExdiscount | Line[].Amount                          | `Direct Mapping`                                       |                                 |
| amount                | -                                      | -                                                      |                                 |
| saleOrderId           | -                                      | -                                                      |                                 |
| saleOrderItemId       | -                                      | -                                                      |                                 |
| unit                  | -                                      | -                                                      |                                 |
| unitPrice             | -                                      | -                                                      |                                 |
| discount              | -                                      | -                                                      |                                 |
| categoryName          | -                                      | -                                                      |                                 |
| groupCategoryName     | -                                      | -                                                      |                                 |

Customer Creation
{%preview https://hackmd.io/@aung-team/r1xoBtt7ex %}

Item Creation
{%preview https://hackmd.io/@aung-team/Sk4WyYKXee %}

Webhook Document
{%preview https://hackmd.io/SENUZDO5ThWP5jCfcoDvDw#Quickbook-Webhook%}