Ei value not comming ledger amount

Discussion in 'Requests' started by Murali.R, Nov 27, 2023.

    
  1. Murali.R

    Murali.R Member


    My Collection :

    [Collection: MLedgerentries]
    Type : MriTransDetails: voucher
    Childof : ##IsSales
    Fetch : MrdTranWt,MrdTranHalt,MrdTranUload
    BelongsTo : Yes

    My Field :

    [#Field: EI Value]
    Option : MRDEI Value : @@IsSales and @@VTYPTransAct

    [!Field: MRDEI Value]
    Type:Amount: Forced
    Set By Condition : $Ledgername= "Frieght Charges" :mad:ValedTotamt
    Set By Condition : #EiAccDesc= "Unloading Charges" :mad:TotUnloadamt
    ValedTotamt: $$CollAmtTotal:MLedgerentries:$MrdTranFrite
    TotUnloadamt:$$CollAmtTotal:MLedgerentries:$MriULadAmt
    ;Set Always: Yes

    My Frieght charges EI Value Coming Correct but my "Unloading Charges" ledger Ei Value Not Comming please guid developers
     


  2. Murali.R

    Murali.R Member



  3. Murali.R

    Murali.R Member



  4. Rishi kumar

    Rishi kumar Member


    Sir did u get the solution of your problem ?
    I have also the same problem
     


  5. Access

    Access Member


    Try This

    Code:
    [Collection: MLedgerentries]
        Type : MriTransDetails: voucher
        Childof : ##IsSales
        Fetch : MrdTranWt,MrdTranHalt,MrdTranUload,MriULadAmt
        BelongsTo : Yes
    
    [#Field:EI Value]
        Option : MRDEI Value : @@IsSales and @@VTYPTransAct
       
    [!Field:MRDEI Value]
        Add:Set By Condition : $$InCreateMode And $$InAlterMode Or($Parent:Ledger:$LedgerName="Indirect Incomes" and $Narration:Ledger:$LedgerName="Frieght Charges" ) :@FrieghtAmt
        Add:Set By Condition : $$InCreateMode And $$InAlterMode Or($Parent:Ledger:$LedgerName="Indirect Incomes" and $Narration:Ledger:$LedgerName="Unloading Charges" ) : @Unloadamt
        Local Formula:FrieghtAmt: $$CollAmtTotal:InventoryEntries:$MrdTranFrite
        Local Formula:Unloadamt : $$CollAmtTotal:InventoryEntries:$MriULadAmt
       
    [#Field:CIValue]
        Option : MRDCI Value : @@IsSales and @@VTYPTransAct
       
    [!Field:MRDCI Value]
        Add:Set By Condition : $$InCreateMode And $$InAlterMode Or($Parent:Ledger:$LedgerName="Indirect Incomes" and $Narration:Ledger:$LedgerName="Frieght Charges" ) :@FrieghtAmt
        Add:Set By Condition : $$InCreateMode And $$InAlterMode Or($Parent:Ledger:$LedgerName="Indirect Incomes" and $Narration:Ledger:$LedgerName="Unloading Charges" ) : @Unloadamt
        Local Formula:FrieghtAmt: $$CollAmtTotal:InventoryEntries:$MrdTranFrite
        Local Formula:Unloadamt : $$CollAmtTotal:InventoryEntries:$MriULadAmt
     


  6. sivam

    sivam Active Member


    [!Field: MRDEI Value]
    Type:Amount: Forced
    Set By Condition : $Ledgername= "Frieght Charges" :mad:ValedTotamt
    Set By Condition : $Ledgername= "Unloading Charges" :mad:TotUnloadamt
     


Share This Page