Simplest Code for Lines between Stock Items

Discussion in 'Free Source Codes' started by Adeshwar Mehta, Jan 24, 2018.

    

  1. What would be the simplest code for Lines between Stock Items during Invoice Print.

    Irrespective of credit note debit note purchase sales ..

    Is it possible???
     


  2. Sanjeev S

    Sanjeev S Active Member


    [#Line: EXPSMP InvDetails]
    Border : Thin Bottom : @@MyLF = 0

    [System: Formulae]
    MyLine : $$Line
    MyLF : (#EXPINVSLNo/5) - $$RoundDown:(@@MyLine/5):1

    ;;---- here 5 is no of line after which you need a line/border if its after every line then the code can be
    [#Line: EXPSMP InvDetails]
    Border : Thin Bottom
     



  3. Hi thanks for your reply..
    However both the codes and its variations don't seem to be working
     



  4. Was able to fix it with a minor change in the code

    [#Line: EXPINV InvDetails]
    Border : Thin Bottom : @@MyLF = 0

    [System: Formulae]
    MyLine : $$Line
    MyLF : (#EXPINVSLNo/2) - $$RoundDown:(@@MyLine/2):1

    Thanks a lot for pointing me in the right direction. Solved my problem. Need to figure out how to add a mild gray border shading for every second line
     

    Attached Files:



  5. Systecg

    Systecg Member


    It's NOT WORKING ....cAN U PLZ SHRE SCREENSHOT

    THANKS
     


  6. Hemanth

    Hemanth New Member



    Hi Please Let Us know how you got the colors as shown in the PDF
     


  7. Sanjeev S

    Sanjeev S Active Member


    for getting colors ... You can simply add @line level

    Local : Field : Default : Print BG : Light Grey

    Regards
     



  8. Hi Sanjeev I tried a lot with a lot of variations but unfortunately your suggestion doesnt seem to be working. I am using the default invoice and have added only these lines in a txt file and using it as a tdl

    [#Line: EXPINV InvDetails]
    Border : Thin Bottom : @@MyLF = 0

    [System: Formulae]
    MyLine : $$Line
    MyLF : (#EXPINVSLNo/2) - $$RoundDown:(@@MyLine/2):1

    Can it be done within this code or do i need to alter the default invoice code.
    Please do guide. thanks a lot
     


  9. Sanjeev S

    Sanjeev S Active Member


    for getting colors ... You can simply add @line level

    Local : Field : Default : Print BG : Light Grey

    Regards
    Just Try....

    [System : Formulae]
    OddLine : $$IsOdd:$$Line

    [#Line: EXPINV InvDetails]
    Option : BG ODD Print : @@IsSales and @@OddLine

    [!Line : BG Odd Print]
    Local : Field : default : Print BG : Light Grey
     


  10. Sanjeev S

    Sanjeev S Active Member


    for getting colors ... You can simply add @line level

    Local : Field : Default : Print BG : Light Grey

    Regards
    Just Try....

    [System : Formulae]
    OddLine : $$IsOdd:$$Line

    [#Line: EXPINV InvDetails]
    Option : BG ODD Print : @@IsSales and @@OddLine

    [!Line : BG Odd Print]
    Local : Field : default : Print BG : Light Grey
     


  11. Sanjeev S

    Sanjeev S Active Member


    I have done some changes and made it very simple hope this will solve your both quarries.
     

    Attached Files:



  12. Sanjeev S

    Sanjeev S Active Member


    I have done some changes and made it very simple hope this will solve your both quarries.
     

    Attached Files:

    Adeshwar Mehta likes this.



  13. Boss your a genius. Thanks for solving the Problem
    Truly indebted.
     


  14. Chetan S

    Chetan S New Member


    Sir, Lines are coming, but no background colour... Please help
     



  15. Weird Problem I am facing



    [System : Formulae]
    OddLine : $$IsOdd:$$Line

    ;;;------------- Print Background color to odd inventory lines.

    [#Line: EXPINV InvDetails]
    Option : BG ODD Print : @@IsSales and @@OddLine

    [!Line : BG Odd Print]
    Local : Field : default : Print BG : Light Grey


    *********************************END CODE *****************************************

    This code was working fine in 6.6.3 . Due to a system corruption I had to install tally again. In the reinstalled version this code has stopped working.. The same code is working in a old tally version of 6.6 .. So i am guessing nothing is wrong with the code but wondering why it is not working in the new tally.. any inputs in why it may be like that..
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Line: EXPINV InvDetails]
    Option : BG ODD Print : @@IsSales
     


  17. vakul

    vakul Member


    [#Line: EXPINV InvDetails]
    Border:Thin Bottom
    ----------------------------------------------------------------------------------------------------
    [#Line: EXPSMP InvDetails]
    Border:Thin Bottom
    ;;---------------------------------------------------------------------------------------------------
     



  18. Amitji what u suggested isnt working.. in the old tally it works but every line is now with background... reverted back to the old code.. What a weird situation.. will probably try reinstalling the new tally and see if the problem solves itself.
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is working fine here..........

    Maybe your Old version become JEALOUS of being replaced and put a CURSE on the new one :) :)
     
    Sanjeev S likes this.


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member




  21. Reinstalling Tally solved the problem.. I guess waste of time to wonder what might have caused it.. in any case solved.
     


Share This Page