Knowledge Base

Inventory Dimension

  • 99views
  • February 6, 2024

Inventory Dimension

 

In BizCentric, inventory dimensions are employed to monitor inventory based on various parameters. By default, BizCentric facilitates inventory tracking using warehouses, batches, and serial numbers. However, if users wish to track inventory using custom parameters, they can configure this using the Inventory Dimension feature. This feature allows users to select the Inventory Dimension in respective inventory documents, as well as in the stock ledger and stock balance report. With this functionality, users can access dimension-specific stock ledger and stock balance reports.

To access the Inventory Dimension list, go to:

Stock > Settings > Inventory Dimension

Create Inventory Dimension

  • Generate a new entry and designate the Reference Document to be utilized as a personalized Inventory Dimension.
  • You may choose any non-child document as the reference document.
  • Subsequently, the user is required to specify the dimension name, for which the system will generate a customized link field in the Applicable Documents.

Applicable For Documents

Apply to All Inventory Documents

  • This feature will enable users to choose the custom Dimension in inventory-related documents.
  • For instance, if a user creates an Inventory Dimension named “Shelf” and enables “Apply to All Inventory Document Types,” the system will automatically generate a custom link field named “Shelf” in inventory documents where Batch No and Serial No fields are present.

Apply to Specific Document

  • If a user wishes to incorporate an Inventory Dimension into a specific document, they must deactivate the checkbox labeled “Apply to All Inventory Document Types” and designate the relevant document in the “Applicable to Document” field.
  • Furthermore, if users desire to add an Inventory Dimension for particular conditions, such as requiring separate dimensions like “From Shelf” for stock entry type Issue and “To Shelf” for stock entry type Material Receipt, they can achieve this by utilizing the “Applicable Condition” feature.
  • The “Applicable Condition” option will only be visible when “Apply to All Inventory Document Types” is disabled. Additionally, users can utilize the “Type of Transaction” parameter with choices such as Inward or Outward to specify conditions.

Use of Inventory Dimension

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

Users will then have the option to select the Inventory Dimension in the respective transactions.

For instance, if a user has included the Inventory Dimension “Shelf” in the Stock Entry Detail document, they will be presented with the choice to select a shelf in the child table of the stock entry. Following the submission of the stock entry, the system will generate the stock ledgers with the selected inventory dimensions.

Validate Negative Stock

If the user has activated the “Validate Negative Stock” checkbox in the inventory dimension, the system will prevent stock transactions from being processed if the corresponding dimensions show negative stock levels in the respective warehouse. If a user attempts to initiate a stock transaction with negative stock for the inventory dimension, the system will display the following error.

Stock Balance and Stock Ledger Report

  • Users can be able to filter the Stock Balance and Stock Ledger report using Inventory Dimension
  • With this feature, users can be able to see Inventory Dimension wise available quantity.

Stock Ledger Report

Note:

Users are solely permitted to utilize stock reconciliation with inventory dimensions for inputting opening values and are restricted from using it to adjust available stock or valuation. Given that inventory dimension-wise valuation rates are not maintained, it is illogical to permit modification of valuation rates through stock reconciliation. In the event that users attempt to update the quantity or valuation rate via stock reconciliation, the system will generate the following error.