Financial Position Controller Documentation

File: /controllers/FinancialPositionController.php

Purpose: Provides comprehensive financial position analysis and real-time balance sheet reporting

Last Updated: December 19, 2024

Total Functions: 21

Lines of Code: 696

---

📋 Overview

The Financial Position Controller provides real-time financial position analysis and comprehensive balance sheet reporting for the ERP system. It handles:

• Current assets and liabilities calculation
• Fixed assets valuation and tracking
• Property rights and equity analysis
• Real-time profit calculations
• Cash flow position monitoring
• Debt analysis (clients and suppliers)
• Check values tracking
• Capital and partner investment tracking
• Bills of exchange (Kempiala) management
• Multi-currency support for financial reporting

Primary Functions

✅ Calculate current assets and liabilities
✅ Track fixed assets and depreciation
✅ Monitor cash flow positions
✅ Analyze profit and loss in real-time
✅ Track client and supplier debts
✅ Calculate property rights and equity
✅ Monitor bills of exchange
✅ Support multiple inventory valuation methods
✅ Handle multi-currency financial data
✅ Generate comprehensive financial statements

Related Controllers

• balancereportController.php - Historical balance reports
• FaidaController.php - Profit analysis
• sellbillController.php - Revenue generation
• buyBillController.php - Cost analysis
• storereportController.php - Inventory valuation
• clientController.php - Customer debt tracking
• supplierController.php - Supplier debt tracking
• expenseController.php - Operating expenses

---

🗄️ Database Tables

Asset Tables

Table Name	Purpose	Key Columns
`storedetail`	Inventory assets	storedetailid, productid, productquantity, storeid
`product`	Product pricing	productId, productBuyPrice, lastbuyprice, meanbuyprice, overAllAveragePrice
`assets`	Fixed assets	assetsid, assetvalue, assetsdate, assetscatid
`productserial`	Serial number inventory	id, buybilldetailid, don, del
`sizecolorstoredetail`	Size/color inventory	id, productid, quantity, storeid, sizeid, colorid

### Financial Tables

Table Name	Purpose	Key Columns
`bankaccount`	Bank balances	bankaccountid, accountbeginingbalance, bankaccountbalance
`save`	Petty cash accounts	saveid, savecurrentvalue, savecurrentvalueInMainCurrency
`capital`	Company capital	capitalid, capitalamount, capitaldate
`partner`	Partner investments	partnerid, partnermoney, conditions

### Debt & Receivables Tables

Table Name	Purpose	Key Columns
`client`	Customer debts	clientid, clientname, clientdebt
`supplier`	Supplier debts	supplierid, suppliername, suppliercurrentDebt
`kempiala`	Bills of exchange	kempialaId, kempialaValue, kempialadate, kempialaisselling
`datedchecked`	Check tracking	id, checkValue, checktype, checkdate

### Configuration Tables

Table Name	Purpose	Key Columns
`programsettings`	System settings	id, Inventoryevaluation, currency_settings
`buybilldetail`	Purchase details	buybilldetailid, buybilldetailprice, payedtax
`buybill`	Purchase headers	buybillid, buybilldate, conditions

---

🔧 Key Functions

Core Financial Position Functions

Main Financial Position Display (Lines 189-277)

Purpose: Generates complete financial position statement with all components

Process Flow:

┌─ Load Settings ────┐

Get evaluation

Current + Fixed

Current debts

Capital + Profits

└─ Display Report ──┘

Asset Calculation Functions

`totalproduct()` (Lines 453-545)

Purpose: Calculates total inventory value using configured evaluation method

Returns: Total inventory value based on system settings

Inventory Evaluation Methods:

switch ($Programsetting->Inventoryevaluation) {
    case "first": $buyprice = (float) $storedata->productBuyPrice; break;
    case "last": $buyprice = (float) $storedata->lastbuyprice; break;
    case "mean": $buyprice = (float) $storedata->meanbuyprice; break;
    case "last_discount": $buyprice = (float) $storedata->lastbuyprice_withDiscount; break;
    case "mean_discount": $buyprice = (float) $storedata->meanbuyprice_withDiscount; break;
    case "generalPrice": $buyprice = (float) $storedata->overAllAveragePrice; break;
}

Size/Color Inventory Handling:

if($storedata->hasSizeAndColor == 1) {
    $scquantity = R::getCell('select sum(quantity) from sizecolorstoredetail where productid = '.$storedata->productid);
    $quantity = $scquantity;
} else {
    $quantity = $storedata->productquantity;
}

`productserialvalue()` (Lines 286-293)

Purpose: Calculates inventory value based on serial numbers for specific products

Returns: Total value of serialized inventory including taxes

Calculation Formula:

SELECT sum((buybilldetailprice * don) + ((buybilldetailprice * don * payedtax) / 100))
FROM productserial
LEFT JOIN buybilldetail ON buybilldetail.buybilldetailid = productserial.buybilldetailid
WHERE productserial.don > 0 AND productserial.del = 0

`calculateFixedassets()` (Lines 651-663)

Purpose: Calculates total fixed assets value

Returns: Sum of all fixed assets grouped by category

`Currentassets()` (Lines 678-695)

Purpose: Calculates total current assets

Components:

• Bank account balances
• Client debt (receivables)
• Inventory value
• Petty cash (saves)
• Collection items (checks + bills of exchange)
• Serialized product value

Formula:

$totalCurrentassets = $totalaccount + $totalclientdebt + $totalcollection + $totalprice + $savevaluex;

Cash & Bank Functions

`Bankaccount()` (Lines 296-305)

Purpose: Calculates total bank account balances

Returns: Sum of all bank account beginning balances

`savevalue()` (Lines 548-560)

Purpose: Calculates total petty cash value with multi-currency support

Returns: Total save value in main currency

Multi-Currency Support:

foreach ($allsavedata as $savedata) {
    $savevaluex += $savedata->savecurrentvalueInMainCurrency; // Converted to main currency
}

Debt & Receivables Functions

`clientdebt()` (Lines 308-317)

Purpose: Calculates total customer debt (accounts receivable)

Returns: Sum of all client debts

`supplierdebt()` (Lines 320-329)

Purpose: Calculates total supplier debt (accounts payable)

Returns: Sum of all supplier current debts

`clientcheckvalue()` (Lines 363-375)

Purpose: Calculates value of checks received from clients

Returns: Total value of client checks not yet collected

`suppliercheckvalue()` (Lines 402-414)

Purpose: Calculates value of checks issued to suppliers

Returns: Total value of supplier checks not yet paid

Bills of Exchange Functions

`kempilavalue()` (Lines 332-360)

Purpose: Calculates value of active bills of exchange

Process Flow:

┌─ Get Available ────┐

Bills not expired

Bills past due

Available only

└─ Return Value ────┘

Logic:

$allavailabledata = $myKempialaEx->queryAlllavilablekempila2(0, $today);
$allexpiredata = $myKempialaEx->queryAllexpierkempila2(0, $today);
$totalkempilavalue = $totalavailablekempila; // Only available, not expired

`collection()` (Lines 665-675)

Purpose: Calculates total collection items (checks + bills of exchange)

Returns: Combined value of kempiala and client checks

Capital & Equity Functions

`allcapitalvalue()` (Lines 605-615)

Purpose: Calculates total company capital investment

Returns: Sum of all capital contributions

`partnervalue()` (Lines 377-399)

Purpose: Calculates partner investment/withdrawal balance

Returns: Net partner money using direct SQL query

Query:

SELECT sum(partnermoney) FROM partner WHERE partner.conditions = 0

`Profits()` (Lines 594-602)

Purpose: Calculates current profit/loss position

Formula:

$totalProfits = round(($forYou - $totalCurrentliabilities - $totalallmoney), 2);
// Where: forYou = Total Assets, totalCurrentliabilities = Current Liabilities, totalallmoney = Capital

`Propertyrights()` (Lines 617-624)

Purpose: Calculates total property rights (equity)

Components: Capital + Retained Earnings (Profits)

Liability Functions

`Currentliabilities()` (Lines 575-582)

Purpose: Calculates total current liabilities

Components:

• Supplier checks
• Supplier debts

Formula:

$totalCurrentliabilities = $totalsuppliercheck + $totalsupplierdebt;

Summary Functions

`totalmoneyforyou()` (Lines 564-571)

Purpose: Calculates total assets (fixed + current)

Formula: Fixed Assets + Current Assets

`totaltoyou()` (Lines 627-633)

Purpose: Calculates total liabilities + equity

Formula: Current Liabilities + Property Rights

`allmoney()` (Lines 584-591)

Purpose: Calculates total capital (company + partners)

Formula: Capital Amount + Partner Money

---

🔄 Business Logic Flow

Financial Position Analysis Process

System Start → Load Configuration → Calculate Components
     ↓
Current Assets Calculation → Fixed Assets Calculation
     ↓
Current Liabilities Calculation → Equity Calculation
     ↓
Profit/Loss Calculation → Balance Verification → Report Display

Asset Valuation Logic

│ └─ General Price

└─ Calculate Total Value

Balance Sheet Structure

├─ Cash (Bank + Save)

│ ├─ Inventory │ └─ Supplier Checks

│ ├─ Client Debt └─ Equity

├─ Client Checks

│ └─ Bills of Exchange │ ├─ Partner Money

└─ Fixed Assets │ └─ Retained Earnings

└─ Asset Categories └─ Total Equity

---

⚠️ Common Issues

Data Accuracy Issues

1. Real-time calculations: No caching may cause performance issues with large datasets

2. Currency conversion: Multi-currency support may have conversion rate delays

3. Inventory valuation: Different methods can show significant differences

Performance Considerations

1. Complex queries: Multiple table joins for real-time calculations

2. No caching: All values calculated on each request

3. Large inventory: Size/color variants require additional processing

Business Logic Warnings

1. Balance verification: No automatic balance checking between assets and liabilities

2. Date sensitivity: Some calculations are date-dependent but use current date only

3. Negative balances: No validation for negative equity or unrealistic values

---

🔗 Dependencies

Required Files

• ../public/impOpreation.php - Core operations
• ../public/include_dao.php - All DAO includes
• ../public/config.php - Database configuration
• ../public/authentication.php - User authentication
• ../library/breadcrumb.php - Navigation support

Database Dependencies

• Accurate inventory quantities and pricing
• Current debt balances for all parties
• Proper asset valuations and depreciation
• Up-to-date bank account balances
• Valid partner and capital records

External Dependencies

• RedBean ORM for direct SQL queries
• Smarty templating for financial reports
• Multi-currency conversion rates
• YouTube integration for training videos

Configuration Dependencies

• Inventory evaluation method settings
• Currency configuration for multi-currency support
• Decimal precision settings for financial calculations
• Asset category definitions

---

Financial Analysis Notes:

• Total Assets = Current Assets + Fixed Assets
• Current Ratio = Current Assets / Current Liabilities
• Debt-to-Equity = Total Liabilities / Total Equity
• Working Capital = Current Assets - Current Liabilities
• Return on Assets = Net Income / Total Assets
• Asset Turnover = Revenue / Total Assets

Key Financial Position Indicators:

• Assets must equal Liabilities + Equity
• Positive working capital indicates good liquidity
• High current ratio indicates strong financial position
• Inventory valuation method significantly impacts asset values

📚 ERP Docs

FinancialPosition Documentation

Financial Position Controller Documentation

📋 Overview

Primary Functions

Related Controllers

🗄️ Database Tables

Asset Tables

🔧 Key Functions

Core Financial Position Functions

Main Financial Position Display (Lines 189-277)

Asset Calculation Functions

totalproduct() (Lines 453-545)

productserialvalue() (Lines 286-293)

calculateFixedassets() (Lines 651-663)

Currentassets() (Lines 678-695)

Cash & Bank Functions

Bankaccount() (Lines 296-305)

savevalue() (Lines 548-560)

Debt & Receivables Functions

clientdebt() (Lines 308-317)

supplierdebt() (Lines 320-329)

clientcheckvalue() (Lines 363-375)

suppliercheckvalue() (Lines 402-414)

Bills of Exchange Functions

kempilavalue() (Lines 332-360)

collection() (Lines 665-675)

Capital & Equity Functions

allcapitalvalue() (Lines 605-615)

partnervalue() (Lines 377-399)

Profits() (Lines 594-602)

Propertyrights() (Lines 617-624)

Liability Functions

Currentliabilities() (Lines 575-582)

Summary Functions

totalmoneyforyou() (Lines 564-571)

totaltoyou() (Lines 627-633)

allmoney() (Lines 584-591)

🔄 Business Logic Flow

Financial Position Analysis Process

Asset Valuation Logic

Balance Sheet Structure

⚠️ Common Issues

Data Accuracy Issues

Performance Considerations

Business Logic Warnings

🔗 Dependencies

Required Files

Database Dependencies

External Dependencies

Configuration Dependencies

`totalproduct()` (Lines 453-545)

`productserialvalue()` (Lines 286-293)

`calculateFixedassets()` (Lines 651-663)

`Currentassets()` (Lines 678-695)

`Bankaccount()` (Lines 296-305)

`savevalue()` (Lines 548-560)

`clientdebt()` (Lines 308-317)

`supplierdebt()` (Lines 320-329)

`clientcheckvalue()` (Lines 363-375)

`suppliercheckvalue()` (Lines 402-414)

`kempilavalue()` (Lines 332-360)

`collection()` (Lines 665-675)

`allcapitalvalue()` (Lines 605-615)

`partnervalue()` (Lines 377-399)

`Profits()` (Lines 594-602)

`Propertyrights()` (Lines 617-624)

`Currentliabilities()` (Lines 575-582)

`totalmoneyforyou()` (Lines 564-571)

`totaltoyou()` (Lines 627-633)

`allmoney()` (Lines 584-591)