Section Items

In this article, particular columns contained in the section Items, are described.

Section Items in IQC document

Detailed description of the basic columns contained in the list can be found in article Tab Items.

Other columns available in the list:

Column Quantity in Stock corresponds to a quantity:

  • of resources of a given item/lot available in a given warehouse, indicated in section Parameters
  • reduced by shortages resulting from SI and R documents
  • reduced by reservations of resources from SI, R and SIQC trade documents not associated with any warehouse documents
  • reduced by reservations resulting from unconfirmed SOR, IR-, WM-, PORQC, IR+QC warehouse documents
  • reduced by quantity resulting from subitems associated with resources derived from not executed orders, when the due date or activation date in SO or IO is later than the final date in IQC
  • increased by quantity resulting from SIQC or RQC, but only if no warehouse documents were generated to SI and R associated with them.

Column In Transit (+) presents quantity of items/lots resulting from:

  • not executed purchase orders – Unconfirmed, Confirmed, Pending
  • not executed internal orders – submitted, confirmed or pending, whose target warehouse is a warehouse indicated in IQC and whose expected date or activation date is not later than the final date of IQC

Column Ordered (-) presents quantities resulting from:

  • not executed sales orders – initiated, unconfirmed, confirmed, pending
  • not executed internal orders – confirmed or pending, whose target warehouse is a warehouse indicated in IQC and whose expected date or activation date is not later than the final date of IQC. A quantity calculated this way is presented as a negative value.

The quantity of the component Demand Forecast results from the quantity forecasted in demand forecast document for individual items/lots. It its proportional to the period indicated in the IQC. Forecast quantity is presented with a minus sign, because it reduces the balance by increasing a quantity necessary for order.

Example
In the item quantity calculation, for item BZKD, a period from 01/01/2019 to 15/01/2019 was defined. The forecast quantity from the forecast document, in which the quantity of item BZKD was forecasted for a period from 01/01/2019 to 31/01/2019, will be included in the IQC Quantity resulting from the forecast = 310 pcs of BZKD. However, the quantity of 150 pcs only from this forecast will be included in the item quantity calculation (for 15 days from a period from 01/01/2019 to 31/01/2019).

The quantity of the components Forecast Realization results from the quantity of a given item/lot released with the use of a confirmed warehouse document (IR-, WM-, SOR) whose:

  • date of release – for SOR documents
  • date of issue – for IR- and WM- documents

falls within the period indicated in the item quantity calculation. The value of forecast realization is displayed with a minus sign, because it decreases the forecast quantity.

Note
If quantity resulting from a demand forecast document is less than quantity resulting from warehouse documents for released items (SOR, IR-, and WM-) included in component Forecast Realization, column Forecast Quantity takes on value 0.

In case of adding onto IQC document an item with features, quantity is retrieved for that specific lot from DF document for components Demand Forecast and Forecast Realization.

The value in column Planned Inventory is retrieved from the item form, where in tab Resources → Planned Inventory a user can define the minimum and optimal quantity of an item in individual warehouses.

In an IQC, in section Parameters, in field Planned Inventory, it is necessary to specify which value should be included the calculation.

In case of adding onto IQC document an item with features, quantity is retrieved for that specific lot from DF document for components Demand Forecast and Forecast Realization.

Example
On item BZKD form, the following values of planned stock are defined for the main warehouse:

  • Item BZKD (without division into lots) – 10 pcs
  • Item BZKD with features Red/S – 5 pcs

The item is added onto IQC document with the use of button:

  • [Add], [Add Group] – quantity in column Planned Stock will be 10 pcs
  • [Add By Features], [Add By Features Through Form] and selection of lot Red/S – quantity in column Planned Stock will be 5 pcs

The balance shows the quantity of an item that is a sum of quantity in columns:

  • Quantity in Stock – positive values
  • In Transit (+) – positive values
  • Ordered (-) – negative values
  • Forecast Quantity – negative values
  • Planned inventory – negative values

Quantity to Order takes on the value required to cover the balance. The field is editable. If the balance has a positive value or equals zero, then the quantity to order will be zero.

Subtotal Price is retrieved from the last up-to-date and active purchase price list.

Value is the product of price and quantity to order.

Note
f currency of the price retrieved from a purchase price list is different from system currency of a company, a recalculation is made according the default exchange rate type for that company by the recently available value of the exchange rate.

A list of items can be narrowed down through selecting in field Items, located immediately below the list, one of the following options:

  • All – default value; it displays all items regardless of the assumed values
  • All with non-zero subitems – it shows items which assume value other than zero in particular columns
  • All with balance less than zero – it displays items whose balance assumes a negative value

Czy ten artykuł był pomocny?

Wyślij opnie