StockM Update 2020.05.07

PTO orders (pto.csv) validity period.

PTO orders in StockM can be entered manually or received via pto.csv from accounting.

The pto order received so far in StockM could be closed only if it was removed from StockM or if the pto.csv file was not received from accounting.

Since this update, it is possible to specify the number of days of validity of the pto order „Delete after X days“. The number of days can be entered in StockM, in the PTO orders window, or uploaded via pto.csv file. After the specified number of days after the „Delivery date“, the pto order / quantity will be removed automatically or no longer included in the orders to the supplier. If the field „Delete after X days“ is empty, the order has no expiration date.

StockM Update 2020.04.30

1. New setting for calculating buffer by coefficient.

In the Periods or Inventory window when calculating the buffer according to the specified coefficient, the buffer is calculated according to the formula:  

New BUF = (BUF - MOQ) * coeff. + MOQ

Since this update, this buffer calculation method has a selection / checkbox “Take into account MOQ” that allows you to select to take into account MOQ or not:

• By default, the check mark is placed and the new buffer calculation formula remains as it was.
• If the check mark is not placed, new buffer formula is:

 New BUF = BUF * coeff.

2. Calculation of average sales for lost sales.

Lost sales are only calculated for DTA items with a balance ≤ 3% (buffer + safety buffer). It is checked how many days a week the items met this condition and the number of days obtained is multiplied by the average daily sales. Average sales are calculated at purchase prices.

Until now, average daily sales have been calculated by taking sales over a three-month period and dividing them by a number of days of 3 months without evaluating whether there was a balance in stock during these days. Average daily sales were inaccurate because there was no balance of some items in stock for the entire period. In other words, they could have counted smaller.

To make the calculation of average daily sales more accurate, after the update, they will be calculated by taking sales for a three–month period and diving them by the number of days when the balance or sales were available.

StockM Update 2020.04.23

1. Reservations by date (pto.csv).

There are 2 types of reservations in StockM: from the existing stock in the warehouse and special orders from customers (received in StockM via the pto.csv file).

Since this update, StockM immediately included received pto order in the nearest order to supplier, the date when the order had to be fulfilled was not estimated. In other words, program did not take into account the fact that the customer / buyer does not need these goods now and they can be delivered later with next orders.

Now StockM will check what delivery date of pto is. In the separate field “Activate before X d.” the number of days before the necessary delivery date can be specified, i.e. when the order must become active and can be already fulfilled. If in the field “Activate before X d.:  

• nothing is specified, the field is empty, the pto order will be processed immediately and it will be included in the nearest order to the supplier;
• 0 is entered, the goods will be ordered with the last order, which will arrive before the specified delivery date;
• certain number of days is entered, the order will become active in such a number of days before the “Delivery date” and will be included in the next order to supplier after this activation.

2. Verification by uploading data to StockM via Table L11.

When uploading data to StockM via table L11, the information was loaded only when there were no errors. If the program found errors, the information was not loaded. A list of items was displayed to the user and errors had to be corrected.

Since this update, information will be loaded from those rows that do not contain errors, and a list of errors will be shown to the user (errors can be exported to excel as before). Once the errors are corrected, the data will have to be uploaded for specified rows once again by entering information into a new / separate L11 table template.

3. New filtering operator in StockM windows.

An additional text field filtering operator has been added to StockM. It allows to specify / enter several values via a semicolon.

StockM Update 2020.04.09

1. Combining of items into a group of alternative (ALT) items.

Until now, when combining items into the ALT product group, the main item had to be in all active warehouses, and the ALT product was not necessarily present.

This situation created problems in the distribution of items from the central warehouse to the branches. When it was necessary to order a product from a central warehouse, an ALT product was offered to be transported to the branch if there was a sufficient ALT product balance in the center and it was not checked that the branch does not sell the ALT product.

Since this update, the main and alternative items’ codes must be in all storage locations to combine ALT items.

A warning has been made in the confirmation window of combining when saving settings that both main and alternative items will be distributed through the warehouses. Distribution takes place through all warehouses containing at least one product involved in the ALT combination. The message after combining of items will show how many new items (SKU) cards have been created through the warehouses.

     2. New setting in SM Admin “Divide product order amount”.

If orders for the supplier are formed frequently, but the delivery / delivery time is long, there is no need to order the entire buffer immediately with the first orders. It is possible to create several orders in one delivery time and thus reduce the amount of ordered goods. In other words, “fill the buffer” not immediately, but in several deliveries (divide the ordered quantity of one item in time over several orders).

After the update, it is possible to enable the setting so that in case of frequent but long deliveries, the entire buffer would not be ordered at once in one order. If at least 2 regular orders can be formed during the delivery time, then a maximum limit is applied to the ordered quantity, which is calculated according to the ratio of delivery frequency and duration and buffer. The maximum quantity also includes a PTO and a reservation so that ordered quantity was not restricted for special needs.

Important: The possibility to use this function has to be agreed separately and setting of this function works company-wide. If necessary, contact the project manager.

StockM update 2020.02.06

Order formation several times a day.

The orders are formed by StockM system once a day.  They are only formed if the data are renewed on that date before the order's formation.

Since this update, there is an option to form orders according to the time set in the 'Suppliers schedule '(data before order formation must be renewed). You can see the "Time" column in the 'Suppliers schedule ' to indicate the order formation time. The time is chosen from a list that is specified in SM Admin.

Important: usage of this function is agreed separately and is set for a whole company. If needed, contact the project manager.