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
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
Remember to change to the correct field before proceeding to run ANY script.
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