Dear experts, I want multiplication of value in voucher which is billed qty and my user defined field like freight and other charges. I tried it, but don't multiply the two fields(quantity field, udf). Please guide us.....
Dear Sir, I Add two fields in purchase voucher and i want to multiply two fields which is freight amount (from stock item) & billed qty . I tried it, but don't come. Please correct my code. [#Part: STKI Batch] Add : Line : After : STKI SetSTDRate : LEDExpsFrg, LEDExpsCooli [Line: LEDExpsFrg] Fields : Medium Prompt, LEDExpsFrg Local : Field : Medium Prompt : Set as: $$LocaleString:"Freight Charges" [Field: LEDExpsFrg] Use : Amount Field Storage : ItemFreight [Line:LEDExpsCooli] Fields : Medium Prompt, LEDExpsCooli Local : Field : Medium Prompt : Set as: $$LocaleString:"Cooli" [Field: LEDExpsCooli] Use : Amount Field Storage : LEDCooli ;;-------------USER DEFINED FIELDS---------------;; [System:UDF] ItemFreight : Amount : 9006 LEDCooli : Amount : 9007 ;;Add Fields in Voucher [#Line : EI ColumnOne] Option : Global EI ColumnOne : @@IsPurchase [!Line: Global EI ColumnOne] Add : Fields : At End : SGFreight, SGFreightAmt, SGCli, SGCliAmt [Field : SGFreight] Use : Short Name field Info : "Freight" Align : Centre Width : 15 Style : Small bold [Field : SGFreightAmt] Use : Short Name field Info : "Freight Amt" Align : Centre Width : 15 Style : Small bold [Field : SGCli] Use : Short Name Field Info : "Cooli" Align : Center Width : 15 Style : Small bold [Field : SGCliAmt] Use : Short Name Field Info : "Cooli Amt" Align : Center Width : 15 Style : Small bold [#Field: VCH ItemTitle] Width : @@LongWidth [#Line : EI ColumnTwo] Option : Global EI ColumnTwo : @@IsPurchase [!Line: Global EI ColumnTwo] Add : Fields : At End : SGFreight, SGFreightAmt, SGCli, SGCliAmt Local : Field : SGFreight : Info : " " Local : Field : SGCli : Info : " " Local : Field : SGFreightAmt : Info : "" Local : Field : SGCliamt : Info : "" [#Line : EI InvInfo] Option : Global EI InvInfo : @@IsPurchase [#Line : CI InvInfo] Option : Global EI InvInfo : @@IsPurchase [!Line: Global EI InvInfo] Add : Fields : At End : SGFreight1, SGFreight2, SGCli1, SGCli2 [Field : SGFreight1] Use : Amount Field Set As : $Itemfreight:StockItem:$StockItemName Align : Center Width : 15 Skip : YES [Field : SGFreight2] Use : Amount Field Set As : $BilledQty * $ItemFreight Align : Center Width : 15 Skip : YES [Field : SGCli1] Use : Amount Field Set As : $LEDCooli:StockItem:$StockItemName Align : Center Width : 15 Skip : YES [Field : SGCli2] Use : Amount Field Set As : $BilledQty * $LEDCooli Align : Center Width : 15 Skip : YES
Objectify the UDFs in Object:stockitem............. Are you getting this value???? --- $Itemfreight:StockItem:$StockItemName