Godown Control

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

 

Great its working. Thank You Very Very Very Much .

 

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

 

Not working. Please share full codes.

 

Once Again Good Work Aldrin.

 

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

 

good i want it to ledger control pls

 

Auto Godown Selection is working but
enter rate and Stop entry
and Not select next Stock Item...

 

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

 

Good works.............................

 

add to auto fill godown with stock

[#Field: VCHINV Godown]
;Set as:"test3"
Set as:$$FilterValue:$Name:Godown:First:SAPPEMPTYFILTER