Stock Item

Stock Item's Database

UI Name	Database	Type	Remarks
Item Code	ItemCode	String	E.g.: Item-Code-01
UOM	UOM	String	E.g.: UNIT
Rate	Rate	Integer	E.g.: 1
Description	Description	String	E.g.: Description
Description 2	Desc2	String	E.g.: Description2
Item Group	ItemGroup	String	E.g.: ItemGroup
Item Type	ItemType	String	E.g.: ItemType
Lead Time	LeadTime	String	E.g.: LeadTime
Duty Rate	Duty Rate	String	E.g.: Duty Rate
Supply Tax Code	TaxCode	String	E.g.: Tax Code
Purchase Tax Code	PurchaseTaxCode	String	E.g.: PurchaseTaxCode
Tariff Code	Tariff Code	String	E.g.: Tariff Code
Shelf	Shelf	String	E.g.: Shelf
Price 1	Price	Decimal	E.g.: 1.00
Price 2	Price2	Decimal	E.g.: 1.00
Price3	Price3	Decimal	E.g.: 1.00
Price 4	Price4	Decimal	E.g.: 1.00
Price 5	Price5	Decimal	E.g.: 1.00
Price 6	Price6	Decimal	E.g.: 1.00
Standard Cost	Cost	Integer	E.g.: 1.8
Min. Selling Price	MinSalePrice	Decimal	E.g.: 1.00
Max. Selling Price	MaxSalePrice	Decimal	E.g.: 1.00
Min. Purchase Price	MinPurchasePrice	Decimal	E.g.: 1.00
Max. Purchase Price	MaxPurchasePrice	Decimal	E.g.: 1.00
Balance Qty	BalQty	Integer	E.g.: 100
Min. Qty	MinQty	Decimal	E.g.: 1.00
Max. Qty	MaxQty	Decimal	E.g.: 1.00
Normal Level	NormalLevel	Decimal	E.g.: 1.00
Re-order Level	ReOLevel	Decimal	E.g.: 1.00
Re-order Qty	ReOQty	Decimal	E.g.: 1.00

Stock Item'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].

debug("test")
moduleName = "{YOUR-MODULE-NAME}"
inistateKeyField = "DocumentId"
keyField = "Doc"
modifiedDateField = "LastModified"
fields = [["DocumentId", "Doc"], ["LastModified", "LastModified"]]
inistateFields = []


result = list(inputs["list"]).ToList()
for item in result:
    entry = Module(moduleName).find({
        "$and": [
            {"Dynamic.Extension.{fieldName}": item["{YOUR-ITEM-CODE}"],
            {"Dynamic.Extension.{fieldName}": item["{YOUR-UOM}"]
        ]
    })
    debug('entry' + item['ItemCode'].ToString(),entry)
    form = Module(moduleName).execute("sync", entry)
    debug('form',form)
    form["Item Code"] = item["{YOUR-ITEM-CODE}"]
    form["UOM"] = item["{YOUR-UOM}"]
    form["Rate"] = item["{YOUR-RATE}"]
    form["Description"] = item["{YOUR-DESCRIPTION}"]
    form["Description 2"] = item["{YOUR-DESCRIPTION-2}"]
    form["Item Group"] = item["{YOUR-ITEM-GROUP}"]
    form["Item Type"] = item["{YOUR-ITEM-TYPE}"]
    form["Lead Time"] = item["{YOUR-LEAD-TIME}"]
    form["Duty Rate"] = item["{YOUR-DUTY-RATE}"]
    form["Supply Tax Code"] = item["{YOUR-SUPPLY-TAX-CODE}"]
    form["Purchase Tax Code"] = item["{YOUR-PURCHASE-TAX-CODE}"]
    form["Tariff Code"] = item["{YOUR-TARIFF-CODE}"]
    form["Shelf"] = item["{YOUR-SHELF}"]
    form["Price 1"] = item["{YOUR-PRICE-1}"]
    form["Price 2"] = item["{YOUR-PRICE-2}"]
    form["Price 3"] = item["{YOUR-PRICE-3}"]
    form["Price 4"] = item["{YOUR-PRICE-4}"]
    form["Price 5"] = item["{YOUR-PRICE-5}"]
    form["Price 6"] = item["{YOUR-PRICE-6}"]
    form["Standard Cost"] = item["{YOUR-STANDARD-COST}"]
    form["Min. Selling Price"] = item["{YOUR-MIN-SELLING-PRICE}"]
    form["Max. Selling Price"] = item["{YOUR-MAX-SELLING-PRICE}"]
    form["Min. Purchase Price"] = item["{YOUR-MIN-PURCHASE-PRICE}"]
    form["Max. Purchase Price"] = item["{YOUR-MAX-PURCHASE-PRICE}"]
    form["Balance Qty"] = item["{YOUR-BALANCE-QTY}"]
    form["Min. Qty"] = item["{YOUR-MIN-QTY}"]
    form["Max. Qty"] = item["{YOUR-MAX-QTY}"]
    form["Normal Level"] = item["{YOUR-NORMAL-LEVEL}"]
    form["Re-order Level"] = item["{YOUR-REORDER-LEVEL}"]
    form["Re-order Qty"] = item["{YOUR-REORDER-QTY}"]

    debug("form "+ item['ItemCode'].ToString(), form)
    Module(moduleName).submit(entry, form)

SQL Script

jobs.json