A/P Invoice

A/P Invoice's Database

UI Name
Database
Type
Remarks

Debtor

creditorCode

String

E.g.: 400-X001

Invoice No

docNo

String

E.g.: INV24121436

Date

docDate

String

E.g.: 2024-11-15T00:00:00+08:00

Description

description

String

E.g.: PURCHASE - SI0000001

Journal Type

journalType

String

E.g.: PURCHASE

Inclusive

inclusiveTax

Boolean

E.g.: true

Credit Term

displayTerm

String

E.g.: NET 30

Table Item

details

Array

A/P Invoice's Table Item

UI Name
Database
Type
Remarks

Item Code

accNo

String

E.g.: 600-0005

Description

description

String

E.g.: OFFICE SUPPLIES

Qty

qty

Number

E.g.: 20

UOM

uom

String

E.g.: PKG

Unit Price

unitPrice

Number

E.g.: 150

SubTotal

subtotal

Number

E.g.: 3000

Tax Adjustment

taxAdjustment

Number

E.g.: 75

A/P Invoice's Sample Code

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' } })
debug('documentList', documentList)

resultList = []

def prepareRow(x):
    row = JObject()
    row["accNo"] = x['{YOUR-ITEM-CODE}']
    row["description"] = x['{YOUR-DESCRIPTION}']
    row["qty"] =  x['{YOUR-QUANTITY}']
    row["uom"] = "N/A"
    row["unitPrice"] = x['{YOUR-UNIT-PRICE}'] 
    row["subtotal"] = x['{YOUR-TOTAL}']
    if x["{YOUR-TAX-CODE}"].Id != 0:
        row["taxCode"] = x['{YOUR-TAX-CODE}']['{YOUR-TAX-CODE}']
        # row["taxRate"] = x['{YOUR-TAX-CODE}']['{YOUR-PERCENTAGE}'].ToString()
    row["taxAdjustment"] = None
    return row
    
def preparePayload(data):
    payloadData = JObject()
    payloadData["type"] = "APInvoice"
    payloadData["cancelled"] = data['{YOUR-CANCELLED}']
    payloadData["payload"] = JObject()
    if data['{YOUR-CODE}'] != None and data['{YOUR-CODE}'] != 0:
        payloadData["payload"]["docKey"] = data['{YOUR-CODE}'] 
    payloadData["payload"]["creditorCode"] = data['{YOUR-COMPANY-CODE}']
    payloadData["payload"]["docNo"] = data['{YOUR-SUPPLIER-INVOICE-NO}']
    payloadData["payload"]["docDate"] = data['{YOUR-SUPPLIER-INVOICE-DATE}']
    payloadData["payload"]["description"] = data['{YOUR-TRANSACTION-DESCRIPTION}']
    payloadData["payload"]["inclusiveTax"] = True 
    payloadData["payload"]["displayTerm"] = data['{YOUR-TERM}']
    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"]["creditorCode"] != None and payloadData["payload"]["creditorCode"] != "":
        resultList.append(payloadData)
    #debug('payloadData', payloadData)
    
#debug('done', resultList)

outputs['results'] = JArray.FromObject(resultList)

Last updated