How To auto entry fixed discount in field....

I want to fixed amount to discount by my calculation... anybody guide me...

 

[#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 you for continue support Mr Mahbu...

I am Using ERP 9 ... its not working

video file is added

 

TODAY I CHECKED ERP ALSO IT IS WORKING ME
Please check your code as per attached picture

 

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...

 

The discount value less from total amount... but it add the amount. please guide me...

 

Hi Mr.Udaya
just change formula as per your criteria

 

Your grate Support Is Like a teacher.... thanks lot..... mahbu... thanks once again....

 

Your grate Support Is Like a teacher.... thanks lot..... mahbu... thanks once again....