TAAS

GUI CHANGES
------------

-> Supplier/FOP - Check Refund Master Client - Need Check section, Card Section etc...
-> Add Supplier after Supplier/FOP, If Supplier/FOP == CASH Mode
-> Add 'Warranty Expair' Datebox in popup before 'Amount In INR *'

GUI CHANGES
---------------

-> Pupup
- Rename 'Warranty Expires' to 'Warranty Expire'
- Add 'Tax Expire' datebox After Warranty Expires
- Add 'Insurance Expire' datebox
- Add 'Next Service' datebox
- Add 'Service Phone' Textbox
- Add 'Item Code' entrybox before Sequence Code
- Purchase Date*(Blue) - Title= Actual Purchase Date(Assets Import Case) -> Need Checkbox-Title=Imported Assets(Purchase Date Madatory)
- Deduction and Extra Pay Checkbox and need(like payment, but tick allowed both at a time)
- Add 'A Asset Value*(Blue):0.00'(Title=The value take Depreciation) before 'Total Amount'
- Add 'Total Asset Value:0.00'
- Add 'A Asset Expense:0.00'
- Add 'Total Asset Expense:0.00'
- Remove 'Total Amount'
- Add 'Total Depreciation' Textbox(Disable) after before 'VAT In QAR'
- Add 'Last Depreciation Date' Datebox(Disable)
- Add 'Discount, Extrapayment'(Select label) entrrybox in master section after 'Reference'
- Add Tittle on Sequence Code (Code will be used to generate unique code to identify item)
- Add 'Posting Status: No Posting(Assets Imported)' in master section

GUI Change

-> Add 'Current Assets Status' label in popup item tab -> label grid/list/table last
-> Move 'Last Depreciation Date' to  (popup item tab) label grid/list/table last
-> move 'Total Depreciation' to  (popup item tab) label grid/list/table last
- Add 'Current A Assets Value'(Next Depreciation base value - title) in (popup item tab) label grid/list/table last() after 'Total Depreciation'
- Add 'Current Branch', 'Current Department' popup item tab) label grid/list/table last
-> add 'Current Assets Status' column List(Last)
-> Popup-> Purchase Date -> Checkbox title -> 'Tick means imported/Old asset, So purchase date allowed to change, otherwise take master date and Disable'
-> 'Depreciation %' inputbox with checkbox(Title->Tick means change the Depreciation %, Otherwise take Assets Master) after 'Depre. Start Date' 
-> Add 'Enter a Unit Amount' checkbox - Default off before 'Amount In' (Unit > 1 otherwise hide)
-> Add 'VAT In INR' after 'Amount In INR'
- 'VAT In' Need blue star and Titile:- 'Posting or not based on Admin setting otherwise Just know the Tax Amount, No other use'
- Add a checkbox(First in VAT In... entrybox - Grouping also) - Title:-Tick Means Inclusive Tax, Default Tick
-> Add drop down label('Depreciation Done on Assets Value' and 'Depreciation Done on Assets Value %') and inputbox after 'Vat In...'
-> Item Name mandatory(red *) and Need Auto Complite from - tbl_assests_items_master

asset popup
-----------
--> popup -> deduction/extra pay tab -> grid -> need total(group wise)
--> popup -> jv tab -> grid -> need total

Work Flow

-> 'Depre. Start Date' enable or disable based on 'Allow Change Depreciation Start Date in Assets Purchase' admin settings
-> 'Depre. Start Date' Default value 'Depreciation Start Date' admin settings
-> 'Depre. Start Date' validation
-  'Depre. Start Date' included current 'Depreciation Period' based on Document date or 'Next Depreciation Period start date' based on Document date
-  'Depre. Start Date' not allowed Depreciation Done Period dates
-> 'Depreciation %' Editable based on assets master checkbox base
-> 'Enter a Unit Amount' checkbox showing Unit > 1 otherwise hide
-> 'Depreciation Done on Assets Value' and 'Depreciation Done on Assets Value %' enable and disable based on admin settings(Depreciation Done Assets Value Edit Allow to edit in assets Purchase)
-> 'Current A Assets Value' calculation
- New Entry -> Amount In / No of unit
- Update -> dbl_ledg_cur_current_value
-> A Asset Value
- New Entry -> Amount In / No of unit
- Update -> Amount In / No of unit*(1 only)
-> A Asset Expense
- New Entry -> (Amount In+VAT(Not Inclusive case) + Extra Pay/No of unit - Deduction/ No of unit)/ No of unit
- Update -> (Amount In+VAT(Not Inclusive case) + Extra Pay/No of unit - Deduction/ No of unit)/ No of unit*(1 only)
-> Update Mode status != Active(Depreciation Not Started) then not allow to edit in pupup
-> NOT NEED(sin_assets_previous_status wise solve the issue) -> Create a common DB function fn_get_previous_assets_status(assets_code, item_code, from_module, Depreciation_details_id=0) return - 1, or 2, .. 5
if (from_module == Depreciation) then need Depreciation_details_id and skip the id record
--        1->Active(Depreciation Not Started) -> [No Depreciation, Sold, Write Off]
--          2->Active(Depreciation Started) -> [Exist Depreciation(sin_depreciation_count) and No Sold, Write Off]
--          3->Active(Depreciation Completed) -> [dbl_ledg_cur_current_value <= dbl_depreciation_done_perc(Based on Purchase value)/dbl_depreciation_done_amount and No Sold, Write Off]
--          4->Sold -> [Sold]
--          5->Write Off -> [Write Off]
-> Create a common DB function fn_generate_item_code(assets_code, item_code + no_of_unit = 1)
- return Item_code, code part, Number_part
-Code:-  assets.tbl_assets_items->sin_in_code_set_branch_code + assets.tbl_assets_items->vhr_code_prefix + bin_code_part_last_number 
-Update assets.tbl_assets_items->bin_code_part_last_number + no_of_unit based on assets.tbl_assets_items->sin_in_code_set_branch_code and assets.tbl_assets_items->vhr_code_prefix
-Like doc no gen
->dat_depreciation_start-> Date not include  depreciation FY/Month(<= dat_depreciation_end)

Posting

->Check Payment/Refund
->Paid Cheque
->Build Naration, Json field items(Bill No, Item no, supplier, particulars, Deduction, Extra ...)->Check Refund/Sale - Comments KEYS in transaction table
->Posting Each Item Wise
->Master Deduction/Extra Payment posting check Refund
-> Deduction and Extra Pay  item wise posting check payment - More items here

->Normal
Doc Date | Assets          | Dr
Doc Date | Supplier/FOP    | Cr

->Imported
Doc Date | Assets Ac           | Dr -> Purchase Value
-if Depreciation Debit Account == Accm Dep Ac
    Doc Date | Accum Dep ac    | Cr -> import(Accm ) Dep Amount
-if Depreciation Debit Account == Assets Ac
    Doc Date | Assets ac    | Cr -> import(Accm) Dep Amount
Doc Date | OB Control Ac   | Cr -> Actual Assets value(Purchase Value-Accum Dep Amount)

->Deduction and Extra Pay - ONE SIDE POSTING Direct
-Its Less(Extra Pay) and Add(Deduction) from assets value - So no direct posting
-Deduction account Credit
-Extra Pay account Debit

->JV - All dr and Cr Tally mandatory 
-Direct posting

Set Document Id in Posting

Eg:

mdlTransaction.binDocumentId = mdlReceiptDocument.binDocumentId; // 1st time, Set From Procedure
mdlTransaction.binSubDocId = mdlReceiptDocument.binDocumentId; // 1st time, Set From Procedure