User Manual: Special Closing Balance

1. Overview

The Special Closing Balance module allows users to record and reconcile stock quantities at specific times. It supports stock quantity adjustments and automatic stock entries, ensuring accurate inventory records.


2. Key Features

  • Fetch items from warehouse stock.
  • Auto-calculate stock differences.
  • Create stock entries (Material Receipt or Manufacture).
  • Supports BOM-based manufacturing for quantity adjustments.
  • Track stock balance at submission.
  • Integrated with CSF TZ Settings.

3. Pre-Requisites

  • Valid Warehouse and Company created.
  • Items must be stock items, with default warehouse set per item.
  • For manufacturing, BOM must be active, default, and submitted.
  • User must have appropriate Stock User/Manager permissions.

4. Step-by-Step Usage

  1. Create New Record under Special Closing Balance.
  2. Select Company, Posting Date/Time, and Warehouse.
  3. Click Fetch Items from Warehouse.
  4. System will populate stock items and current balances.
  5. Enter actual Quantity observed.
  6. Submit the document:
    • System creates Stock Entry for adjustments.
    • If manufacturing is enabled, Manufacture Entry is created.
  7. View linked Stock Entry in the document.

5. Script Customizations

  • JS Custom Button: Triggers get_items method to fetch stock data.
  • Python Submit Logic: Validates quantity, fetches BOM, and creates Stock Entry.
  • Warehouse Query: Filters warehouses by selected company.
  • Child Table: Special Closing Balance Detail captures item, UOM, quantity, and stock balance.

6. Troubleshooting (Common Errors and Resolutions)

Error Cause Resolution
Default active BOM not found No default BOM for item Create/activate BOM for item
Stock Entry Creation Failed Data inconsistency or missing fields Review quantity and item setup
No items fetched Default warehouse not matching Set correct default warehouse in item master

7. User Roles and Permissions

Role Permissions
System Manager Full Access
Stock Manager Full Access
Stock User Read, Write, Submit

8. Key Notes

  • Non-stock items, serial/batch items are excluded.
  • Ensure CSF TZ Settings are correctly configured.
  • Stock difference = Entered Quantity - Current Balance.
  • Generated Stock Entries are traceable via link field.
Discard
Save
Was this article helpful?

On this page

Review Changes ← Back to Content
Message Status Space Raised By Last update on