# Invoice ## Invoice's Database

UI Name	Database	Type	Remarks	Important
Debtor	`debtorCode`	`String`	`Debtor` must match existing debtor code, and they must be active state. E.g.: `300-A001`
Invoice No	`docNo`	`String`	Avoid using the same `Invoice No` to prevent overwrite. *Document Id or Running Number E.g.: `INV00001`
Date	`docDate`	`String`	E.g.: `2024-11-27T00:00:00+08:00`
Sales Location	`salesLocation`	`String`	Must have existing `Sales Location` in the accounting system. E.g.: `HQ`
Credit Term	`displayTerm`	`String`	`Credit Term` must match the same in the accounting system E.g.: `C.O.D.`
Description	`Description`	`String`	E.g.: `INVOICE`	Limit 80 Characters Max
Inclusive?	`inclusiveTax`	`Boolean`	E.g.: `False`
Rate	`currencyRate`	`Decimal`	E.g.: `1.234`
Table Item	`details`	`Array`	Refer below

## Invoice's Table Item

UI Name	Database	Type	Remarks
Item Code	`itemCode`	`String`	E.g.: `A001`
Acc. No.	`accNo`	`String`	E.g.: `500-0123`
Description	`description`	`String`	E.g.: `PRODUCT - CL14`
D/O Number	`ourDONo`	`String`	E.g.: `DO-123-456`
UOM	`uom`	`String`	E.g.: `UNIT`
Location	`location`	`String`	Must have existing `Location` in the accounting system. E.g.: `HQ`
Qty	`qty`	`Decimal`	Value must be number, and value cannot be negative. E.g.: `10.0`
Unit Price	`unitPrice`	`Decimal`	Value must be number, and value cannot be negative. E.g.: `10.0`
Tax Adjustment	`taxAdjustment`	`String`	Value must be None
Tax Code	`taxCode`	`String`	E.g.: `SV-01`

### Additional for E-Invoice

Name	Field	Type	Remarks
E-Invoice Start Date	`e_inv_start_date`	`DateTime`	`DateTime(2026,1,1)` Login to AutoCount, go to the `e-Invoice tab` → `e-Invoice Setting` → tick* "`Enable e-Invoice`" →Start Date: `01/01/2026`
Cancelled	`cancelled`	`Boolean`	Pass `true` to `void the Invoice`
Draft	`draft`	`Boolean`	Pass `true` to allow Invoice `Save as Draft` . (invoice will not be finalized).
Submit E-Invoice	`submitEInvoice`	`Boolean`	Pass `true` to check on the `Submit e-Invoice?`

## Invoice's Sample Code {% hint style="warning" %} Remember to change to the **correct field** before proceeding to run **ANY** script. {% endhint %} {% tabs %} {% tab title="Logic Script" %} {% hint style="info" %} To find `{fieldName}`, you are required to have access to **Alpha** or use **Network** in Developer Tools `[F12]`. {% endhint %}

import clr
clr.AddReference("Newtonsoft.Json")
clr.AddReference("System.Net")
clr.AddReference("System.IO")

from System.Text import *
from Newtonsoft.Json import *
from Newtonsoft.Json.Linq import *
from System import *

clr.AddReference("System.Drawing")
from System.Drawing import Bitmap, Image
from System.Drawing.Imaging import ImageFormat
from System.IO import MemoryStream, StreamWriter
from System.Net import WebClient
import binascii
from System import BitConverter

# search
documentList = Module("{YOUR-MODULE-NAME}").findAll(
    {
        "Audit.UpdatedDate": {"$gt": Inputs["lastSync"]},
        "Audit.UpdatedBy": {"$ne": "External"},
        'Dynamic.Extension.{fieldName}': {'$in': [None, '']}, #Error Message
        "Dynamic.Extension.{fieldName}": {"$eq" : None }, #E-Invoice Validated Date
        "Dynamic.Extension.{fieldName}": {"$ne": None}, #Business logic
    }
)
debug("documentList", documentList)

resultList = []
# E-Invoice implementation start date
e_inv_start_date = DateTime(2026, 1, 1)

def prepareRow(x):
    row = JObject()
    # row["itemCode"] = x["{YOUR-ITEM-CODE}"]
    payloadData["payload"]["docNo"] = data.DocumentId
    # row["ourDONo"] = x["{YOUR-DO-NO}"]
    # row["location"] = x["{YOUR-LOCATION}"]
    row["description"] = x["{YOUR-DESCRIPTION}"].ToString()
    row["qty"] = x["{YOUR-QTY}"]
    row["uom"] = x["{YOUR-UOM}"]
    row["unitPrice"] = x["{YOUR-UNIT-PRICE}"] * x["{YOUR-EXCHANGE-RATE}"]
    row["subtotal"] = x['YOUR-SUBTOTAL']
    row['classification'] = str(x['YOUR-CLASSIFICATION'])
    row["taxAdjustment"] = None
    if x["Tax Code"].Id != 0:
        row["taxCode"] = x['YOUR-TAX-CODE']['YOUR-TAX-CODE']
    return row


def preparePayload(data):
    payloadData = JObject()
    payloadData["type"] = "ARInvoice"
    payloadData["cancelled"] = data["{IS-YOUR-DOC-CANCELLED}"]
    payloadData["payload"] = JObject()
    
    # Only process e-Invoice logic for invoices issued after e-Invoice start date
    if data['Invoice Date'] > e_inv_start_date:
        payloadData["draft"] = True
        if data['E-Invoice Validated Date'] is not None:
            payloadData["draft"] = False
        
        payloadData["payload"]["submitEInvoice"] = True    

    if data['Code'] != None and data['Code'] != 0:
        payloadData["payload"]["docKey"] = data['YOUR-CODE']
    
    
    payloadData["payload"]["debtorCode"] = data["{YOUR-DEBTOR-CODE}"]
    payloadData["payload"]["docNo"] = None if data['{YOUR-DOC-NO}'] == "" or data['{YOUR-DOC-NO}'] is None else data['{YOUR-DOC-NO}']
    #payloadData["payload"]["docNo"] = data.DocumentId
    payloadData["payload"]["docDate"] = data["{YOUR-DOC-DATE}"]
    payloadData["payload"]["salesLocation"] = data["{YOUR-SALES-LOCATION}"]
    payloadData["payload"]["description"] = data['YOUR-TRANSACTION-DESCRIPTION'][:80]
    payloadData["payload"]["inclusiveTax"] = False if data['YOUR-TAX-INCLUSIVE?'] != True else True
    payloadData["payload"]["displayTerm"] = data["{YOUR-TERM}"]
    payloadData["payload"]["currencyRate"] = Convert.ToDecimal(data['YOUR-EXCHANGE-RATE']) if data['YOUR-EXCHANGE-RATE'] is not None else Decimal(0)

    payloadData["payload"]["details"] = JArray.FromObject(data['YOUR-DETAILS'].Select(lambda x: prepareRow(x)))

    payloadData["LastModified"] = data.UpdatedDate
    return payloadData


# end of added
for entry in documentList:
    payloadData = preparePayload(entry)
    if (
        payloadData["payload"]["debtorCode"] != None
        and payloadData["payload"]["debtorCode"] != ""
    ):
        resultList.append(payloadData)
    # debug('payloadData', payloadData)


# debug('done', resultList)
outputs["results"] = JArray.FromObject(resultList)
debug("result", resultList)

{% endtab %} {% tab title="Extras" %} ``` def image_to_hex(image_url): web_client = WebClient() image_data = web_client.DownloadData(image_url) with MemoryStream(image_data) as image_stream: bitmap = Bitmap(image_stream) # Resize the image original_width = bitmap.Width original_height = bitmap.Height max_width = 240.0 max_height = 240.0 # Calculate new dimensions preserving the aspect ratio ratio = min(max_width / original_width, max_height / original_height) new_width = int(original_width * ratio) new_height = int(original_height * ratio) debug("new_width", new_width) resized_bitmap = bitmap.GetThumbnailImage( new_width, new_height, None, IntPtr.Zero ) # Convert the image to PNG (or other supported formats) png_stream = MemoryStream() # resized_bitmap.Save(png_stream, ImageFormat.Png) png_bytes = png_stream.ToArray() # Convert PNG byte array to hexadecimal string png_hex = "".join("{:02x}".format(b) for b in png_bytes) # Create RTF content with the embedded PNG image rtf = [] rtf.append( r"{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}}" ) rtf.append(r"\viewkind4\uc1") # image start stream = MemoryStream() resized_bitmap.Save(stream, ImageFormat.Bmp) # Save as BMP stream.Position = 0 # Reset stream position # Read bytes and convert to hex img_bytes = stream.ToArray() # debug('img_bytes', img_bytes) # debug('here', 'here1') # hex_string = binascii.hexlify(img_bytes).decode('ascii') hex_string = BitConverter.ToString(img_bytes).Replace("-", "").ToLower() # Write the RTF content to a file return hex_string ``` {% endtab %} {% endtabs %} --- # 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://inistate.gitbook.io/home/advanced/integration/accounting-1/invoice.md?ask= ``` 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.