Deal all TDL Experts, i need to total the secondary qty with different units like Box, Pocket. I used following code. But it is not working, pls help me. [Part : myinventorypart] Line : Myinventoryline, myqtytotalLne Repeat: Myinventoryline:inventoryentries Scroll : Vertical Total:Myqtyfield [Line : Myinventoryline] Field : Myqtyfield [Field : Myqtyfield] use : Qty Secondary Field Set As : $$Number:$ActualQty Format : "Nosymbol" Align : center [Line : myqtytotalLne] Field : Myqtytotalfld [Field : Myqtytotalfld] use : Qty Secondary Field Set As : $$Total:Myqtyfield Format : "Nosymbol" Align : center
Here is the code defined for Sales Voucher :- [#Line: VCH NarrPrompt] Option : Wgt Total : $$IsSales:##SVVoucherType [!Line : Wgt Total] Add : Right Field : VCH wgt [Field: VCH Wgt] Use : Name Field Align : Right Width : @@VCHQtyWidth Style : Small Italic Set as : "( " + $$String:$TotalAltQty:Symbol,ShortForm,Secondary + " )" Set always : Yes Skip : Yes Inactive : $$IsEnd:$StockItemName OR @@NoAltUnits Border : Totals ;; Option : QtyWithCmdUnitTot : ##ICFGStkCmdunit [ System : Formula ] TotalAltQty : $$Owner:$$CollQtyTotal:InventoryEntries:$Billed Qty 1. Add an attribute callesd - Total in the Part level where you are repeating Inventory Entries [Part: My Part] Line : my Line Repeat : My Line : Inventory Entries Total: My Alt Qty ;; Field in the Repeated Line [Field: My Alt Qty] Use: Qty Secondary Field Set As: $BilledQty ;; Field in the Total Line [Field: My Alt Qty Total] Use: Qty Secondary Field Set As: $$Total:MyAltQty
New Here is the code defined for Sales Voucher :- [#Line: VCH NarrPrompt] Option : Wgt Total : $$IsSales:##SVVoucherType [!Line : Wgt Total] Dear Taufeeq Shaikh sir First I Thank you very much for your immediate response. Your code is working fine and superb. But i need the total as shown in the screen shot. pls help me.
Dear Mutharasan, I think that you have to just think little bit and make the concept of actual requirement. Because if it is like ( Kgs, Pkts, Nos, etc ) then it may be simple or compound units. So either you should try it as by making the value as String or Number and then adding it up. I am not sure but just applying the logic that it may be something like that.
h [Field: SDn1MyVchqty_slr] ;Use : Qty Field Set: $$CollQtyTotal:InventoryEntries:$BilledQty Style: Normal Align:Centre Width: 8 Border : Thick Left Color:black Background:Light Grey hi i am using this in one field by using this iam fetching qty like this (2600.00 Nos) but i like to prit it as (2600) only with out nos and decimile kindly help plz
h [Field: SDn1MyVchqty_slr] ;Use : Qty Field Set: $$CollQtyTotal:InventoryEntries:$BilledQty Style: Normal Align:Centre Width: 8 Border : Thick Left Color:black Background:Light Grey hi i am using this in one field by using this iam fetching qty like this (2600.00 Nos) but i like to print it as (2600) only with out nos and decimile kindly help plz
thanks dear i have 1 more small query kindly help i am attaching one screen shoot for your kind attentin kindly g=help in this tdl u can see the voucher creatiobn date such as 31 Jul 2017 can i show only July not with Day means to say i need to show only month of invocie not Date Of invocie thanks
thanks dear i have 1 more small query kindly help i am attaching one screen shoot for your kind attentin kindly g=help in this tdl u can see the voucher creatiobn date such as 31 Jul 2017 can i show only July not with Day means to say i need to show only month of invocie not Date Of invocie thanks View attachment 3319
thanks dear i have 1 more small query kindly help i am attaching one screen shoot for your kind attentin kindly g=help in this tdl u can see the voucher creatiobn date such as 31 Jul 2017 can i show only July not with Day means to say i need to show only month of invocie not Date Of invocie thanks View attachment 3319