Knowledge Base

Stock Settings

  • 112views
  • February 7, 2024

Stock Settings

You can set default settings for your stock-related transactions from the Stock Settings page.

1. Item Naming By 

By default, the Item Name corresponds to the Item Code provided. If you prefer Items to be named according to a predefined Naming Series, select the ‘Naming Series‘ option.

2. Defaults

2.1 Default Item Group

This will serve as the default item group assigned to a newly created item. Item groups are valuable for categorization and establishing properties for the entire group.

2.2 Default Stock UOM

The default unit of measure for stock is set as numbers (Nos), it can be changed from here.

2.3 Default Warehouse

Establish the default Warehouse for stock transactions. This setting will be retrieved and assigned to the Default Warehouse field in the Item master.

2.4 Sample Retention Warehouse

This is the Warehouse where sample retentions are stored.

2.5 Default Valuation method

FIFO, which stands for First In, First Out, or the moving average valuation method for your items, is available. The default method is FIFO. If you opt for Moving Average, new items will be valued based on the moving average. You can adjust this when creating new items in the Item form. However, once the item is saved, the Valuation Method cannot be modified.

3. Limit Percent

This represents the permissible percentage by which you can receive or deliver beyond the ordered quantity. For instance, if you’ve ordered 100 units and the supplier delivers 120 units, with the percentage set at 10%, you are permitted to receive 110 units. By default, this value is set to 0%.

4. Role Allowed to Over Deliver/Receive

Users assigned this role have permission to exceed the specified allowance percentage for delivering or receiving orders.

5. Show Barcode Field

A field to enter Barcode details for an item. If unticked, the field won’t be visible in the Item form.

6. Convert Item Description to Clean HTML

Typically, descriptions are copied and pasted from websites or Word/PDF files, often containing various embedded styles. This can disrupt the print view of your invoices or quotes.

To resolve this issue, you can enable “Convert Item Description to Clean HTML” in Stock Settings. This ensures that when you save the items, their descriptions will be cleaned up.

If you prefer to have control over your descriptions, views, and allow embedding any HTML, you can disable this property.

7. Auto insert

7.1 Auto insert Price List rate if missing

When enabled, this feature will automatically add an item price to the price list of an item upon its first transaction. This price will be fetched from the ‘Rate’ specified in the initial transaction involving the item. The relevant price list depends on whether it’s a purchase or sales transaction.

It’s important to note that the item price will only be automatically added during the first transaction if it’s not already present.

If this option is unchecked, the ‘Standard Selling Rate’ set for the item during its creation will be used as the item price.

7.2 Automatically Set Serial Nos based on FIFO

Serial numbers for stock will be automatically assigned based on the items entered, following a first-in, first-out (FIFO) approach. These serial numbers will be automatically generated in transactions such as Purchase/Sales Invoices, Delivery Notes, etc.

8. Allow Negative Stock

Enabling this option permits stock items to be shown with negative values. Its usage depends on your specific scenario. For instance, if stock transaction entries are made during weekends or at month-end, enabling negative stock is necessary to facilitate continued purchase/sales transaction entries.

Alternatively, rather than enabling negative stock universally, you can opt to enable it for individual items based on your requirements.

9. Set Qty in Transactions based on Serial No Input

The quantity of items will be set according to the serial numbers. For example, if the user has added serial nos like A001, A002, and A003 then the system will set the quantity as 3 in the transaction.

10. Automatic Material Request

10.1 Raise Material Request when the stock reaches re-order level

This option is useful if you want to ensure a constant supply of raw materials/products and avoid shortage. A Material Request will be raised automatically when stock reached the re-order level defined in the Item form.

10.2 Notify by Email on the creation of automatic Material Request

An email will be sent to notify the User with the role ‘Purchase Manager’ when an automatic Material Request is created.

11. Inter Warehouse Transfer Settings

11.1 Enable customer warehouse for material transfer from Delivery Note and Sales Invoice

This option proves beneficial when presenting material transfers as Delivery Notes. For instance, if statutory requirements mandate the application of taxes on each material transfer, it’s more manageable within a transaction like a Delivery Note rather than in a Stock Entry.

11.2 Enable supplier warehouse for material transfer from Purchase Receipt and Purchase Invoice

Similar to above option this option is useful when material transfer needs to be presented as Purchase Receipt.

To know more about inter warehouse material transfer via Delivery Note and Purchase Invoice please refer this article Material Transfer From Delivery Note

12. Freeze Stock Entries

The user will be restricted from making stock postings beyond this specified date.

  • Stock Frozen Up to: A threshold date until which stocks will remain frozen.
  • Freeze Stocks Older Than [Days]: Stocks older than a certain number of days will be frozen. This is determined based on the item’s creation date.
  • Role Allowed to Edit Frozen Stock: The chosen role here will have permission to edit frozen stock.

13. Batch identification

Global setting for batches of stocks to be identified by a Naming Series. You can override this in the Item DocType.

14. Allow to Edit Stock Quantity

Enable “Allow to Edit Stock UOM Qty for Sales Documents / Allow to Edit Stock UOM Qty for Purchase Documents” in the stock settings.

Why to Edit Stock Qty / Qty as Per Stock UOM

If you’re using multi-uom and your stock uom is a whole number, then you might face the issue that the Stock UOM should be non-decimal. Users experience this problem when they are unable to set an accurate conversion factor..

Solution

User will set the Stock Quantity and system will calculate the conversion factor