2B Column Data in Ledger Columnar Report

Discussion in 'Tally Developer' started by Kamal Kishore Jhawar, Sep 1, 2022.

    

  1. Link of this thread for earlier Filter Option and Solution i got from the @sattam ji and @Amit Kamdar ji
    http://tdlexpert.com/index.php?threads/help-to-make-fileter-option-for-gst2b.11302/

    Now, i am trying to get both the options (2B Status and 2B Month) in Columnar report, succeed in Purchase Register Columnar Report, But on specific Ledger Columnar Report Columns are appearing, But data in not fetching, So, Mostly #Collection of Columnar Report or Fetch option, i may be missing something.

    Below code i have tried to get the result (Columnar Report with GST2B Status Option, and same is worked in Purchase Register, but not working in Ledger Columnar Report.

    ;;Columnar Report with 2B Status and 2B Month option - (Code pasted here is for only 1 object)

    [#Part: CMP COLBasics]
    ;Option Added in Columnar Report Options
    Add: Lines: After: COLREGWithGSTIN:COLREGWith2BStat,COLREGWith2BM

    [Line: COLREGWith2BStat]

    Fields : Medium Prompt, COLREGWith2BStat
    Local : Field : Medium Prompt : Info : $$LocaleString:"2B Status ?" ;;; To Display 2B Status
    Invisible : NOT @@IsGSTOn

    [Field: COLREGWith2BStat]
    Use : Logical Field
    Modifies : COLREGWith2BStat

    [Variable: COLREGWith2BStat]

    Type : Logical
    Persistent : Yes

    [#Line: DSP ColVchDetail]

    Add: Field : After: DBC GSTIN:DBC 2BS
    Add: Field : After: DBC GSTIN:DBC G2BM

    [Field : DBC 2BS]
    Use : Simple Name Field
    Set As : $GST1169
    ;UDF Saved for Status Update for Specific Invoice with Match, Not Matching, RCM, Pending, Etc.
    Width : 7
    Border: Thin Left Right
    Color:Blue
    Invisible : ##Colregwith2BM="No"

    ;Mostly in this Portion, i have to make some changes or one more Collection i have to use for Columnar Report in Ledger.

    [#Collection: Columnar Vouchers of Company]
    Add:Fetch:GST1165, GST1169, DBC G2BM

    @Experts plz guide me how to get Columnar Report with information saved in entries in Ledger Report.

    **above Code is shown for 1 variable, same is used for both in the program.
     

    Attached Files:

    Last edited: Sep 6, 2022




Share This Page