Dear Sir, cant fetch total no of invoice of particular GSTIN for the month.please help Please see the screen shot
[Collection: TSPLJsongstr2coll] Data Source:File JSON:##SVGSTR2JSONfilepath1 JSON Object Path:b2b:1 fetch: ctin,cfs,itms.*,num.*,itm_det.*,inv.*,b2b.* Fetch : *.* Client Only:Yes [Collection: TSPLGSTR2SUPLCOLL] Source Collection: TSPLJsongstr2coll fetch: ctin,cfs,itms.*,num.*,itm_det.*,inv.*,b2b.* Fetch : *.* Walk :inv;,itms;b2b; By: ctin :$ctin Compute: cfsstat:$cfs Compute: totinum:$$Number:$inv Walk :itms Walk :itm_det Aggr Compute :totinvval : Sum : $$AsAmount:$val Aggr Compute :tottxval : Sum : $$AsAmount:$txval Aggr Compute :totiamt : Sum : $$AsAmount:$iamt Aggr Compute :totcamt : Sum : $$AsAmount:$camt Aggr Compute :totsamt : Sum : $$AsAmount:$samt [Collection: TSPLsuppjsoncoll] Source Collection: TSPLJsongstr2coll fetch: ctin,cfs,itms.*,num.*,itm_det.*,inv.*,b2b.* Fetch : *.* Client Only:Yes Walk :inv ;By:inum:$inum ;Compute:ctin:$ctin Compute:val:$$AsAmount:$val Compute:idt:$idt Compute:inum:$inum Walk :itms Walk :itm_det Compute: txval :$$AsAmount:$txval Compute: iamt :$$AsAmount:$iamt Compute: camt :$$AsAmount:$camt Compute: samt :$$AsAmount:$samt [Field: TSPLSupltotinvno] Use: Namefield Set as:$totinum
[Collection: GstnWiseInvNos] Source Collection: TSPLJsongstr2coll fetch: ctin,cfs,itms.*,num.*,itm_det.*,inv.*,b2b.* Fetch : *.* Client Only:Yes Walk :inv By : ctin:$ctin By : inum:$inum [Field: TSPLSupltotinvno] Use: Namefield Set as:$$NumItems:GstnWiseInvNos
Wrong.. Sorry : Correct as follows [Collection: GstnWiseInvNos] Source Collection: TSPLJsongstr2coll fetch: ctin,cfs,itms.*,num.*,itm_det.*,inv.*,b2b.* Fetch : *.* Client Only:Yes Walk :inv By : ctin:$ctin By : inum:$inum [Field: TSPLSupltotinvno] Use: Namefield Set as:$$FilterCount:GstnWiseInvNos:CtinFilter [System : Formulae] CtinFilter : $ctin = $$ReqObj:$ctin
$$NumItems Can be used but he wanted it for a particular GSTN.. that issue was solved.. later.. [System : Formulae] CtinFilter : $ctin = $ctin but .. I expect people to take deep interest in what they are doing..
Now I want to reconcile tally data with portal data Is it possible to show both data collection in a single line? that is repeat a line with 2 collection, 1st portal data and 2nd tally data
dear sir, please provide procedure to get this tdl which u develp sir. my mail id yaggarwaloffice@gmail.com please share me this tdl or procedure to get this tdl thanks sir