1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Columnar Purchase Register and Sales Register with HSN code, Sales/Purchase Ledger and GST rate

Discussion in 'Free Source Codes' started by Devendra_Rawat, Dec 27, 2018.

    
Page 3 of 3
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear @Ashu001 -- All cannot be accomplished with simple copy and paste.... the Situation also need to be understood.

    The code you have copied is for Outstanding Report and so the same has been objectified in OBJECT:BILL .... You want the details in a register so you need to define it in OBJECT:Voucher
     
    Last edited: Oct 3, 2022
    Amit Kamdar, Oct 3, 2022
    #51
    Jaydeep Shah likes this.


  2. RAVI BANOTH

    RAVI BANOTH Member


    How:
    Set : Display to Yes for in F5 (Columnar Report) of Sales/Purchase Register
    1. HSN/Code
    2. Non Party Ledger
    3. GST Rate


    Amit Sir ,
    Above code are not working in TallyPrime .
     
    RAVI BANOTH, Dec 8, 2022
    #52


  3. RAVI BANOTH

    RAVI BANOTH Member


    Hsn Code & Gst rate in sales columnar report.jpeg
     
    RAVI BANOTH, Dec 8, 2022
    #53


  4. RAVI BANOTH

    RAVI BANOTH Member


    Amit Sir ,
    This is over Exiting Code. Please verify Once Sir Ji. Required in Prime

    [#Part: CMP COLBasics]
    Add: Lines: After: COLREGWithGSTIN:COLREGWithHSNSAC, COLREGWithLEDGER, COLREGWithGSTRate
    [Line: COLREGWithHSNSAC]
    Fields : Medium Prompt, COLREGWithHSNSAC
    Local : Field : Medium Prompt : Info : $$LocaleString:"Show HSN/SAC Code ?" ;;; To Display Show party's GSTIN/UIN
    Local : Field : Medium Prompt :Style:thin Bold
    Local : Field : Medium Prompt :Color:Blue
    Invisible : NOT @@IsGSTOn
    [Field: COLREGWithHSNSAC]
    Use : Logical Field
    Modifies : COLREGWithHSNSAC
    [Line: COLREGWithLEDGER]
    Fields : Medium Prompt, COLREGWithLEDGER
    Local : Field : Medium Prompt : Info : $$LocaleString:"Show Ledger for Entry ?" ;;; To Display Show party's GSTIN/UIN
    Local : Field : Medium Prompt :Color:Blue
    Local : Field : Medium Prompt :Style:thin Bold
    Invisible : NOT @@IsGSTOn

    [Field: COLREGWithLEDGER]
    Use : Logical Field
    Modifies : COLREGWithLEDGER
    [Line: COLREGWithGSTRate]
    Fields : Medium Prompt, COLREGWithGSTRate
    Local : Field : Medium Prompt : Info : $$LocaleString:"Show GST Rate ?" ;;; To Display Show party's GSTIN/UIN
    Local : Field : Medium Prompt :Color:Blue
    Local : Field : Medium Prompt :Style:thin Bold
    Invisible : NOT @@IsGSTOn
    [Field: COLREGWithGSTRate]
    Use : Logical Field
    Modifies : COLREGWithGSTRate

    [System: Variables]
    COLREGWithHSNSAC : No
    COLREGWithLEDGER : No
    COLREGWithGSTRate : No
    [Variable: COLREGWithHSNSAC]
    Type : Logical
    Persistent : Yes
    [Variable: COLREGWithLEDGER]
    Type : Logical
    Persistent : Yes
    [Variable: COLREGWithGSTRate]
    Type : Logical
    Persistent : Yes
    [#Line: DSP ColVchTitle]
    Add: Field : After: DBC GSTIN:DBC HSNSAC
    Add: Field : After: DBC GSTIN:DBC LEDGERNP
    Add: Field : After: DBC GSTIN:DBC GSTRATE
    Local : Field:DBC HSNSAC : Set as : $$LocaleString:"HSN/SAC"
    Local : Field:DBC LEDGERNP : Set as : $$LocaleString:"Non Party Ledger"
    Local : Field:DBC GSTRATE : Set as : $$LocaleString:"GST Rate"
    [#Part: DBC QtyDetails]
    Local : Field : DBC LEDGERNP : Set as : $GSTEntryLedgerName
    [#Line: DSP ColVchDetail]
    Add: Field : After: DBC GSTIN:DBC HSNSAC
    Add: Field : After: DBC GSTIN:DBC LEDGERNP
    Add: Field : After: DBC GSTIN:DBC GSTRATE
    [Field: DBC HSNSAC]
    Use : Short Name Field
    Set as : $GSTItemHSNCodeEx;DBCHSNSAC
    Width : 0
    Style : Normal
    Bound : 8,15
    Invisible : NOT (##COLREGWithHSNSAC AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left

    [Field: DBC LEDGERNP]
    Use : Short Name Field
    Set as : $GSTEntryLedgerName; DBCLEDGERNP
    Width : 0
    Style : Normal
    Bound : 8,15
    Invisible : NOT (##COLREGWithLEDGER AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left
    [Field: DBC GSTRATE]
    Use : Short Name Field
    Set as : $GSTLedItemIGSTRateEx; DBCGSTRATE
    Width : 0
    Style : Normal
    Bound : 8,15
    Invisible : NOT (##COLREGWithGSTRATE AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left
    Alignment : Centre

    [#Collection: Columnar Vouchers of Company]
    Fetch : AllInventoryEntries.GSTLedItemIGSTRateEx, AllInventoryEntries.GSTItemHSNCodeEx, AllInventoryEntries.GSTEntryLedgerName
     
    RAVI BANOTH, Dec 8, 2022
    #54


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Field: DBC LEDGERNP]
    Use : Short Name Field
    Set as : $$CollectionField:$LedgerName:2:AllLedgerentries
    Width : 0
    Style : Normal
    Bound : 8,15
    Invisible : NOT (##COLREGWithLEDGER AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left
    [Field: DBC GSTRATE]
    Use : Short Name Field
    Set as : $$GetInfoFromHierarchy:$StockItemName:"Stock Item":"GSTRate":$Date:"GST":0:mad:@IGSTDutyHead
    Width : 0
    Style : Normal
    Bound : 8,15
    Invisible : NOT (##COLREGWithGSTRATE AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left
    Alignment : Centre
     
    Amit Kamdar, Dec 8, 2022
    #55
    Jaydeep Shah likes this.


  6. RAVI BANOTH

    RAVI BANOTH Member


    Same Issue Amit Sir.
     
    RAVI BANOTH, Dec 9, 2022
    #56


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try to explode........ it will appear
     
    Amit Kamdar, Dec 9, 2022
    #57
    Jaydeep Shah likes this.


  8. Chintan987

    Chintan987 New Member


    [#Part: CMP COLBasics]
    Add: Lines: After: COLREGWithGSTIN:COLREGWithCC
    [Line: COLREGWithCC]
    Fields : Medium Prompt, COLREGWithCC
    Local : Field : Medium Prompt : Info : $$LocaleString:"Show Cost Centre Name?" ;;; To Display Show party's GSTIN/UIN
    ;; Invisible : NOT @@isCost
    [Field: COLREGWithCC]
    Use : Logical Field
    Modifies : COLREGWithCC

    [System: Variables]

    COLREGWithCC : No
    [Variable: COLREGWithCC]
    Type : Logical
    Persistent : Yes
    [#Line: DSP ColVchTitle]
    Add: Field : After: DBC GSTIN:DBC CCName
    Local : Field:DBC CCName : Set as : $$LocaleString:"CostCentre Name"
    [#Part: DB Columnar]
    Local : Field : DBC CCName : Set as : $CostcentreName

    [#Part: DBC QtyDetails]
    Local : Field : DBC LEDGERNP : Set as : $CostcentreName
    [#Line: DSP ColVchDetail]
    Add: Field : After: DBC GSTIN:DBC CCName
    [Field: DBC CCName]
    Use : Short Name Field
    Set as : $CostcentreName
    Width : 0
    Style : Normal
    Bound : 8,15
    Invisible : NOT (##COLREGWithCC);; AND @@IsGSTOn)
    Scroll : Yes
    Border : Thin Left

    [#Collection: Columnar Vouchers of Company]
    Fetch: Costcentrename


    I was able to fetch costcentre name in case of single cost centre in columnar Purchase register.
     
    Chintan987, Feb 4, 2023
    #58


Page 3 of 3

Share This Page