Invoice Height depending on Item Line number

Discussion in 'Requests' started by Gopal Rajbhandari, Sep 4, 2020.

    

  1. Dear experts

    I want to set customized invoice height according to item line number. I tried to count line number but not succeed.

    [Field : IE LnCount]
    Use : Name Field
    Width: 5
    Set as : "1"
    Invisible: Yes

    [Field: TotalLnCount]
    Set as : $$Total:IELnCount
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have you defined the Total in the PART level ???
     



  3. Yes, I defined

    [Part : IE Details]
    Line :IE Details
    Repeat :IE Details : Inventory Entries
    Total :TotalLnCount, IE Qty, IE Amount
     


  4. sattam

    sattam Active Member


    I Think Use : Number Field should work

    [Field : IE LnCount]
    Use : Number Field
    Width: 5
    Set as : "1"
    Invisible: Yes

    [Field: TotalLnCount]
    Set as : $$Total:IELnCount
     



  5. Dear Sir,

    I didn't get any result using Number Field also. Here I attached full code. It is for Simple Invoice. Could you please check ?

    [#Line: EXPSMP Column1]
    Add : Left Field: Before : EXPINV SLNoTitle : LnCountTitle1
    [Field: LnCountTitle1]
    Use: Name Field
    Set as: "Line"
    Width: 4
    [#Line: EXPSMP Column2]
    Add : Left Field: Before : EXPINV SLNoTitle : LnCountTitle2
    [Field: LnCountTitle2]
    Use: Name Field
    Set as: "Count"
    Width: 4

    [#Part: EXPSMP AccDetails]
    Total:LnCounter

    [#Line: EXPSMP InvDetails]
    Add : Left Fields : Before : EXPINV SLNo : LnCounter
    [Field: LnCounter]
    Use: Number Field
    Set as: "1"
    Width: 4
    [#Line: EXPSMP AccDetails]
    Add : Left Fields : Before : EXPINV SLNoTitle : LnCountTotal
    [Field: LnCountTotal]
    Use: Number Field
    Set as: $$Total:LnCounter
    Width: 4
     


  6. sattam

    sattam Active Member


    Try This
    Code:
     [#Line: EXPSMP Column1]
        Add : Left Field: Before : EXPINV SLNoTitle : LnCountTitle1
        [Field: LnCountTitle1]
        Use: Name Field
        Set as: "Line"
        Width: 4
        [#Line: EXPSMP Column2]
        Add : Left Field: Before : EXPINV SLNoTitle : LnCountTitle2
        [Field: LnCountTitle2]
        Use: Name Field
        Set as: "Count"
        Width: 4
    
        ;[#Part:EXPINV Totals]
        ;Total:LnCounter
    
        [#Line: EXPSMP InvDetails]
        Add : Left Fields : Before : EXPINV SLNo : LnCounter
        [Field: LnCounter]
        Use: Number Field
        Set as: "1"
        Width: 4
        [#Line: EXPSMP Totals]
        Add : Left Fields : Before : EXPINV SLNoTitle : LnCountTotal
        [Field: LnCountTotal]
        Use: Number Field
        Set as:$$CollNumTotal:InventoryEntries:$$Number:#LnCounter
        Width: 4
     



  7. Thank you Sattam Sir,
    It is perfectly working.
     
    sattam likes this.


  8. SRJ

    SRJ New Member


    Dear Sattam Sir,
    I want to achieve the same thing in [#Part: EXPINV AccInfo].
    That is i want count the number of lines in [#Part: EXPINV AccInfo]

    Instead of "InventoryEntries" which collection should i use.
    Please Help.
     


  9. SRJ

    SRJ New Member


    I found the Answer.
     


Share This Page