Could someone help me with this code

Discussion in 'Free Source Codes' started by ANURAG954245, Dec 26, 2022.

    
  1. ANURAG954245

    ANURAG954245 Member


    [#LINE:VCHNARRATION]
    Add:Field:After:VCHNARRATION:TOTALTOPS

    [Field:TOTALTOPS]
    Use : Qty Primary Field
    Set By Condition: @@TOTALTOP
    Set always : Yes
    Skip : Yes
    Style : Normal
    Border:TOTALS


    [System:Formula]
    TOTALTOP :$$FilterQtyTotal:TOTALTOP:TOPPARENT:$SGQTy
    TOPPARENT :$SGNAME= "TOP"


    [Collection:TOTALTOP]
    Source Collection:..
    Walk:All Inventory ENtries
    By:SGName : $Parent:StockItem:$StockItemName
    Aggr Method:SGQTy : Sum: $BilledQty
     


  2. narayane88

    narayane88 Active Member


    State What is error
     


  3. ANURAG954245

    ANURAG954245 Member


    not able to get the value
     


  4. narayane88

    narayane88 Active Member


    first compute SGNAME this value in collection. when use aggregate method convert in Qty in Number. if primery collection not work then use secoudry collection source of primery collection then fetch intial value from Primery collection then try and
     


  5. Sanjeev S

    Sanjeev S Active Member


    Try this ....

    Code:
    [#LINE:VCHNARRATION]
    Add:Field:After:VCHNARRATION: TOTALTOPS
    
    [Field:TOTALTOPS]
    Use : Qty Primary Field
    Set as    :    @@GrpQty
    Set always : Yes
    Skip : Yes
    Style : Normal
    Border:TOTALS
    
    
    [System:Formula]
    GrpFilter            :    $Parent:StockItem:$StockItemName containing "Top"
    GrpQty                :    $$FilterQtyTotal:InventoryEntries:GrpFilter:$BilledQty
    
    
     



  6. Try this Parent Group & Till Group Explode

    [#LINE:VCHNARRATION]
    Add:Field:After:VCHNARRATION:TOTALTOPSTillAllExp,TOTALTOPS

    [Field:TOTALTOPSTillAllExp]
    Use : Qty Primary Field
    Set as: @@TOTALTOPExplevel
    Set always : Yes
    Skip : Yes
    Style : Normal
    Border:TOTALS
    Background: Red

    [Field:TOTALTOPS]
    Use : Qty Primary Field
    Set as : @@TOTALTOPParent
    Set always : Yes
    Skip : Yes
    Style : Normal
    Border:TOTALS
    Background: Green

    [System:Formula]

    TOTALTOPExplevel : $$FilterQtyTotal:InventoryEntries:TOPPARENTExplevel:$BilledQty
    TOTALTOPParent : $$FilterQtyTotal:InventoryEntries:TOPPARENT:$BilledQty
    SGName : $Parent:StockItem:$StockItemName
    TOPPARENTExplevel : $$IsObjectBelongsTo:StockGroup:mad:@SGName:"Top" ;;; Till all explode level of 'Top' Group
    TOPPARENT : $Parent:StockItem:$StockItemName = "Top" ;;; Parent Group Total
     


  7. udaya

    udaya Active Member

    Sanjeev S likes this.


  8. ANURAG954245

    ANURAG954245 Member


    thank you everyone for helping me out
     


Share This Page