1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

SCRAP CALCULATION HELP ME REMOVE ZERO VALUE ENTRY

Discussion in 'Free Source Codes' started by harbansh, Oct 6, 2016.

    
Tags:
  1. harbansh

    harbansh Active Member


    Dear All,
    I have created a scrap calculation report according to our requirement. Report is ok. But there is a problem it shows zero valued entries also. But i want that zero value entry can not be included. Help me to filter zero value entry i have try but not get success.

    Code:
    ; scrap calculation report designed by Mr. Harbansh Singh


; stock item master modification

[#Part: STKI Parent]

    Lines       : STKI Parent, STKI Category,scrapline,scraplinevmc,scraplinelath
    Space Top   : 0.25

[line : scrapline]
field : scraptitle,scrapfield

[field : scraptitle]
use : name field
set as : "Scrap in KG CNC : "
skip : yes

[field : scrapfield]
use : number field
set as : ""
storage : scrapweight


[system : udf]
scrapweight : number : 5698




[line : scraplinevmc]
field : scraptitlevmc,scrapfieldvmc

[field : scraptitlevmc]
use : name field
set as : "Scrap in KG VMC : "
skip : yes

[field : scrapfieldvmc]
use : number field
set as : ""
storage : scrapweightvmc


[system : udf]
scrapweightvmc : number : 5699



[line : scraplinelath]
field : scraptitlelath,scrapfieldlath

[field : scraptitlelath]
use : name field
set as : "Scrap in KG LATH : "
skip : yes

[field : scrapfieldlath]
use : number field
set as : ""
storage : scrapweightlath


[system : udf]
scrapweightlath : number : 5685



[#Menu: Gateway of Tally]
Add: Item: SCRAP CALCULATION : Display: Scrap Calculation By Harbansh
[Report: Scrap Calculation By Harbansh]
Form : Scrap Calculation By Harbansh
Use : Dsp Template
Title : "SCRAP REPORT BY HARBANSH SINGH"
Variable: ExplodeFlag
PrintSet : Report Title : "SCRAP CALCULATION REPORT BY HARBANSH SINGH"+ @@DspDateStr
Variable : SV Print Orientation : String

[Form: Scrap Calculation By Harbansh]
Use : DSP Template
Part : Scrap Calculation By Harbansh
Background : White
Button : Change Period, Change Company, Print Button , Explode Flag, ExportButton, UploadButton, MailButton, FilterButton, ValueButton, DSP AutoColumns, BlankButton ;;ChangeValue,Report Operations, DSPAutoColumns;;BSConfigure,GRPVCH Configure, , DSP NewColumn
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
Set Always : SV Print Orientation : "Landscape"
Height : 100 % Screen
Width : 110 % Screen

[Part: Scrap Calculation By Harbansh]
Parts : Form SubTitle, Scrap Calculation By Harbansh Details
Local : Field : Form SubTitle : Set as : "SCRAP CALCULATION REPORT BY HARBANSH SINGH FROM PERIOD  " + @@DspDateStr
Vertical: Yes

[Part: Scrap Calculation By Harbansh Details]
Lines : Scrap Calculation By Harbansh Title, Scrap Calculation By Harbansh Details
Bottom Line : Scrap Calculation By Harbansh Total
Repeat : Scrap Calculation By Harbansh Details : Scrap Item Collection 
Total : Scrap Calculation By Harbansh Item SaleQty, Scrap Calculation By Harbansh Item SaleVal,Scrap Calculation By Harbansh Item ScSaleQty, Scrap Calculation By Harbansh Item ScSaleVal,Scrap Calculation By Harbansh Item Qty,Scrap Calculation By Harbansh Item ScSaleQtyVMC,Scrap Calculation By Harbansh Item ScSalevalVMC,Scrap Calculation By Harbansh Item Value,Scrap Calculation By Harbansh Item ScSaleQtyLath,Scrap Calculation By Harbansh Item ScSalevalLath,Scrap Calculation By Harbansh Item ScSaleQtyToSc,Scrap Calculation By Harbansh Item ScSalevalToAmt
Scroll : Vertical

[Line: Scrap Calculation By Harbansh Details]

Fields : Scrap Calculation By Harbansh Item Name, Scrap Calculation By Harbansh Item SaleQty, Scrap Calculation By Harbansh Item SaleVal, Scrap Calculation By Harbansh Item ScSaleQty , Scrap Calculation By Harbansh Item ScSaleVal,Scrap Calculation By Harbansh Item Qty,Scrap Calculation By Harbansh Item ScSaleQtyVMC,Scrap Calculation By Harbansh Item ScSalevalVMC,Scrap Calculation By Harbansh Item Value,Scrap Calculation By Harbansh Item ScSaleQtyLath,Scrap Calculation By Harbansh Item ScSalevalLath
Right Field : Scrap Calculation By Harbansh Item ScSaleQtyToSc,Scrap Calculation By Harbansh Item ScSalevalToAMt



[Part: Smpl Stk Grp Item Details]

Line : Smpl Stk Grp Item Details
Repeat : Smpl Stk Grp Item Details : Scrap Item Collection 

[Line: Smpl Stk Grp Item Details]

Use : Scrap Calculation By Harbansh Details

[Line: Scrap Calculation By Harbansh Total]

Use : Scrap Calculation By Harbansh Details

Local : Field : Default : Type : String
Local : Field : Scrap Calculation By Harbansh Item Name : Align : Center
Local : Field : Scrap Calculation By Harbansh Item Name : Set As : "TOTAL"
Local : Field : Scrap Calculation By Harbansh Item SaleQty : Set As : $$Total:SmplStkGrpRepItemSaleQty
Local : Field : Scrap Calculation By Harbansh Item SaleVal : Set As : $$Total:SmplStkGrpRepItemSaleVal

Local : Field : Scrap Calculation By Harbansh Item ScSaleQty : Set As: $$Total:SmplStkGrpRepItemScSaleQty
Local : Field : Scrap Calculation By Harbansh Item ScSaleVal : Set As: $$Total:SmplStkGrpRepItemScSaleVal


Local : Field : Scrap Calculation By Harbansh Item Qty : Set As : $$Total:SmplStkGrpRepItemQty
Local : Field : Scrap Calculation By Harbansh Item ScSaleQtyVMC : Set As: $$Total:SmplStkGrpRepItemScSaleQtyVMC
Local : Field : Scrap Calculation By Harbansh Item ScSaleValVMC : Set As: $$Total:SmplStkGrpRepItemScSaleValVMC
Local : Field : Scrap Calculation By Harbansh Item Value : Set As : $$Total:SmplStkGrpRepItemValue
Local : Field : Scrap Calculation By Harbansh Item ScSaleQtyLATH : Set As: $$Total:SmplStkGrpRepItemScSaleQtyLATH
Local : Field : Scrap Calculation By Harbansh Item ScSaleValLATH : Set As: $$Total:SmplStkGrpRepItemScSaleValLATH
Local : Field : Scrap Calculation By Harbansh Item ScSaleQtyToSc : Set As: $$Total:SmplStkGrpRepItemScSaleQtyToSc
Local : Field : Scrap Calculation By Harbansh Item ScSaleValToAmt : Set As: $$Total:SmplStkGrpRepItemScSaleValToAmt

Border : Totals



[Line: Scrap Calculation By Harbansh Title]

Use : Scrap Calculation By Harbansh Details

Local : Field : Default : Type : String
Local : Field : Scrap Calculation By Harbansh Item Name : Align : Center
Local : Field : Scrap Calculation By Harbansh Item Name : Set As : "ITEM NAME"
Local : Field : Scrap Calculation By Harbansh Item SaleQty : Set as : "SALES QTY"
Local : Field : Scrap Calculation By Harbansh Item Saleval : Set as : "CNC SCR"
Local : Field : Scrap Calculation By Harbansh Item ScSaleQty : Set as : "T SCRAP"
Local : Field : Scrap Calculation By Harbansh Item ScSaleval : Set as : "T CNC AMT"

Local : Field : Scrap Calculation By Harbansh Item Qty : Set As : "VMC SCR"
Local : Field : Scrap Calculation By Harbansh Item ScSaleQtyVMC : Set as : "T SCRAP"
Local : Field : Scrap Calculation By Harbansh Item ScSalevalVMC : Set as : "T VMC AMT"

Local : Field : Scrap Calculation By Harbansh Item Value : Set As : "LATH SCR"
Local : Field : Scrap Calculation By Harbansh Item ScSaleQtyLATH : Set as : "T SCRAP"
Local : Field : Scrap Calculation By Harbansh Item ScSalevalLATH : Set as : "T LATH AMT"
Local : Field : Scrap Calculation By Harbansh Item ScSaleQtyToSc : Set as : "F SCRAP"
Local : Field : Scrap Calculation By Harbansh Item ScSalevalToAmt : Set as : "F AMT"

Border : Column Titles


[Field: Scrap Calculation By Harbansh Item Name]

Use : Name Field
Set As : $Name
Variable: Stock Item Name
Display : Item Monthly Summary
Alter : Stock Item
border : thick left right
width : 30


[Field: Scrap Calculation By Harbansh Item SaleQty]

Use : Qty Primary Field
Width : 13
Set as : $SaleQty
border : thick right
align : center

[Field: Scrap Calculation By Harbansh Item SaleVal]

Use : Number Field
Width : 11
Set As : $scrapweight
align : center
Format : "No Zero"

[Field: Scrap Calculation By Harbansh Item ScSaleQty]

Use : Number field
Width : 11
Set as : $SaleQty * $scrapweight
align : center
Format : "No Zero"

[Field: Scrap Calculation By Harbansh Item ScSaleVal]

Use : Number Field
Width : 11
Set As : $SaleQty * $scrapweight * 15
align : center
Format : "No Zero"
border : thin right
color : red

[Field: Scrap Calculation By Harbansh Item Qty]

Use : number field
Width : 11
Set As : $scrapweightvmc
align : center
Format : "No Zero"

[Field: Scrap Calculation By Harbansh Item ScSaleQtyVMC]

Use : Number field
Width : 11
Set as : $SaleQty * $scrapweightvmc
align : center
Format : "No Zero"

[Field: Scrap Calculation By Harbansh Item ScSaleValVMC]

Use : Number Field
Width : 11
Set As : $SaleQty * $scrapweightvmc * 15
align : center
Format : "No Zero"
border : thin right
color : green

[Field: Scrap Calculation By Harbansh Item Value]

Use : number field
Width : 11
Set As : $scrapweightlath
align : center
Format : "No Zero"
[Field: Scrap Calculation By Harbansh Item ScSaleQtylath]

Use : Number field
Width : 11
Set as : $SaleQty * $scrapweightlath
align : center
Format : "No Zero"

[Field: Scrap Calculation By Harbansh Item ScSaleVallath]

Use : Number Field
Width : 11
Set As : $SaleQty * $scrapweightlath * 15
align : center
Format : "No Zero"
border : thin right
color : blue


[Field: Scrap Calculation By Harbansh Item ScSaleQtyToSc]

Use : Number field
Width : 11
Set as : $SaleQty * $scrapweightlath + $SaleQty * $scrapweightvmc + $SaleQty * $scrapweight
align : center
Format : "No Zero"

[Field: Scrap Calculation By Harbansh Item ScSaleValToAmt]

Use : Number Field
Width : 11
Set As : $SaleQty * $scrapweightlath * 15 + $SaleQty * $scrapweightvmc * 15 + $SaleQty * $scrapweight * 15
align : center
Format : "No Zero"
border : thin right
color : dark green
align : right
[Collection: Scrap Item Collection ]

Collection : Scrap Collection  



[Collection: Scrap Collection ]
Type :  Stock Item
Fetch : Name, SaleQty, Sale Value, Closing Balance, Closing Value,scrapweight,scrapweightvmc,scrapweightlath
Filter : ZeroQty
Filter : filtersc

[System : Formula]
ZeroQty  : Not $$IsEmpty:$saleqty
filtersc : Not $$IsEmpty:$scrapweight or Not $$IsEmpty:$scrapweightvmc or Not $$IsEmpty:$scrapweightlath
     

    Attached Files:

    harbansh, Oct 6, 2016
    #1
    SURENRA likes this.


  2. harbansh

    harbansh Active Member


    Dear Experts,
    Please help me to correct above problem.
     
    harbansh, Oct 7, 2016
    #2
    SURENRA likes this.


  3. D Lokesh

    D Lokesh Member


    Dear Sir,

    for Zero Entry Filer

    you can filter the closing balance is Zero then it'll remove.

    [System : Formula]

    NoClosing : Not $$IsEmpty:$ClosingBalance
     
    D Lokesh, Oct 7, 2016
    #3


  4. harbansh

    harbansh Active Member



    Dear Lokesh,
    not possible from this filter.
    please see my problem in given below screen shots.
     

    Attached Files:

    harbansh, Oct 7, 2016
    #4


Share This Page