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

Remember to change to the correct field before proceeding to run ANY script.

Logic Script

To find {fieldName}, you are required to have access to Alpha or use Network in Developer Tools [F12].

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)

Extras