MRP Column in Report

Discussion in 'Tally Developer' started by Piyush Kankaria, Feb 6, 2020.

    
  1. Piyush Kankaria

    Piyush Kankaria New Member


    Hey, I've Created a TDL for Item wise sales; But unable to fetch the MRP for the items.
    Here is the code, could you please help me with the same..

    [#Menu : Gateway of Tally]
    Add: Item : Piyush Reports: Menu: Piyush Reports

    [Menu : Piyush Reports]
    Item : Load (Item Wise) : Display : Item Wise Report

    [Report :Item Wise Report]
    Form :Item Wise Report
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : $$CurrentDate
    Set : SVToDate : $$CurrentDate

    Variable : EBFVoucherNumberFrom,EBFVoucherNumberTo
    Set : EBFVoucherNumberFrom : $$SysName:NotApplicable
    Set : EBFVoucherNumberTo : $$SysName:NotApplicable

    [Form :Item Wise Report]
    Part : DSP AccTitles,MyReportTitle,Item Wise ReportTL,Item Wise Report
    Page Break : DSP ClPageBreak, CyDSPOpPageBreak
    Full Width : No
    Space Top : If $$InPrintMode Then 0.2 Else 0 inches
    Space Bottom : If $$InPrintMode Then 0.25 Else 0 inches
    Space Left : If $$InPrintMode Then 0.25 Else 0 inches
    Space Right : If $$InPrintMode Then 0.25 Else 0 inches
    Button : F2Change Period,EBFIsOfSelectedVchNo
    Bottom Buttons : BlankButton, InvReports, AcctReports, Report Operations, DYBKConfigure, FilterButton, ValueButton
    Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
    Buttons : PrintButton, ExportButton, UploadButton, MailButton
    Background : @@SV_UNYELLOW

    [Part : CyDSPOpPageBreak]
    Parts : DSP OpCompanyName,DSP Op ReportTitle,Item Wise ReportTL
    Vertical: Yes

    [Part : MyReportTitle]
    Line :MyReportTitle

    [Line :MyReportTitle]
    Field : Simple Field
    Local : Field : Simple Field : Set As : "Item Wise Load (Piyush Kankaria Format) from - " + $$String:##SVFromDate +" to " + $$String:##SVToDate
    Local : Field : Simple Field : Style : Normal Bold

    [Part : Item Wise ReportTL]
    Line : Item Wise ReportTL
    Border : Column Titles

    [Line : Item Wise ReportTL]
    Use : Item Wise Report
    Local : Field : Default : Type : string
    Local : Field : SRNO : Set As : "Sl. No."
    Local : Field : Item Wise ReportItem : Set As : "Particulars"
    Local : Field : MyItemsSalesMRP : Set As : "MRP"
    Local : Field : MyItemsSalesQty: Set As : "Sales Qty"
    Local : Field : MyItemsSalesRate : Set As : "Rate"
    Local : Field : MyItemsSalesAmount : Set As : "Sales Value"
    Local :Field : Default : Style : Small Bold

    [Part :Item Wise Report]
    Lines : Item Wise Report
    BottomLines:Item Wise ReportTotal
    Repeat : Item Wise Report :MySalesItems
    Scroll : Vertical
    Float : Yes
    Total : MyItemsSalesQty,MyItemsSalesAmount
    CommonBorder : Yes

    [Line :Item Wise Report]
    Left Field : SRNO
    Right Field : Item Wise ReportItem,MyItemsSalesMRP,MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount
    Border : Thin bottom

    [Field: SRNO]
    Use: Simple Field
    Set as: $$Line
    Width : 4
    Format: "No Zero"
    Style:Normal
    Align: Center

    [Field : Item Wise ReportItem]
    Set As : $Stockitem
    Width : 40% Screen
    Style : Normal
    Display : Item Monthly Summary
    Variable : StockitemName
    Border : Thin Left

    [Field : MyItemsSalesMRP]
    Use : Number Field
    Style : Normal
    SET : $MrpRate
    Border : Thin Left
    Width : 10

    [Field : MyItemsSalesQty]
    Use : Qty Primary Field
    Style : Normal
    Set As : $ActualQty
    Border : Thin Left
    Width : 10

    [Field : MyItemsSalesRate]
    Use : Rate Price Field
    Set as : $Rate
    Style : Normal
    Border : Thin Left
    Width : 10

    [Field : MyItemsSalesAmount]
    Use : Amount Field
    Set As : $Amount
    Style : Normal
    Border : Thin Left Right

    [Line : Item Wise ReportTotal]
    Use : Item Wise Report
    Local : Field : Item Wise ReportItem : Set As : "Total"
    Local : Field : MyItemsSalesQty : Set As : $$Total:MyItemsSalesQty
    Local : Field : MyItemsSalesAmount : Set As : $$Total:MyItemsSalesAmount
    Local : Field : Default : Style : Small Bold
    Border: Thin Top Bottom


    [Collection : MySalesSummaryCollection]
    Title : "List of Sales vouchers"
    Type : Vouchers : VoucherType
    Child of : $$VchTypeSales
    Belongs to : Yes
    Format : $VoucherNumber, 20
    Fetch : VoucherNumber
    Fetch : Inventory Entries
    Filter : EBFIsOfSelectedVchNo
    Sort : @@InvoiceNumberIncr : $VoucherNumber

    [Collection : MySalesItems]

    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : StockItemName : $StockItemName
    Sort : StockItemName : $StockItemName
    Aggr Compute : ActualQty : Sum : $ActualQty
    Aggr Compute : Rate : Sum : $Rate
    Aggr Compute : Amount : Sum : $Amount
    Keep Source : ().

    [Button : EBFIsOfSelectedVchNo]
    Key : Alt+V
    Title : Selected Vch No
    Action : Alter:EBFIsOfSelectedVchNo

    [Report: EBFIsOfSelectedVchNo]
    Form : EBFIsOfSelectedVchNo

    [Form : EBFIsOfSelectedVchNo]
    Part : SelectedVchNoHead,EBFIsOfSelectedVchNo
    Width : 30% page

    [Part : SelectedVchNoHead]
    Line : SelectedVchNoPart1
    Space Bottom :0.20 cm

    [Line: SelectedVchNoPart1]
    Fields : Name Field
    Local : Field: Name Field : Info : "Voucher Filter"
    Local : Field: Name Field : Style : SelectedVchNoStyle
    Local : Field: Name Field : Border : Double Bottom
    Local : Field: Name Field : Align : Center
    Local : Field: Name Field : Full Width : Yes

    [Style: SelectedVchNoStyle]

    Use : Normal Bold
    Height : 12
    Italic : Yes

    [Part : EBFIsOfSelectedVchNo]
    Line : EBFVoucherNumberFrom,EBFVoucherNumberTo

    [Line : EBFVoucherNumberFrom]

    Field : Medium Prompt,EBFVoucherNumberFrom
    Local : Field : MediumPrompt :Info : "Voucher No.From:"


    [Field : EBFVoucherNumberFrom]
    Use : Name Field
    Modifies : EBFVoucherNumberFrom
    Table : MySalesSummaryCollection, Not Applicable
    Show Table : Default

    [Line : EBFVoucherNumberTo]
    Field : MediumPrompt,EBFVoucherNumberTo
    Local : Field : MediumPrompt :Info : "Voucher No.To:"

    [Field :EBFVoucherNumberTo]
    Use : Name Field
    Modifies : EBFVoucherNumberTo
    Set always : Yes
    Table : MySalesSummaryCollection, Not Applicable
    Show Table : Default


    [System : Variable]

    EBFVoucherNumberFrom : ($$SysName:NotApplicable)
    EBFVoucherNumberTo : ($$SysName:NotApplicable)

    [Variable : EBFVoucherNumberFrom]

    Type : String
    volatile : Yes
    Default : ($$SysName:NotApplicable)

    [Variable :EBFVoucherNumberTo]

    Type : String
    Volatile : Yes
    Default : ($$SysName:NotApplicable)


    [System :Formula]
    EBFIsOfSelectedVchNo:If (($$ExactMatch:##EBFVoucherNumberFrom:$$SysName:NotApplicable) OR ($$IsEmpty:##EBFVoucherNumberFrom)) AND (($$ExactMatch:##EBFVoucherNumberTo:$$SysName:NotApplicable) OR ($$IsEmpty:##EBFVoucherNumberTo)) Then yes else +
    ($$Number:$VoucherNumber >= $$Number:##EBFVoucherNumberFrom) AND ($$Number:$VoucherNumber <=$$Number:##EBFVoucherNumberTo)
     


  2. balajimg

    balajimg Active Member


    you haven't written any "compute" or "fetch" in your collection,
    from where did you get that $MRPrate
     


Share This Page