Finally done full Quotation Module.....Thank full to Amit sir & all of developers

Discussion in 'Free Source Codes' started by Jenny, Apr 13, 2019.

    
  1. K V Shah

    K V Shah New Member



  2. santoshonlyone

    santoshonlyone New Member



  3. Jenny

    Jenny Active Member


    Hello Everyone...
    For all of your request i attach my code for Trial basis...

    . Its Only For 10 Days Trial Period...
    . For Starting This Module Follow My Procedure Which I Post Before In This Post With Screenshot
    . Procedure Details In 1st Page ...
    . Its Humble To Request All Of You Please don't Asking Me To Send Code Because Its Not A Free Code.
    . Anything Else Contact Me Thru Email - kissudears@gmail.com
     

    Attached Files:



  4. tejeet

    tejeet Member


    HELP NEEDED - HOW TO CHANGE "invoice no" as "proforma invoice no" in proforma invoice, please provide us the code, when we prepare invoice if we want sent it as proforma invoice , we select titling button from print setting & enter invoice title as proforma invoice & print proforma invoice, but it print title as proforma invoice & invoice no ( instead of proforma invoice no ) , so please suggest code to change as per attachment below :
    upload_2020-3-17_21-46-51.png
     


  5. Jenny

    Jenny Active Member


    Proforma invoice and Sales invoice both are difference in same voucher its not possible to change this..because proforma and quotation both are sales order voucher and tax invoice is "sales" voucher so its not possible. only its possible in title change and manually write down but its only changes in title not in proforma invoice no.
     


  6. tejeet

    tejeet Member


    Jenny Madam,
    please note that performa invoice is sales voucher only , while printing sales invoice, we select in printing setting --> titling -> proforma invoice instead of gst invoice , but when we check printout - title is proforma invoice , but number box by default is "invoice No" , but since this performa invoice , it should print as "proforma invoice" & this change is possible by writing tdl code , it is done by some developer , proof is attached , so i request you to write code , in which their should be condition if sales invoice title is "gst invoice" it should print as "invoice No" & if sales invoice title is "proforma invoice" it should print as "proforma invoice No" .

    similar code for purchase order is as follows :
    [#Part: EXPINV Number]
    Local : Field : EXPINV SubTitle : Set as : IF @@IsPurcOrder Then "Purchase Order No." ELSE @@InvNumTitle


    upload_2020-3-18_22-31-55.png
     


  7. Jenny

    Jenny Active Member


    [#Part: EXPINV Number]
    Local : Field : EXPINV SubTitle : Set as : IF ##ReportTitle = "PROFORMA INVOICE" Then "Proforma Invoice No." ELSE @@InvNumTitle
     


  8. tejeet

    tejeet Member


    jenny madam,

    thank you very much for your great help & your above code, it is working perfect now while printing proforma invoice it print "proforma invoice no "
     
    Jenny likes this.


  9. tejeet

    tejeet Member


    Help needed - how to add or use city udf in destination field in despatch details part in sales invoice entry , I have city udf - udfLedCity in ledger creation , i want to use this city udf for destination field, so please provide me codes , so that when i come to destination field in sales invoice list of city table should pop up & i have select city from the table available.

    please provide / develop code for destination field, i am attaching my city udf code for your reference for developing above code for me.


    Code:
    [System : UDF]
    udfLedCity : String : 20001 ;; Ledger City
    
    ; City Master
    
    [#Menu : Accounts Info.]
    Add : Key Item : After : @@locLedgers : "City" : Y : Menu : VIT City Menu
    
    [Menu : VIT City Menu]
    Title : $$LocaleString:"City Master"
    Indent : "Single City"
    Item : BLANK
    Key Item : @@locCreate : C : Create Collection : List of ExtractCostCategories : @Allowed AND $$Allow:Create:AccountsMasters
    Key Item : @@locDisplay : D : Display Collection : List of ExtractCostCategories : @Allowed AND $$NumCostCategories > 0 AND $$Allow:Display:AccountsMasters
    Key Item : @@locAlter : A : Alter Collection : List of ExtractCostCategories : @Allowed AND $$NumCostCategories > 0 AND $$Allow:Alter:AccountsMasters
    Item : BLANK
    ;Indent : "Multiple City"
    ;Item : BLANK
    ;Key Item : @@locCreate : R : Create : Multi Cost Category : @Allowed AND $$Allow:Create:AccountsMasters
    ;Key Item : @@locDisplay : I : Display Collection : Multi Cost Category : @Allowed AND $$NumCostCategories > 0 AND $$Allow:Display:AccountsMasters
    ;Key Item : @@locAlter : T : Alter Collection : Multi Cost Category : @Allowed AND $$NumCostCategories > 0 AND $$Allow:Alter:AccountsMasters
    ;Item : BLANK
    Key Item : @@locQuit : Q
    Allowed : $$IsAccountingOn:$$CurrentSimpleCompany
    
    [#Collection : List of ExtractCostCategories]
    Title : $$LocaleString:"List of Cities"
    Filter : NoPrimary
    
    [#Collection : Cost Category]
    Title : $$LocaleString:"List of Cities"
    Filter : NoPrimary
    
    [System : Formula]
    NoPrimary : $Name <> $$PrimaryCostCategory
    
    [#Report : SCostCategory]
    Title : $$LocaleString:"Select City"
    Local : Field: MV Title : Info : $$LocaleString:"Name of City"
    
    [System : Formula]
    MultCostCatCreateModeFormat : $$LocaleString:"Multi City %s %s"
    
    [#Report : Cost Category]
    Title : $$LocaleString:"City" + @@ModeName + @@SubModeName
    
    [#Form : Cost Category]
    Delete : Top Parts : CSTCAT Behaviour
    
    [#Form : Multi Cost Category]
    Width : 100% Screen
    
    [#Part : MCSTCAT Body]
    Delete : Lines : MCSTCAT Secondary Titles
    
    [#Line : MCSTCAT Main Titles]
    Delete : Right Fields : MCSTCAT Allocation Title
    
    [#Field : MCSTCAT Name Title]
    Info : $$LocaleString:"Name of City"
    
    [#Line : MCSTCAT Body]
    Delete : Right Fields : CSTCAT ForRevenue, CSTCAT ForNonRevenue
    
    [Collection : MyCity]
    Type : Cost Category
    Fetch : *
    IsOdbcTable : Yes
    
    ; Ledger
    
    [#Part : LED Mailing Address]
    Add : Bottom Line : Before : LEDState : lnCityUDF
    
    [#Field : LED Mailing Address]
    Set Always : Yes
    
    [Line : lnCityUDF]
    Field : Medium Prompt,fldCityUDF
    Local : Field : Medium Prompt : Set as : "City"
    Local : Field : Medium Prompt : Inactive : NOT @@IsDebtorCreditor
    
    [Field : fldCityUDF]
    Use : Name Field
    Storage : udfLedCity
    Max : 40
    Table : Cost Category,Not Applicable
    Show Table : Always
    Key : Create Cost Category
    Style : Small Bold
    Inactive : NOT @@IsDebtorCreditor
     


  10. tejeet

    tejeet Member


    jenny madam,

    i have added following codes to my city codes, still i am not getting desired result , in destination filed - my city list is not showing & asking for input, so request you to correct my codes

    [#Field : EI PORT Destination]
    Set as : $UDFLedCity:Ledger:#EIConsignee
    Set Always : Yes

    [System : UDF]
    UDFLedCity : String : 21101
     


  11. tejeet

    tejeet Member


    jenny madam,
    above codes is not working , please check the codes , 1 am attaching screen shot for your reference , you can check when we come to despatch through - list of despatch through pop up & we have to select from pop up list
    similar codes we require for destination - presently we have to make manual entry, but i need codes as per above despatch to, so when we come to destination - list of city should pop up & we have to select from pop up list of city, i have already 50 names in list of city ( codes for list of city is already attached in my previous emails
    View attachment 6519

    View attachment 6520
     


  12. tejeet

    tejeet Member


    jenny madamr,

    i have modify above codes with your guidance & it is now working perfectly it now show list of city in destination field & we can select city from pop up list.

    ;;;;-------------Addition Code
    [#Field : EI PORT Destination]
    Use : Name Field
    Storage : udfLedCity
    Width: 30
    Table : Cost Category,End of List
    Show Table : Always
    Key : Create Cost Category
    Style : Small Bold
    Set Always : Yes
    ;;;;----------------End of Additional code
     


  13. chavan manohar

    chavan manohar New Member



  14. chavan manohar

    chavan manohar New Member


    MDM WHAT IS THE PRICE. PLEASE EMAIL TO TALLYBELLARY@GMAIL.COM
     


  15. HARSH PATEL

    HARSH PATEL New Member



  16. anupreeti

    anupreeti New Member



  17. gopakishore

    gopakishore New Member



  18. venkatkolla

    venkatkolla New Member



  19. sumitdhawan2008

    sumitdhawan2008 New Member



  20. ankurshah1985

    ankurshah1985 Member



  21. Asraf

    Asraf New Member



  22. Bhuban Debnath

    Bhuban Debnath New Member







  23. G Vijay

    G Vijay Member


    HI.

    Nice hard work. :) one small suggestion :
    Quotation is appearing in every voucher type.. kindly have a look
     


Share This Page