Columnar Register

Discussion in 'Requests' started by rony, Oct 3, 2018.

    
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If he has single item....then just need to change the SET AS............

    BTW....do not understand, if there is only one StockItem as he mentioned in previous post, what is the need of a Serial # column ????

    Anyone can remember a single serial #.
     


  2. rony

    rony Member


    Dears,
    Thanks. Till Date my Invoice has one item but it is not forever. just now I have only one commodity but it will increase so I M trying serial no. otherwise Set As is perfect as amit sirji suggest. I am direct opening display -sales register F5 columnar in that i put entry as COLREG. And copy past means I just put same code of urs in my txt file with my other txt where i entering same no. in invoice entry. That why I posted columnar where serial no. column is coming blank. Amitsirji asked Serial No. is name field is correct because it may contain no and letters so name field is correct. I also could not understand why it is not coming because amit sirji posted screenshot means it is working, maybe because i m using ERP9.1.1. Even though today i will thoroughly go through code if I made any mistake.
    Thanks And Regards for innovating.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Are you Exploding???

    When you go the columnar sales register....press Alt+F1...

    This is a simple code.....plus my code is not dependent on the COLLECTION or on GST or any other Statutory changes made since then ........ so for this code --- I think the version difference will not matter.

    Do you have Tally Developer ??????
     


  4. rony

    rony Member


    Dear Amitji,
    Thanks Finally I corrected and now Alt+F1 Sr No. coming. I refer tally developer also, In that while making invoice entry that field must store with unique UDF but I don't know how to call that . But I thanks That time being u r code is working till I get condensed format entry.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    as per your code...there is no involvement in Invoice Entry......the Serial Number is entered in the StockItem Master.

    What you mean by "condensed format entry"???
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If you are not comfortable in English....try Hindi........... because i cannot understand or comprehend your statements and what exactly you are trying to say.

    Also it would be better if you make screenshots and write explanatory notes... for our better understanding and also to ensure we do not waste time over misunderstanding or misinterpretation.
     


  7. rony

    rony Member


    Amitsirji,
    Thanks.Actually i want stock serial no . in my invoice so i make field in stock item master.and add column in invoice master. Every thing was good but when I add a column in columnar the same serial no was not coming and after Ur help/support it has come but, after Alt+F1. Which means in detail report format. in columnar or in any report two format default are there, one detail and other condensed type . Voucher No. Voucher Type Gst No. Amount. Quantity Ledger Details every column is coming/Showing value in condensed mode , Only Item in detail format. and Ur code also showing SR NO. in detail mode or u say in explode mode. I m trying to take in normal/condensed mode . I think for that I have to make DSP field . Yesterday I was referring Tally developer which is showing DSP menu separately. And sirji I m not expert like u but not coming near 2 Ur knowledge. People like U help and I have made some TDL for my use its the big help of TDLEXPERT Site. THANKS for what u have done for me. Really i mean it.
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Dear Ronyji,

    If you want the serial number to be shown in NON-Explode mode or condensed mode as you call it.......... .....then simply change the formula......

    Local : Field : DBC SrNo : Set as : IF #DBCParty = $DSPPartyLedger Then "" Else $udfStkSrno:StockItem:$STockItemName

    TO THIS>................................

    Local : Field : DBC SrNo : Set as : $udfStkSrno:StockItem:$STockItemName

    Mind. you above will only show the Serial Number of the First STOCK Item.................
     
    naren1234 likes this.


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    And we are glad that people like you are really learning and making an effort to learn and make TDLs .......... appreciate that...........

    I wish you luck in your learning efforts. Please do keep it up.

    And we are always glad to lend a helping hand................. for genuine learners............. we just ignore the beggars and leechers.
     
    Meena Mhatre likes this.


  10. rony

    rony Member


    Sirji,
    First I tried that, but want fetch value thats why I create this post. even though I tried above code, not working. Instead tally acceptation error coming .
    Thanks And Regards
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You must understand the logic............

    1. You have put the Serial Number in StockItem.
    2. When you go to Columnar Sales Register.... the unexploded or condensed view shows the Ledger A/c and not the Stock Item............
    3. So there is no way to collate the datacall .... coz Serial Number belongs to Item and not ledger.
    4. Hence when u explode or detailed view.... the stockitem is viewed and hence Serial Number will show because there is direct correlation..
     
    Meena Mhatre likes this.


  12. rony

    rony Member


    Dear Amitji,
    I understand that concept. THANKS. Today i made one more field in invoice that APMC PERMIT and same in sales columnar with same formula as serial no. and that value
    fetching in condensed mode. I was referring T.D. in that I saw that though value come from any function but STORAGE can save that value as UDF. But I could not fetch that value like APMC Field. If u say, can I send file 2 U? so that I get guidance from U. One more thing when we make duties ledger tax type selection came, as i m using ERP 9.1.1 it saws CST,VAT, EXCISE And OTHERS . Where these names resides in TD, I went through full TD and made so many changes in Collection and table of TAX /DUTY TYPE but did not succeeded. If u can help. Please
    REGARDS
     
    Last edited: Oct 19, 2018


  13. rony

    rony Member


    Dear Sirji,
    Why no response. Pl guide.
    Thanks and Regards
     


  14. rony

    rony Member


    Dear Sirji,
    Why no response. Pl guide.
    Thanks and Regards
     


  15. sivam

    sivam Active Member



    1. You should use Original Licensed Version Of Tally with Latest Version.
    2. Your using Old Tally, Old Tally Have Different concept, That Mean Early Tally using STAT Concept, We can't alter that STAT files.

    Buy Original Tally Or Upgrade to Latest version and joy full features
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Send your file by email...will see in a couple of days or next week. right now am dealing with death of my father.
     


  17. rony

    rony Member


    DEAR AMITJI,
    HEART FELT CONDOLATION ON SAD DEMISE OF UR FATHER. MY DEEPEST SYMPATHY IS WITH U AND UR FAMILY. SORRY 2 DISTURB. LATER DISCUSS NO PROBLEM.
    REGARDS
     


  18. rony

    rony Member


    Dear Nallasivamji,
    I m not asking to edit STAT. But when craeting duties ledger, group of duties show DUTY TYPE. That is not part of STAT and that shows with $$Localstring function, that i want to modified.
    And what about font color how to change in invoice as i have tried EXPSMP COMPANY and EXPINV COMPANY both font can be changed but can not change the font color with COLOR: attribute . Pl guide
    Thanks And Regards
     
    Last edited: Oct 24, 2018


  19. sivam

    sivam Active Member


    I not hv Experience with Old Versions. and i know above Tally.ERP9 Release 3.6 Above Only.

    For font color, use

    Print FG & Print BG Attribute.
     
    vinoth likes this.


  20. rony

    rony Member


    Thanks Knsivamji, it works. Old versions means ERP 9.1.1 nothing big diff between 1.1 & 3.1 . anyway Thanks a lot
     


  21. sekharchana

    sekharchana Member


    Sir is this correct for color

    @@SV_CMPCONFIG

    [Part : Party Details]

    Background : Red Print BG : Green

    [Field : Party Ledger Name]

    Background : Yellow

    Print BG : Red
     


  22. sivam

    sivam Active Member


    Print BG is Background color and Print FG is the Text Color. Which one You need to change Use based on that
     
    vinoth likes this.


  23. sekharchana

    sekharchana Member


    can't we use both sir
    i mean BG and FG for party name or for total amount like this
     


  24. sivam

    sivam Active Member


    I not Understand. Print BG and Print FG Only Show in Print Mode. Background and color Only for Display Mode.
     
    vinoth likes this.


  25. rony

    rony Member


    Dear sekharchana,
    u did not understand sivanji. If u want print paper background then BG , rest for all letters (any letters) FG. U have used both background and BG use only Print BG and Print FG
    attributes only. Background : Red Print BG : Green. Hope helped.
    Regards
     


Share This Page