Quantity Total

Hello Experts
I have a Report of Item Name wise Qty Sold Total, as available in Sample tdl (Itemwise Sales)
I need to Get Total of Qty in Nos. But qty is in Doz, Box, Nos, etc. How to Achieve it.?

Please guid. Thanks

 

Dear Hitarth,
Create new field as bellow.
[Field : Temp Field]
Use : Number Field
Set As : $BilledQty
Invisible : Yes (if required you can give invisible = yes)

As you said that your item unit is Kg, Nos, Box so you can't give total without using number field.

Try as above and you get solution.

Regards,

Ritesh Mehta

 

Dear Ritesh Mehta
Thanks for guide, i added above field and get the result in numbers,
And to get Total in Bottom Line, using

Local : Field : Prev Qty Field : Type : Number
Local : Field : Prev Qty Field : Set As : $$Total:TempField

Thanks

 

Deari Hitarth Sir,,

Same problem ,, i want to need item qty total in sales voucher . but not show please check,,

[#Part: DBLLINE Narration]
Add : Line : Before : VCH NarrPrompt : Totalsss

[Line : Totalsss]
Fields : TotalsssTitle ,Totalsss

[Field : TotalsssTitle]
Set as : "Item Qty Title"
Skip : Yes

[Field : Totalsss]
Use : Number Field
;Set as :$$Total:BilledQty
;Use : EI BilledQtyTotal
Set as : $$Total:VCHBilledQty

 

Dear Vyadav,

Already Inventory Item Qty Total is displayed Default by Tally

and still if u want the total again ,use this

[#Part BLLINE Narration]
Add :Line : Before: VCH NarrPrompt :Totalsss

[Line : Totalsss]
Fields: TotalsssTitle ,Totalsss

[Field : TotalsssTitle]
Set as : "Item Qty Title"
;Skip : Yes

[Field : Totalsss]
Use :QTY Primary Field
Set as: $$Total:VCHBilledQty

 

Thank your for your replay NAGARAJKMAR SUBRAMANIAN sir

But my query is , if i select different types unit item then Default tally not showing item qty total (Filed Blank)

I want to item qty total value in my filed ,,,, How it's possible ...

i am sending attachment copy , I think you understand my problem and solved

thanks Sir,, i am waiting your replay ,,,,,,,,,,

 

Dear Mr.Vyadav,

This code will give total of Multiple Items with Multiple units

[#Part BLLINE Narration]
Add :Line : Before: VCH NarrPrompt :Totalsss

[Line : Totalsss]
Fields: TotalsssTitle ,Totalsss

[Field : TotalsssTitle]
Set as : "Item Qty Title"
;Skip : Yes

[Field : Totalsss]
Use :Number Field
Set as: $$Collnumtotal:Inventoryentries:$numqty
Set Always : Yes


[System : UDF]
NumQty : Number : 8600

[Field : QtyasNum]
use : Number Field
Set as : $$Number:$BilledQty
Format : Decimals:3
Set Always : Yes
Storage : NumQty

 

Dear Sir


Thank You for your replay but above code is not working in tally 4.91

 

i am also trying in tally 4.93 & 4.5 but item qty total show 0

 

see the screen shot, it is Rel 4.93

concept is

stock item with multiple units cannot be added in tally, if u convert the item as Number , you will get it.

This work for all releases.

 

dear sir

i am already check 4.93 but number of Qut. not show , there is show only (0) value

my item is

item name unit

pen Pcs
rubber Nos

i want only numbering total of item

please help me sir,,,,,

 

Dear Sir,

Yet still my Quantity Total Please sir what are i Doing

Please help

 

Dear sir,

i need to total discount value print in invoice

pl show attach image & solution ..

 

Please check

Default total?

 

SIR
I WANT TO ADD LIKE BELOW EXAMPLE

5 PKTS
10 PCS
3 CTN
8 PCS
4 PKTS

TOTAL 3 CTN , 9 PKTS , 18 PCS

ITS TOTAL OF SAME UNITS , IS IT POSSIBLE ?? KINDLY PROVIDE THE HINT SO THAT I CAN DEVELOP

REGARDS

 

You can calculate total only the items with same unit,
Filter the Collection using unit, the calculate using FilterQtyTotal Formulae

or u can convert qty field to Numbner using $$Number then you can add

 

can u share the code for qty total of different units

 

this code not working in tally 6.4.6 plz help