GSTR-2 PORTAL JSON DATA IN TALLY

Discussion in 'Tally Integration' started by sattam, Feb 11, 2020.

    
  1. sattam

    sattam Active Member


    Dear Sir,
    cant fetch total no of invoice of particular GSTIN for the month.please help

    Please see the screen shot
     

    Attached Files:



  2. Jenny

    Jenny Active Member


    can u post your code?
     


  3. sattam

    sattam Active Member


    [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
     


  4. sattam

    sattam Active Member


    Please rectify my collection to fetch total no of invoice of particular GSTIN for the month
     


  5. Jenny

    Jenny Active Member


    post your full code here or send me my email id - kissudears@gmail.com
     


  6. Jenny

    Jenny Active Member


    try this way ....
    Aggr Compute : TotalCnt : Sum : $TotalNofovouchers
     


  7. sattam

    sattam Active Member


    not working
     


  8. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    [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
     


  9. sattam

    sattam Active Member


    Untitled.png
     


  10. Jenny

    Jenny Active Member



  11. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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
     


  12. sattam

    sattam Active Member


    I can't share full code Jenny ji
     


  13. sattam

    sattam Active Member


    Not getting Perfect result.may be there is some mistake in my end
     


  14. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Have you tried this simple method

    $$Numitems:yourcollection
     


  15. Devendra_Rawat

    Devendra_Rawat Well-Known Member


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


  16. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Got it Sir
    Mail recd yesterday late night
    Forgot to Delete post.
     


  17. sattam

    sattam Active Member



  18. sattam

    sattam Active Member



  19. sattam

    sattam Active Member



  20. sattam

    sattam Active Member


    Many many thanks to Jay kumar Tailor and Devendra(Garima) ji for giving me valuable advice
     
    Last edited: Feb 15, 2020


  21. sattam

    sattam Active Member


    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
     


  22. sattam

    sattam Active Member


    Please give me some clue how I do this
     


  23. Damodaran

    Damodaran New Member


    How to get 2A Month from json
     


  24. Yash@82872

    Yash@82872 New Member


    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
     


Share This Page