How to get value immediately

Dear sir,
I have attached a subform in sale vch ( accounting inv mode) when a particular ledger selected then subform will open.
Subform is open correctly and the amount we insert in subform , coming on EI value field in voucher . Problem is when I insert value in subform and exit from subform value not come .I want to go back on ledger , subform open and exit from subform then value appear on EI VALUE field.
How to fix this problem pls advice.


What i did.
To add subform

[#FIELD:EI ACC DESC]
ADD:SUBFORM: AWB DETAILS@CLEDNAME

[# FIELD: EI VALUE]
SETAS: IF @@COURIERLED THEN @@AWBINVOICE ELSE @ROUNDEDVAL

[ SYSTEM: FORMULA]
Awbinvoice: $$collamttotal: AWBDETAILSCOLL: $AWBTOTAL
COURIERLED: $LEDGERNAME contains "courier"

 

Hello Sir,,
Half code mai nahi Samjega Kuch Subfrom mai kya likha ye nahi samjega..

 

Here is the full code sir,

[#Field: EI AccDesc]
Add: Sub Form:Awb Details@cLedName

[Report:Awb Details]
Form:Awb Details
Title: "Awb Details"
Object: Voucher

[Form:Awb Details]
Part: Form Subtitle, Awb Part
Local:Field:FormSubtitle:Info:$$LocaleString:"AWB Details of " + ":" + $PartyLedgerName
Full Height:Yes
Full Width:Yes

[Part:Awb Part]
Lines: Awb Title Line, Awb Details Line
;; Bottom Line:Awb Total Line
Repeat:Awb Details Line: Awb Details Coll
Common Border:Yes
Scroll:Vertical
Float: No
Border : Thin Box
Total: Awb Total
Break On: $$IsSysName:$AwbAwbNo

[Line:Awb Title Line]
Use:Awb Details Line
Local:Fieldefaultelete:Storage
Local:Fieldefaultelete:Set as
Local:Fieldefaultelete:Inactive
;;Local:Fieldefaultelete:Use
;;Left Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
;;Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
Local : Field : Default : Type: String
;;Local : Field : Default : Style: Small Bold
Local : Field : Default : Align: Centre
Local : Field : Default : Skip : Yes
Local: Field: Awb Sl:Set as:$$LocaleString:"SL.No"
Local:Field:Awb Awb No :Set as:$$LocaleString:"AWB No."
Local:Field:Awb Date: Set as:$$LocaleString:"Date"
Local:Field:Awb Destination:Set as:$$LocaleString:"Destination"
Local:Field:Awb Network:Set as:$$LocaleString:"Network"
Local:Field:Awb Ds:Set as:$$LocaleString:"D/s"
Local:Field:Awb Weight:Set as:$$LocaleString:"Weight"
Local:Field:Awb Amount:Set as:$$LocaleString:"Amount"
Local:Field:Awb Covid:Set as:$$LocaleString:"Covid-19"
Local:Field:Awb FSC:Set as:$$LocaleString:"FSC"
Local:Field:Awb Total:Set as:$$LocaleString:"Total"
Border: Thin bottom

[Line:Awb Details Line]
;; Fields: Awb Sl, Awb Awb No, Awb Date, Awb Destination, Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
Local: Field: Default: Align: Centre
[Field:Awb Sl]
Use: Number Field
Set as:$$Line
Width: 3
;;Style: Small
Border : Thin Right
Skip:Yes

[Field:Awb Awb No]
Use: Name Field
Storage:AwbAwbNo
Width:15
Border: Thin Right
Table: AWB List Coll, End of List
Show Table:Always
Set Always:Yes
Unique:Yes

[Field:Awb Date]
Use: Name Field
Storage:AwbDate
;;Style:Small
Width:10
Border:Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Set as:$$Table:AwbAwbNo:$AWBILLDate

[Field:Awb Destination]
Use: Name Field
Storage:AwbDestination
;;Style:Small
Border: Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Set as:$$Table:AwbAwbNo:$Dest

[Field: Awb Network]
Use: Name Field
Storage:AwbNetwork
;;Style:Small
Border: Thin Right
;;Width:10
Inactive:$$IsEnd:$AwbAwbNo
Set as:$$Table:AwbAwbNo:$NETWORK

[Field:Awb Ds]
Use: Name Field
Storage:AwbDs
;; Style:Small
Border: Thin Right
Width:10
Inactive:$$IsEnd:$AwbAwbNo

[Field:Awb Weight]
Use: Name Field
Storage:AwbWeight
;;Style:Small
Border: Thin Right
Width:10
Inactive:$$IsEnd:$AwbAwbNo
Set as:$$Table:AwbAwbNo:$Weight
[Field:Awb Amount]
Use: Name Field
Storage:AwbAmount
;; Style: Small
Border: Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Set as: $$Table:AwbAwbNo:$CAmount
Formatecimal:2

/*[Field:Awb Covid]
Use: Amount Forex Field
Storage:AwbCovid
;;Style: Small
Border: Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Formatecimal:2

[Field:Awb FSC]
Use:Amount Forex Field
Storage:AwbFSC
;;Style: Small
Border: Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Formatecimal:2*/

[Field: AwbTotal ]
Use: Number Field
Set as:#AwbAmount ;;#AwbAmount+#AwbCovid+#AwbFSC
Storage:AwbTotal
;; Style: Small
Border: Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Formatecimal:2
Skip:Yes
;;Set Always:Yes

[Line: Awb Total Line]
Fields :Awb Sl, Awb Awb No, Awb Date, Awb Destination
Right Fields:Awb Network, Awb Ds, Awb Weight, Awb Amount, Awb Covid, Awb FSC, Awb Total
Local:Fieldefaultelete:Storage
Local:Fieldefaultelete:Set as
Local:Fieldefaultelete:Inactive
Local:Field:default:Skip:Yes
Local:Field:Awb Sl:Set as:""
Local:Field:Awb Sl:Format:"nozero"
Local:Field: AwbAwbNo:Set as:$$LocaleString:"Totals"
Local:Field: AwbAwbNoelete:Table
Local:Field:AwbTotal:setas:$$total:AwbTotal
Local:Field: AwbFSC:Set as:""
Local:Field: Awbcovid:Set as:""
Local:Field: AwbAmount:Set as:""
Local:Field: Awbweight:Set as:""
Local:Field: Awb Ds:Set as:""
Local:Field: AwbNetwork:Set as:""
Local:Field: AwbDestination:Set as:""
Local:Field: AwbDate:Set as:""
Border:Thick Top



[System: UDF]
AwbAwbNo : String: 41002
AwbTotal: Number:31002
AwbFSC: Amount:31003
AwbCovid:Amount:31004
AwbAmount:String:31006
AwbWeight:String:31005
AwbDs:String:31007
AwbNetwork:String:31008
AwbDestination:String:31009
AwbDate:String:31011
AwbDetailsColl:Aggregate:31012
;; AwbTotalH:Amount:31013


[#Field:EI VALUE]
add: Set By Condition@courierLED @awbINVOICEaMOUNT ;;IF @@courierLED THEN @@awbINVOICEaMOUNT ELSE @RoundedVal


[System:Formula]
awbINVOICEaMOUNT:$$CollAmtTotal:AwbDetailsColl:$AwbTotal
courierLED: $LEDGERNAME CONTAINS "COURIER"

 

Dear friend

Use: number field

 

Ok i do it

 

nothing happen
see screen shot...
where i want amount is not reflecting but in vch total field (in last) amount is reflecting.
amount will come whwn i go back to courier (Led Name) then enter enter just like refresh.
pls solve this issue.

 

;Ye agar Number Field Hai.. To.
;$$CollAmtTotal ki Jagah $$CollNumTotal Use Karo

[Field: AwbTotal ]
Use: Number Field
Set as:#AwbAmount ;;#AwbAmount+#AwbCovid+#AwbFSC
Storage:AwbTotal
;; Style: Small
Border: Thin Right
Inactive:$$IsEnd:$AwbAwbNo
Formatecimal:2
Skip:Yes
;;Set Always:Yes


[#Field:EI VALUE]
add: Set By Condition@courierLED @awbINVOICEaMOUNT ;;IF @@courierLED THEN ($$AsAmount@awbINVOICEaMOUNT) ELSE @RoundedVal


[System:Formula]
awbINVOICEaMOUNT:$$CollNumTotal:AwbDetailsColl:$AwbTotal
courierLED: $LEDGERNAME CONTAINS "COURIER"

 

Gr8 bro...thanks a lot. Ho gya....
Karte karte hi aayega....

 

One more query bro pls advice

I have to create a invoice format with 2 pages. First page belong to summary and second page belong to details of first page. I mean to say every invoice would be 2 pages. First page i create but the second page how i create.
Pls advice.

 

Thanks Bhai.. .

 

Bhai jaise tumne btaya tha waise hi kiya magar 2nd page add nahi Hua..
Are u sure aise hi hoga...

 

Try This
;-----
[#Form : Printed Invoice]
delete : Form
Add : Form : Form Page 1
Add : Form : Form Page 2

 

Tried
Default with my invoice

See images

 

Bhai tumhara jitna dhanyawad kiya jaye utna kam hai..

Ho gya Bhai..

 

Bhai tumhara bhi dhanyawad...
Bas ak mistake ho gaye warna tum sahi the.
Add: print : report name Ki jagah
Report def me add form kar dete to ho jata.. .

 

Bhai ak ledger hai under direct income group eska hsn code define kiya hai.
Magar hsn code fetch nahi ho raha hai bahut try kiya ..esko bhi dekho..

 

abhi to me bahar aa gya hu.

Iska jugad yh ho skta hai.

Ledger master me
Apna udf add kar do
Fir
Us ledger ko alter karke
Apne udf field me hsn add kar do

Aur us udf ki value apni report me la skate ho.

 

Baat tmhare sahi hai mgr ak jagah feed hai to wahi se liya jaye to teek hai.

 

Is image me jis tarah party ka gstno aayega

Usi tarah hsn no. Bhi aayega

 

Nahi mere Bhai.gstn no easy aa jayega.
Mgr hsn code ka coll. Alag hai storage alag hai..
Tum ak ledger bnao under direct income. Or gst applicable kar ke hsn feed karo..

 

;Try This
GSTHSNCode : $$GetInfoFromHierarchy:$Name:"Ledger":"HSNCode"@VchDate:"GST"

 

Nahi aaya

Bro Maine sales voucher (acc vch mode)
Me ak sub form bnaya or usko main income ledger se add kar diya.
Es subform me kaie udf hai.
En udf ko kaise object me add kare taki
Sale vch ka coll bnake enki value report me fetch ho sake.
Udf list
[System: UDF]
AwbAwbNo : String: 41002
AwbTotal: Number:31002
AwbFSC: Amount:31003
AwbCovid:Amount:31004
AwbAmount:String:31006
AwbWeight:String:31005
AwbDs:String:31007
AwbNetwork:String:31008
AwbDestination:String:31009
AwbDate:String:31011
AwbDetailsColl:Aggregate:31012
;; AwbTotalH:Amount:31013

 

My dear friend
Here
Your issue solution

Visit here

http://tdlexpert.com/index.php?thre...-subform-on-a-sales-voucher.11751/#post-48862

 

Bhai Mai esko dekh chuka hun
Mere value nahi aa rahi hai.

[Collection: AWB inv summary]
Type: vouchers: voucher type
Childof: $$vchtypesales
Belongto: yes

[ collection: awb summary coll]
Source collection: AWB inv summary
Walk : AWB details coll
Fetch: awbawbno

Btao kahan galti hai..