Print Stock Item Additional Description as additional column in Invoice

Discussion in 'Free Source Codes' started by Devendra_Rawat, Nov 15, 2018.

    
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I suggest to you a smart workaround..... If you are not using "Part No" Or Alias then put a coded word there.....e.g. zz001, zz002, zz003, zz004 and so on..... then make a filter wherein STOCKITEMS containing "ZZ" in either Alias or Part No.........and then use it in your formula...........

    Your field in which you are computing the QTY....check if you are using the proper USE.... like Qty primary field etc.... refer TDE..............

    Yes if you want then you need to put new columns as per your UoM...............
     
    Jaydeep Shah likes this.


  2. Rais Ahmed

    Rais Ahmed Member


    Thanks Amitji,
    For net amount solved with simple function. Qty total i checked TD and accordingly re checked every thing correct but total is not coming. For UOM only column r option and which function i mention is it correct sir ? Because Invisible I used in IGST,CGST but then column alignment changing. Shall I send TDL PL
    Regards
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Next week buddy...... am tied up with my own TDL problems..............

    always work on DEMO DUMMY data............

    and next week when u send TDL files, send demo data alongwith..............
     


  4. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    Thanks for advise for Dummy Data. I created one. As per Ur guidance I have tried 2nd column for UOM could not succeed, as Ur instruction shall I send TDL PL.
    Regards
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    send it to nehalsofttech@gmail.com

    send dummy tally data and TXT files.

    but have patience.....as am busy with other things......
     
    Muhammadhaneef likes this.


  6. Devendra_Rawat

    Devendra_Rawat Well-Known Member



  7. Rais Ahmed

    Rais Ahmed Member


    Garimaji,
    Ur refer thread has same thing which default has what is the diff?
    Regards
     


  8. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Display-> Accounts Books-Sales/Purchase Register-F5(Columnar)
     


  9. Rais Ahmed

    Rais Ahmed Member


    Garimaji ,
    Any new development?
     


  10. Rais Ahmed

    Rais Ahmed Member


    Garimaji,
    Qty, and Rate detail in normal mode has solved as well as qty total also cleared so only multiple unit fetching and if put Invisible to tax field alignment is changing remains. If u can help though I M trying also.
    Thanks and Regards
     


  11. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    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
     


  12. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    Most of problem solved thanks for UR support. Invisible field of IGST,CGST,SGST I removed .Now problem is that 1 ) I can not show the concern voucher with enter. I tried / Keys Alter On Enter, Display On Alt Enter and Enter To Edit / but not working. 2)UOM function for multiple Item which I send Is correct. 3)Company name and address is not coming in report though I tried lot with page break. Pl Help
    Thanks and Regards
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your BODY line...........

    Option : Alter On Enter : $$IsVoucher
    Option : DisplayOnAltEnter : $$IsVoucher
     
    naren1234 likes this.


  14. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    It is nice code, How it is different from default Sales/Purchase Register(plus my alteration to include three additional Columns).. Only column sequence is different.

    If you have finished your code and it is working. kindly post it for the benefit of learners as it is an example of good independent report.
     


  15. Rais Ahmed

    Rais Ahmed Member


    Dear garimaji,
    What U add is coming in condensed mode not in regular mode, more over I was trying multiple item in separate column so total can be fetched. I tried lot could not succeeded so time Bing ignored. I also send U all the pic but U did not replied nor anyone as all may busy with their commitment. Even trying if got success, will inform. Amitji told about edit function
    Option : Alter On Enter : $$IsVoucher
    Option : DisplayOnAltEnter : $$IsVoucher
    I tried not working. After I reefer so many TDL as well as TD, same function, But 4 me not working. May be some extra thing has 2 be added. If any suggestion highly appreciate.
    Thanks and Regards
     


  16. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    I tried Ur suggestion Option : Alter On Enter : $$IsVoucher and Option : DisplayOnAltEnter : $$IsVoucher did not worked. And for 1 ) Invisible, I tried Inactive and it works. 2) for page break issue I put field of company name and solved 3) UOM is not coming for multiple Column and I think without Ur help it is not possible even though I M trying.
    Regards and THANKS.
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    send the file and dummy tally data....will have a look
     


  18. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    As per Ur instruction all ready sent data & TDL on 27-12-2018
    Regards
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In
    [Field : Party]
    Alter : Voucher : ($$IsVoucher AND NOT $IsDeleted) ;;; This will open the Voucher.

    Your
    [Field : Billqty1]
    Set As : if $BaseUnit Contains "Gunny Bags" then $BilledQty else "" ;

    Well there are no "gunny bags" as per your screenshot, then as per your above line it will be BLANK............... (It refers to UoM not ItemName)

    Rest...there is too much jumble..... 3 report menus (same type)..... kindly put everything in order, because I cannot understand. Also please explain what is the purpose of this report and especially your RIGHT fields...
     
    Jaydeep Shah likes this.


  20. Rais Ahmed

    Rais Ahmed Member


    Amit Sir,
    Pl spare me 2/4 days I will clarify.
    Thanks and Regards
     


  21. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    I was trying 2 make sale and purchase summary in 1 page so I put right field but then i dropped that idea and added voucher wise summary but in that, LIST OF VOUCHERS r not fetching. After UR reply I cleaned TDL and sent fresh TDL pl look and suggest solution. One more issue, if U can help. I want 2 edit debitnote,creditnote and journal voucher default field but I could not find related voucher in TD. If U can guide that in which portion of default TDL these will be found I will be highly appreciated.3/4 times I went through TD.
    Regards.
     


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Report : Voucher is common for all accounting vouchers..........

    from there........it diversifies......... so start from REPORT:VOUCHER
     


  23. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    I tried Lot but could not succeeded to edit debit note credit note field only I can put class field in credit note like journal voucher to pass entry of GST ledger but could not open all the ledgers in both notes.
    So dropped idea for time being. But with the guidance and help from experts specially Amit sir I make GST report for Tally 1.1. But still need some improvement and still trying for better. I M very much THANKFUL 2 all of U for such help,guidance motivation .
    Regards.
     

    Attached Files:

    • 3B.jpg
      3B.jpg
      File size:
      2.9 MB
      Views:
      72
    • B1.jpg
      B1.jpg
      File size:
      1.2 MB
      Views:
      56
    • B2.jpg
      B2.jpg
      File size:
      3 MB
      Views:
      58
    • B2B.jpg
      B2B.jpg
      File size:
      3.1 MB
      Views:
      55
    • B2C.jpg
      B2C.jpg
      File size:
      2.5 MB
      Views:
      53


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very good....carry on.......... Mine is still abandoned since 3+ months now................

    Also learn to take screenshots........to enable us to view and appreciate your work.................this camshots and angles are blurry.
     
    Ras Raj likes this.


  25. Rais Ahmed

    Rais Ahmed Member


    Definitely Sir, this Pic I degraded for small size. even will try for better thanks again.
     


Share This Page