please help to get opening billed qty in customiz stock report

Discussion in 'Requests' started by Naitesh, Oct 21, 2019.

         
  1. Naitesh

    Naitesh Member


    hello sir
    please help me to get opening billed qty
    i use this code
    thank you

    [#Menu: Gateway of Tally]
    Add: Item: Stock Billed Qty : Display: MySalesSummaryA

    [Report :MySalesSummaryA]
    Use : DSP Template
    Form :MySalesSummaryA
    Title: "Stock Billed Qty Summary"
    Variable:SVFromDate,SVToDate
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate

    [Form :MySalesSummaryA]
    Part : MyReportTitleA,My SalesSummaryTL0A,My SalesSummaryTLA,My SalesSummaryA
    Button : Print Button,Export Button,Change Period
    Bottom Part : MySalesSummaryBTMA
    Background : @@SV_UNYELLOW

    [Style:nFSA]
    Height:20
    Bold: Yes

    [Part : MyReportTitleA]
    Line :MyReportTitleA
    [Line :MyReportTitleA]
    Field : Simple Field
    Local : Field : Simple Field : Full Width:Yes
    Local : Field : Simple Field : Set As :"ALL PRODUCT LIST" + " " + $$String:##SVFromDate + " TO " + $$String:##SVToDate
    Local : Field : Simple Field : Style : nFSA
    Local : Field : Simple Field : Color: Red
    Local : Field : Simple Field : Align: Left
    Local : Field : Simple Field : Border:BorBottomUL

    [Part : MySalesSummaryTL0A]
    Use : MySalesSummaryA
    Delete : Repeat
    Delete : Scroll
    Local : Field : Default : Type : string
    Local :Field : Default : Style : Small

    Local : Field : MyProductA : Set As : ""
    Local : Field : MyProductA : Width : 25

    Local : Field : MyTotPQA: Set As : "Inward"
    Local : Field : MyTotPAA: Set As : ""

    Local : Field : MyTotSQA: Set As : "Outward"
    Local : Field : MyTotSAA: Set As : ""

    Local : Field : MyTotBAA: Set As : "Closing"
    Local : Field : MyClsValueA : Set As : ""


    [Part : MySalesSummaryTLA]
    Use : MySalesSummaryA
    Delete : Repeat
    Delete : Scroll
    Border : thintop
    Local : Field : Default : Type : string

    Local : Field : MyProductA : Set As : "Product"
    Local : Field : MyProductA : Width : 25

    Local : Field : MyTotOpPPcsA: Set As : "Op.BilledQty"

    Local : Field : MyTotPQA: Set As : "Billed Qty"
    Local : Field : MyTotPAA: Set As : "Value"

    Local : Field : MyTotSQA: Set As : "Billed Qty"
    Local : Field : MyTotSAA: Set As : "Value"

    Local : Field : MyTotBAA: Set As : "Cl.Billed Qty"
    Local : Field : MyClsValueA : Set As : "Cl.Value"

    Local :Field : Default : Style : Small

    [Part :MySalesSummaryA]
    Line : MySalesSummaryA
    Repeat : MySalesSummaryA :MySalesItemsA
    Scroll : Vertical
    Total : MyTotPQA,MyTotPAA,MyTotSQA,MyTotSAA,MyTotBAA,MyClsValueA
    CommonBorder: Yes
    [Line :MySalesSummaryA]
    Field : MyProductA
    Right Field : MyTotOpPPcsA,MyTotPQA,MyTotPAA,MyTotSQA,MyTotSAA,MyTotBAA,MyClsValueA
    Border : Thin bottom
    [Field : MyProductA]
    Set As : $Stockitem
    Style : Small
    Width:25

    [Field : MyTotOpPPcsA]
    Use : Number Field
    Set As : "0";$TotOpPQ-$TotOpSQ
    Style : Small
    Align:Center
    Border:ThinLeft
    Width:10

    [Field : MyTotPQA]
    Use : Number Field
    Set As : $TotPBillQ
    Style : Small
    Align:Right
    Width:10
    Border:ThinLeft

    [Field : MyTotPAA]
    Use : Number Field
    Set As : $TotPA
    Style : Small
    Align:Right
    Width:15

    [Field : MyTotSQA]
    Use : Number Field
    Set as : $TotSBillQ
    Style : Small
    Align:Right
    Width:10
    Border:ThinLeft

    [Field : MyTotSAA]
    Use : Amount Field
    Set As :$TotSA
    Style : Small
    Align:Right
    Width:15

    [Field : MyTotBAA]
    Use : Number Field
    Set As :$TotPBillQ - $TotSBillQ
    Style : Small
    Align:Right
    Width:15
    Border:ThinLeft

    [Field : MyClsValueA]
    Use : Amount Field
    Set As : $$AsAmount:($$Number:$TotPBillQ-$$Number:$TotSBillQ) *( $$Number:$TotPA /$$Number:$TotPBillQ)
    Style : Small
    Align:Right
    Width:15


    [Part:MySalesSummaryBTMA]
    Line : MySalesSummaryBTMTOTALA

    [Line:MySalesSummaryBTMTOTALA]
    Border : Totals
    Use : MySalesSummaryA
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Right
    Local : Field : Default : Style : SMALL
    Local : Field : MyProductA : Set as : "Total :"
    Local : Field : MyProductA : Align : Left

    [Collection : MySalesSummaryCollectionA]
    Type : Voucher
    Belongs to : yes
    Fetch : Date,StockItemName,BilledQty,Amount
    Filter : FilterVch

    [Collection : MySalesItemsA]
    Source Collection : MySalesSummaryCollectionA
    Walk : All Inventory Entries
    By : Stockitem : $StockitemName

    Aggr Compute : TotPBillQ : Sum :If $$IsPurchase:$VoucherTypeName Then $BilledQty Else 0
    Aggr Compute : TotPA : Sum :If $$IsPurchase:$VoucherTypeName Then $Amount Else 0

    Aggr Compute : TotSBillQ : Sum :If $$IsSales:$VoucherTypeName Then $BilledQty Else 0
    Aggr Compute : TotSA : Sum :If $$IsSales:$VoucherTypeName Then $Amount Else 0

    Sort : Default : $Stockitem

    [System: Formula]
    FilterVch : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName
     

    Attached Files:



  2. Murali.R

    Murali.R Member


    $OpeningBalance:stockitem:$StockItemName

    [Field : MyTotOpPPcsA]
    Use : Number Field
    Set As :$OpeningBalance:stockitem:$StockItemName;$TotOpPQ-$TotOpSQ
    Style : Small
    Align:Center
    Border:ThinLeft
    Width:10
     


  3. Barbie Doll

    Barbie Doll New Member


    after changing above mention code not geting opening billed qty sir reply me please
     


Share This Page