Dear All, How can we set that if there is no stock in particular godown then it should not show while passing sales entry. I had tried but no effect.:- [#Collection: Godown] Add: Filter: IsEmpStk [#Collection: Godown for Parent] Add: Filter: IsEmpStk [#Collection: Multi Godown] Add: Filter: IsEmpStk [#Collection: Godown Under MGodown] Add: Filter: IsEmpStk [#Collection: Stockable Godown] Add: Filter: IsEmpStk [#Collection : Godown Summary] Add: Filter: IsEmpStk [System : Formula] IsEmpStk : $GodownItemClBal = 0
Dear Shaikh, check this [#Collection: Stockable Godown VchExtract] Filter : SAPPEMPTYFILTER [System:Formula] SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
only for sales and credit note [#Field: VCHBATCH Godown] Option : SAPPSalCN : ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType) [!Field: SAPPSalCN] Delete : Table Add : Table : SAPP Stockable Godown VchExtract Set Always : Yes [Collection: SAPP Stockable Godown VchExtract] Use : Stockable Godown VchExtract Add : Filter : SAPPEMPTYFILTER [System:Formula] SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
In this if already entered old sales entries, and there is no stock now, and user alter old sales voucher, godown changed to stock available. i modified this like below Code: Option : SAPPSalCN : $$InCreateMode AND ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType)
Only CreateMode [#Field: VCHBATCH Godown] Option : SAPPSalCN : $$InCreateMode AND ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType) [!Field: SAPPSalCN] Delete : Table Add : Table : SAPP Stockable Godown VchExtract,End of List Set Always : Yes [Collection: SAPP Stockable Godown VchExtract] Use : Stockable Godown VchExtract Add : Filter : SAPPEMPTYFILTER [System:Formula] SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
Just a little Bit of modification for not allowing user at the time of alteration to as per HVG88 request. [#Field: VCHBATCH Godown] Option : SAPPSalCN : $$InCreateMode OR $$InAlterMode AND ($$IsSales:##SVVoucherType OR $$IsCreditNote:##SVVoucherType) [!Field: SAPPSalCN] Delete : Table Add : Table : SAPP Stockable Godown VchExtract Set Always : Yes [Collection: SAPP Stockable Godown VchExtract] Use : Stockable Godown VchExtract Add : Filter : SAPPEMPTYFILTER [System:Formula] SAPPEMPTYFILTER : NOT $$IsEmpty:$GodownItemClBal
Dear Shaikh & Prabhakaran, In create mode it is ok, if Stock is Nil (Zero), and user go to alter a voucher (entered during godown having stock), no list of godown showing, Requesting to All Experts, please update, if a godown has no stock, and user go to alter vch, it should show list of godown having stock. thanks & regards
all can help me i want sales and purchase export file from tally to text include 1- date 2- time 3- sales account\purchase account 4-name of item 5-qty 6-amount
add to auto fill godown with stock [#Field: VCHINV Godown] ;Set as:"test3" Set as:$$FilterValue:$Name:Godown:First:SAPPEMPTYFILTER