I HAVE CREATED A SUMMARY REPORT FOR OUTSTANDING PO IN WHICH I WANT TO ADD REMARKS IN STATUS COLUMN AND EXPECTED DATE IN THE SAID COLUMN IM NOT ABLE TO SAVE INPUT IN STATUS COLUMN AND DATE COLUMN FOLLOWING IS MY TDL [#Menu: Gateway of Tally] indent : PURCHASE ORDER REPORT item : blank Item: ORDER FOLLOW UP : Menu: ORDER FOLLOW UP [Menu: ORDER FOLLOW UP] Add : Key Item : "ORDER SUMMARY" : R : Alter : ITEMWISEORDERSUMMARY [Report:ITEMWISEORDERSUMMARY] Use : DSP Template Family : $$Translate:"Item Purchase Orders Outstanding" Title : "ASSUREPHARMA PURCHSE ORDER FOLLOW UP" Variable : SV Print Orientation : String Form : ITEMWISEORDERSUMMARY Set : FilterPOITEMSUMMARY : "item select" Set : SVFromDate : $$MonthStart:##SVFromDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Variable : SVFromDate, SVToDate Variable : Stock Item Name Variable : LedgerName [Form:ITEMWISEORDERSUMMARY] Button : PrintButton, ExportButton add: Button : ChangePeriod,StockItem Part : POPARTYTITLE,PMITEMTITLE,POHEADDETAIL,POSUMMARY Bottom Part: ENDTITLE Width : 100% Page Height : 100% page Space Left : 2 mms Space Right : 2 mms background : white Set Always : SV Print Orientation : "Landscape" [PartOPARTYTITLE] Line : POPARTYTITLE Horizontal Align : Center Common Border : Yes [LineOPARTYTITLE] Field : Simple Field Local : Field : Simple Field : Style : Calibri Large Bold Local : Field : Simple Field : Info : "ORDER FOLLOW UP SUMMARY" Local : Field : Simple Field : Border: column Local : Field : Simple Field : Align : Center Local : Field : Simple Field : COLOR: Aquamarine [PartMITEMTITLE] Line : PMITEMTITLE Common Border : Yes [LineMITEMTITLE] Field : name field Local : Field : Name Field : Info : @@DSPDateStr Local : Field : Name Field : Width : 100% page Local : Field : Name Field : Align : Justified Local : Field : Default : Color : Aquamarine Local : Field : Simple Field : Border: Thin bottom Local : Field : Default : Style : Calibri Large Bold [PartOHEADDETAIL] Line : POHEADDETAIL Common Border : Yes [LineOHEADDETAIL] FieldOSRNOTITLE,PODATETITLE,POVOUCHERIDTITLE,POITEMTITLE,POVENDORTITLE,POSTATUSTITLE,POCALENDERTITLE Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Name field : Width : 100% page Local : Field : Default : Border rint : Topped Double Sub Column Titles Local : Field : Default : Style : Calibri Large Bold Local : Field : Default : background : Aquamarine Local : Field : Default : Color : WHITE Local : Field : POSRNOTITLE : Set as : "SR NO" Local : Field : PODATETITLE : Set as : "DATE" Local : Field : POVOUCHERIDTITLE : Set as : "VOUCHER NO" Local : Field : POITEMTITLE : Set as : "PRODUCT" Local : Field : POVENDORTITLE : Set as : "VENDOR NAME" Local : Field : POSTATUSTITLE : Set as : "STATUS" Local : Field : POCALENDERTITLE : Set as : "EXPECTED DATE OF DELIVERY" [Field : POSRNOTITLE] Use : Simple Field Style : Normal BOLD Width : 4% page Border : Thin Right Align : Center Read Only : Yes Skip : Yes [Field: PODATETITLE] Use : Date Field Style : Normal BOLD Width : 6% page Align : Center Read Only : Yes Skip : Yes [Field : POVOUCHERIDTITLE] Use : Simple Field Style : Normal BOLD Width : 12% page Align : Center Read Only : Yes Skip : Yes [Field : POITEMTITLE] Use : Simple Field Style : Normal BOLD Width : 18% page Align : Center Read Only : Yes Skip : Yes [Field : POVENDORTITLE] Use : Simple Field Style : Normal BOLD Width : 20% page Color : BLUE Align : Center Read Only : Yes Skip : Yes [Field : POSTATUSTITLE] Use : Simple Field Style : Normal BOLD Width : 25% page Color : BLUE Align : Center Read Only : Yes Skip : Yes [Field : POCALENDERTITLE] Use : Simple Field Style : Normal BOLD Width : 15% page Color : BLUE Align : Center Border : Thin right Read Only : Yes Skip : Yes ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Report section;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Part: POSUMMARY] Line : POSUMMARY Scroll : Both Common Border : Yes Border: Bottom Flush Column Titles RepeatOSUMMARY:OUTSTANDINGPURCHASEALL [LineOSUMMARY] FieldOSRNOSUMMARY,PODATESUMMARY,POVOUCHERIDSUMMARY,POITEMSUMMARY,POVENDORSUMMARY,POSTATUSSUMMARY,POCALENDERSUMMARY Local : Field : Default : Type : String Local : Field : Default : Align : Justified Local : Field : Default : Border: Double Sub Column Titles Local : Field : Default : Style : Calibri Default Bold Local : Field : Name field : Width : 100% page [FieldOSRNOSUMMARY] Use : Number Field Style : Normal BOLD Width : 4% page Align : Center Set as : $$Line Read Only : Yes Skip : Yes [Field: PODATESUMMARY] Use : Date Field Style : Normal BOLD Width : 6% page Align : Center Set as : $Date Read Only : Yes Skip : Yes [Field : POVOUCHERIDSUMMARY] Use : Extract Alias Collection Style : Normal BOLD Width : 12% page Align : Center Set as : $VOUCHERNUMBER Read Only : Yes Skip : Yes [Field : POITEMSUMMARY] Use : Name Field Style : Normal BOLD Width : 18% page Align : Left Set as : $stockitem Read Only : Yes Skip : Yes Quick Search: Yes [Field : POVENDORSUMMARY] Use : Name Field Style : Normal BOLD Width : 20% page Align : Center Set as : $POVENDORSUMMARY Read Only : Yes Skip : Yes [Field : POSTATUSSUMMARY] Use : Name Field Style : Normal BOLD Type : String Width : 25% page Color : BLUE Border : THIN RIGHT Skip : repeat Cell Write : $$Value Set as : $$value Inactive : REPEAT ;Storage : @@narration ;Variable : NARRATION [Field : POCALENDERSUMMARY] Use :UniDateField Style : Normal BOLD Width : 15% page Color : BLUE Align : Center Border : THIN RIGHT Type : Date Inactive : REPEAT Set : $SVTODATESET Variable : SVFromDate, SVToDateSet ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;collection;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Collection: OUTSTANDINGPURCHASE] Collection : OUTSTANDINGPURCHASEALL, OUTSTANDINGPURCHASEALLITEM [Collection:OUTSTANDINGPURCHASEALL] Type : Purchase Orders Child Of : ##LedgerName,##Voucher Cleared : No Compute: POVENDORSUMMARY :$LedgerName Fetch:VCHNUM [Collection:OUTSTANDINGPURCHASEALLITEM] Type : Purchase Orders Cleared : No Child Of : ##StockItemName Compute : POITEMSUMMARY :$StockItemName Walk : ALLInventoryEntries Fetch : Date,stockitemname,vchnum,narration Compute: POVOUCHERIDSUMMARY :$VoucherNumber Compute: PODATESUMMARY :$DATE Compute: PONARRATIONSUMMARY:$Narration [PART:ENDTITLE] Line : ENDTITLE Horizontal Align : Center Common Border : Yes [Line:ENDTITLE] Field : Simple Field Local : Field : Simple Field : Style : Calibri Large Bold Local : Field : Simple Field : Info : "ASSURE PHARMA" Local : Field : Simple Field : Border: column Local : Field : Simple Field : Align : Center Local : Field : Simple Field : COLOR: Aquamarine Local : Field : Name field : Width : 100% page ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Buttons;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Button:StockItem] Key : F3 Action : Execute : ITEMWISE Title : ITEM [Report:ITEMWISE] Form :ITEMWISE [Form:ITEMWISE] Part :ITEMWISE Space Left : 2 mms Space Right : 2 mms [Part:ITEMWISE] Line : ITEMWISE [Line:ITEMWISE] Field : Medium Prompt,ITEMWISE Local : Field : Medium Prompt : Set as : "SELECT ITEM" Space Bottom : 2 mms [Field:ITEMWISE] Table : FILTERITEM ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterPOITEMSUMMARY [Collection: FilterPOITEMSUMMARY] Typeurchase Orders Use:$POITEMSUMMARY FILTER :##StockItemName [System:formula] POITEMSUMMARY : $$IsBelongsTo:$$STOCKITEMNAME
[Field : POSTATUSSUMMARY] Use : Narration Field Style : Normal BOLD Width : 36% page Color : BLUE Align : Center Set as :$$REMARK Storage :MYNARRATION [System : UDF] MYNARRATION : String : 25022 [Field : POCALENDERSUMMARY] Use : name Field Style : Normal BOLD Width : 10% page Color : BLUE Align : Center Border : THIN RIGHT Set as : $MYDATE Storage : mydate [System : UDF] mydate : String : 25023
[#Menu: Gateway of Tally] indent : PURCHASE ORDER REPORT item : blank Item: ORDER FOLLOW UP : Menu: ORDER FOLLOW UP [Menu: ORDER FOLLOW UP] Add : Key Item : "ORDER SUMMARY" : R : Alter : ITEMWISEORDERSUMMARY [Report:ITEMWISEORDERSUMMARY] Use : DSP Template Family : $$Translate:"Item Purchase Orders Outstanding" Title : "ASSUREPHARMA PURCHSE ORDER FOLLOW UP" Variable : SV Print Orientation : String Form : ITEMWISEORDERSUMMARY Set : FilterPOITEMSUMMARY : "item select" Set : SVFromDate : $$MonthStart:##SVFromDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Variable : SVFromDate, SVToDate Variable : Stock Item Name Variable : LedgerName [Form:ITEMWISEORDERSUMMARY] Button : PrintButton, ExportButton add: Button : ChangePeriod,StockItem Part : POPARTYTITLE,PMITEMTITLE,POHEADDETAIL,POSUMMARY Bottom Part: ENDTITLE Width : 100% Page Height : 100% page Space Left : 2 mms Space Right : 2 mms background : white Set Always : SV Print Orientation : "Landscape" [PartOPARTYTITLE] Line : POPARTYTITLE Horizontal Align : Center Common Border : Yes [LineOPARTYTITLE] Field : Simple Field Local : Field : Simple Field : Style : Calibri Large Bold Local : Field : Simple Field : Info : "ORDER FOLLOW UP SUMMARY" Local : Field : Simple Field : Border: column Local : Field : Simple Field : Align : Center Local : Field : Simple Field : COLOR: Aquamarine [PartMITEMTITLE] Line : PMITEMTITLE Common Border : Yes [LineMITEMTITLE] Field : name field Local : Field : Name Field : Info : @@DSPDateStr Local : Field : Name Field : Width : 100% page Local : Field : Name Field : Align : Justified Local : Field : Default : Color : Aquamarine Local : Field : Simple Field : Border: Thin bottom Local : Field : Default : Style : Calibri Large Bold [PartOHEADDETAIL] Line : POHEADDETAIL Common Border : Yes [LineOHEADDETAIL] FieldOSRNOTITLE,PODATETITLE,POVOUCHERIDTITLE,POITEMTITLE,POVENDORTITLE,POSTATUSTITLE,POCALENDERTITLE Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Name field : Width : 100% page Local : Field : Default : Border rint : Topped Double Sub Column Titles Local : Field : Default : Style : Calibri Large Bold Local : Field : Default : background : Aquamarine Local : Field : Default : Color : WHITE Local : Field : POSRNOTITLE : Set as : "SR NO" Local : Field : PODATETITLE : Set as : "DATE" Local : Field : POVOUCHERIDTITLE : Set as : "VOUCHER NO" Local : Field : POITEMTITLE : Set as : "PRODUCT" Local : Field : POVENDORTITLE : Set as : "VENDOR NAME" Local : Field : POSTATUSTITLE : Set as : "STATUS" Local : Field : POCALENDERTITLE : Set as : "EXPECTED DATE OF DELIVERY" [Field : POSRNOTITLE] Use : Simple Field Style : Normal BOLD Width : 4% page Border : Thin Right Align : Center Read Only : Yes Skip : Yes [Field: PODATETITLE] Use : Date Field Style : Normal BOLD Width : 6% page Align : Center Read Only : Yes Skip : Yes [Field : POVOUCHERIDTITLE] Use : Simple Field Style : Normal BOLD Width : 12% page Align : Center Read Only : Yes Skip : Yes [Field : POITEMTITLE] Use : Simple Field Style : Normal BOLD Width : 18% page Align : Center Read Only : Yes Skip : Yes [Field : POVENDORTITLE] Use : Simple Field Style : Normal BOLD Width : 20% page Color : BLUE Align : Center Read Only : Yes Skip : Yes [Field : POSTATUSTITLE] Use : Simple Field Style : Normal BOLD Width : 25% page Color : BLUE Align : Center Storage: Status Read Only : Yes Skip : Yes [Field : POCALENDERTITLE] Use : Simple Field Style : Normal BOLD Width : 15% page Color : BLUE Align : Center Border : Thin right Read Only : Yes Skip : Yes Storage: Delivery [System: UDF] Delivery: String: 41071 Status: String: 41072 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Report section;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Part: POSUMMARY] Line : POSUMMARY Scroll : Both Common Border : Yes Border: Bottom Flush Column Titles RepeatOSUMMARY:OUTSTANDINGPURCHASEALL [LineOSUMMARY] FieldOSRNOSUMMARY,PODATESUMMARY,POVOUCHERIDSUMMARY,POITEMSUMMARY,POVENDORSUMMARY,POSTATUSSUMMARY,POCALENDERSUMMARY Local : Field : Default : Type : String Local : Field : Default : Align : Justified Local : Field : Default : Border: Double Sub Column Titles Local : Field : Default : Style : Calibri Default Bold Local : Field : Name field : Width : 100% page [FieldOSRNOSUMMARY] Use : Number Field Style : Normal BOLD Width : 4% page Align : Center Set as : $$Line Read Only : Yes Skip : Yes [Field: PODATESUMMARY] Use : Date Field Style : Normal BOLD Width : 6% page Align : Center Set as : $Date Read Only : Yes Skip : Yes [Field : POVOUCHERIDSUMMARY] Use : Extract Alias Collection Style : Normal BOLD Width : 12% page Align : Center Set as : $VOUCHERNUMBER Read Only : Yes Skip : Yes [Field : POITEMSUMMARY] Use : Name Field Style : Normal BOLD Width : 18% page Align : Left Set as : $stockitem Read Only : Yes Skip : Yes Quick Search: Yes [Field : POVENDORSUMMARY] Use : Name Field Style : Normal BOLD Width : 20% page Align : Center Set as : $POVENDORSUMMARY Read Only : Yes Skip : Yes [Field : POSTATUSSUMMARY] Use : Name Field Style : Normal BOLD Type : String Width : 25% page Color : BLUE Border : THIN RIGHT Skip : repeat Cell Write : $$Value Set as : $$value Inactive : REPEAT ;Storage : @@narration ;Variable : NARRATION [Field : POCALENDERSUMMARY] Use :UniDateField Style : Normal BOLD Width : 15% page Color : BLUE Align : Center Border : THIN RIGHT Type : Date Inactive : REPEAT Set : $SVTODATESET Variable : SVFromDate, SVToDateSet ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;collection;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Collection: OUTSTANDINGPURCHASE] Collection : OUTSTANDINGPURCHASEALL, OUTSTANDINGPURCHASEALLITEM [Collection:OUTSTANDINGPURCHASEALL] Type : Purchase Orders Child Of : ##LedgerName,##Voucher Cleared : No Compute: POVENDORSUMMARY :$LedgerName Fetch:VCHNUM [Collection:OUTSTANDINGPURCHASEALLITEM] Type : Purchase Orders Cleared : No Child Of : ##StockItemName Compute : POITEMSUMMARY :$StockItemName Walk : ALLInventoryEntries Fetch : Date,stockitemname,vchnum,narration Compute: POVOUCHERIDSUMMARY :$VoucherNumber Compute: PODATESUMMARY :$DATE Compute: PONARRATIONSUMMARY:$Narration [PART:ENDTITLE] Line : ENDTITLE Horizontal Align : Center Common Border : Yes [Line:ENDTITLE] Field : Simple Field Local : Field : Simple Field : Style : Calibri Large Bold Local : Field : Simple Field : Info : "ASSURE PHARMA" Local : Field : Simple Field : Border: column Local : Field : Simple Field : Align : Center Local : Field : Simple Field : COLOR: Aquamarine Local : Field : Name field : Width : 100% page ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Buttons;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Button:StockItem] Key : F3 Action : Execute : ITEMWISE Title : ITEM [Report:ITEMWISE] Form :ITEMWISE [Form:ITEMWISE] Part :ITEMWISE Space Left : 2 mms Space Right : 2 mms [Part:ITEMWISE] Line : ITEMWISE [Line:ITEMWISE] Field : Medium Prompt,ITEMWISE Local : Field : Medium Prompt : Set as : "SELECT ITEM" Space Bottom : 2 mms [Field:ITEMWISE] Table : FILTERITEM ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterPOITEMSUMMARY [Collection: FilterPOITEMSUMMARY] Typeurchase Orders Use:$POITEMSUMMARY FILTER :##StockItemName [System:formula] POITEMSUMMARY : $$IsBelongsTo:$$STOCKITEMNAME
Ooh Sorry I can't help you much Because My tally is going crazy, Maybe there is some bug in Latest Update So, I can't check your TDL in my System But You made an awesome TDL So, Congrats
It will be resolved Try this (At Form Level) on: Form accept:Call: Function try to do something like this
You have split up the PARTS, in order to use the aggregrate i.e. different collections......... but this will not work....as there is no LINK. Let's say u have 10 POs pending and you get / feed the above status etc..... now if let say PO # 5 and 6 are fulfilled and no longer pending, the left part will remove them, but your right part will retain the data... with no clear match. You can try this and see........... Best way is to use the in-built pending Purchase Order reports and add your 2 columns there.
THANK U SO MUCH SIR FOR YOUR HELP! BUT THAN AS AMIT SIR SAID THIS DIVISON OF PART IS NOT LINKING TWO PARTS AND IF ITEM IS GETTING CLOSED BUT STILL THE STATUS IS THERE ONLY. SO THE PURPOSE OF THIS TDL ISNT SOLVED. BUT IM REALLY THANK FULL TO U
DEAR AMIT SIR THANK YOU FOR GUIDING ME BUT IM QUITE AMATEUR TDL DEVELOPER AND I REALLY DONT KNOW HOW TO ADD COLOUMN IN EXISTING REPORT
Hi Vishnu, Appreciate if you stop using ALL CAPS. Type normally. You have already ventured in TDL, and there is no need to be scared. Initially always work on dummy data. And feel free to explore. There are many TDLs and also in sample folder of Developer........... You need to find the Field, Line, Part etc from Tally in developer mode. Once you find, it is easy to add your fields there. Keep on doing it and revert if you have problems. We, the experts here will guide you. Do not have any hesitation, keep doing and you will gain confidence in time.