Itemwise-SalesRoprt18082019

Discussion in 'Free Source Codes' started by ANAND J, Aug 18, 2019.

         
?

Itemwise Sales report Part no and Group Name

  1. 2

    0 vote(s)
    0.0%
  2. 2

    0 vote(s)
    0.0%
  1. ANAND J

    ANAND J New Member


    Dear Admin,

    I need your help.. how to fetch the part number , item category in this screen. I tried below line but coming


    [Field : My SalesSummaryItemPart]
    Set as: $PartNo
    Style : Small
    Display : Item Monthly Summary
    Variable : StockitemPart
    Width : 10

    [Field : My SalesSummaryItemCate]
    Set As : $StockGroupName
    Style : Small
    Display : Item Monthly Summary
    Variable : StockGroupName

    [Collection : MySalesItems]
    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : StockitemPart :$PartNo
    By : StockGroupName : $StockGroupName
     

    Attached Files:



  2. ANAND J

    ANAND J New Member


    Help me Admin....
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $PartNo:StockItem:$StockItemName
     


  4. ANAND J

    ANAND J New Member


    but Collection Line no need mention.. Why because not appearing
     


  5. Murali.R

    Murali.R Member


    [Field : My SalesSummaryItemPart]
    Set as: $PartNo:Stockitem:$Stockitemname
    Style : Small
    Display : Item Monthly Summary
    Variable : StockitemPart
    Width : 10

    [Field : My SalesSummaryItemCate]
    Set As : $Name:StockCategory:$StockCategoryName
    Style : Small
    Display : Item Monthly Summary
    Variable : StockGroupName
     


  6. ANAND J

    ANAND J New Member


    No Sir... Not Coming. Please check my below codes. I need Item Category name & Item Part Number.



    [#Menu : Gateway of Tally]
    Item : Sales Summary Item wise - ANAND : Display : My SalesSummary

    [Report : My SalesSummary]
    Form : My SalesSummary
    Variable: SVFromDate,SVToDate
    Set : SVFromDate : $$MonthStart:##SVFromdate
    Set : SVToDate : $$MonthEnd:##SVFromdate

    [Form : My SalesSummary]
    Part : MyReportTitle,My SalesSummaryTL,My SalesSummary,;Test
    Button : Change Period,Print Button,Export Button
    Bottom Part : My SalesSummaryBTM
    Background : @@SV_UNYELLOW

    [Part : MyReportTitle]
    Line : MyReportTitle


    [Line : MyReportTitle]
    Field : Simple Field
    Local : Field : Simple Field : Set As : "";
    Local : Field : Simple Field : Style : Normal Bold


    [Part : My SalesSummaryTL]
    Use : My SalesSummary
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string

    Local : Field : StockGroupName1 : Set As : "Category"
    Local : Field : My SalesSummaryItem : Set As : “Descriptipon”
    Local : Field : My SalesSummaryItemPart : Set As : “PartNoTT”
    Local : Field : MyItemsSalesQty: Set As : “Sales Qty”
    Local : Field : MyItemsSalesRate : Set As : “Avg. Rate”
    Local : Field : MyItemsSalesAmount : Set As :"Amount"
    Local :Field : Default : Style : Small Bold

    [Part : My SalesSummary]
    Line : My SalesSummary
    Repeat : My SalesSummary :MySalesItems
    Scroll : Vertical
    Total : MyItemsSalesQty,MyItemsSalesAmount



    [Line : My SalesSummary]
    Field : StockGroupName1,My SalesSummaryItemPart,My SalesSummaryItem,
    Right Field : MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount
    Border : Thin bottom



    [Field : My SalesSummaryItem]
    Set As : $Stockitem
    Style : Small
    Display : Item Monthly Summary
    Variable: StockitemName
    Border : Thin Left


    [Field : MyItemsSalesQty]
    Use : Qty Primary Field
    Style : Small
    Set As : $BilledQtyToT
    Border : Thin Left Right

    [Field : MyItemsSalesRate]
    Use : Rate Price Field
    Set as : $AmountToT / $BilledQtyToT
    Style : Small

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


    [Part : My SalesSummaryBTM]
    Use : My SalesSummary
    Delete : Repeat
    Delete : Scroll
    Delete : Total
    Border : Totals
    Local : Field : My SalesSummaryItem : Set As : “Total”
    Local : Field : MyItemsSalesQty: Set As : $$Total:MyItemsSalesQty
    Local : Field : MyItemsSalesAmount : Set As : $$Total:MyItemsSalesAmount
    Local : Field : Default : Style : Small Bold


    [Collection : MySalesSummaryCollection]
    Type : Vouchers : VoucherType
    Child of : $$VchTypeSales
    Belongs to : yes
    Fetch : Date,Inventory Entries

    [Collection : MySalesItems]
    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : Stockitem : $StockitemName
    Aggr Compute : BilledQtyToT : Sum : $BilledQty
    Aggr Compute : AmountToT : Sum : $Amount
    Fetch : Inventory Entries

    ;By : My SalesSummaryItemPart : $PartNo:StockItem:$StockItemName
    ;By : StockGroupName1 : $StockGroupName


    [Field : My SalesSummaryItemPart]
    Set as: $PartNo:Stockitem:$Stockitemname
    Style : Small
    Display : Item Monthly Summary
    Variable : StockitemPart
    Width : 10



    [Field : StockGroupName1]
    Set As : $Name:StockCategory:$StockCategoryName
    Style : Small
    Display : Item Monthly Summary
    Variable : StockGroupName
    Width : 10



    ;;By: PartyName : $PartyLedgerName
    ;;By: ItemName : $StockItemName
    ;;By : Stockitem : $StockitemName
    ;;By : StockGroupName1 : $StockGroupName
    ;;##Category
    ;;Variable : StockitemName

    ;;;END OF FILES
     


  7. ANAND J

    ANAND J New Member


    i think collection line we need to give extra line .. i dont know exact line. Admin can you give any idea...

    [Collection : MySalesItems]
    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : Stockitem : $StockitemName
    Aggr Compute : BilledQtyToT : Sum : $BilledQty
    Aggr Compute : AmountToT : Sum : $Amount
    Fetch : Inventory Entries
     



  8. [Field : My SalesSummaryItemPart]
    Set as: $PartNo:Stockitem:#MySalesSummaryItem
    Style : Small
    Display : Item Monthly Summary
    Variable : StockitemPart
    Width : 10



    [Field : StockGroupName1]
    Set As : $category:stockitem:#MySalesSummaryItem ; $Name:StockCategory:$StockCategoryName
    Style : Small
    Display : Item Monthly Summary
    Variable : StockGroupName
    Width : 10
     



  9. ;; try this
    [#Menu : Gateway of Tally]
    Item : Sales Summary Item wise - ANAND : Display : My SalesSummary

    [Report : My SalesSummary]
    Form : My SalesSummary
    Variable: SVFromDate,SVToDate
    Set : SVFromDate : $$MonthStart:##SVFromdate
    Set : SVToDate : $$MonthEnd:##SVFromdate

    [Form : My SalesSummary]
    Part : MyReportTitle,My SalesSummaryTL,My SalesSummary,;Test
    Button : Change Period,Print Button,Export Button
    Bottom Part : My SalesSummaryBTM
    Background : @@SV_UNYELLOW

    [Part : MyReportTitle]
    Line : MyReportTitle


    [Line : MyReportTitle]
    Field : Simple Field
    Local : Field : Simple Field : Set As : "";
    Local : Field : Simple Field : Style : Normal Bold


    [Part : My SalesSummaryTL]
    Use : My SalesSummary
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string

    Local : Field : StockGroupName1 : Set As : "Category"
    Local : Field : My SalesSummaryItem : Set As : “Descriptipon”
    Local : Field : My SalesSummaryItemPart : Set As : “PartNoTT”
    Local : Field : MyItemsSalesQty: Set As : “Sales Qty”
    Local : Field : MyItemsSalesRate : Set As : “Avg. Rate”
    Local : Field : MyItemsSalesAmount : Set As :"Amount"
    Local :Field : Default : Style : Small Bold

    [Part : My SalesSummary]
    Line : My SalesSummary
    Repeat : My SalesSummary :MySalesItems
    Scroll : Vertical
    Total : MyItemsSalesQty,MyItemsSalesAmount



    [Line : My SalesSummary]
    Field : StockGroupName1,My SalesSummaryItemPart,My SalesSummaryItem,
    Right Field : MyItemsSalesQty,MyItemsSalesRate,MyItemsSalesAmount
    Border : Thin bottom



    [Field : My SalesSummaryItem]
    Set As : $Stockitem
    Style : Small
    Display : Item Monthly Summary
    Variable: StockitemName
    Border : Thin Left


    [Field : MyItemsSalesQty]
    Use : Qty Primary Field
    Style : Small
    Set As : $BilledQtyToT
    Border : Thin Left Right

    [Field : MyItemsSalesRate]
    Use : Rate Price Field
    Set as : $AmountToT / $BilledQtyToT
    Style : Small

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


    [Part : My SalesSummaryBTM]
    Use : My SalesSummary
    Delete : Repeat
    Delete : Scroll
    Delete : Total
    Border : Totals
    Local : Field : My SalesSummaryItem : Set As : “Total”
    Local : Field : MyItemsSalesQty: Set As : $$Total:MyItemsSalesQty
    Local : Field : MyItemsSalesAmount : Set As : $$Total:MyItemsSalesAmount
    Local : Field : Default : Style : Small Bold


    [Collection : MySalesSummaryCollection]
    Type : Vouchers : VoucherType
    Child of : $$VchTypeSales
    Belongs to : yes
    Fetch : Date,Inventory Entries

    [Collection : MySalesItems]
    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : Stockitem : $StockitemName
    Aggr Compute : BilledQtyToT : Sum : $BilledQty
    Aggr Compute : AmountToT : Sum : $Amount
    Fetch : Inventory Entries

    ;By : My SalesSummaryItemPart : $PartNo:StockItem:$StockItemName
    ;By : StockGroupName1 : $StockGroupName


    [Field : My SalesSummaryItemPart]
    Set as: $PartNo:Stockitem:#MySalesSummaryItem
    Style : Small
    Display : Item Monthly Summary
    Variable : StockitemPart
    Width : 10



    [Field : StockGroupName1]
    Set As : $category:stockitem:#MySalesSummaryItem ; $Name:StockCategory:$StockCategoryName
    Style : Small
    Display : Item Monthly Summary
    Variable : StockGroupName
    Width : 10



    ;;By: PartyName : $PartyLedgerName
    ;;By: ItemName : $StockItemName
    ;;By : Stockitem : $StockitemName
    ;;By : StockGroupName1 : $StockGroupName
    ;;##Category
    ;;Variable : StockitemName

    ;;;END OF FILES
     


  10. balajimg

    balajimg Member


    it should be as follows

    [Collection : MySalesItems]
    Source Collection : MySalesSummaryCollection
    Walk : Inventory Entries
    By : Stockitem : $StockitemName
    Compute : ItemPartNo : $PartNo:StockItem:$StockItemName
    Compute : ItemCategory : $Category:StockItem:$StockItemName
    Aggr Compute : BilledQtyToT : Sum : $BilledQty
    Aggr Compute : AmountToT : Sum : $Amount
    Fetch : Inventory Entries

    and in field levels as follows

    [Field : My SalesSummaryItemPart]
    Set as: $ItemPartNo
    Style : Small
    Display : Item Monthly Summary
    Variable : StockitemPart
    Width : 10



    [Field : StockGroupName1]
    Set As : $ItemCategory
    Style : Small
    Display : Item Monthly Summary
    Variable : StockGroupName
    Width : 10
     


  11. ANAND J

    ANAND J New Member



  12. ANAND J

    ANAND J New Member


    Dear Admin....

    I tried so many lines... how to add the altf12 and controlf12 button.....in this report.
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Add the Buttons in [Form : My SalesSummary] ........... FilterButton and ValueButton
     
    ANAND J likes this.


  14. ANAND J

    ANAND J New Member


    Super Admin..
    I Checked ControlF12 Value Button is working good. But AltF12 not working (Range Button) its coming blank).
    I am searching more than 2Hrs Admin :(..
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    the default AltF12 and CtrlF12 will be active, based on the variable of the reports and the objects contained therein.

    If the Objects and Variable are not pertinent, then it will not be active.
     


  16. ANAND J

    ANAND J New Member


    Ok Admin.I dont have that much idea for Objects and Variables.
    But i need one button for Item Group Filter.
    So give me idea for that .. already i added the button but i don't know the Item Group Filter Line...
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    That button will not work for your code, as there is no link.....to perform any search/filter on your code.

    And since you do not know much about Objects and Variables, implementing the same in your code will be complicated for you.

    Easy way would be to make your own button for search/filter operations. There are few codes on customized search buttons existing in this forum..........find that code, learn and understand it and then you can implement the same within your code.
     


Share This Page