dear sir, please check this what is mistake in this code for not getting total of purchase rate column [System : UDF] TTEPurchaseRate : String : 2011 [#Line : EI ColumnOne] Add : Right Field : Before : VCH QtyTitle : TTEPurchaseRate Add : Right Field : Before : VCH QtyTitle : TTEBarcode [Field :TTEPurchaseRate] Use : Name Field Width : 16 Align : Center Setas : $$LocaleString:"PURCHASE RATE" Style : Normal Bold Set Always : Yes Border: Thin Left Right Skip : Yes [Field :TTEBarcode] Use : Name Field Width : 16 Align : Center Setas : $$LocaleString:"BARCODE" Style : Normal Bold Set Always : Yes Border: Thin Left Right Skip : Yes ------------------------------------------------ [#Line : EI InvInfo] Add : Right Field : Before : VCHBilledQty : VCHPurchaseRate Add : Right Field : Before : VCHBilledQty : VCHBarcode [Field : VCHPurchaseRate] Use : Name Field Align : Center Width : 16 Color : DEEP COBALT BLUE Set as :$StandardCost:StockItem:$StockItemName Set Always : Yes Skip : Yes [Field : VCHBarcode] Use : Name Field Align : Center Color : DEEP COBALT BLUE Width : 16 Set as :$PartNo:StockItem:$StockItemName Set Always : Yes Skip : Yes [Field : VCHPurchaseRate Total] Use : Number Field Set As : $$Total:VCHPurchaseRate Width : 12 Border : Totals Skip : Yes [System : UDF] VCHPurchaseRate : Number : 5000
JAY AND AMIT SIR I have done it For TOTAL, in TDE I found this code and i have put some changes so this code perfectly works but please check this image one problem is coming, in sales voucher this purchase rate Column total is perfectly working but in POS Voucher This Purchase Rate Column Total not shown please check this code and please help me Code: [#Line: EI ColumnOne] Option : TTE EI ColumnOne : @@IsSales [!Line: TTE EI ColumnOne] Add : Right Fields : At Beginning : TTE VCH NumPack Local : Field : Default : Align : Center Local : Field : TTE VCH NumPack : Info : "PURCHASE RATE" [#Line: EI InvDetails] Option : TTE EI InvDetails : @@IsSales [#Line: CI InvDetails] Option : TTE CI InvDetails : @@IsSales [#Line: EI InvInfo] Option : TTE EI InvInfo : @@IsSales [#Line: CI InvInfo] Option : TTE EI InvInfo : @@IsSales [!Line: TTE EI InvInfo] Add : Right Fields : At Beginning : TTE VCH NumPack Local : Field : TTE VCH NumPack : Storage : BasicNumPackages [Field: TTE VCH NumPack] Use : Name Field Align : Center Width : 16 Border : Thin Left Right Color : DEEP COBALT BLUE Set as :$StandardCost:StockItem:$StockItemName Set Always : Yes Skip : Yes Invisible : NOT ##VrVarC1 Skip on : $$IsEnd:$StockItemName ;; Inactive : $$IsEnd:$StockItemName [#Form: Export Invoice] Option : TTE Export Invoice NP : @@IsSales [!Form : TTE Export Invoice NP] Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : TTE Total NumPack [Field: TTE Total NumPack] Use : TTE VCH NumPack Border : Totals Set as : $$String:@@NumNumPackTotal Skip : Yes Set always : Yes [System: Formula] NumNumPack : $$Number:$BasicNumPackages NumNumPackTotal : $$CollNumTotal:InventoryEntries:@@NumNumPack SEE THIS IMAGES
From code above...cannot see where u have defined total for TTE VCH NumPack above code is for Sales.........not POS Sales.......... lookup part ....... EI Details .......and add your total definition in the relevant part.
Instead of a proper total..... this is used........... NumNumPackTotal : $$CollNumTotal:InventoryEntries@NumNumPack This is a wrong method for column totaling in a Invoice.............because it will just take the NUMBERS, discarding the units and hence will total up 1 no + 500 kgs + 250 Ltrs... so total will come to 751, which is wrong representation.
anyone help me add column in sales invoice,,,this code not working..... [#Part: EXPINV Column] Lines : EXPINV Column1 SpaceBottom : 0.5 Local : Field : EXPINV RatePerTitle : Info : $$LocaleString:"Order No" Local : Field : EXPINV RatePerTitle : Delete : Border [Line: EXPINV RatePerTitle ] Field: Name Field Local:Field: Name Field: Set as: $BasicPurchaseOrderNo Local:Field: Name Field: Style: Large Bold Local:Field: Name Field:Border: Thick Left Local:Field: Name Field: Width:22.6 Space Top: 0.3 Space Bottom: 0.3
anyone help me i use UDF field ,,,,how to collect the value in invoice customization ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [#Part :LedOtherDetails] Add : Line : MG Led ECCNo [Line : MG Led ECCNo] Fields : Short Prompt, MG Led ECCNo Local : Field : Short Prompt : Setas : "Agent Code:" [Field : MG Led ECCNo] Use : name Field Setas : $MGLedINo Storage : MGLedDINo [system : udf] MGLedDINo : string : 500 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Field:OTS Agent] Use: Name Field Set as:$MGLedINo Style: O12B