Values

From BSG Knowledge Base

[edit] Stock Value

[edit] Triggers for leather bill taxes stocks

Table : acc_bill_items_106 Trigger : bill_value_update_106_trigg AFTER INSERT OR UPDATE Function : bill_value_update_func Work --> Setting initial bill value for the item with base value + tax values

Table : acc_bill_items_tax_106 Trigger :item_tax_amount_update_106_trigg BEFORE INSERT OR UPDATE Function : item_tax_amount_func Work --> to calculate item tax amount from tax rate

Table : acc_bill_tax_106 Trigger :bill_tax_amount_update_106_trigg BEFORE INSERT OR UPDATE Function : bill_tax_amount_func Work --> to calculate bill tax amount from tax rate

Table : acc_bill_tax_106 Trigger :final_bill_value_update_106_trigg AFTER INSERT OR UPDATE Function : final_bill_value_func Work --> to update tax amount and common tax in acc_bill_items_106

[edit] Triggers for leather stocks

Table : receipt_item_price_106 - Trigger : receipt_item_price_update_106_trigg AFTER UPDATE Function : receipt_item_price_106_update_func() Work --> To update stock value when receipt item price is changed

Table : acc_bill_items_tax_106 Trigger : item_all_tax_amount_update_106_trigg AFTER INSERT OR UPDATE Procedure : taxed_bill_item_value_func Work --> To update stock value when bill taxes are entered.

Table : stock_transaction_detail_106 Trigger : stock_outgoing_value_update_106_trigg AFTER INSERT OR DELETE OR UPDATE Function : stock_outgoing_value_update_106_func Work --> To update outgoing value of stock_value table for 'o' transactions

Table : stock_transaction_detail_106 Trigger : trans_value_issue_106 AFTER INSERT ON Function : trans_value_issue_update_106 Work --> To update outgoing value of stock_value table for 'o' transactions

Table : stock_transaction_detail_106 Trigger : trans_value_pur_106_trig AFTER INSERT OR DELETE OR UPDATE Function : trans_value_update_106 Work --> To update receipt_value for purchase receipts

Table : stock_transaction_detail_117 Trigger : chemical_stock_value_update_trigg AFTER INSERT OR DELETE OR UPDATE Function : chemical_stock_value_update Work --> To add issued chemical value to the stock to which it is issued

Table : prd_status_operation_costing Trigger : trans_value_mac_106 AFTER INSERT OR DELETE OR UPDATE Function : trans_value_mac_entry_106 Work --> To add cost of machinery operation to the batch stock.

1. When material is received against a Delivery Challan from supplier: Receipt Value (in Rs) = Receipt Quantity (Kg or Sqft or Pcs) * Receipt Price (Rs/Kg or Rs/Sqft or Rs/Pcs) (Unit of Measurement of Price and Quantity match)

Stock Value=Receipt Value

Receipt Price is stored in receipt_item_price Stock Value is stored in transaction_value of corresponding transaction which is updated in value of stock_value table.

2. When bill for the received material is entered (the price may change and taxes will be added) Bill value = Receipt Value (recalculated with bill price) + Taxes which form part of bill

Bill value is stored in initial_item_value in acc_bill_items table Tax Value is stored in tax_value in acc_bill_items_table

Stock Value = Bill value + value of taxes not part of bill (freight, handling charges etc).

Stock Value is stored in transaction_value of corresponding transaction which is updated in value of stock_value table.

3. When received material is returned to supplier Purchase Return value = Incoming Rate of stock (stock_value.value/stk_details_meta.incoming_quantity) * Return Quantity

4. When material is issued to production/or shipped stock_value.outgoing_value=stock_value.outgoing_value+new_transaction_quantity*stock_price (stock_value.value/sum(incoming_quantity)