.

Muskan · Dec 22, 2022

.

narayane88 · Dec 20, 2022

Muskan said: ↑

Dear developers,
i want to add a button in my report to show All the items including zero quantity, but i am not able to do that. by default this report shows only items with closing balance but i also want to see zero quantity items when i press "F7" button. please tell me how can it be done.
Here is my code:

[#Menu: Gateway of Tally]
Add: Item: before : @@locBalanceSheet rice List : Display: HAS_Price List

[Report: HAS_Price List]

Form : HAS_Price List
Use : Dsp Template
Title : "Price List 2.0"
Variable: ExplodeFlag, Stock Group Name
Local:Collection:Smpl StkGrp Items:Sortefault:$ClosingBalance ;;;16062020
Local:Collection:Smpl StkGrp Items:Add:Filter:Zerovaluehasan ;;;16062020

[Form: HAS_Price List]

Part : HAS_Price List, HAS_Price List Details
Button : Change Period, Explode Flag, StockQuery
Buttons : PrintButton, ExportButton, UploadButton, MailButton, ShowAllItem
BottomButton : BlankButton, RelReports, InvReports, AcctReports, Report Operations, /*StatRegConfigure,*/ FilterButton, ValueButton
Keys : Form Remove Line, Form Show Last Removed Line

Height : 100 % Screen
Width : 100 % Screen

[Part: HAS_Price List]

Lines : HASPrtHdr

[Line: HASPrtHdr]

Field : Name Field
Right Field : DSP MainDateTitle
Field : HASFldHrd
Local : Field : Name Field : Style : Normal Bold
Space Bottom : 1.5

[Field: HASFldHrd]

Set As : "PRICE LIST"
Style : HEADER TITLE ;Book Antiqua Bold
FullWidth : Yes
Border : Thin Bottom
Align : Centre
Skip : Yes
Fixed : Yes
Width : 60% Screen
Wide Space:Yes

[#Style:HEADER TITLE]
Font: "Book Antiqua Bold"
Bold: Yes

[Part: HAS_Price List Details]

Lines : HAS_Price List Title, HAS_Price List Details
Repeat : HAS_Price List Details : Smpl Stk Grp and Item Coll

Total : HAS_Price List Item Price, HAS_Price List Item Qty, HAS_Price List Item Value,
Scroll : Vertical
Common Border : Yes

[Line: HAS_Price List Details]

Fields : HAS_Price List Item Name
Right Field :HAS_Price List Item Desc, HAS_Price List Item Price, HAS_Price List Item Qty
Explode : Smpl Stk Grp Item Details : $$IsStockGroup AND (##ExplodeFlag OR $$KeyExplode)

Option : Smpl IsStock Item : $$IsStockItem
Space Bottom: 2 mms

[Part: Smpl Stk Grp Item Details]

Line : Smpl Stk Grp Item Details
Repeat : Smpl Stk Grp Item Details : Smpl Stk Grp and Item Coll

[Line: Smpl Stk Grp Item Details]

Use : HAS_Price List Details

[Line: HAS_Price List Total]

Use : HAS_Price List Details

Local : Field : Default : Type : String
Local : Field : HAS_Price List Item Name : Align : Center

[Line: HAS_Price List Title]

Use : HAS_Price List Details

Local : Field : Default : Type : String
Local : Field : HAS_Price List Item Name : Set As : "Particulars"
Local: Field : HAS_Price List Item Desc: Set as: "Description"
Local : Field : HAS_Price List Item Price : Set as : "Price"
Local : Field : HAS_Price List Item Qty : Set As : "Closing Stock"

Local :Field : Default : Style : Normal Bold
Local :Field : Default : Align : Centre

[Field: HAS_Price List Item Name]

Use : Name Field
Set As : $Name

Option : Smpl Stk Grp Item Name : $$IsStockItem
Option : Smpl Stk Grp Name : $$IsStockGroup
Color: Black
style: Large

[Field: HAS_Price List Item Desc]
Use: Name Field
Set as: $Description
Style : Normal
Border : Thin Left
Width: 50
max: 1000
Align: left

[!Field: Smpl Stk Grp Name]

Variable: Stock Group Name
Display : HAS_Price List

Alter : Stock Group
Variable: StockGroupName
Color : Black

[!Field: Smpl Stk Grp Item Name ]

Variable: Stock Item Name
Display : Item Monthly Summary
Style : Normal
width: 30
Alter : Stock Item

[FIELD: HAS_Price List Item Price]
Use : SIMPLE FIELD
Set As : $$GetPriceFromLevel:$StockItemName:"Pricelist":##SvCurrentDate:$ClosingBalance
Storage : PriceListRte
Width : 25
Style : Normal
Border : Thin Left
Align: Center

[Field: HAS_Price List Item Qty]

;Use : Qty Primary Field
;Type: Number: Forced
;Set Always: Yes
Width : @@NameWidth
Set As : $ClosingBalance
Color : Black
Style : Normal
Border : Thin Left
Align: Center

[Button:ShowAllItem]
Key: F7
Title: $$LocaleString:"Show All Items"
Action: Display Collection:Smpl StkGrp Items

[Button: StockQuery]
Key: F3
Title:"Stock Query"
Actionisplay Collection : Stock Query

[Collection: Smpl Stk Grp and Item Coll]

Collection : Smpl Stk Grp Coll, Smpl StkGrp Items

[Collection: Smpl Stk Grp Coll]

Type : Stock Group
Child Of: #StockGroupName
Fetch : Name, Closing Balance, Closing Value

[Collection: Smpl StkGrp Items]

Type : Stock Item
Childof : #StockGroupName
Fetch : Name, Closing Balance, Closing Value
Compute : IntQtyOpBal :$$AsSignedQty:$$GodownItemValueIntFGPET:$StockItemName:$OpeningBalance
Filter : IsaEmptyItem

[System: Formula]
IntFGPET : "Finished Good PET";"Finished Goods - Int"
Zerovaluehasan:$ClosingBalance > 0 ;;;16062020
IsaEmptyItem: $$IsEmpty:$ClosingBalance
Click to expand...

please check your filter formula is not proper

Log in or Sign up

.

Muskan New Member

narayane88 Active Member

Share This Page

Log in or Sign up

.

Muskan New Member

narayane88 Active Member

Share This Page

Useful Searches