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
Please make some serious efforts........... The code above has nothing to do with STOCK or stockreport ..........
You can make a proper attempt at a proper code........ we can guide you if there is any problem..........
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.
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
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......
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.
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
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
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.
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......
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
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
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.
[#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
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