Please Help

Discussion in 'Tally Developer' started by Joharfchhil, Dec 10, 2013.

    
  1. Joharfchhil

    Joharfchhil Member


    I have created in Ledger master to Print Invoice in Sorted form or default, that is logical field it accepts the value but it is not checking at the time of print. Code is below.

    [System: UDF]
    SPSortincative:Logical:150

    [#Part: LED Other Details]
    Option : MDFLED Other Details

    [!Part : MDFLED Other Details]
    Add : Lines : SSortincative


    [Line : SSortincative]
    Field : Medium Prompt,SSortincative
    Local : Field : Medium Prompt : Set As : "Sorting Order? :"
    [Field : SSortincative]
    Use : Logical Field
    Storage : SPSortincative
    Set As: If $$IsEmpty:$$Value then "No" else $$Value


    *********************** In printing *****************

    If $SSortincative
    Repeat : AInvLines: My Item List
    Else
    Repeat: AInvLines: Inventory Entries
     


  2. Maulik Patel

    Maulik Patel Active Member


    Hi,

    $SSortincative:Ledger:$PartyLedgerName

    Did you try this?
     


  3. Joharfchhil

    Joharfchhil Member


    no sir it is not working
     


  4. Joharfchhil

    Joharfchhil Member


    Can somebody please help
     


  5. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Sir,

    Am not sure but having doubt that whether you set logical value as YES at printing or not ??

    SPSortincative = YES

    and then giving condition as

    if $SSortincative:Ledger:$PartyLedgerName
    Repeat : AInvLines: My Item List
    Else
    Repeat: AInvLines: Inventory Entries

    Am not sure but just giving idea
     


  6. Joharfchhil

    Joharfchhil Member


    That's what Maulik Patel told me to do, but its not working. Iam setting "YES' Value in Ledger Master, but when i try to retrieve it it becomes "NO". I am unable to understand how this YES value becomes NO.

    Can somebody tell me Please....

    Thanks a lot Maulik & Taufeeq
     


  7. HVPatel

    HVPatel Active Member


    You may try this,
    [Field : SSortincative]
    Use : Logical Field
    Table: YesNoTable
    Show Table: Always
    Storage : SPSortincative
    Set As: If $$IsEmpty:$$Value then "No" else $$Value
     


  8. Joharfchhil

    Joharfchhil Member


    No sir not working
     


  9. Maulik Patel

    Maulik Patel Active Member


    Hi you can do optional part
    [Part My Part]
    Line : AInvLines
    Option : Option1 : $SSortincative:Ledger:$PartyLedgerNam
    Option : Option : NOT $SSortincative:Ledger:$PartyLedgerName
    [!Part : Option 1]
    Repeat : AINVLines : My Item List
    [!Part : Option 2]
    Repeat : AInvLines : Inventory Entries
     


  10. Joharfchhil

    Joharfchhil Member


    Dear Experts,
    I have created new field & trying to save the value in UDF but it is not saving it takes default as "Yes" even if we select "No", Can any one guide me please..

    [system : UDF]
    Sortinactive : String : 100001

    [#Part: MST LED Details]
    Add : Lines : SSortincative
    [Line : SSortincative]
    Field : Medium Prompt, SSortincative
    Local : Field : Medium Prompt : Set As : "Sorting Order? :"
    [Field : SSortincative]
    Use : Short Name Field
    Table: YesNoTable
    Show Table: Always
    Storage : Sortincative
    Set As: If $$IsEmpty:$$Value then "Yes" else $$Value
     



  11. Check This

    [system : UDF]

    JoharInactive : Logical : 400

    [#Part: MST LED Details]

    Add : Lines : SSortincative

    [Line : SSortincative]

    Field : Medium Prompt, SSortincative
    Local : Field : Medium Prompt : Set As : "Sorting Order? :"

    [Field : SSortincative]

    Use : Logical Field
    Storage : JoharInactive
    Table : YesNoTable
    Show Table : Always
     


  12. Joharfchhil

    Joharfchhil Member


    Dear Experts,

    What i wanted is in my ledger master i have set sorting order as Sorted / Assortedto (Yes/No), Now at the time of printing it should take that value and print the invoice accordingly. But it does not check ??? Please help ???

    Thanks
     

    Attached Files:

    • raj.txt
      File size:
      15.8 KB
      Views:
      28



  13. Check this File
     

    Attached Files:

    • raj.txt
      File size:
      15.8 KB
      Views:
      85
    Muhammadhaneef and santosh swami like this.


  14. Taufeeq Shaikh

    Taufeeq Shaikh Active Member


    Thanks a lot Aldrin Sir,

    We have almost tried everything just a single mistake in the syntax and that is we didnt write ( = YES ) $JoharInactive:Ledger:$PartyLedgerName = Yes
     


  15. Joharfchhil

    Joharfchhil Member


    Thanks a lot Aldrin it worked, thanks
     


  16. Joharfchhil

    Joharfchhil Member


    thanks to Maulik & Taufeeq for helping
     


  17. Joharfchhil

    Joharfchhil Member


    Dear Experts,

    How to change the Name Field in Sales Voucher -> Dispatch Details Like :

    Delivery Note ------ P.O. Amount
    Order No. ------- P.O No.
    Other Ref ------- P.O Qty

    Thanks
     


  18. laxman

    laxman Member


    Dear Try

    ;; Substitute the required prompt in the place of Regular Prompts .

    [#Line : EI NumPackages]
    Local : FIeld : Short Prompt : Info : "Num Packages :"
    [#Line : EI ChallanNo]
    Local : Field : Medium Prompt : Info : "Delivery Note No(s). :"
    [#Line : EI ShipDetails]
    Local : Field : Medium Prompt : Info : "Despatch Doc. No. :"

    [#Line : EI ShipDate]
    Local : Field : Medium Prompt : Info : "Date of Despatch :"
    [#Line : EI PreCarriage]
    Local : Field : Medium Prompt : Info : "Despatched Thru :"
    [#Line : EI PortDestination]
    Local : Field : Medium Prompt : Info : "Destination :"
    [#Line : EI PLARG23]
    Local : Field : Medium Prompt : Info : "Sl. No. in PLA/RG-23 :"
    [#Line : EI PreCarriageLoc]
    Local : Field : Medium Prompt : Info : "Place of Receipt by Shipper :"
    [#Line : EI Vessel]
    Local : Field : Medium Prompt : Info : "Vessel/Flight No. :"
    [#Line : EI PortLoading]
    Local : Field : Medium Prompt : Info : "Port of Loading :"
    [#Line : EI PortDischarge]
    Local : Field : Medium Prompt : Info : "Port of Discharge :"
    [#Line : EI DestCountry]
    Local : Field : Medium Prompt : Info : "Country To :"
    [#Line : EI DateTimeOfInvoice]
    Local : Field : Medium Prompt : Info : "Date & Time Of Invoice :"
    [#Line : EI DateTimeOfRemoval]
    Local : Field : Medium Prompt : Info : "Date & Time Of Removal :"
    [#Line : EI OrderDetails]
    Local : Field : Medium Prompt : Info : "Order No. :"
    [#Line : EI OrderDate]
    Local : Field : Medium Prompt : Info : "Date of Order :"
    [#Line : EI DueDate]
    Local : Field : Medium Prompt : Info : "Terms Of Payment :"
    [#Line : EI OrderRef]
    Local : Field : Medium Prompt : Info : "Other References(s) :"
    [#Line : EI Terms]
    Local : Field : Medium Prompt : Info : "Terms Of Order :"
     
    Muhammadhaneef likes this.


Share This Page