Inventory Integration in Dash SaaS

Introduction

The Inventory Add-On allows businesses to efficiently manage their stock levels, track inventory movements, and calculate costs of goods sold (COGS) using various valuation methods like FIFO, LIFO, and Weighted Average. By enabling inventory tracking, users can set reorder and maximum stock levels, upload product images, and perform adjustments such as increases, decreases, or recounts. Detailed reports, including stock valuation, COGS, and stock movement, provide insights into inventory performance across different warehouses, helping users make informed decisions about stock management. With intuitive features like filtering, searching, and visual charts, businesses can streamline their inventory operations and maintain accurate, up-to-date records.

How to Install the Add-On?

To Set Up the Agriculture Management Add-On, you can follow this link: Setup Add-On

Note: This Add-On is dependent on the Project Add-On, so you need to purchase it first.

How to use the Inventory Add-On?

Inventory Items

• To access the inventory fields, navigate to the Product & Service Add-On from the main menu. Once there, select the Item page and click the Create Item button to open the item creation form.
• The inventory-related fields shown in the form are only visible when the Inventory Add-On is enabled. If the Inventory Add-On is not enabled, these fields will not appear in the form.
• In the form, you can upload a Product Image by clicking the Browse button and selecting an image file. For Additional Images, click the Browse button to select and upload multiple product images.
• Set your inventory levels by entering the Reorder Level (the minimum quantity that triggers reordering) and Maximum Level (the maximum quantity to maintain in stock).
• Choose your Valuation Method from the dropdown menu, which includes options for FIFO, LIFO, and Weighted Average.
• Enable the Track Inventory checkbox if you want to track this item in your inventory system, or leave it unchecked if tracking is not required.
• After filling in all the necessary information, click the Update button to save the item. Once the item is created and saved, it will appear as an entry in the Inventory Items section, where you can view and manage it.
• The list page displays all products in a table with columns for Product, SKU, Reorder Level, Maximum Level, Valuation Method, Tracked, and Actions.
• Use the search button to find the specific inventory record. Click the Filters button to access filtering options, including selecting Valuation Method from the dropdown (options include FIFO, LIFO, and Weighted Average) and choosing Tracked from the dropdown (options include Yes and No). Click the Apply button to filter the data or the Clear button to reset the filters.
• You can use the toggle between list view and grid view. Available actions: You can use the view to see the product details.

Inventory Adjustments

• To create a new adjustment, click the “Create” button at the top of the inventory adjustments page.
• Fill in the Adjustment Details section by selecting the Adjustment Date, choosing a Warehouse from the dropdown menu, and selecting the Adjustment Type from the dropdown (options include Increase, Decrease, and Recount). At the end, enter the reason.
• In the Adjustment Items section, select an Inventory Item from the dropdown menu. The Current Quantity field displays the existing stock level for the selected item.
• Enter the Quantity you are adjusting, and the system will automatically display the Adjusted Quantity based on your entry. At the end add the note.
• Click the Add Item button to include additional items in the same adjustment if needed.
• The list page displays all adjustments in a table with columns that include Adjustment Number, Date, Warehouse, Type, Status, and Actions. Use the search function to find the specific adjustments record.
• Click the Filters button to access filtering options, including selecting Type from the dropdown and choosing Status from the dropdown. Click the Apply button to filter the data or the Clear button to reset the filters.
• Click the Filters button to access filtering options, including selecting Type from the dropdown (options include Increase, Decrease, and Recount) and choosing Status from the dropdown (options include Draft, Approved, and Posted). Click the Apply button to filter the data or the Clear button to reset the filters.
• In the action column, you can use the action option like approve (clicking on this will make the status in Approved), view (clicking on this to see the inventory adjustment details), and delete (clicking on this to remove the existing data).
• After clicking the Approve option, the system displays the post action and hides the Approve option; clicking Post will update the stock levels in the system and change the status to Posted.
• When you post a sales invoice, the system automatically calculates Cost of Goods Sold (COGS) based on the selected valuation method, creates COGS history records, reduces available stock quantities, and updates inventory valuation accordingly.

Automated Stock Valuation and COGS Handling

• When you post a purchase invoice, the system automatically creates cost layers for tracked inventory items, records the purchase date, quantity, and unit cost, updates available stock quantities, and maintains cost history for accurate valuation.
• When you post a sales invoice, the system calculates Cost of Goods Sold (COGS) based on your selected valuation method, creates COGS history records, reduces available stock quantities, and updates inventory valuation accordingly.

Stock Valuation Report

• On the Manage Stock Valuation Report page, you can view complete inventory valuation data across your warehouses. The page displays key metrics, including Total Value, Total Items, and Total Quantity in summary cards at the top.
• Use the Warehouse filter dropdown to select a specific warehouse or choose “All Warehouses” to view consolidated data. Click the Apply button to update the report or the Clear button to reset the filter.
• The Valuation by Method chart displays a visual breakdown of your inventory valuation methods, showing the distribution between FIFO, LIFO, and Weighted Average methods used across your inventory items.
• The Low Stock Items section alerts you to items that have fallen below their reorder level. When all items are above the reorder threshold, the section displays “No low stock items” with the message “All items are above reorder level.”
• The Valuation by Warehouse chart provides a bar graph showing the inventory value distributed across different warehouse locations, allowing you to compare stock values by location at a glance.

COGS Report

• On the Manage COGS Report page, you can analyze Cost of Goods Sold (COGS) data to gain profitability insights by product and track historical cost trends. The page displays key metrics, including Total COGS, Total Quantity Sold, and Avg Unit Cost in summary cards at the top.
• Use the Date Range filter to select a specific time period, and choose a Warehouse from the dropdown to filter by location or select “All Warehouses” for consolidated data. Click the Apply button to update the report or the Clear button to reset the filters.
• The Monthly COGS Trend chart displays a line graph showing your cost of goods sold over time, allowing you to track historical cost trends and identify patterns across months from January through December.
• The Top 10 Items by COGS section ranks your inventory items by their cost of goods sold, helping you identify which products have the highest costs and analyze profitability by product. When no data is available, the section displays “No data found.”
• The Recent COGS Transactions section shows the latest cost of goods sold transactions, providing visibility into recent inventory movements and their associated costs. When no transactions exist, the section displays “No COGS transactions.”

Stock Movement Report

• On the Manage Stock Movement Report page, you can track all inventory transactions and monitor increases, decreases, and current balances across your warehouses. The page displays key metrics, including Total In, Total Out, and Net Movement in summary cards at the top.
• Use the Date Range filter to select a specific time period, and choose a Warehouse from the dropdown to filter by location or select “All Warehouses” for consolidated data. Click the Apply button to update the report or the Clear button to reset the filters.
• The Movement by Type chart displays a bar graph comparing Purchase (IN) transactions against Sales (OUT) transactions, giving you a clear view of inventory inflow and outflow by transaction type.
• The Monthly Movement Trend chart shows a line graph tracking both “In” and “Out” movements over time, allowing you to identify patterns and trends in your inventory transactions across months from February through December.
• The Recent Movements section displays the latest inventory transactions, providing real-time visibility into stock changes. When no recent activity exists, the section displays “No recent movements.”