HELP NEEDED - DESTINATION FIELD IN DESPATCH DETAIL'S IS NOT PRINTING IN INVOICE PRINTING

Discussion in 'Free Source Codes' started by tejeet, Jun 16, 2020.

    
  1. tejeet

    tejeet Member


    dear developer,

    i have develop tdl for both city & destination field in despatch, i am using same city udf for both city & destination field, on screen it is working perfectly , but while printing of invoice both city & destination field is not printed on invoice - it is printing blank, so request you to correct my codes so that both city & destination field will printed in invoice printing.

    my codes are as follows :

    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
    ;;;;-------------Addition Code
    [#Field    :    EI PORT Destination]
    Use         : Name Field
    Storage     : udfLedCity
    Width: 40
    Table : Cost Category,End of List
    Show Table : Always
    Key : Create Cost Category
    Style : Small Bold
    Set Always    :    Yes
    ;;;;----------------End of Additional code   
    
     


  2. Murali.R

    Murali.R Member


    [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


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


    [#Part: EXPINV Consignee]
    Add: Lines : After: EXPINV ConAddress: Mri Cityname

    [#Part: EXPINV Buyer]
    Add: Lines : After: EXPINV Address: Mri Cityname

    [Line : Mri Cityname]
    Field : Medium Prompt, Mri Cityname
    Local : Field : Medium Prompt : Set as : "City"
    ;Local : Field : Medium Prompt : Inactive : NOT @@IsDebtorCreditor

    [Field : Mri Cityname]
    Use : Name Field
    Style : Small Bold
    Set as: $udfLedCity
     
    tejeet likes this.


  3. tejeet

    tejeet Member


    Dear sir,

    thank you very much it is working perfectly.
     


  4. dkp_jal

    dkp_jal Member


    Above code working perfectly to add CITY in Ledger & Delivery Note.
    But it not Print in Sale Invoice.
    How to print this in INVOICE
     


Share This Page