Here are some tips from Guru Mathieu Goodman to help in the creation of search filters using internal ID:
- If you want to use numerical value (greaterthan, equalto...) always use 'internalidnumber' instead of 'internalid'
- If you are using internalid with the anyof operator make sure the id list is not null or undefined. The error thrown when trying to use a null list is confusing and tell you the opreator is wrong.
2. Use Item Cost as Transfer Cost
When the functionality to use Item Cost as Transfer Cost is activated, the Transfer Price still defaults to Transfer Price from item. The amount of transfer order is also set to that Transfer Price.
However, when the transfer order is fulfilled and received the average cost is used (ignoring the transfer
price and amount from the transfer order). This works with FIFO, LIFO and Average Cost methods.
The inventory worksheet value defaults to Average Cost for location; if there is no value as of the date of the inventory worksheet it is defaulted to Purchase Price. Meanwhile, the inventory adjustment value defaults to Average Cost for location. If there is no value as of the date of the inventory adjustment it is defaulted to 0.