Dear Experts I want to display narration column in movement analysis report (Display -->Inventory Books-->Movement Analysis-->Stock Item Analysis-->Item Name -->Party Name /Ledger Name-->)but I couldn't success. Can anybody help me ? Picture of desired report is attached. Code is : [#Line: STV ColVchTitle] Add : Field : After : STV Fixed: DSP VchNarration Local : Field : DSP VchNarration : Info : "Voucher" [#Line: STV ColVchTitle1] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : "Narration" ;----------------Body Part----------------------------------------------------- [#Line : STV MoveTitle] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : "" [#Line: STV ColVchDetail] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : $Narration [#Line: STV Vouchers] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : "" [#Line: STV AltQExplode] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : "" [#Line: STVVCH Narr] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : "" [#Line: STV ColVchTotal] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : "" Local : Field : DSP VchNarration: Delete: Border [Field: DSP VchNarration] Set as: $Narration Width : 20
When you are in this report..... Press F12....select "DETAILED" report, then the narration option comes which you can set as YES. and so you will get Narration. So why go the roundabout way to get narration when the option already exists??
[#Field: STV Fixed] Add : Field: After : STV Party : NarrationDetails [Field: NarrationDetails] Use : Name Field Set as : $Narration Width : 20 Border : Thin Right Lines : 0 [#Line: STVScrBorders] Local : Field : NarrationDetails : Delete : Border Use above code............ discard rest of your code.... the NARRATION will appear in detailed mode (Alt+F1)
Dear Amit Jee, Yes, we can display Narration by pressing F12 option, but when we want to print this report it takes too much paper. So I want to display narration just after party ledger name.
Dear Amitji, I am uploading the screenshot here, because there is no option in conversation Cost Centre- Month wise.
Yes, I tried the code you mentioned. But it is not as per my requirement. We have to press Alt + F1 to view the narration but I want to show the narration directly (without pressing ALT+F1) I am trying to display narration in this line : [#Line: STV ColVchDetail] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : $Narration I tested the date to display date in this field [#Line: STV ColVchDetail] Add : Field: After : STV Fixed : DSP VchNarration Local : Field: DSP VchNarration : Set As : $Date It displays easily, but narration is not displaying. I am surprised.
I NEED TO EXPORT MULTI STOCK ITEM ALTERATION IN EXCEL SHEET...... ANY OTHER SOLUTION IS THERE HA SIR?
That is because the column heading Fields and the Body Fields are different. Also the 7 columns + there are 3 hidden (non-active) columns..i.e. Godown, Batch Name and Additional cost. Therefore you code is correct, but because of column limitations it is not showing. You will have to redesign the whole body part and inserting your narration column in between. I also used same method like you...other data is displaying but not narration.
Hey Mr. Gangstar (CAPS)... please use another thread or make a new one..... No one will reply if you use the wrong thread. Kindly delete and post your query the right way. And stop using CAPS. Thanks.
I need to Export Multi Stock Item Alteration in Excel Sheet ..... Any other solution is there ha Sir?