# 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 %}