UDF value in pending bill collection

Discussion in 'Requests' started by Soni HK, Jul 22, 2025.

Tags:
  1. Soni HK

    Soni HK New Member


    Namskar to all members
    Please solve my issue

    I want to show my udf value in pending bill collection.

    I entered udf value in sales/purchase voucher.
    Then
    Make payment/receipt entry in pending bill collection, its showing.

    But

    When entered in ledger master opening balance.

    Not showing.

    Image and code attached
    Code:
    [System:UDF]
    hkmark:String:42155
    [#Line:Eiconsignee]
    Add:Field:After:Eiconsignee:hkmark
    [Field:hkmark]
      Use:short name field
      Storage:hkmark
      Color:red
    
    [#Collection: Pending Bills]
     
    Title  : $$LocaleString:"Pending Bills"
    Delete:Sub Title
    Add:Sub Title: $$LocaleString:"Name",$$LocaleString:"Mark", $$LocaleString:"Date", $$LocaleString:"Balance"
    Delete : Format
    Fetch:ledgerentries.*, hkmark, ledger bills.*
    Add: Format : $$Name, 14
    Add: Format : $ledgerentries.hkmark, 10;
    Add: Format : $BillDate, 8 : Universal Date
    Add: Format : $BaseClosing : "AllSymbols, DrCr"
    
        Column Align   : Left, Left, Left, Right
    
    [#Line: LEDALLOC CTLineOne]
       Add:Field:After:LEDALLOC DateTitle: LEDALLOCDateTitleHK
    
      [Field:LEDALLOCDateTitleHK]
       Use:short name field
        Width:10
        Align:Right
        Style:normal
        Set as:$$LocaleString:"Mark"
        Skip:Yes
       
    
    [#Line: LEDALLOC MainLine]
    Add:Field:After: LEDALLOCDate: LEDALLOCDateHK
    
      [Field:LEDALLOCDateHK]
       Use:short name field
       Width:10
       Align:Right
       Storage:hkmark
    Please solve this.

    How can do this....??
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In Ledger Creation/Alteration the SubForm is Different than that of Voucher's.
    Find the appropriate subform of Master's and add your code.
     


  3. Soni HK

    Soni HK New Member


    Sir thanks for reply
    But
    In attached image
    I add my udf value in subform of master's.
    Please see in image my udf value in subform is "xyz" and "abc".

    I want these value show in pending bills collection, when payment/receipt voucher entry.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your collection ---

    Add: Format : $ledgerentries.hkmark, 10; -- means it will pickup the Voucher based UDFs only.

    You need to put a conditional one ---
    If $$IsEmpty:$ledgerentries.hkmark Then $hmark:ledger:$LedgerName else $ledgerentries.hkmark -- in a System formula.

    Then use that formula in your collection.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I went by the code -- in which the relevant code is not visible.
     


  6. Soni HK

    Soni HK New Member


    Problem solved sir.
    Thanks for guidance IMG20250722225026.jpg
     


Share This Page