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.

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}";
PreviousPurchase OrderNextPayment Voucher

Last updated