To Item List were added the next parameters:
- “Date” datepicker from-to. If date is selected the values in the next columns is filtered by selected date range:
- Received;
- In stock;
- Allocated;
- Available;
- Incoming PO;
- SLT;
- Landed cost;
- Inv. Value;
- Qty Sold;
- Avg Price;
- “Extended View” checkbox. If checkbox is checked the next columns is displayed:
- Received = sum (Qty in IR in statuses Received). Qty is displayed according to the entered date. If date range is empty -> is calculated for the all time;
- Qty sold = sum (Qty in Invoice in statuses In review/Open/Paid). Qty is displayed according to the entered date. If date range is empty -> is calculated for the all time;
- Avg Price – is calculated based on the Qty sold.
