Suitescript code of Saved search to find item fulfillments and item receipts of a transfer order

let transferorderSearchObj = search.create({
    type: "transferorder",
    filters:
        [
            ["mainline", "is", "F"],
            "AND",
            ["taxline", "is", "F"],
            "AND",
            ["cogs", "is", "F"],
            "AND",
            ["shipping", "is", "F"],
            "AND",
            ["type", "anyof", "TrnfrOrd"],
            "AND",
            ["internalid", "is", "123"],//internal id
            "AND",
            ["applyingtransaction.type", "anyof", "ItemShip", "ItemRcpt"]
        ],
    columns:
        [
            search.createColumn({ name: "tranid", label: "Document Number", summary: "MAX", }),
            search.createColumn({ name: "statusref", label: "Status", summary: "MAX", }),
            search.createColumn({ name: "internalid", label: "Internal ID", summary: "MAX", }),
            search.createColumn({
                name: "internalid",
                join: "applyingTransaction",
                summary: "GROUP",
                label: "applyingTransactionId"
            }),
            search.createColumn({
                name: "type",
                join: "applyingTransaction",
                summary: "MAX",
                label: "applyingTransactionType"
            }),
        ]
});


Leave a comment

Your email address will not be published. Required fields are marked *