Saved search to calculate location inventory
We modified some field in List ">" Account ">" Item to show item inventory.
But we have one problem when manage faulty product inventory (DOA)
Let's say, we have 4 warehouse.
MainWH - M01
Faulty Product - DOA
Consignment goods - C01, C02
At first, we use quantityonhand - locationquantityonhand show all other site quantity.
But when more DOA product transfer to the warehouse.
We need more precise to show only C01 + C02 inventory instead of above formula.
In short, we need to show all consignment quantity in that field only.
Is there any way to do that?
One more question, if a location unchecked "MAKE INVENTORY AVAILABLE". All inventory only not available for order but it still shown in all report or saved search. Is it correct?