Narration in Stock Item

Discussion in 'Tally.ERP 9' started by bharat shah, Jan 23, 2021.

    
  1. bharat shah

    bharat shah Member


    dear Experts
    i want narration field in stock item as show . i tried this code but not showing in stock item voucher

    [#Form: Stock Item]

    [#Line: DBTitle2]
    Add : Field : After : DSP VchAcctTitle : Narration
    [Field: Narration]
    Set As : "Narration"
    Width : 15
    Align : center
    Style : Normal Bold

    [#Line: DSP VchDybkDetail2]
    Add : Field : After : DSP VchAccount : Narration1
    [Field:Narration1]
    Use : Name Field
    Set As : $Narration
    Width : 15
    Align : Center
    color : blue
    Style : Normal bold


    [#Collection : Vouchers of StockItems]
    Fetch : Narration
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Please make some serious efforts...........

    The code above has nothing to do with STOCK or stockreport ..........
     
    bharat shah likes this.


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You can make a proper attempt at a proper code........ we can guide you if there is any problem..........
     


  4. bharat shah

    bharat shah Member


    Amit sir i want narration in stock item Report. is the below form right or not
    [#Form: Stock Item]
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    No...the FORM is wrong...........

    Open Tally in Developer mode.............

    Go to the above screenshot .... and place cursor in any blank spaces...... you will get the FORM name........... The Form name is "STOCK VOUCHERS"

    Refer to that FORM in Developer......... find the Title Line and the BODY Line........... refer to it and make your fields..........

    Your Fields are correct, you just need to reference the correct one.
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  7. bharat shah

    bharat shah Member



  8. bharat shah

    bharat shah Member


    amit sir i tried but not coming. The Field DSP VchAcctTitle is common in Sales/ Purchase register also . It is showing there but not in stock voucher. I tried in Developer Mode also. I think
    i am not getting the Form correct

    [#Form: Stock Vouchers]

    [#Line: DBTitle1]
    Add : Field : After : DSP VchAcctTitle : Narration
    [Field:Narration]
    Set As : "Narration"
    Width : 15
    Align : center
    Style : Normal Bold
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Either you are confused or making others confused........ :);)

    From your fist POST and screenshot, it is apparent you want Narrration in Stock Report... when you drill down to the "Stock Vouchers"

    Now, as per your previous Post, you are talking about Sales/Purchase register...............

    Kindly examine.......... Line: DSP VchTitle ..... from there you will get an OPTION for INV-related titles.

    Kindly examine........ Line: STKVCH VchDetail ... from there you will get the Details field......
     
    bharat shah likes this.


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You do not need to refer to the FORM nor the Collection.

    Simply address the appropriate LINE, add your fields and you are done. Your FIELD parameters are also correct.
     


  11. bharat shah

    bharat shah Member


    No sir i want Narrration in Stock Report. its just that Field is common in both Report
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You can get Narration in "Stock Vouchers" ... that is what the screenshot of yours is showing.

    Narration is not possible in Stock Report.... as there are no vouchers..........

    In Stock Report...... you press ENTER on any StockItem.....it will take you to monthly report..........PRess Enter on any month and it will take you to Voucher-wise StockItem Report.......... here in this report, you will be able to get the NARRATION.

    I have given you the HINTS to Title Line and Data Line............am sure you can do it on your own. Keep on
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is Common for Accounting vouchers.............. for Inventory Vouchers, they are not common.
     


  14. bharat shah

    bharat shah Member


    Amit sir
    after going from Tally developer , i am blank and confused . i tried with [#Form: Stock Vouchers] or [#Line: StockItemName] but failed. if you can give starting line then
    i can go forward
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I am already helping you, but you are NOT reading it properly and thoroughly.

    You DO NOT need to refer to FORM in your code......... just directly address the relevant LINE and add your Fields.

    I have given you the name of the 2 LINES that you need to refer to. Find that lines in Developer and from there add your fields.
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Kindly examine.......... Line: DSP VchTitle ..... from there you will get an OPTION for INV-related titles.

    Kindly examine........ Line: STKVCH VchDetail ... from there you will get the Details field......
     


  17. bharat shah

    bharat shah Member


    Amit sir
    i got one line correct but dont know 2 nd is correct or not
    [#Line : DSP VchInv1Titles]
    Add : Field : After : DSP VchAcctTitle : Narration
    [Field:Narration]
    Set As : "Narration"
    Width : 15
    Align : center
    Style : Normal Bold

    [#Line: STKVCH ClPageBreak]
    Add : Field : After : DSP VchitemAccount : Narration1
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have given you the CORRECT name of the 2nd Line........... please read my previous post.
     
    Jaydeep Shah and bharat shah like this.


  19. bharat shah

    bharat shah Member


    sir i tried with that too but not working

    [#Line: STKVCH VchDetail]
    Add : Field : After : DSP VchitemAccount : Narration1
    [Field:Narration1]
    Use : Name Field
    Set As : $Narration
    Width : 15
    Align : Center
    color : blue
    Style : Normal bold
     


  20. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In Field : Narration1 ......... add line ....... Background: yellow ....... does it show ??? NO .... then it is wrong......

    In [#Line: STKVCH VchDetail] ... There are multiple OPTIONS......... take the Normal One ..... add your fields there.
     
    Jaydeep Shah and bharat shah like this.


  21. bharat shah

    bharat shah Member


    Finally got it amit sir. thanks for your Valuable time
     

    Attached Files:

    Jaydeep Shah likes this.


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very Good....hope you learned it well :);)
     
    bharat shah likes this.


  23. suresh mittal

    suresh mittal New Member


    [#Line : DSP VchInv1Titles]
    Add : Field : After : DSP VchAcctTitle : DBC Batch

    [Field : DBC Batch]
    Set As : "Batch"
    Width : 15
    Align : center
    Style : Normal Bold

    [#Line: DSP VchInvDetail]
    Add : Field : After : DSP VchItemAccount : DBC Batch1

    [Field : DBC Batch1]
    Use : Name Field
    Width : 15
    ;Set as : $Narration
    Set as : $$FullList:BatchAllocations:$BatchName
    Align : Center
    Style : Normal bold

    This is working code in Narration but i am not able to get batch number pls help
     


  24. vishnu joshi

    vishnu joshi Member


    Try This
    Code:
    [Field : DBC Batch1]
    Use : Name Field
    Width : 15
    ;Set as : $Narration
    Set as : $$FullList:AllInventoryEntries:@@ItemBatch
    Align : Center
    Style : Normal bold
    
    [System:Formula]
    ItemBatch : $$FullList:BatchAllocations:$BatchName
     


Share This Page