IF i changes in set as : $JAPDesc or its blank its not storing the value..i want to this field value manual store. please help me... Code: [#Line: EI DescExplosion] Fields : EI Desc, JAP Desc, JAP Desc1,JAP Desc2 Indent : If $$InPrintMode Then 6 Else 2 Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat [Field : JAP Desc] Use : Number Field Set As :#VCHBilledQty :::;I Want to this field store the value manual Storage : JAPDesc Align : Centre Style : Normal Set Always : Yes Width : 4 [System : Udf] JAPDesc : Number : 1100
Try this.... [Field : JAP Desc] Use : Number Field Set As :$ JAPDesc;#VCHBilledQty :::;I Want to this field store the value manual Storage : JAPDesc Align : Centre Style : Normal Set Always : Yes Width : 4 [System : Udf] JAPDesc : Number : 1100 or [Field : JAP Desc] Use : Qty Primary Field;Number Field Set As :$BilledQty :::;I Want to this field store the value manual Storage : JAPDesc Align : Centre Style : Normal Set Always : Yes Width : 4 Format : "No Symbol, No Short Form, No Compact" [System : Udf] JAPDesc : Quantity: 1100
is ok, jenny [#Line: EI DescExplosion] Fields : EI Desc, JAP Desc, JAP Desc1,JAP Desc2 Indent : If $$InPrintMode Then 6 Else 2 Option : EI DescExplosion Excel : $$InExportMode AND @@IsExcelFormat [Field : JAP Desc] Use : Number Field Storage : JAPDesc Align : Centre Style : Normal Set Always : Yes Width : 4 [Field : JAP Desc1] Use : Qty Primary Field Storage : JAPDesc1 Align : Centre Style : Normal Set Always : Yes Width : 4 Format : "No Symbol, No Short Form, No Compact" [Field : JAP Desc2] Use : AMOUNT Field Storage : JAPDesc2 Align : Centre Style : Normal Set Always : Yes Width : 4 [System : Udf] JAPDesc : Number : 1100 JAPDesc1 : Quantity: 1101 JAPDesc2 : Amount: 1102
Thanx prema but 1st one is bad formula and second one working but not manual store its fetch the main qty
Jenny...lets stop this back and forth dialogue........ the code that others have given MIGHT work and should be working......... including one recently given by Pankaj. If at all they do not work it is because of behaviour from other line of codes........which might be affecting it. So i think in essence u r wasting time of all by submitting part code...... experts would need to see sectional code to understand and give solutions. If one asks half-assed questions, one should get only half-baked answers.
Dear Experts, Can anyone please help me to resolve this ERROR : Incorrect type for field ! Conflicts with storage. in Field: CMPPriceLevelsKm ???? [#Part: Company Price Levels] Add: Lines :Before: CMP PriceLevels: CMP PriceLevelsTittle [Line: CMP PriceLevelsTittle] Use: CMP PriceLevels Local : Field : Default : Style : Small Bold Local : Field : Default : Skip : Yes Local : Field : Default : Type : String Local:Field: Multi SNo: Set As: $$String:"SL No" Local:Field: CMPPriceLevels:Set As: $$String:"Price-List" Local:Field: CMPPriceLevelsRegion:Set As: $$String:"Region" Local:Field: CMPPriceLevelsKm:Set As: $$String:"Km" Local:Field: CMP OldPriceLevels:Set As: $$String:"" [#Line: CMP PriceLevels] Add: Field: After: CMPPriceLevels: CMPPriceLevelsRegion, CMPPriceLevelsKm [Field: CMPPriceLevelsRegion] Table: Region Master Show Table: Always Use : Short Name Field Storage : PriceLevelRegion Inactive : $$IsEmpty:$PriceLevel [Field: CMPPriceLevelsKm] Use : Amount Field Storage : RCPKMpricelevel Inactive : $$IsEmpty:$PriceLevel [System : UDF] RCPKMpricelevel :Amount : 21007
In Title LINE, you have used Default : Type : String .... and so it clashes...... In case when using or making a new UDF, it is better coding practice to have Title Fields seperate from Data Fields. Also if the Field is not being used for UDF storage, then also it does not matter. Make your title Fields Distinct from data fields, which has DATA TYPES other than strings. e.g. CMPPriceLevelsKmTitle - for title CMPPriceLevelsKm - for Data