Please help me in this code. We want repeat lines for description but dont want to repeat lines for sq mt Qty & sq.mt Rate. (It should come only one time.) Awaiting your valuable guidance. ;;-------Item DEtails---------------------------------------------------------------------- [Part : OTS AddlDesc] Lines : OTS AddlDesc Repeat : OTS AddlDesc : UserDescription: Option : Small Size Part [Line : OTS AddlDesc] Fields : Simple Field Right Field: OTS Qty, OTS Rate,OTS GrossAmt;EXPINV MyNewFields Local : Field : Simple Field : Set as : $UserDescription Local : Field : Simple Field : Full Width : Yes Local : Field : Simple Field : Space Left : 10 mms Local: Field: Name Field: Style:O9 Local: Field:OTS Qty : Delete: Storage Local: Field:OTS Qty: Type: String Local: Field:OTS Qty : Set as: "("+$$String@MyVchSqMt + "Sq.mt.)" Local: Field: Name Field: Style:O9 Local: Field:OTS Rate : Delete: Storage Local: Field:OTS Rate : Type: String Local: Field:OTS Rate : Set as: "(" +$$String@MyVchMTRate + "Sq.mt.)" Local: Field: Name Field: Style:O9 Local: Field: OTS GrossAmt :Set as: "" ;===============================================================================
We want repeat lines for description but dont want to repeat lines for sq mt Qty & sq.mt Rate. (It should come only one time.) Please guide Amitjee..
In Field.............OTS Qty, OTS Rate Set as : If $$Line>1 then "" Else "("+$$String@MyVchSqMt + "Sq.mt.)" Do same for the other field.
Actually you should be typing the whole Description in one line, instead, you are breaking the line manually and hence the other items are also being repeated.
One more query is width x height x copies=qty if 2.25x2.35x2=10.575 it is coming round off. it should come abosulte [System : Formula] MyBatchFilter $StockItemName = $StockItemName MyVchSqMt : $$Number:$BilledQty * 0.092903 MyVchMTRate : $$Number:$Rate / 0.092903 MyVchArea : $MyVchWidth * $MyVchHeight * $MyVchAreaVal MyVchBilledQty : ($MyVchArea = $BilledQty) Please guide.
Please check [#Field: VCH NrmlBilledQty] ; Quantity column should fill qty values automatically oldSet as : If @HasInvAlloc Then $$CollQtyTotal:BatchAllocations:$BilledQty Else @ResetVal Set as : if $$IsEmpty:$MyVchArea then @OldSetas else $$AsQty:$MyVchArea ; if Area is not Empty then only Quantity column should fill qty values automatically Skip: !$$IsEmpty:$MyVchArea
Now if I enter in tally width x height x copies=qty if 2.25x2.35x2=10.575 it is coming round off. means it is coming 11.00 but my requirement is it should come 10.58 in qty column instead of round off qty 11
Since you are using default Tally field, I would not consider changing the settings........... So you need to do the following....... Add a field before [Field: VCH NrmlBilledQty] .... say MyQtyFld..... In there use type Number..... put you computed formula result in this field. and then make this field Invisible. Then in [#Field: VCH NrmlBilledQty] .... instead of $MyVchArea ...replace it with #MyQtyFld
Amijee.. As per suggestion i have done same way.. but still qty not coming absolute it is rounding off [Field : MyVchRSJQty] ; RJQTY column Use : Number Field Width : @@VCHRateWidth Style : Normal Inactive: $$IsEnd:$StockItemName or (! $RSColumnEnabled:StockItem:$StockITemName) Set as @MyVchArea Storage : MyVchArea Set Always : Yes Align : Right Skip : Yes Border :Thin Left Right Format : Decimal :0 Invisible : Yes
Thank you Amitjee for your valuable guidance.. I have done it. [Field : MyVchRSJQty] ; RJQTY column Use : Number Field Width : @@VCHRateWidth Style : Normal Inactive: $$IsEnd:$StockItemName or (! $RSColumnEnabled:StockItem:$StockITemName) Set as @MyVchArea Storage : MyVchArea Set Always : Yes Align : Right Skip : Yes Border :Thin Left Right Format : Decimal :2 Invisible : Yes [#Field: VCH NrmlBilledQty] ; Quantity column should fill qty values automatically oldSet as : If @HasInvAlloc Then $$CollQtyTotal:BatchAllocations:$BilledQty Else @ResetVal Set as : if $$IsEmpty:#MyVchRSJQty then @OldSetas else $$AsQty:#MyVchRSJQty ; if Area is not Empty then only Quantity column should fill qty values automatically Skip: !$$IsEmpty:#MyVchRSJQty
You are welcome..... remove storage from your new field.... it is not required. Also remove style, border, align, skip....since this is an invisible field.... all specifications are redundant.
We have used following conversion factor for sq.mt qty & rate. MyVchSqMt : $$Number:$BilledQty * 0.092903 ;For Sq.Mt.Qty Column MyVchMTRate : $$Number:$Rate / 0.092903 ; For Rate / Sq.Mt Column