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

This TDL attempts to add additional columns..
wiz HSN Code
Sales/Purchase Ledger
GST Rate


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


It keeps intact all other default features of the report intact, and gives details as intended in Explode mode also.

It is now working for all item invoices in explode mode in Columnar Format, Check posted code again ..

It has ledger Allocation Name (Purchase/Sales Ledger) name against each item and Item IGST Rate and HSN code if defined in the master.. These three columns are not available in default columnar sales/Purchase Registers

Code:

[#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
        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
        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
        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

 

SIR PLEASE CORRECT CODE, THEIR IS MISTAKE 1) GST RATE NOT SHOWING 2) ALL ITEMS HSN CODE IS SHOWN WRONG , IT IS SHOWING HSN CODE OF 1st ITEM ONLY FOR ALL THE ITEMS IN INVOICE.

 

Ok.. upload your tally data.. I do not have tally data to test it.

Yes there is issue when voucher has multiple stock items.. I will shortly update it.

 

It is now working for all Inventory Vouchers in explode mode

 

Thanks Sir..

 

PLEASE SHARE THE LATEST & CORRECTED CODES

 

latest code is already updated... old one has been removed.. what you see in code section, is latest code

 

It is now working for all Inventory Vouchers in explode mode , THANK YOU VERY MUCH

 

gst rate is piking from based on accounting ledger.

 

Yes, it follows as..... if GST rate is empty in accounting ledger then it will pick up stock item else from accounting ledger.. see the gsttraingulationmethods tdl in tally developer..

 

Extremely Useful TDL. How to get the Place Of Supply in one Column as well?

There seems to be no source collection for
Columnar Vouchers of Company?

 

Do you want to add it ?

 

Yes, I was able to get it.

But I was not able to understand - if a collection does not have a 'Type' or 'Source Collection' attribute, how does it know which object to use?

 

Then Pls upload the tdl. so that others can take benefit of your work

 

What is difference between soruce collection and Use:

 

Ok Sir,

I got it..

No.. Its not that.. It didn't occurred to me.

You have vast and in depth knowledge of TDL..

But I know only a few specific parts of TDL .. all my TDL posted over here are just solutions to somebody's queries.. credit goes to original coder.

 

Oh

This is a really good explanation. Many thanks Amit Ji.

 

It's exactly the same as your TDL, only I added a formula called GSTpartyplaceofsupply from one of the inbuilt GST TDLs.

Thanks again for your code.

 

Garimaji

How to Add Godown Name Column ?

 

a little busy for next 15 days..

 

Ok

I will wait

Thank you

 

Cess based on value and quantity rate how to display in above code