Good Receive

Good Receive's Database

UI Name	Database	Type	Remarks
G/R No	Doc	String	Avoid using the same G/R No to prevent overwrite. E.g.: GR-001234
G/R Key	DocKey	String	E.g.: 271800
Last Modified	LastModified	String	E.g.: 2024-12-20T08:57:37.557
Creditor	CreditorCode	String	Creditor must match existing creditor code, and they must be active state. E.g.: 400-R002
Name	CreditorName	String	E.g.: BLUE SOFA PLT
Supplier DO No	SupplierDONo	String	E.g.: DO-100355
Address [Line 1]	InvAddr1	String	E.g.: NO 64, JALAN KP5
Address [Line 2]	InvAddr2	String	E.g.: KAWASAN INDUSTRIAL KOTA PUTERI
Address [Line 3]	InvAddr3	String	E.g.: 48200, BATU ARANG SELANGOR
Address [Line 4]	InvAddr4	String	E.g.: BLOCK B, UNIT 12
Date	DocDate	String	E.g.: 2024-12-20T00:00:00
Branch	BranchCode	String	E.g.: BR001
Display Term	DisplayTerm	String	E.g.: NET 60
Purchase Location	PurchaseLocation	String	Must have existing Purchase Location in the accounting system. E.g.: PJ
Purchase Agent	PurchaseAgent	String	E.g.: AGENT001
Ship Via	ShipVia	String	E.g.: DHL
Ship Info	ShipInfo	String	E.g.: EXPRESS
Total (ex)	TotalExTax	Number	E.g.: 5000
Inclusive	InclusiveTax	String	E.g.: T
Taxable Amount	TaxableAmt	Number	E.g.: 4500
Tax	Tax	Number	E.g.: 500
Currency	CurrencyCode	String	E.g.: USD
Rate	CurrencyRate	Number	E.g.: 1.2
Local Total	LocalNetTotal	Number	E.g.: 6000
Total	NetTotal	Number	E.g.: 5500
Seq	Seq	Number	E.g.: 17
Item Code	ItemCode	String	E.g.: RDS-5528 SOFA
Description	Description	String	E.g.: RDS CLOUD SOFA 5528
Description 2	Desc2	String	E.g.: L Shape(30", 40") / Col: Beetex HIVE GD 2035 - 05# Gold
Delivery Date	DeliveryDate	String	E.g.: 2024-12-21T00:00:00
Location	Location	String	E.g.: PJ
UOM	UOM	String	E.g.: PCS
Quantity	Qty	Number	Value must be number, and value cannot be negative. E.g.: 2
Unit Price	UnitPrice	Number	Value must be number, and value cannot be negative. E.g.: 2500
Discount	Discount	String	E.g.: 10%
C/N Amt.	CNAmt	String	E.g.: 100
Subtotal	SubTotal	Number	E.g.: 4500
Subtotal (ex)	SubTotalExTax	Number	E.g.: 4000
Detail Tax	DtlTax	Number	E.g.: 500
Ref Doc No	FromDocNo	String	E.g.: PO-001638
UDF Desc 2	UDF_Desc2	String	E.g.: Special Instructions

Good Receive's Sample Code

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

SQL Script

This is a sample SQL, may not be as same as your database.

SELECT TOP (10)
    Doc AS Document,
    DocKey AS DocumentKey,
    LastModified,
    CreditorCode,
    CreditorName,
    SupplierDONo,
    InvAddr1,
    InvAddr2,
    InvAddr3,
    InvAddr4,
    DocDate,
    BranchCode,
    DisplayTerm,
    PurchaseLocation,
    PurchaseAgent,
    ShipVia,
    ShipInfo,
    TotalExTax,
    InclusiveTax,
    TaxableAmt,
    Tax,
    CurrencyCode,
    CurrencyRate,
    LocalNetTotal,
    NetTotal,
    Seq,
    ItemCode,
    Description,
    Desc2,
    DeliveryDate,
    Location,
    UOM,
    Qty,
    UnitPrice,
    Discount,
    CNAmt,
    SubTotal,
    SubTotalExTax,
    DtlTax,
    FromDocNo,
    UDF_Desc2,
    LastModified
FROM GoodReceives
WHERE LastModified > "{LAST_MODIFIED_DATE_TIME}";

jobs.json

Logic Script