1.) Enable Multiple Stock Locations and Warehouses

Activating this option allows users to manage multiple warehouses and stock locations within the same database.

Navigation : Settings → Users & companies → User

2.) Enable Warehouse Average Costing

Warehouse-wise average costing is enabled from user settings to activate warehouse-specific cost calculations.

3.) Assign Accounting Features to User

Accounting permissions are assigned to the responsible user to ensure full access to costing, valuation, and financial entries.

4.) Create Multiple Warehouses for Average Costing

Multiple warehouses are created to manage stock and product costs independently.

5.) Set Product Category Costing Method

The product category is configured with the Average Cost (AVCO) method and Automated Inventory Valuation.

6.) Create a Storable Product

A storable product is created to enable inventory tracking and costing features. Only storable products support warehouse-wise cost calculations and inventory valuation.

7.) Warehouse-Wise Costing Tab in Product

The product form includes a dedicated Warehouse-wise Costing tab.

8.) Purchase Product for Different Warehouses

Purchase orders are created for different warehouses with varying quantities

9.) Warehouse-Wise On-Hand Quantity and Cost

The warehouse-wise costing tab reflects updated on-hand quantities and average costs after purchases.

10.) Add Landed Cost to Purchased Product

Additional expenses such as freight or service charges are added as landed costs.

11.) Updated Cost Price After Landed Cost

After applying landed costs, the product average cost is recalculated automatically.

12.) Create Sale Order for Product

A sale order is created for the product, allowing stock to be delivered from a selected warehouse.

13.) Select Warehouse in Sale Order

The warehouse selection in the sale order ensures that stock, cost, and valuation are deducted from the correct location.

14.) Invoice and Journal Entries for Sale Order

An invoice is generated for the sale order, and the corresponding journal entries are created automatically.

15.) Journal Entries After Product Delivery

Once delivery is completed, inventory valuation and accounting entries are updated

16.) Product Costing Table Before and After Sales

The product costing table provides a clear comparison of costs and quantities before and after the sales order.

17.) Purchase Same Product at Different Price

A new purchase order is created for the same product with a different price.

18.) Updated Cost After Incoming Shipment

After validating the incoming shipment, the warehouse-wise cost and on-hand quantity are recalculated.

19.) Inventory Valuation by Date and Warehouse

Inventory valuation can be reviewed by selecting a specific warehouse and date range.

20.) Valuation Report for Selected Warehouse

A detailed valuation report is generated for the chosen warehouse.

21.) Stock Valuation for Another Warehouse

Switching the warehouse filter allows users to compare inventory valuation across different warehouses.

22.) Warehouse Costing Table Before Internal Transfer

Before performing an internal transfer, the warehouse-wise costing table shows the current quantity and average cost for each warehouse.

23.) Internal Transfer Between Warehouses

Stock is transferred from one warehouse to another while maintaining accurate cost allocation.

24.) Updated Quantity and Cost After Transfer

After the internal transfer, both warehouses reflect updated on-hand quantities and average costs.

25.) Warehouse Selection in Revaluation Wizard

The revaluation wizard allows users to select a specific warehouse for cost adjustments.

26.) Manual Inventory Valuation Adjustment

Manual valuation adjustments update the total inventory value based on business requirements.

27.) Product Cost Update During Adjustment

During stock or valuation adjustments, the product form updates the on-hand quantity and average cost in real time.

28.) Stock Adjustment in Specific Warehouse

Stock adjustments are performed for a selected warehouse to correct inventory levels.

29.) Updated Quantity and Cost After Stock Adjustment

After completing the stock adjustment, the warehouse-wise costing tab reflects the corrected on-hand quantity and updated average cost, keeping inventory and accounting data aligned.