1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

HELP IN REPORT TDL

Discussion in 'Tally Developer' started by vishu009, Jul 31, 2020.

    
Tags:
Page 1 of 3
  1. vishu009

    vishu009 New Member


    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"

    [Part:pOPARTYTITLE]
    Line : POPARTYTITLE
    Horizontal Align : Center
    Common Border : Yes


    [Line:pOPARTYTITLE]
    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

    [Part:pMITEMTITLE]
    Line : PMITEMTITLE
    Common Border : Yes

    [Line:pMITEMTITLE]
    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

    [Part:pOHEADDETAIL]

    Line : POHEADDETAIL

    Common Border : Yes


    [Line:pOHEADDETAIL]

    Field:pOSRNOTITLE,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 :print : 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
    Repeat:pOSUMMARY:OUTSTANDINGPURCHASEALL

    [Line:pOSUMMARY]

    Field:pOSRNOSUMMARY,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

    [Field:pOSRNOSUMMARY]

    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]
    Type:purchase Orders
    Use:$POITEMSUMMARY
    FILTER :##StockItemName

    [System:formula]
    POITEMSUMMARY : $$IsBelongsTo:$$STOCKITEMNAME
     

    Attached Files:

    vishu009, Jul 31, 2020
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    U need the define the UDF for storage.
     
    Amit Kamdar, Jul 31, 2020
    #2


  3. vishu009

    vishu009 New Member


    [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
     
    vishu009, Jul 31, 2020
    #3


  4. vishu009

    vishu009 New Member


    sir i did this changes but still input is not getting saved
     
    vishu009, Jul 31, 2020
    #4


  5. Himanshu-2002

    Himanshu-2002 Active Member


    [#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"

    [Part:pOPARTYTITLE]
    Line : POPARTYTITLE
    Horizontal Align : Center
    Common Border : Yes


    [Line:pOPARTYTITLE]
    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

    [Part:pMITEMTITLE]
    Line : PMITEMTITLE
    Common Border : Yes

    [Line:pMITEMTITLE]
    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

    [Part:pOHEADDETAIL]

    Line : POHEADDETAIL

    Common Border : Yes


    [Line:pOHEADDETAIL]

    Field:pOSRNOTITLE,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 :print : 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
    Repeat:pOSUMMARY:OUTSTANDINGPURCHASEALL

    [Line:pOSUMMARY]

    Field:pOSRNOSUMMARY,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

    [Field:pOSRNOSUMMARY]

    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]
    Type:purchase Orders
    Use:$POITEMSUMMARY
    FILTER :##StockItemName

    [System:formula]
    POITEMSUMMARY : $$IsBelongsTo:$$STOCKITEMNAME
     
    Himanshu-2002, Jul 31, 2020
    #5


  6. Himanshu-2002

    Himanshu-2002 Active Member


    Now ?
     
    Himanshu-2002, Jul 31, 2020
    #6


  7. vishu009

    vishu009 New Member


    thank sir,
    but still the input is not getting saved
     
    vishu009, Jul 31, 2020
    #7


  8. Himanshu-2002

    Himanshu-2002 Active Member


    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
     
    Himanshu-2002, Jul 31, 2020
    #8


  9. vishu009

    vishu009 New Member


    thank u but its all in vein as the purpose of this tdl is not getting solved :(
     
    vishu009, Jul 31, 2020
    #9


  10. Himanshu-2002

    Himanshu-2002 Active Member


    It will be resolved Try this
    (At Form Level)
    on: Form accept:Call: Function

    try to do something like this
     
    Himanshu-2002, Jul 31, 2020
    #10


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    send me ur dummy tally data ... attach it here in ZIP format.
     
    Amit Kamdar, Jul 31, 2020
    #11


  12. vishu009

    vishu009 New Member


    YES SIR
     

    Attached Files:

    vishu009, Jul 31, 2020
    #12


  13. sattam

    sattam Active Member


    Untitled.png
     
    sattam, Jul 31, 2020
    #13


  14. sattam

    sattam Active Member


    Do You want this?
     
    sattam, Jul 31, 2020
    #14


  15. vishu009

    vishu009 New Member


    YES
    IT SHOULD BE SAVED
     
    vishu009, Jul 31, 2020
    #15


  16. vishu009

    vishu009 New Member


    WHATEVER INPUT WE ARE TYPING IN THESE COLUMNS
     
    vishu009, Jul 31, 2020
    #16


  17. sattam

    sattam Active Member


    Try This ,hope it should solve your problem.
     

    Attached Files:

    sattam, Jul 31, 2020
    #17


  18. Himanshu-2002

    Himanshu-2002 Active Member


    Sir, How you achieved this
    Please explain me
     
    Himanshu-2002, Jul 31, 2020
    #18


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     
    Amit Kamdar, Jul 31, 2020
    #19


  20. vishu009

    vishu009 New Member


    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
     
    vishu009, Jul 31, 2020
    #20


  21. vishu009

    vishu009 New Member


    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
     
    vishu009, Jul 31, 2020
    #21


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.

    11.PNG
     
    Amit Kamdar, Jul 31, 2020
    #22


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    111.PNG
     
    Amit Kamdar, Jul 31, 2020
    #23


  24. vishu009

    vishu009 New Member


    dear sir
    can i get the codes if possible
     
    vishu009, Jul 31, 2020
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Sorry...am here to guide and teach. Not to share codes. Am not a seller nor a professional coder.
     
    Amit Kamdar, Jul 31, 2020
    #25


Page 1 of 3

Share This Page