RE: How to filter adjustment acccout dropdown to a few accounts on the Inventory adjustment form.
Nee to filter the adjustment account dropdown to the following account internal id’s:
[‘558’, ‘371’, ‘386’, ‘609’
To filter the adjustment account dropdown to the following account internal IDs:
['558', '371', '386', '609']
you can use the following steps:
- Go to Customization > Forms > List > Edit for the form where you want to filter the adjustment account dropdown.
- Click the Fields subtab.
- Find the Adjustment Account field and click Edit.
- In the Filter section, select Custom Filter.
- In the Custom Filter dialog box, enter the following formula:
[ACCOUNT].internalid in ('558', '371', '386', '609')
- Click Save.
- Click Save again to save the form.
Once you have followed these steps, the adjustment account dropdown will be filtered to the following account internal IDs:
['558', '371', '386', '609']
Note: If you are using the NetSuite UI, you can also filter the adjustment account dropdown by selecting the Custom Filter option and entering the following formula in the Filter field:
[ACCOUNT].internalid = 558 OR [ACCOUNT].internalid = 371 OR [ACCOUNT].internalid = 386 OR [ACCOUNT].internalid = 609
This formula will filter the adjustment account dropdown to the following account internal IDs:
['558', '371', '386', '609']
