Item Description Printing Issue

Discussion in 'Requests' started by vinayprasad.Dubai, Oct 21, 2019.

    

  1. Code:
    Right Fields: My Unit, My Rate, my Amount, My Vat Amount, My Totals
            Explode     : Item Desc2    : $$NumItems:UserDescription  > 0
          
            ;border    : thin box
            ;Space Top    : if $$Line = 1 then 1 else 0
            ;Height            : 10
          
        [Part: Item Desc2]
    
        Lines         : Item Desc2
        Repeat      : Item Desc2     : UserDescription
        ;BreakOn : $$IsEmpty:$BasicUserDescription
    
        [Line: Stock Desc2]
    
        Fields      : Stock Desc2
    
        [Field: Stock Desc2]
    
        Use         : Name Field
        Width         : 40
        Indent         : 8
        Set as        : $UserDescription
        Style         : Normal Italic

    In this code if the Item Description given for first item, All the items are exploding can you please help me in this
     


  2. balajimg

    balajimg Active Member


    Right Fields: My Unit, My Rate, my Amount, My Vat Amount, My Totals
    Explode : Item Desc2 : $$NumItems:BasicUserDescription > 0

    ;border : thin box
    ;Space Top : if $$Line = 1 then 1 else 0
    ;Height : 10

    [Part: Item Desc2]

    Lines : Item Desc2
    Repeat : Item Desc2 : BasicUserDescription
    ;BreakOn : $$IsEmpty:$BasicUserDescription

    [Line: Stock Desc2]

    Fields : Stock Desc2

    [Field: Stock Desc2]

    Use : Name Field
    Width : 40
    Indent : 8
    Set as : $BasicUserDescription
    Style : Normal Italic
     



  3. No Effect !!!
     


  4. gangstar

    gangstar Member


    ;; Sample Format for item Description

    [Style:HUMNST]
    Font:"Humnst777 BT"
    Bold:Yes
    Height:12

    [Style:NOHUMNST]
    Font:"Humnst777 BT"
    Bold:NO
    Height:12

    [#Part:VTYP BehaviourMain]
    Option:VTYP BehaviourMain Vchtype:mad:@CMPVCHTYPE

    [!Part:VTYP BehaviourMain Vchtype]
    Add:Line:After:VTYP PrintSave:CMP VCHTYPE CONFIRM

    [Line:CMP VCHTYPE CONFIRM]
    Field:LONG PROMPT,LOGICAL FIELD

    Local:Field:LONG PROMPT:Set as:"PRINT A5 SIZE FORMAT ?"
    Local:Field:LONG PROMPT:Width:mad:@LONGWIDTH
    Local:Field:LOGICAL FIELD:Storage:CMPVCHCONFIRM

    [System:Formula]
    CMPVCHTYPE:$$IsSales:$PARENT
    CMPNEWALLOW:$CMPVCHCONFIRM:VOUCHERTYPE:$VOUCHERTYPENAME

    [System:UDF]
    CMPVCHCONFIRM:Logical:1782

    [#Form:SALES COLOR]
    Option:SPHALFSHEET:mad:@CMPNEWALLOW

    [!Form:SPHALFSHEET]
    Delete:print
    Add:print:SPA5SHEET

    [Report:SPA5SHEET]
    Use:pRINTED INVOICE
    Delete:Form:pRINTED INVOICE
    Form:SPA5HALF

    [Form:SPA5HALF]
    Width:6 INCH
    Height:8 INCH
    Space Top:0.10 INCH
    Space Left:0.50 INCH
    Space Right:0.10 INCH
    Space Bottom:0.10 INCH
    Page Break:CMP PAGE BREAK

    Part:CMP OPENING PAGE BREAK,CMP INVOICE BODY

    Bottom Part:CMP AMT WORDS

    Page Break:CMP PAGE BREAK,CMP OPENING PAGE BREAK

    Set Always:SVPrintOrientation : $$SysName:Landscape

    [Part:CMP PAGE BREAK]
    Lines:CMPPBREAK

    [Line:CMPPBREAK]
    Fields:SIMPLE FIELD

    Local:Field:SIMPLE FIELD:Set as:"Continued...."
    Local:Field:SIMPLE FIELD:Full Width:Yes
    Local:Field:SIMPLE FIELD:Align:Right

    Border:FULL THIN TOP

    [Part:CMP OPENING PAGE BREAK]
    Part:SPTTITLE,SPPARTY,SPBODY
    Vertical:Yes

    [Part:SPTTITLE]
    Line:SPTTITLE

    [Line:SPTTITLE]
    Field:NAME FIELD

    Local:Field:NAME FIELD:Set as:"MEMO"
    Local:Field:NAME FIELD:Style:HUMNST
    Local:Field:NAME FIELD:Align:Center
    Local:Field:NAME FIELD:Full Width:Yes

    [Part:SPPARTY]
    Left Part:SPPARTYNAME
    Right Part:SPINVDET
    Border:THICK COVER

    [Part:SPPARTYNAME]
    Line:SPPARTY,SPPDDRESS
    Width:70% PAGE

    [Line:SPPARTY]
    Field:SIMPLE FIELD

    Local:Field:SIMPLE FIELD:Set as:"Party: "+@@SimpleOtherPartyName
    Local:Field:SIMPLE FIELD:Style:HUMNST
    Local:Field:SIMPLE FIELD:Full Width:Yes

    [Line:SPPDDRESS]
    Field:SIMPLE FIELD

    Local:Field:SIMPLE FIELD:Set as:$$FullList:BasicBuyerAddress:$BasicBuyerAddress
    Local:Field:SIMPLE FIELD:Style:NOHUMNST
    Local:Field:SIMPLE FIELD:Width:35% PAGE
    Local:Field:SIMPLE FIELD:Lines:0

    [Part:SPINVDET]
    Line:SPINVDATE,SPINVNO
    Width:35% PAGE
    Border:THIN LEFT

    [Line:SPINVDATE]
    Field:MEDIUM PROMPT,Simple Field

    Local:Field:MEDIUM PROMPT:Set as:"Dated"
    Local:Field:MEDIUM PROMPT:Style:HUMNST
    Local:Field:MEDIUM PROMPT:Width:12

    Local:Field:SIMPLE FIELD:Set as:$$String:$DATE:SHORTDATE
    Local:Field:SIMPLE FIELD:Style:NOHUMNST
    Local:Field:SIMPLE FIELD:Full Width:Yes

    [Line:SPINVNO]
    Field:MEDIUM PROMPT,Simple Field

    Local:Field:MEDIUM PROMPT:Set as:"No."
    Local:Field:MEDIUM PROMPT:Style:HUMNST
    Local:Field:MEDIUM PROMPT:Width:12

    Local:Field:SIMPLE FIELD:Set as:$VOUCHERNUMBER
    Local:Field:SIMPLE FIELD:Style:NOHUMNST
    Local:Field:SIMPLE FIELD:Full Width:Yes

    [Part:SPBODY]
    Line:SPBODYTITLE
    Border:THICK COVER
    Common Border:Yes

    [Part:CMP INVOICE BODY]
    Part:CMP INVOICE BODY COLUMNS,SPLED
    Vertical:Yes
    Border:THIN COVER
    ;Scroll:Vertical
    ;Common Border:Yes
    ;Float:No

    [Part:SPBODYTITLE]
    Line:SPBODYTITLE
    Common Border:Yes

    [Line:SPBODYTITLE]
    Use:BODY

    Local:Field:DEFAULT:Type:String
    Local:Field:DEFAULT:Align:Center
    Local:Field:DEFAULT:Style:HUMNST

    Local:Field:SRNO:Set as:"S.No"
    Local:Field:DESC:Set as:"Description of Goods"
    Local:Field:QTY:Set as:"Qty"
    Local:Field:RTE:Set as:"Rate"
    Local:Field:AMOT:Set as:"Amt"

    Border:THIN BOTTOM
    Space Bottom:0.25

    [Part:CMP INVOICE BODY COLUMNS]
    Line:Inventory
    Repeat:Inventory:INVENTORY ENTRIES
    ;Border:THICK COVER
    Scroll:Vertical
    Float:No
    Common Border:Yes
    ;Bottom Line:TOTAL

    [Line:Inventory]
    Use:BODY

    Explode:DESC:$$NumItems:BASICUSERDESCRIPTION > 0

    [Part:DESC]
    Line:DESC
    Repeat:DESC:BASICUSERDESCRIPTION

    [Line:DESC]
    Field:SRNO,DESC
    Right Field:QTY,RTE,AMOT

    Local:Field:SRNO:Set as: ""
    Local:Field:DESC:Set as:$BASICUSERDESCRIPTION
    Local:Field:QTY:Set as: ""
    Local:Field:RTE:Set as: ""
    Local:Field:AMOT:Set as: ""

    [Line:BODY]
    Field:SRNO,DESC
    Right Field:QTY,RTE,AMOT

    Local:Field:SRNO:Width:4
    Local:Field:QTY:Width:10
    Local:Field:RTE:Width:10
    Local:Field:AMOT:Width:10

    Local:Field:SRNO:Border:THICK RIGHT
    Local:Field:QTY:Border:THICK LEFT
    Local:Field:RTE:Border:THICK LEFT
    Local:Field:AMOT:Border:THICK LEFT
    Space Top:0.15

    [Field:SRNO]
    Use:SIMPLE FIELD
    Set as:$$Line
    Style:NOHUMNST

    [Field:DESC]
    Use:SIMPLE FIELD
    Set as:if NOT $$IsSysName:$StockItemName then @@InvItemName else ""
    Style:NOHUMNST
    Full Width:Yes
    Line:0

    [Field:QTY]
    Use:QTY PRIMARY FIELD
    Style:NOHUMNST
    Set as:$BilledQty

    [Field:RTE]
    Use:RATE PRICE FIELD
    Style:NOHUMNST
    Set as:$Rate

    [Field:AMOT]
    Use:AMOUNT FIELD
    Set as:$Amount
    Style:NOHUMNST

    [Line:TOTAL]
    Use:BODY
    Border:THICK TOP BOTTOM

    Local:Field:SRNO:Set as:""
    Local:Field:DESC:Set as:"TOTAL"
    Local:Field:DESC:Align:Right
    Local:Field:DESC:Style:HUMNST
    Local:Field:QTY:Set as:$$CollAmtTotal:InventoryEntries:$BILLEDQTY
    Local:Field:QTY:Style:HUMNST
    Local:Field:RTE:Set as:""
    Local:Field:AMOT:Set as:$Amount
    Local:Field:AMOT:Style:HUMNST

    [Part:CMP AMT WORDS]
    Left Part:SPAMTWORDS

    [Part:SPAMTWORDS]
    Part:SPWORDS
    Vertical:Yes

    [Part:SPWORDS]
    Line:SPWORDS

    [Line:SPWORDS]
    Field:SIMPLE FIELD

    Local:Field:SIMPLE FIELD:Set as:"Amount Chargeable (in words) Rs." +" "+ $$InWords:$Amount
    Local:Field:SIMPLE FIELD:Style:HUMNST
    Local:Field:SIMPLE FIELD:Align:Center
    Local:Field:SIMPLE FIELD:Full Width:Yes

    [Part:SPLED]
    Line:LEDDET
    Repeat:LEDDET:LEDGER ENTRIES
    Bottom Line:TOTAL
    ;Border:THICK COVER
    Scroll:Vertical
    Float:No
    Common Border:Yes

    [Line:LEDDET]
    Use:BODY

    Local:Field:SRNO:Set as:""
    Local:Field:DESC:Set as:$LEDGERNAME
    Local:Field:DESC:Align:Left
    Local:Field:QTY:Set As:" "
    Local:Field:RTE:Set As:" "
    Local:Field:AMOT:Set AS:$Amount
    Remove if:$LEDGERNAME=@@SimpleOtherPartyName
    Local:Field:DEFAULT:Type:String
     


Share This Page