Hello,

I have two functions in a script, one works the other does not.

First function based on inventory balance:

function getQtyFromWestbury(itemId) {

    let qty = 0;

    //Search: 'Inventory Balance Search'

    let inventorySearch = search.create({

        type: 'inventorybalance',

        filters:

        [

            ['item','anyof',itemId], 

            'AND', 

            ['location','anyof','4'] // Westbury

        ],

        columns:

        [

            search.createColumn({name: 'item'}),

            search.createColumn({name: 'available'}),

            search.createColumn({

                name: 'type',

                join: 'item'

            })

        ]

    });

    inventorySearch.run().each(function(result){

        const qtyAvailable = parseInt(result.getValue({name: 'available'})) || 0;

        const itemNameText = result.getText({name: 'item'});

        const itemType = result.getValue({name: 'type', join: 'item'});

        log.debug('getBalanceFromWestbury', 'The available quantity for item ' + itemNameText + ' of type ' + itemType + ' in Westbury is ' + qtyAvailable);