Stock balance processings

The following processings are available from the Stock balance table.

Correct stock balances

This processing is used to correct stock balances for selected rows after stock count, and update shipments and product transactions.

When the processing is executed, a check is made if you have selected the During stock take field under Stock balance status in the Stock balance table. If so, there will be no processing of the stock levels of the shipment.

Note:
The Correct stock balances processing in the Stock balance table requires that the Stock balance row is Transfer to stock count. It is not possible to run the Correct stock balances processing from the Stock balance table if you have chosen to base stock count on locations.

The processing performs the following operations:

  • The Countable quantity field is cleared.
  • The stock is set equal to Counted quantity, and the Count difference field is cleared.
  • The values in the Counted quantity, Count date and Counted by fields are transferred to Prev. counted quantity, Prev. count date and Prev. counted by fields, so that the fields are ready for the next stock take.
  • Shipments and product transactions are updated. In the event of a reduction in stock, the count difference will be taken from the shipments in the default FIFO order, and in the event of an increase, new shipments will be added with a cost price equal to the average cost price for the product in the warehouse. For the transactions, the Transaction type is set to 4 - Adjustment/internal issue with a negative quantity field if the stock increases and the shipments are given the Normal supplier and Normal location from the Stock balance table.
  • The Trans. date is set to the present date, and the Cost currency no. is set equal to the default currency specified in the Company information table. Information on the transactions from the shipments and products is also provided.
  • If there is not a sufficient quantity of available units when you try to reduce the stock balance, which means thatPhysical stock minus Counted quantity is greater than Available stock, you will see a message stating that the stock cannot be reduced because of reservations. You will also see how many stock balances this relates to.
  • The values in the Counted quantity, Count date and Counted by fields remain in these rows so that you can see by how much the stock balance is to be corrected in the Count difference field. If you want to reduce the stock levels further, you must cancel reservations.

Starting the processing

  1. Select the Stock balance rows you want to process.
  2. In the Processing menu, select Correct stock balances.

The rows/products you have selected are now final, and you can enter for example orders and invoices again for these products.

Inside lead time

This processing is used to calculate the quantities "in order" inside the lead time, and converts fields that display stock levels inside and outside the lead time.

The system also takes into account which order type is saved, and does not process orders with order type 5 - Quotation/Inquiry.

The fields are updated continuously as you save the order. However, the items that fall within the lead time change every day, so if you use these fields, you must run this processing for each new date Business NXT is in use. The fields are also converted when you use the Regenerate stock balance processing.

When you save order lines that have been changed or deleted, it is a precondition that this processing has been run on that day. Each individual order line previously contributed to increase or decrease inside and outside the lead time is calculated. This is done on the basis of the values contained in the Delivery date or Arrival/departure date and Total lead time fields when they were loaded.

Starting the processing

  1. Select the Stock balance rows you want to process.
  2. In the Processing menu, select Inside lead time.
  3. Today’s date is suggested in the From date field.

Regenerate stock balance

This processing regenerates values in the Stock balance, Stock change and Shipment tables on the basis of the Product transaction, Order line and Reservation tables.

Starting the processing

  1. Select the Stock balance rows you want to process.
  2. In the Processing menu, select Regenerate stock balance.
  3. Make settings in the dialog.
Option Description
Read Product transaction Uses the product transaction as the basis for regenerating the stock balance and/or shipment.
Read Order line Uses the order line as the basis for regenerating the stock balance and/or stock change.
Read Reservation Uses the reservation as the basis for regenerating the stock balance and/or shipment.
Rebuild Stock balance Rebuilds the stock balance.
Rebuild Stock change Rebuilds the stock change.
Rebuild Shipment Rebuilds the shipment.

Transfer to stock count

The Transfer to stock count processing sets the selected posts to status During stock take.

During a physical count of the inventory levels, the stock needs to be locked in the system in order to avoid transactions during the count. Using this processing locks the selected rows for any further processing.

The processing performs the following operations:

  • The Countable quantity field is set equal to Physical stock minus Finished quantity not yet realised in the decrease order lines (unrealised stock reduction).
  • The Count difference field appears as the difference between the Counted quantity (which you have entered) and the Countable quantity (which Business NXT has calculated).
  • The During stock take selection is checked in a dialog box belonging to the Stock balance status and Shipment status fields.
  • When processing an order, there will be no reservation made to shipments that are undergoing stocktaking (the reservation will take place during saving, picking or finishing).

Starting the processing

  1. Select the Stock balance rows you want to process.
  2. In the Processing menu, select Transfer to stock count.
  3. The date you enter for Value date updates the Count date field.

These products are now labelled as being part of the stock take and you will not be able to enter orders, invoice, etc. for these products until they have been counted. This means until you have entered the Counted quantity and run the Correct stock balances processing.

Withdraw reservations

This processing withdraws reservations that have not been picked. In addition to the Stock balance row, the Order line, Reservation and Shipment tables are also updated.

You can, for example, use the processing in connection with stocktaking to increase the available quantity before using the Correct stock balances processing, when the available quantity is less than the reduction (the negative count difference.) The only rows withdrawn are those reserved during the saving routine or those entered manually. Reservations that have been picked or finished are not withdrawn.

Note:
The processing skips stock balance rows and orders that are locked. Shipment rows are locked when the corresponding Stock balance rows are locked. Order line and Reservation lines are locked when the order is locked.

Starting the processing

  1. Select the Stock balance rows you want to process.
  2. In the Processing menu, select Withdraw reservations.

This processing will not withdraw invoiced lines with Transaction type 2 - Hire or 3 - Loan.