Print Stock Item Additional Description as additional column in Invoice

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

    
  1. Rais Ahmed

    Rais Ahmed Member


    In B2C report I M facing 1 problem that is I put Invisible field for Gst No. Item so B2C item only come out but invisible line r coming in between is there any solution 2 remove those blank lines? And I put sale and credit note and purchase and debit note combined filter but even there is no tax entry even though all the credit note debit note is coming.
    Regards
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    "Snipping Tool" is available in WINDOWS.............use that..........

    why take pics, transfer to PC, then downsize, the upload............I hope you do not travel between 2 cities via a whole world tour :):cool::p
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Are you using Invisible in both the Titles and Data fields???
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    The DN and CN amount not coming....might be due to the way you have defined the Purchase and Sales figure. Cannot comment without looking. If purchase is positive then DN will be negative and vice versa.

    Capture.PNG
     


  5. Rais Ahmed

    Rais Ahmed Member


    Improved pic. Thanks will use that tool
     

    Attached Files:

    • 1.jpg
      1.jpg
      File size:
      241.2 KB
      Views:
      38
    • 2.jpg
      2.jpg
      File size:
      3.1 MB
      Views:
      32
    • 3.jpg
      3.jpg
      File size:
      3.3 MB
      Views:
      35
    • 4.jpg
      4.jpg
      File size:
      3 MB
      Views:
      31
    • 5.jpg
      5.jpg
      File size:
      2.4 MB
      Views:
      35


  6. Rais Ahmed

    Rais Ahmed Member


    No Sir only put in field. I have sent my TDL 2 U on DEC end.
     


  7. Rais Ahmed

    Rais Ahmed Member


    Invisible was not working so i put Inactive, I have informed u earlier but at that time I did not test thoroughly. Due 2 that B2C report has blank lines (1.jpg) also credit not entry also come. If can put condition that "If credit note or debit note has tax ledger only then yes else no". Is it possible? In B1 and B2b report i remove invisible because alignment was changing.
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use..............remove if : <condition> at LINE level
     


  9. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    Very Much thankful to guide me. I succeeded with Ur suggestion of "REMOVE IF:". But I could not insert $IsDutyLedger function to collection.Instead if I put "Belong to" or "Child of" to filter duty ledger from DN or CN or from any type of vouchers. I actually don't know 2 apply those attributes .Any Help SIR
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    you cannot insert filter directly..................$IsDutyLedger......... but you can use that in Child Of--------

    Make formula
    [System : Formula]
    myFltrDutyLeds : $IsDutyLedger

    Then in Collection.............put

    Filter : myFltrDutyLeds
     


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Or if you want JUST .......GST Duty ledgers....

    myFltrDutyLeds : ($$IsSysNameEqual:GST:$TaxType) AND $IsDutyLedger
     


  12. Rais Ahmed

    Rais Ahmed Member


    Amitji,
    Actually My collection entry is as under in that I tried both suggestion but all the field goes blank than I tried this one that also not worked.
    [Collection : My Voucher Collection]
    Type : Vouchers
    Filter : OnlySalesCreditNote
    ;Filter : DutyLedgers
    Fetch : Date,Amount,PartyLedgerName,Reference,VoucherNumber,TAmount,IGST,CGST,SGST,CESS
    Fetch : Stock Item,Inventory Entries
    [System: Formula]
    OnlySalesCreditNote : $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName Or $Journal:$VoucherTypeName
    ;DutyLedgers : If $$IsCreditNote:$VoucherTypeName Contains "Duty Ledgers" then yes else no
    I M trying that if CN or DN or JR voucher has Duty Ledgers that entry only comes and I have APMC as duty Ledger not only GST so I M taking Duty Ledgers. Pl help in this matter.
    Regards
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [Collection : My Voucher Collection]
    Type : Vouchers
    Child of : $$Name
    Belongs to : yes

    Filter : OnlySalesCreditNote
    ;Filter : DutyLedgers
    Fetch : Date,Amount,PartyLedgerName,Reference,VoucherNumber,TAmount,IGST,CGST,SGST,CESS
    Fetch : Stock Item,Inventory Entries
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your collection is of Vouchers.....and in that how are you trying to have a filter of Dutyledgertype...... it won't work........

    If collection is of ledger, then Dutytype filter will work...............
     


  15. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    I tried Ur Suggestion, But all entry R coming not only Duty Ledgers. I tried Filter formula in Line and Field also not worked so tried in collection. Is it possible that I put "REMOVE IF" in all the field with condition that "IF $voucher has Duty Ledgers Then Yes else No". Or else can make 2 collection . 1 with voucher, 2 with ledgers but hoe 2 apply same time?
    Regards
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    can't comment without looking at the code..... send it to my email.............

    and also please explain by screenshot what ur objective and u trying to get???
     


  17. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    sent mail with code and demo data. this time I use Snipping Tool as U suggested. Please help.
    Regards.
     


  18. Rais Ahmed

    Rais Ahmed Member


    Dear Amitji,
    One problem of Total mistake has been solved. Now only DN,CN & Jr entry remains.
    Thanks And Regards
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Ok will check....give time...as am travelling.
     


  20. Abhishek55

    Abhishek55 New Member


    Hello Garima

    Can you help update this TDL so that it works in Tally Prime? Any help is greatly appreciated.

    Thanks in advance!

    Abhishek

    EDIT:
    F12 does not print the option "Print Additional Description in separate Column?"
    In my fair opinion the following line needs to be edited and it should work as desired.

    Add : Line : Before : SATraderAddlDesc : RBCAddlDescColumn

    The code works in Tally Prime if
    RBCTraderAddlDesc is set to : Yes
     
    Last edited: Apr 18, 2022


Share This Page