Inventory Dimension

Introduction

Inventory dimensions in iVendNext are used to track an inventory with multiple parameters. By default, iVendNext allows to track an inventory using warehouses, batches, and serial numbers. If users want to track inventory with custom parameters then they can configure it using the Inventory Dimension feature. The user gets an option to select the Inventory Dimension on respective inventory documents as well in the stock ledger and stock balance report. With this feature, you can view dimension-wise stock ledger and stock balance reports.

Access Inventory Dimension

To access the Inventory Dimension list, go to: Home > Stock.

Then under the Settings Section click on the Inventory Dimension shortcut. That should take you to the Inventory Dimension List View Screen.

Click on the Add Inventory Dimension button. That should take you to the New Inventory Dimension Creation screen. Fill in the required information including the mandatory fields and then click the Save button to create an Inventory Dimension.

The New Inventory Dimension Creation screen is split into the following tabs:

Details
Applicable For

A screenshot of the Details Tab is pasted below:

A screenshot of the Applicable For Tab is pasted below:

Fill in the required information including the mandatory fields and then click the Save button to create an Inventory Dimension.

Create Inventory Dimension

Create a new record and select the Reference Document which you want to use as a custom Inventory Dimension.

New Inventory Dimension - Shelf

You can select any non-child document in the reference document.

Next, the user has to put the dimension name against which the system will create a custom link field in the Applicable Documents.

Applicable For Documents

You can apply the Inventory Dimension to all the inventory documents or to a specific document.

Apply to All Inventory Documents

It will be used to select the custom Dimension in the inventory-related documents.

For example, the user has created Inventory Dimension with the name "Shelf" and enabled "Apply to All Inventory Document Types". Then the system will create a custom link field with the name "Shelf" in the inventory documents where Batch No and Serial No fields exist.

Apply to Specific Document

If the user wants to add Inventory Dimension to a specific document then they have to disable the checkbox "Apply to All Inventory Document Types" and select the respective document in the "Applicable to Document" field.

Also if you want to add Inventory Dimension for a specific condition like for stock entry type Issue you want separate dimension as "From Shelf" and stock entry type Material Receipt you want separate dimension as "To Shelf" then that can be possible using "Applicable Condition"

Applicable Condition only can be visible if "Apply to All Inventory Document Types" is disabled

You can also use the "Type of Transaction" with options such as Inward or Outward for a condition.

Use of Inventory Dimension

Once the Inventory Dimension is created system will create the custom field in respective documents

The user gets an option to select the Inventory Dimension in the respective transaction.

For example, if the user has added Inventory Dimension as "Shelf" in the Stock Entry Detail document. Then in the stock entry, the child table user gets an option to select a shelf (see above image). Post submission of the stock entry system will create the stock ledgers with selected inventory dimensions.

Validate Negative Stock

If the user has enabled the "Validate Negative Stock" checkbox in the inventory dimension, the system will not allow to make stock transactions if the respective dimension has negative stock in the respective warehouse. If a user tries to create the stock transaction with negative stock for the inventory dimension then the system will throw an error.

Stock Balance and Stock Ledger Report

Users can able to filter the Stock Balance and Stock Ledger report using Inventory Dimension

With this feature, users can able to see Inventory Dimension wise available quantity

Users can only use the stock reconciliation with inventory dimensions to enter opening values and they can't use the stock reconciliation to modify the available stock or the valuation. Since we are not maintaining inventory dimensions wise valuation rate there is no sense to modify valuation rate through stock reconciliation. in case if they tried to update the quantity or valuation rate through stock reconciliation, the system will throw an error.