Dynamics Community Forum Thread Details

How to customise SalesTable for to allow user to Enter the ItemId with Barcode Scanner

I have a requirement to customise the SalesTable form to allow the user to enter the ItemId with a Barcode scanner on the salesTable form.

I have tried a number of ways and places. The following is the furthest that I got and everyting works except where I want to update the ItemId with the value returned from InventTable.ItemId. And then I am assuming I will have to refresh the form to show the changed item id.

Can someone help with what I am doing wrong or if there is a better way of doing this. I have added comments to my code where it is going wrong.

Any Advice will greatly be appreciated

[ExtensionOf(formControlStr(SalesTable, SalesLine_ItemId))]
final class SalesTableForm_ItemIdControl_???_Extension
{
    public boolean modified()
    {
        boolean             ret;
        FormStringControl   ctrl     = this as FormStringControl;
        ItemId              itemId   = ctrl.text();
        InventTable         inventTable;

        if(itemId != '' && !InventTable::exist(itemId)) // ItemId has been entered but it is not valid InventTable Item
        {
            inventTable = InventTable::find(InventItemBarcode::findBarcode(itemId, False, False).itemId);
            if (inventTable.ItemId != '') //Not an Item found with barcode
            {
                info(StrFmt("Barcode value entered. Item ID: %1.",inventtable.ItemId)); //Optional
                ctrl.text(inventTable.ItemId); // Update the control with the correct Item Id
                //WHEN DEBUGGING THE ctrl.text is ""
                //How do I refresh the form ????????
                
            }
        }
        ret = next modified();
        return ret;

    }

}

Categories:

Dynamics 365 Finance

Quick Links