Dear Experts, please guide me to fetch a particular ledger amount in a separate field My Trail code is attached here please guide me I need to fetch the Fright Advance Ledger Amount of 100 Rupees, in the below Fright Advance Field. [#Part: DBLLINE Narration] Add : Lines : After : VCH ShowStatutoryDetails : PayVchPayments [Line : PayVchPayments] Field : Medium Prompt, Amount Field;PayVchPayments Local : Field : Medium Prompt : Set as : $$LocaleString:"Fright Advance" Local : Field : Amount Field : Set as : $Amount:Ledger:$LedgerName="Fright Advance" Local : Field : Amount Field : Storage : FrightAmount Local : Field : Amount Field : Set always:Yes Invisible : NOT @@IsSales [System:UDF] FrightAmount:Amount:1994
Use $$FilterValue to get the Closing Balance of the "FRIGHT Advance" Learn FilterValue and its usage from Developer. And WHY you need a STORAGE for that value ????
Yes sir, actually I am writing a code for an auto-payment voucher for Cash to Fright Advance from the sales entry Here is the complete code please guide me sir ;;--------- Auto Payment for Purchase [#Form: Sales Color] Add : On : At End : Form Accept : Yes : CALL : PaymentVchCreate [#Object: Voucher] PayPayBillName1: $$CollectionField:$PayBillName:1:LedgerEntries PayPayBillAmt1 : $$CollectionField:$PayBillAmt:1:LedgerEntries [#Object: LedgerEntry] PayBillName : $$CollectionField:$Name:1:BillAllocations PayBillAmt : $$CollectionField:$Amount:1:BillAllocations PayVTypeName: $PayRcptVchType [Function: PaymentVchCreate] ;; Variable Block Variable : CashLedger : String Variable : CashAmount : Amount Variable : VchType : String Variable : VchCostCentre : String Variable : VchDate : Date Variable : VchNarration : String Variable : VCHAmount : Amount Variable : VCHNumber : String ; 090 : Set : CashLedger : "Cash" 100 : Set : CashAmount : $FrightAmount;$Amount:Ledger$LedgerName = "Fright Advance") 110 : Set : VchType : $$VchTypePayment 115 : Set : VchCostCentre : $AutoCostLevel 120 : SET : VchDate : $DATE 130 : SET : VCHAmount : ##CashAmount;##PayCardAmount + ##ChequeAmount + ##CashAmount 140 : SET : VchNarration : "Bill No.: " + $$String:$VoucherNumber + ", and Vehicle No: "+$$String:$BasicShipVesselNo;+ " Payment Received " ;+ $$String:##PayCardNumber 141 : Set : VCHNumber : $VoucherNumber 150 : QUERYBOX : "Create Payment Voucher ?":Yes:No 160 : IF : $$LastResult 170 : NEW OBJECT : VOUCHER 180 : SET VALUE : Date : ##VchDate 185 : Set Value : AUTOCOSTLEVEL : ##VchCostCentre 190 : SET VALUE : VoucherTypeName : ##VchType 200 : SET : SVViewName : $$SysName:AcctgVchView 210 : INSERT COLLECTION OBJECT : AllLedgerEntries 220 : SET VALUE : LedgerName : "Fright Advance";$PartyLedgerName 230 : SET VALUE : Amount : -1 * ##VCHAmount 240 : SET VALUE : Is Deemed Positive : "Yes" 250 : INSERT COLLECTION OBJECT : BillAllocations 260 : SET VALUE : Name : ##VCHNumber;;$PayPayBillName1 270 : SET VALUE : BillType : "AgstRef" 280 : SET VALUE : Amount : -1 * ##VCHAmount 290 : SET TARGET : ... ; 490 : If : NOT $$IsSysName:##CashLedger 500 : INSERT COLLECTION OBJECT : AllLedgerEntries 510 : SET VALUE : LedgerName : ##CashLedger 520 : SET VALUE : Amount : -1 * ##CashAmount 530 : SET VALUE : Is Deemed Positive : "No" 540 : SET TARGET : .. 550 : End If 551 : Set Value : Narration : ##VchNarration 560 : SET VALUE : PersistedView : ##SVViewName 570 : CREATE TARGET 580 : ENDIF [#Part: DBLLINE Narration] Add : Lines : After : VCH ShowStatutoryDetails : PayVchPayments [Line : PayVchPayments] Field : Medium Prompt, Amount Field;PayVchPayments Local : Field : Medium Prompt : Set as : $$LocaleString:"Fright Advance" Local : Field : Amount Field : Set as : $Amount:Ledger:$LedgerName="Fright Advance" Local : Field : Amount Field : Storage : FrightAmount Local : Field : Amount Field : Set always:Yes Invisible : NOT @@IsSales [System:UDF] FrightAmount:Amount:1994 ;; End-of-File
[System:Formula] cGST :$$FilterAmtTotal:LedgerEntries:cGST1:$Amount cGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST" change "cgst" to "freightxxxx" and in ur field set as@cgst and check once whether u need storage or not.....