GSTR2 Viewer with Party Summary and Bills

Discussion in 'Free Source Codes' started by garima, Feb 17, 2020.

         
  1. garima

    garima Active Member


    It is set to work for purchases only.
     


  2. Jenny

    Jenny Active Member


    tell me how to fetch taxable value?
     


  3. garima

    garima Active Member


    send me tally data and json...
     


  4. Jenny

    Jenny Active Member


    where to send tally data ? here its not possible
     


  5. garima

    garima Active Member


    email id ;
    Tally data and json file for both gstr2 and gstr1 as I do not have matching data
     


  6. Jenny

    Jenny Active Member


    i send u in email..just check
     


  7. Jenny

    Jenny Active Member


    i sending u another tally data..just check your email
     


  8. garima

    garima Active Member


    Try

    Code:
    Aggr Compute :txval : Sum : If NOT @@IsGSTDutyLed then  $GStAssesableValue else 0
     
    Jenny likes this.


  9. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    can 2 or more .json files can be merged to view in Tally?
     

    Attached Files:



  10. garima

    garima Active Member


    why not..:):)

    you can do it.. I mean , I know you can do it boss.

    if for view purpose then list variable as data source and function to handle it would do the job
     
    Last edited: Feb 20, 2020


  11. Jenny

    Jenny Active Member


    how to fetch gst rate?
     


  12. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    Sir, tried but not comfortable with 'list variable' and related functions, it will be helpful if a sample is available, the purpose is to load month wise .json files simultaneously.
     


  13. garima

    garima Active Member


    Example;; Purely example
    [Function : AddDatatoListVariable]

    100 : List Delete Ex: RCD_Tracks
    110 : Walk Collection: SelecteDJasonFilesColl
    ;;;120 : Here set your jsaonfilepath
    130 : Call: ListFillTracks; this will add data to list varialbe
    140: End Walk


    Code:
    [Collection    : RCD_TrackNos SrC]  ; this will make your list variable as collection
        Data Source: Variable: RCD_Tracks
        Fetch    : *
      
    [Object    :RCD_Tracks]  
        [Object    : RCD_TrckItems]
      
    
    [System        : Variables]
        List Variable     : RCD_Tracks
      
    [Variable  : RCD_Tracks] ; ITS STRUCTURE SHOULD MATCH WITH WHAT YOU WANT IN COLLECTION
        Variable: lvSrno            : Number
        Variable: lvTrackNumber     : String
        Variable: lvTrackDate        : Date
        List Variable    : RCD_TrckItems ; THIS IS GOING TO BE SUB COLLECTION
      
        [Variable    : RCD_TrckItems] ; THIS SHOULD HAVE STRUCTURE WHAT YOU WANT IN COLLECTION
            Variable: lvSrno                : Number
    
            Variable: lvTrckItemName        : String
            Variable: lvTrckItemAvblQty        : Quantity
            Variable: lvTrckItemDlvrQty        : Quantity
    
    [Function    : ListFillTracks]
    
      
        Variable: vTrck                    : Number 
      
      
        Variable: vTrackNumber             : String
        Variable: vTrackDate            : Date
        Variable: vListKey                : String
        Variable: vLIdx                    : Number
      
      
      
        020    :    Walk Collection    : UDN_Default ; HERE WILL COME your GSTR2A Collection
        025    :        Walk : InvoiceDelNotes
        030    :        If: NOT ($$IsEndOfList:$BasicShipDeliveryNote )
        040    :         Set        : vTrackNumber        : $BasicShipDeliveryNote
        050    :         Set        : vTrackDate        : $udn_TrackDate
        060    :         Set        : vTrck                : $$LoopIndex
        070    :        Set        : vListKey             : ##vTrck  
      
        085    :        Do If    : NOT ($$ListFind:RCD_Tracks:##vListKey): List Add:RCD_Tracks:##vListKey
        090    :        Set        : vLIdx : $$ListIndex:RCD_Tracks:##vListKey
    ;    095    :        Log:$$String:"List Index -"+$$String:##vLIdx
        100    :        Set: RCD_Tracks[##vLIdx].LvSrNo                :##vLIdx
        110    :         Set: RCD_Tracks[##vLIdx].lvTrackNumber        :##vTrackNumber      
        120    :         Set: RCD_Tracks[##vLIdx].lvTrackDate        :##vTrackDate      
    ;    125    :        Log:$$String:##vTrackNumber
        130    :        End If
      
        140    :        Do If: NOT ($$IsEndOfList:$BasicShipDeliveryNote ): Call:ListFillItems:##vTrck  
        150    :        End Walk
      
        200    :    End Walk
      
    ;----------------------------------------------------------------------------------------------------------------------------------------------
    
    [Function    : ListFillItems]
    
      
        Parameter : pTrckLastLine        : Number
      
      
        Variable: vItem            : Number 
      
        Variable: vListKey        : String
        Variable: vLIdx            : Number
      
      
        Variable: vTrckItemName            : String
        Variable: vTrckItemAvblQty        : Quantity
        Variable: vTrckItemDlvrQty        : Quantity
      
      
        100    :    Walk : udn_StockItems
        150    :        If        : NOT ($$IsEndOfList:$udn_StockItemName)
        170    :         Set        : vTrckItemName        : $udn_StockItemName          
        175    :         Set        : vTrckItemAvblQty    : $udn_StckAvblQty  
        180    :         Set        : vTrckItemDlvrQty    : $udn_StckDlvrQty  
      
      
        190    :        Set        : vItem        : $$LoopIndex
    ;    195    :        Log        : ##vItem  
    ;    200    :        Log        : ##vListKey  
        205    :        Set        : vListKey : ##vItem
        215    :        Do If    : NOT ($$ListFind:RCD_Tracks[##vTrck].RCD_TrckItems:##vListKey): List Add:RCD_Tracks[##vTrck].RCD_TrckItems:##vListKey
        220    :        Set        : vLIdx : $$ListIndex:RCD_Tracks[##vTrck].RCD_TrckItems:##vListKey
      
        225    :        Log:$$String:"List Item Index -"+$$String:##vLIdx
        230    :        Set: RCD_Tracks[##vTrck].RCD_TrckItems[##vLIdx].LvSrNo                :##pTrckLastLine  
        265    :        Set: RCD_Tracks[##vTrck].RCD_TrckItems[##vLIdx].lvTrckItemName        :##vTrckItemName              
        280    :         Set: RCD_Tracks[##vTrck].RCD_TrckItems[##vLIdx].lvTrckItemAvblQty    :##vTrckItemAvblQty  
        285    :         Set: RCD_Tracks[##vTrck].RCD_TrckItems[##vLIdx].lvTrckItemDlvrQty    :##vTrckItemDlvrQty  
        290    :        Log:$$String:##vTrckItemName  
        295    :        End If
      
        ;300    :    Another Sub List Variable could be added here
      
        400    :        End Walk
      
      
    ;-----------------------------------------------------------------------------------------------------------------------------------------------------  
    
    
      
    [Collection    : RCD_TrackNos Coll]             ; HERE IT IS USED AS COLLECTION
        Source Collection    : RCD_TrackNosSrC
        Fetch    : RCD_TrckItems.*,
      
    [Collection    : RCD_TrackItemEnt]
      
        Source Collection    : RCD_TrackNosColl
        Walk        : RCD_TrckItems
        Compute        : TrckItemName     : $lvTrckItemName
        Compute        : TrckDataType     : "StockItem"
        Compute        : TrckItemSrNo    : $LvSrNo
        Compute        : TrckAvblQty    : $lvTrckItemAvblQty
        Compute        : TrckDlvrQty    : $lvTrckItemDlvrQty
    
     
    Last edited: Feb 21, 2020
    sattam likes this.


  14. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    Thank you for your quick reply, I will study the scenario and try to learn the methods. Thank you once again.
     


  15. Damodaran

    Damodaran New Member


    how to read json month
     


  16. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    Data Source:File JSON:"Your File Path and Name"
    JSON Object Path:fp:1
    Fetch:fp
    Compute:fp:$fp
     


  17. sattam

    sattam Active Member


    Dear Members one more problem arise.
    when JSON file contains both "cdn" and "b2b" then my code working fine but if JSON file contains only "b2b" then it shows error
    collection cdn could not found
    why?
    can't understand please reply

    [Collection: TSPLJsongstr2coll]
    Data Source : File JSON:##SVGSTR2JSONfilepath1
    Fetch : *.*
    Client Only:Yes


    [Object :GSTR2ATable]
    Collection : b2b : b2bObject
    Collection : cdn : cdnObject

    [Object : b2bObject]

    Storage : ctin : String
    Storage : cfs : String
    Storage : cname : String
    Collection : inv : invObject

    [Object : cdnObject]

    Storage : ctin : String
    Storage : cfs : String
    Collection : nt : ntObject


    [Object : invObject]

    Storage : val : Number
    Storage : inv_typ : String
    Storage : pos : Number
    Storage : idt : String
    Storage : rchrg : String
    Storage : inum : String
    Storage : chksum : String

    Collection : itms : itmsObject
    [Object : ntObject]

    Storage : val : Number
    Storage : ntty : String
    Storage : nt_dt : String
    Storage : idt : String
    Storage : nt_num : String
    Storage : inum : String
    Storage : chksum : String
    Collection : itms : itmsObject


    [Object : itmsObject]
    Storage : num : Number
    Collection : itm_det : itm_detObject

    [Object: itm_detObject]
    Storage : samt : Amount
    Storage : rt : Number
    Storage : txval: Amount
    Storage : camt : Amount
    Storage : iamt : Amount
     


  18. sattam

    sattam Active Member


    Please Reply any expert how to solve this
     


  19. sattam

    sattam Active Member


    Dear Devendra ji,
    My reconcilation tool completed.it works fine.
    only two issue left
    1.when JSON file contains both "cdn" and "b2b" then my code working fine but if JSON file contains only "b2b" then it shows error
    collection cdn could not found.
    2.want to load 12 month json file but have no idea please give me some solution.
     


  20. garima

    garima Active Member


    Post your code..
     


  21. bhuvangupta

    bhuvangupta New Member


    Sattam ji aapna kaam bhi dikha do.
     


  22. sattam

    sattam Active Member


    please check your mail
     


  23. bhuvangupta

    bhuvangupta New Member



  24. SUSHIL SHARMA

    SUSHIL SHARMA New Member


    SIR CAN YOU PROVIDE HOW TO IMPORT JSON FILE BCOZ I HAVE NOT DONE THIS WORK SIR PLZZ TELL ME STEP BY STEP
    upload_2020-3-23_15-1-32.png
    upload_2020-3-23_15-1-53.png
     


  25. garima

    garima Active Member


    Paste the the complete path of the folder form your browser in first field

    in second field select the with .json extension and then enter and then accept the form
     


Share This Page