Can we control the Negative Stock entry in a Voucher?

Discussion in 'Knowledge Base' started by admin, May 17, 2013.

    
  1. admin

    admin Administrator Staff Member


    Query:
    Can we control the Negative Stock entry in a Voucher?

    Solution:
    Yes, we can control the Negative Stock entry in a Voucher. In default Tally, we have used the Field Attribute Notify to notify the Negative Stock as a warning. In order to control the same, we need to use the Field Attribute Control.

    Syntax:


    Control : <Message Formula> : <Logical Condition>


    Example:

    Code:
    [#Field: VCH NrmlActualQty][/FONT]
    [FONT=georgia]                Option  : NSC NrmlQty  : @@IsSales Or @@IsDelNote[/FONT]
     
    [FONT=georgia][#Field: VCH NrmlBilledQty][/FONT]
    [FONT=georgia]                Option  : NSC NrmlQty  : @@IsSales Or @@IsDelNote[/FONT]
     
    [FONT=georgia][#Field: VCHBATCH NrmlAQty][/FONT]
    [FONT=georgia]                Option  : NSC NrmlQty  : @@IsSales Or @@IsDelNote[/FONT]
     
    [FONT=georgia][#Field: VCHBATCH NrmlBQty][/FONT]
    [FONT=georgia]                Option  : NSC NrmlQty  : @@IsSales Or @@IsDelNote[/FONT]
     
    [FONT=georgia]                [!Field : NSC NrmlQty][/FONT]
    [FONT=georgia]                                Add  : Control    : NegativeStock  : ##VCFGNegativeStock AND @@InvoiceInCreate AND +[/FONT]
    [FONT=georgia]                                                                                                                $$IsNegative:@@FinalStockTotal[/FONT]
     
    [FONT=georgia]

    The above Negative Stock Control solution will not work in Alter Mode.

    A voucher, being a legal document must not be subjected to alteration. Imagine a scenario, where further entries have happened based on the Batch Name specified in one of the entries and later altered to a different Batch Name. Also, the Quantity, Tracking Number, Purchase Order and so on, if altered, can lead to chaos. To avoid this situation, alteration must be controlled and if required, only administrator must alter it. Normally, accounting practise is to reverse the entry and not alter the entry. By allowing to alter an entry, one is compromising on the accuracy of the information/ reports.

    Hence, with the help of default Security Control, one must prevent the alteration of Vouchers.
     



  2. Hello Sir,
    Please find the attached TDL which Allow me to Stop Negative Stock for Being use not matter it a Stock Journal. But How can we Enable this Negative Stock Control Based on Voucher Type.

    For Example
    I don't want Negative Stock Control on My Sales Or Purchase Order. But I want this Control on Godown Transfer Voucher Type which we can enable using Class in Stock Journal.

    Please Help
     

    Attached Files:



Share This Page