1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

WATCH GSTIN NUMBER ON SALES PURCHASE ENTRY SCREEN

Discussion in 'Tally.ERP 9' started by divy2281774, Jul 7, 2017.

    
Tags:
Page 1 of 2
  1. divy2281774

    divy2281774 New Member


    You can check party GSTIN number directly from your sales and purchase screen. No need to activate supplimentry detail for checking party GSTIN.


    For Complete detail watch following vedio.
     

    Attached Files:

    divy2281774, Jul 7, 2017
    #1


  2. J.Ravi Kumar Rao

    J.Ravi Kumar Rao New Member


    please provide tdl file
     
    J.Ravi Kumar Rao, Aug 21, 2017
    #2


  3. dipu369

    dipu369 Member


    Pls.find below the code but when you add a new ledger (after update Tally prime 3.0) it will not show . But old ledger which you added earlier it will show .

    [#Part: VCHTitle2Left]
    Add:Line:After:VCH Ref:Statutory
    [Line: Statutory]
    Add: Field: StatutoryGST
    Invisible: Not (@@IsPurchase Or @@IsSales)
    [Field: StatutoryGST]
    Fields : Simple Prompt, Name Field
    Local : Field : Simple Prompt: Set as : "GST"
    Local : Field :Simple Prompt : color : red
    Local : Field :Simple Prompt : width : 5
    Local : Field : name Field : Set as : $PARTYGSTIN:Ledger:$LedgerName
    Local : Field :name Field : width : 18.5
    Local : Field : Default : Skip : Yes
    Local : Field : Name Field : Color : Blue
     
    dipu369, Aug 12, 2023
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use --- Local : Field : name Field : Set as : $LedGSTRegDetails[Last].GSTIN
     
    Amit Kamdar, Aug 12, 2023
    #4


  5. dipu369

    dipu369 Member


    Sir Thanks. I have put only Local : Field : name Field : Set as : $PARTYGSTIN , now it is working.

    But in my Sales Register I have put Set as : $PARTYGSTIN:Ledger:$LedgerName . It is working . but when i newly made any ledger in current date that
    ledger GST Number is not coming in my Sales Register. It is happened after updating Tally Prime 3.0 .
     
    dipu369, Aug 17, 2023
    #5


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Updating or not updating has nothing to do with the version installed -- it depends on whether the Collection has been refreshed or not.

    Either you can use the code that I have proposed OR if any new Ledger has been created than -- Shut Down Tally and Re-start - it will pick up the values.
     
    Amit Kamdar, Aug 17, 2023
    #6


  7. Nithin Patel

    Nithin Patel Member


    Sir, Help regarding this code, Where Wrong

    [Field : GSTINDisplay]
    Use : NameField
    Width : 10
    Set As : $LedGSTRegDetails[Last].GSTIN
    Color : Blue
    Align : Left
    Border : Thin Left Right

    [#Collection: Vouchers of Ledger]
    Fetch : GSTIN
    Compute : GSTIN: $LedGSTRegDetails[Last].GSTIN
     
    Nithin Patel, Aug 17, 2023
    #7


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Based on your above sample - I surmise that you need it in the "Ledger Vouchers" report --- in that case use ---

    $PARTYGSTIN:Ledger:$LedgerName OR $PARTYGSTIN:Ledger:##LedgerName
     
    Amit Kamdar, Aug 17, 2023
    #8


  9. Nithin Patel

    Nithin Patel Member


    Sir, Thanks for the reply,
    But i need to use it in Sales Register, Purchase Register
     
    Nithin Patel, Aug 18, 2023
    #9


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In Columnar Sales & Purchase Register - it is already there.
     
    Amit Kamdar, Aug 18, 2023
    #10


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    And if you need it in a "separate" field other than default, then you are using the wrong collection for Register. Refer to the appropriate Collection of "Vouchers Register"
     
    Amit Kamdar, Aug 18, 2023
    #11


  12. Nithin Patel

    Nithin Patel Member


    Thanks for your Help,
    Got the result using

    [#Collection: Filtered Vouchers of Company]
    Fetch : PARTYGSTIN
    Compute : PARTYGSTIN: $PARTYGSTIN:Ledger:$LedgerName
     
    Nithin Patel, Aug 18, 2023
    #12


  13. Nithin Patel

    Nithin Patel Member


    Sir and how to get above result in Daybook
     
    Nithin Patel, Aug 18, 2023
    #13


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    refer to the collection of Daybook --- Daybook vouchers of Company or something like that.

    Secondly not all values needs to be COMPUTED -- just FETCH will do.
    In the various reports --- use like this $PARTYGSTIN:Ledger:#FIELDName (which has the LedgerName i.e. #DSPVchAccount in case of registers & daybook)
     
    Amit Kamdar, Aug 18, 2023
    #14


  15. Nithin Patel

    Nithin Patel Member


    Thanks, Amitji. Done!
     
    Nithin Patel, Aug 23, 2023
    #15


  16. Nithin Patel

    Nithin Patel Member


    Help Required!

    [#Line:EXPINV Column2]
    Local : Field : EXPINV DescTitle2 : PrintBG : Grey
    Local : Field : EXPINV QtyTitle : PrintBG : Grey

    Dosn't get result.
     

    Attached Files:

    Nithin Patel, Aug 23, 2023
    #16


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There is no EXPINV DescTitle2 -- so it will not work.
    As for QtyTitle there is no such Field in the LINE : :EXPINV Column2 -- so it will not work either. You will need to insert your Field for the 2nd Row ► Column Title

    As for DescTitle Field -- as there is a BLANK, it will not show, so ADD a space as shown below.

    [#Line:EXPINV Column2]
    Local : Field : EXPINV DescTitle : PrintBG : Grey
    Local : Field : EXPINV DescTitle : Info : " "
     
    Amit Kamdar, Aug 23, 2023
    #17
    Nithin Patel likes this.


  18. Nithin Patel

    Nithin Patel Member


    Still some tweaks in code required plz Help!
     

    Attached Files:

    Nithin Patel, Aug 24, 2023
    #18


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Answer to that already given by me in POST # 17 above -- read the second line.

    As for the GAP ..... it will remain as there are RIGHT Fields and LEFT fields.
     
    Amit Kamdar, Aug 24, 2023
    #19
    Nithin Patel likes this.


  20. SURAJ PRAJAPATI

    SURAJ PRAJAPATI New Member


    [#Field:EI COnsignee]

    Delete:Table

    Add:Table:MyLedgerColl,



    [Collection:MyLedgerColl]

    Use : Alias Collection

    Title : $$LocaleString:"List of Ledger"

    Type : Ledger,

    Fetch : Name,PartyGSTIN

    Report : Ledger

    Variable : LLedger

    Trigger : LLedger

    IsODBCTable : Yes

    Add : SubTitle : $$LocaleString:"Ledger Name","GSTIN","UIN"

    Add :Format :$MyUDF AND $PartyGSTIN
     
    SURAJ PRAJAPATI, Sep 30, 2023
    #20


  21. SURAJ PRAJAPATI

    SURAJ PRAJAPATI New Member


    sir mujhe isme gstin no aur aadhar no dono ek hi list mein chaahiye
     
    SURAJ PRAJAPATI, Sep 30, 2023
    #21


  22. Bipin Damania

    Bipin Damania Active Member


    Fetch : MyUDF
    Add :Format :$MyUDF
    Add :Format :$PartyGSTIN
     
    Bipin Damania, Sep 30, 2023
    #22


  23. Mukesh Garg

    Mukesh Garg Member


    upload_2023-10-12_21-49-49.jpeg

    Sir Plz Help Party Details not display on full screen even width : Full page used on part of code and how to shift party details after account name Code : Add: Lines:After: EI Consignee not working in prime plz help
     
    Mukesh Garg, Oct 12, 2023
    #23


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In Prime the placement is different -- refer to Developer-Prime. And add your lines at the proper place.

    As about other issue -- am still awaiting the Amazon delivery of Harry Potter's wand so i can conjure up the code you have made -- into my mind. :);)
     
    Amit Kamdar, Oct 12, 2023
    #24


  25. dipu369

    dipu369 Member


    Dear Amit Sir ,
    I want to show "Credit Note Value" in my sales register if any . I have written but it is showing same "credit note value" in same parties in all bills.
    It should be on that bill which is adjusted with credit Note.
    My code is given below :

    Local : Field : SimoCRN : Set as : "Cr.Note"

    [Field : SimoCRN] ; Credit Note
    Use : Amount Forex Field
    Set as:$Cnote
    Border : Thin Left
    ;Width : 6% Screen
    Width : 12
    Style : Tiny
    Align : Right

    [Collection: dipu]
    Type : Voucher
    Compute : CNote : $$ReportObject:$$CollectionFieldByKey:$CNote:$Name:Dcollection

    [Collection: CollDipu]
    Type : Voucher

    [Collection: Dcollection]
    Code:
    Dear Amit Sir ,
I want to show "Credit Note Value" in my sales register if any . I have written but it is showing same "credit note value" in same parties in all bills.
It should be on that bill which is adjusted with credit Note.
My code is given below :

Local : Field : SimoCRN         : Set as : "Cr.Note"

[Field : SimoCRN]                   ; Credit Note
Use : Amount Forex Field
Set as:$Cnote
Border : Thin Left
;Width : 6% Screen
Width : 12
Style : Tiny
Align : Right

[Collection: dipu]
Type : Voucher
Compute : CNote : $$ReportObject:$$CollectionFieldByKey:$CNote:$Name:Dcollection

[Collection: CollDipu]
Type : Voucher

[Collection: Dcollection]
Source Collection : CollDipu
Walk : Ledger Entries
By : LedgerName : $LedgerName
Aggr Compute : CNote : Sum : IF $$IsCreditNote:$VoucherTypeName Then $Amount else 0
Search Key : $LedgerName
    Source Collection : CollDipu
    Walk : Ledger Entries
    By : LedgerName : $LedgerName
    Aggr Compute : CNote : Sum : IF $$IsCreditNote:$VoucherTypeName Then $Amount else 0
    Search Key : $LedgerName
     
    dipu369, Nov 28, 2023
    #25


Page 1 of 2

Share This Page