NOT FETCHING VALUE FROM SUBFORM

Dear Expert,
I have created a subform and attached to it a particular Ledger "Courier Income" under Direct Income.
when I select Courier Income led in sale vch (Acct.Inv. Mode) sub form open and insert value in different field.
I called "Courier Income" Led Amount from sub Form Field : Amount
code is Below.
[#Field:EI VALUE]
Add: Set By Condition@courierLED : @@awbINVOICEaMOUNT

[System:Formula]
AWBINVOICEAMOUNT:$$CollNumTotal:AwbDetailsColl:$AwbAmount
courierLED: $LEDGERNAME CONTAINS "COURIER Income"



AwbDetailsColl: Aggregrate UDf of Sub Form

when I called another sub form Field value for another Ledger ,value is not coming.

[#Field:EI VALUE]
Add: Set By Condition@COVID@INVCOVIDVALUE

[System:Formula]
INVCOVIDVALUE:$$CollAmtTotal:AwbDetailsColl:$AwbCovid
COVID: $LEDGERNAME CONTAINS "COVID"

pls see the attached Image

pls advice

Thanks & Regards
Rishi

 

Etna sannata kyu hai Bhai.. .

 

Maine aapka ye sub form try kiya
Lekin 2 se 3 ghante dhundhne pr bhi abhi tak solution nahi mila bhai.


1st ledger ke baad sub form open hota hai. Us sub form se koi bhi value usi line me courier wale ledger ke liye to aa jati hai.

Lekin next ledger covid ke liye nhi .
Wo courier wale ledger ka jo sub form se catch nahi kar raha hai.
.


Try kiya bhai....Lekin solution nhi mila.


Default tally me is tarah ka kahi bhi koi sub form aur uski value main voucher me aai hui hai kya. ???

 

Bilkul thek kaha....yahi to Bhai customisation hai...default me hota to copy ker leta isko

Kisi or se poocho..

 

Bhai mujhe function nahi aata hai .. function aata to an tak solve kar chuka hota. ..tumhe aata hai function create karna. ?

 

Nahi

Function se kya karte koi idea.

Jese
Function run hone pr
Phle
Ye.......... krta

Fir
Ye. ....... Krta.

Fir
Ye......

Fir
Jo result aata
Usko
Use karte.

 

Bhai function se sab ho jata hai . Bas function aache se aana chaheye..
Self Study kiye ho ya kahin se sikhe ho..
Mera to self Study hai tabhi dikkat aate rehte hai..

 

Hum bhi aap jaise hi study kiye hue hai.
Self

 

Ref .book pdf chaheye ya hai tmhare pass.

Kisse pade ho?

 

Tdl manual ref.
PDF hai. .bhai

 

Total kitne page hai pdf me.
Apni email id do tmhe esse badiya Study material deta hun...

 

hi Rishi kumar sir

please send me the Pdf material to my mail id : ravi4u.5577@gmail.com

 

Check your email

 

Thank you so much Rishi sir for sending me the Updated Latest material

 

;Dear experts will any one help me
;with the below tdl - tonnage qty - Billed QTy total is not fetching in the report
;screen shot is enclosed herewith.


[#MenuISPLAY MENU]
Add: Item: Sreenidhi Reports:Menu:despatch report
[Menu:despatch report]
Title:" REPORTS"
Add: Item: Vehicles Reports:display:despatch report
Add: Item: Item Wise Sales Summary isplay: ProductwiseRpt
[Report:despatch report]
Form:despatch report


[Form:despatch report]
Button : F2Change Period
Height:100% page
Width:100% page
Background:released Green
Part:despatch report


[Part:despatch report]
Line:despatch reporttitle,despatch report
Repeat:despatch report :vchcoll
;Repeat:despatch report:vchcoll

Scroll:Vertical
Common Border:Yes
[Line:despatch reporttitle]
Use:despatch report
Local:Field:default:Align:Centre
Local:Field:default:Type:String
Local:Field:default:Background:Released brown

Local:Field:srno:Set as:"S No"
Local:Field:vhdt:info :"Vch Date"
Local:Field:vchno:set as :"Voucher No"
Local:Field:vchrtype:set as :"Voucher Type"
Local: Field:vchparty:Set as:"Party Name "
Local:Field:vehdet:Set as:"Vehicle Details"
Local:Field:billoflad:Info:"Bill of Lading"
Local:Field:tonnage:info:"Tonnage"
Local:Field:invtot:info:"Inv Total"
Border:column titles

[Line:despatch report]
Field:srno,vhdt,vchno,vchrtype,vchparty,vehdet,billoflad,tonnage
Right Field:invtot
Border:thin bottom right
Option:alter on enter


[Field:srno]
Use:name field
Set as: $$line
Width:5
Border:thin right
Align:Center
[Field:vhdt]
Use: uni date field
Set as: $Date
Width:12
Border:thin right
Align:Center
[Field:vchno]
Use:name field
Set as:$VoucherNumber
Width:12
Border:thin right
Align:Center
[Field:vchrtype]
Use:name field
Set as:$Vouchertypename
Width:12
Border:thin right
Align:Center
[Field:vchparty]
Use:name field
Set as:$LedgerName
Width:50
Border:thin right

Alter : Voucher
[Field:vehdet]
Use: name field
Set as:$BasicShipVesselNo
Width:18
Border:thin right
Align:Centre

[Field:billoflad]
Use: Short Name Field
Set as:$BillofLadingNo
Width:30
Border:thin right


[Field:tonnage]
Use: Qty Primary Field
Set as:$Billqty

Width:20
Border:thin right

[Field:invtot]
Use: Amount Field
Set as:$Amount
Width:15
Border:thin right
[Collection:vchcoll]
Type:voucher
Fetch:VoucherNumber,StockItemName,PartyLedgerName,BilledQty,VoucherTypeName,VoucherDate,BasicShipVesselNo,BillofLadingNo,InventoryEntries.*
Filter:mysalesfilter
[System:Formula]
mysalesfilter:$$IsSales:$Vouchertypename

[Collection :StkVouchers]
Source Collection : vchcoll
Walk : Inventory Entries
By : VoucherNumber : $VoucherNumber
Aggr Compute : Billqty : Sum : $BilledQty
Fetch:VoucherNumber,LedgerName,BilledQty,VoucherTypeName,VoucherDate,BasicShipVesselNo,BillofLadingNo,Amount
Keep Source : No

 

Dear,



[Field:tonnage]
Use: Qty Primary Field
;;Set as:$Billqty
Set as : $billedqty
Width:20
Border:thin right

 

SIR
Tried but not working