Show pan and address in sales/purchase register

Discussion in 'Tally.ERP 9' started by rajiv jaiswal, Dec 4, 2020.

    
  1. rajiv jaiswal

    rajiv jaiswal Member


    dear experts please correct this tdl as data is not coming as shown in picture
    Code:
    ;; show pan and address in purchase/ sales register
    [#Form : Purchase Color]
    
    
    [#Line: DBTitle1]
        Add    :     Field    : After : DSP VchAcctTitle    : PAN NO,Address
    
    [Field:PAN NO]
    
        Set As    :    "Pan No"
        Width     :     10
        Align     :     Left
        Style     :     Normal Bold
        Line    :     0
    
    [Field:Address]
    
        Set As    :    "Address"
        Width     :     10
        Align     :     center
        Style     :     Normal Bold
        border     :     thin right left
        Line    :     0
    
    [#Line: DSP VchDybkDetail]
        Add    :     Field    : After    : DSP VchAccount    : PAN NO10,Address10
    
    
    [Field:PAN NO10]
        Use         : Name Field
        Set As         : $SalesTaxNumber
        Width         : 10
        Align        : Center
        ;color         : blue
        Style         : Normal bold
        Border        : Thin Left right
    
    [Field:Address10]
        Use         : Name Field
        Set As         : $STPartyFullAdd
        Width         : 15
        Align        : Center
        ;color         : blue
        Style         : Normal bold
        Border        : Thin Left right
    
    
    
    
    
    
    
    [#Collection : Vouchers of Ledger]
    Fetch : SalesTaxNumber, Address
    
    
     

    Attached Files:

    Jaydeep Shah likes this.


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Add .......... :Ledger:#DSPVchAccount in the end in SET AS
     
    Jaydeep Shah and rajiv jaiswal like this.


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your Field Name is PAN No ......... so why are you trying to put the Sales Tax Number ??? are you still under VAT regime ?
     
    rajiv jaiswal likes this.


  4. rajiv jaiswal

    rajiv jaiswal Member


    Thanks for your help Amit sir its working now. yes sir we are still under VAT. I am from NEPAL
     


  5. rajiv jaiswal

    rajiv jaiswal Member


    Amit Sir
    i want pan and address field to be invisible in DAYBOOK. I tried the below code .its working for Purchase Register BUT i want it also o be VISIBLE in sales/ Journal Register
    Invisible :Not $$IsPurchase:##VoucherTypeName AND ##ISDAYBOOK
    NOT WORKING FOR ALL
    Invisible : Not $$IsPurchase:##VoucherTypeName AND Not$$IsSales:##VoucherTypeName AND Not$$IsJournal:##VoucherTypeName AND ##ISDAYBOOK
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Invisible : Not ( $$IsPurchase:##VoucherTypeName OR $$IsSales:##VoucherTypeName OR $$IsJournal:##VoucherTypeName )
     
    rajiv jaiswal likes this.


  7. rajiv jaiswal

    rajiv jaiswal Member


    Thank you sir
     


Share This Page