tdl experts please help How to get TCP file expiry date in a report

Discussion in 'Free Source Codes' started by abhinand vk, Aug 13, 2020.

    
  1. abhinand vk

    abhinand vk Active Member


    [Collection: TCPInfo]

    Type: Addon

    Fetch: AddonName, AddonDisplayDate
    ,,how to use the collection to diplay addone display date
     


  2. abhinand vk

    abhinand vk Active Member


    please help me to correct the TDL

    [System: Events]

    AppStartEvent : System Start : NOT $$IsRemoteCompany : Call:TDlWORNING


    [Function: TDlWORNING]
    01 : IF :($$Date:$AddonDisplayDate - $$Date:$MachineDate) =10 AND NOT $$IsRemoteCompany
    02 : Msgbox :Warning: "AMC \n Will Expire \n With in \n 10 Days"
    03 : End If
    04 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 9 AND NOT $$IsRemoteCompany
    05 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 9 Days"
    06 : End If
    07 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 8 AND NOT $$IsRemoteCompany
    08 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 8 Days"
    09 : End If
    10 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 7 AND NOT $$IsRemoteCompany
    11 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 7 Days"
    12 : End If
    13 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 6 AND NOT $$IsRemoteCompany
    14 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 6 Days"
    15 : End If
    16 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 5 AND NOT $$IsRemoteCompany
    17 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 5 Days"
    18 : End If
    19 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 4 AND NOT $$IsRemoteCompany
    20 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 4 Days"
    21 : End If
    22 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 3 AND NOT $$IsRemoteCompany
    23 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 3 Days"
    24 : End If
    25 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 2 AND NOT $$IsRemoteCompany
    26 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 2 Days"
    27 : End If
    28 : If :( $$Date:$AddonDisplayDate - $$Date:$MachineDate) = 1 AND NOT $$IsRemoteCompany
    29 :Msgbox :Warning: "AMC \n Will Expire \n With in \n 1 Days"
    30 :End If
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $$MachineDate instead of $$Date:$MachineDate
     


  4. svn

    svn Member


    Hai Sir,
    If you solue this one please send to svninfsolutions@gmail.com
    advance thank you.
     


  5. abhinand vk

    abhinand vk Active Member


    Step 01: On system event application start call a user defined function
    Step 02: Write add on collection "[Collection: TDLsAddonsList] refer this collection"
    Seep 03: Inside the user defined function walking the add on collection compare the add on expirydate with current machine date. If the expirydate is near to machine date show the msg box and display the expiry message.

    try this

    sorry I am not successful in this tdl when I ask about this TDL to tally I got this algorithm please try this
     


  6. svn

    svn Member


    Thank you very much sir.
     


  7. JPmourya

    JPmourya New Member


    We need module helps the user to enter Sales and Purchase Voucher with AMC details. It also helps the user to generate current AMC Customer and Supplier Report and also Expiry Report for AMC. It calculates AMC End Date automatically. Prints AMC Details in Invoice. Gives the option of printing details as Separate Column or Description. Gives the report for AMC which are going to expire in that period.
     


  8. JPmourya

    JPmourya New Member


    We need AMC module helps the user to enter Sales and Purchase Voucher with AMC details. It also helps the user to generate current AMC Customer and Supplier Report and also Expiry Report for AMC. It calculates AMC End Date automatically. Prints AMC Details in Invoice. Gives the option of printing details as Separate Column or Description. Gives the report for AMC which are going to expire in that period.
    Kindly provide me the TDL for AMC
     


Share This Page