EXP Ledger Narration

Discussion in 'Free Source Codes' started by Rais Ahmed, Oct 6, 2020.

    
  1. Rais Ahmed

    Rais Ahmed Member


    Dear Experts,
    I want to add exp ledgers entry with narration in Invoice. Is it possible? Pl give idea.
    Thanks.
     


  2. Rais Ahmed

    Rais Ahmed Member


    Dear experts.
    I mean that if in Invoice I want to add Freight exp or labor charge or any other exp then for that details (Narration) i want to add.
    Please help and guide.
    Thanks.
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Do not understand your need.... isn't narration available in Sales/Purchase ???

    Or you can activate ledger-wise narration in F12.
     


  4. Rais Ahmed

    Rais Ahmed Member


    Dear Sir,
    Attached Invoice . description for exp item entered in invoice.
    thanks
     

    Attached Files:



  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Activate "Additional Description for Ledger" in F12 -> Invoice / Orders Entry
     


  6. Rais Ahmed

    Rais Ahmed Member


    Amitji,
    it is there, but for accounting invoice only, moreover I need only some exp ledger description for exp group not for all accounts. Please if possible pl guide how to make Tdl for description.
    Thanks and Regards
     


  7. Rais Ahmed

    Rais Ahmed Member


    And if I use in New UDF Set As : $BasicUserDescription can work ?
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You can activate it and simply fill in details only for those ledgers that you need, rest all you ignore it.

    As for TDL, you need to make on...based on how the -- BasicUserDescription is.....same way you can make as per your needs. It is available in Developer.
     


  9. rony

    rony Member


    Dear,
    Please refer TD and you will get function in invoice.500 edit it and all you will get what you want. I tried for 2 days and succeed.
    regards.
     


  10. Rais Ahmed

    Rais Ahmed Member


    Dear Sir,
    I go through TD and got particular function edited and got exp led narration in Invoice. But since 5 days same function did not work something mess up i tried lot but in vain. can any one guide me how to enable ledger narration or description in invoice. I tried F-12 for that but it only allows account invoice and not item invoice.
    Thanks.
     


  11. Himanshu-2002

    Himanshu-2002 Active Member


    Post Your Edited Function And Requirements With Screenshot and Proper Example.... I will try to solve it
     


  12. Rais Ahmed

    Rais Ahmed Member


    Dear,
    [Field: EI Desc]

    Use : Name Field
    Style : Small Italic
    Storage : BasicUserDescription
    Set as : If (($$ExplodeLevel = 0) AND ($$Line = 1) AND NOT ##SVAcctsInvoice) Then $Description:StockItem:$StockItemName Else $$Value
    Cells : @@ExcelItemColumn
    This is original in that I removed condition then ledger description enabled but now it is not working. My oct post (above) has screen shot.
    Example;
    In invoice if u add freight exp or wages or any exp ledger for that detail description window open like when we add item then detais description windows come.
    thanks.
     

    Attached Files:



  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    where is the # ?? you forgot to add that.
     


  14. Himanshu-2002

    Himanshu-2002 Active Member


    [#Field: EI Desc]
     


  15. Rais Ahmed

    Rais Ahmed Member


    Sir,
    I put # that on edited function. Above for what Mr. himanshu told for reference so i just reefer. Still I M trying in TD. Any idea sirji please.
    Thanks
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Hey Doc.... I am not feeling well..........

    On basis of above....no Doctor will prescribe medicines or treatment.

    So as Himanshu said / requested ......... please submit the details...without which it is just waste of time, as we the SOLVERS cannot understand your problems.
     


  17. Rais Ahmed

    Rais Ahmed Member


    Dear Experts,
    Something mistaken as Mr. Himanshu said I posted TD default function. Now Sorry for that my need is, In invoice mode if I need to add any Exp it is not showing description windows like Item Pic-1. Earlier Amit sir suggested for F-12 to enable ledger description, But it activates in only for Accounting Invoice and not in Item Invoice. Then Mr. Rony guided for TD file Invoice.500 to edit and I found function in [Field: EI Desc] where condition was given in Set as : If (($$ExplodeLevel = 0) AND ($$Line = 1) AND NOT ##SVAcctsInvoice) Then $Description:StockItem:$StockItemName Else $$Value. So I removed AND NOT ##SVAcctsInvoice with [#Field: EI Desc] and ledger description activated Pic-2. But since 4-5 days same function are not working so I think some thing goes wrong because I m trying so many TDL and function to learn . I again reefer TD but could not succeed . I need that, as in Account Invoice mode ledger description windows come Pic-3 that should be activate in Item Invoice mode. So please help me regarding this . I am still trying in TD but Experts help is must. If I M mistaken PL forgive.
    Thanks and Regards.
     

    Attached Files:



  18. Himanshu-2002

    Himanshu-2002 Active Member


    So, Basically You want to Add Ledger Description in Invoice Mode.... Ok I have to check few Fields after that I will suggest you....
     


  19. Himanshu-2002

    Himanshu-2002 Active Member


    And Sir I was telling you to post the Edited Function Not Default Function... Because Mostly Default default functions have many reference function So, I will never suggest anyone to post Default Function.... No Issue... And One More suggestion that Please try to explain your Requirements In Proper way So, You will get your solution sooner....
     


  20. Rais Ahmed

    Rais Ahmed Member


    Dear Himanshu,
    I explain in detail. As you said " Basically You want to Add Ledger Description in Invoice Mode" is right. And I also explain that in default function I removed default Condition AND NOT ##SVAcctsInvoice after that Ledger description worked (Pic-2). But now it is not working.Meanwhile I was refering same INVOICE.500 in that found
    ;;This will explode Additional Decriptions of ledger.
    Explode : EI DescExplosion : NOT $$IsEmpty:$LedgerName AND ##ICFGLedAddlDesc AND NOT $$IsEmpty:$BasicUserDescription
    In that if can we can add. It is just my view. I M trying.
    Thanks
     


  21. Himanshu-2002

    Himanshu-2002 Active Member


    Sir I think you misunderstood Function with a logical Statement.... Function Looks Like This in TDL

    [Function: Write Hello World ]
    00: Log: "Hello World"

    Logical Statement:
    Set as: If 1=1 Then "Yes" else "No"
     


  22. Himanshu-2002

    Himanshu-2002 Active Member


    And Explode is attribute available at Line Level which has syntax like this

    Explode:<Explode Part>: <Logical Statement>
     


  23. Rais Ahmed

    Rais Ahmed Member


    Dear experts,
    Thanks for your valuable support and help specially Mr. Amit sir and Mr. Himanshuji. Issue resolved just now.
     


  24. Himanshu-2002

    Himanshu-2002 Active Member


    Congrats Sir....
     


  25. Rais Ahmed

    Rais Ahmed Member


    Dear Experts,
    Again same thing happened Tdl not working And again I M approaching High Commands 4 help.
    Regards.
     


Share This Page