[#Field: EI Value] use: Amount Forex Field Set as: If $LedgerName = "Discount" Then "-" + (#OTSCGSTAmt + #OTSSGSTAmt) Else ""
use like this is better Set By Condition : @IsMyDiscountLed : $$Negative#OTSCGSTAmt + #OTSSGSTAmt) IsMyDiscountLed : $LedgerName = "Discount"
Mahbu thanks lot ..... but like below not working (it not getting Auto Value).... please .... support [#Field: EI Value] Set By Condition : @IsMyDiscountLed : $$Negative:#OTSCGSTAmt + #OTSSGSTAmt IsMyDiscountLed : $LedgerName = "Discount"
What is the Nature of Ledger "OTSCGS" + and "OTSSGST" ? you can make formula like ($Taxtype:Ledger:$LedgerName="Others") then :$AllLedgerEntries[1,@@Formula].LedgerEntries.Amount
Sorry.... Mr. Mahbu.... [#Field: EI Value] Set By Condition : @IsMyDiscountLed : $$Negative:#CGSTAmt + #SGSTAmt IsMyDiscountLed : $LedgerName = "Discount" What is the Field name and how set condition.... thank advance
[#Field: EI Value] Set By Condition : If @IsMyDiscountLed then $$Negative:@CGST + $$NegativeSGST Else "" IsMyDiscountLed : $LedgerName = "Discount" SGST :$$FilterAmtTotal:LedgerEntries:SGSTLed:$Amount SGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGSTLed:$Amount CGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"
Thanks Murali sir.... err at formula Showing.... when Open Sales Voucher... please Guide me..... [#Field: EI Value] Set By Condition : If @IsMyDiscountLed then $$NegativeCGST + $$NegativeSGST Else "" IsMyDiscountLed : $LedgerName = "Discount" SGST :$$FilterAmtTotal:LedgerEntries:SGSTLed:$Amount SGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGSTLed:$Amount CGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"
Try this [#Field: EI Value] Set By Condition : @@IsMyDiscountLed : $$Negative@CGST + $$Negative@SGST [System:Formula] IsMyDiscountLed : $LedgerName contains "Discount" SGST :$$FilterAmtTotal:LedgerEntries:SGSTLed:$Amount SGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGSTLed:$Amount CGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"
Thanks lot Mahbu... Its Working Fine ... one issue how the value Should Less (-25.48) as in tally (-)25.48 please....
Try this [#Field: EI Value] Set By Condition : @@IsMyDiscountLed : $$Negative@CGST + $$Negative@SGST Control : MydiscountValue : @@IsMyDiscountLed and (@@CGST+@@SGST) < #EIValue [System:Formula] IsMyDiscountLed : $LedgerName contains "Discount" SGST :$$FilterAmtTotal:LedgerEntries:SGSTLed:$Amount SGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST" CGST :$$FilterAmtTotal:LedgerEntries:CGSTLed:$Amount CGSTLed :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST" MydiscountValue : "Morethan SGSST+CGST not allowed"
Mr. Mahbu Above code is working Same as Previous Code. I what Discount amount as (-)15.24. The code Give as 15.24. (means Plus Value)... Please Give me this Solution...