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
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
;; 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@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@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@CMPNEWALLOW [!Form:SPHALFSHEET] Deleterint Addrint:SPA5SHEET [Report:SPA5SHEET] UseRINTED INVOICE Delete:FormRINTED 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:FieldEFAULT:Type:String Local:FieldEFAULT:Align:Center Local:FieldEFAULT:Style:HUMNST Local:Field:SRNO:Set as:"S.No" Local:FieldESC: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 ExplodeESC:$$NumItems:BASICUSERDESCRIPTION > 0 [PartESC] LineESC RepeatESC:BASICUSERDESCRIPTION [LineESC] Field:SRNO,DESC Right Field:QTY,RTE,AMOT Local:Field:SRNO:Set as: "" Local:FieldESC: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 [FieldESC] 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:FieldESC:Set as:"TOTAL" Local:FieldESC:Align:Right Local:FieldESC: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:FieldESC:Set as:$LEDGERNAME Local:FieldESC:Align:Left Local:Field:QTY:Set As:" " Local:Field:RTE:Set As:" " Local:Field:AMOT:Set AS:$Amount Remove if:$LEDGERNAME=@@SimpleOtherPartyName Local:FieldEFAULT:Type:String