Double Quantity field

How to manage stock meter and pcs both

 

Hi gtendra, Thir is Already "Multy Unit Management in tally. Study..... ". If Any Further Post Your Query here the people all good Hearted Peoples are to support Make your own....

 

I don't want conversion in the second quantity I want, I have to enter it manually.

 

Create a Item with alternative units

While Entry, Type Quantity like 1m=10p

 

NO SIR
in my criteria conversion not apply ( like 1m=10p)

 

Create a Item with alternative units
and create meter wise item

item 2000 mtr as 1 pcs
item 1000 mtr as 1 pcs
item 850 mtr as 1 pcs

 

SIR THIS IS NOT POSSBILE BECAUSE I HAVE MORE THAN 1000 PCS AND METER VARRIABLE

 

pls check this shall fullfil your requirement



[system : udf]
newPc : Number : 1001
newMtr : Number : 1002


[#Line: VCHBATCH ColumnOne]
Add: Right Fields: Before:VCH QtyTitle:fldPc,fldMtr
[Field : fldPc]
Use : Name Field
Set as: "Pcs"
Width: 4
Skip: Yes
[Field : fldMtr]
Use : Name Field
Set as: "Mtr"
Width: 5
Skip: Yes
[#Line: STKVCH Batch2]
Add: Right Fields: Before: VCHBATCH ActualQty : fldPc1,fldMtr1

[Field : fldPc1]
Use : Number Field
Width: 4
Storage: strPc
[Field : fldMtr1]
Use : Number Field
Width: 5
Storage: strMtr
On: Accept: Yes: Field Accept
On: Accept: Yes: Call: funcSetQty:$strMtr:$strPc


[Function : funcSetQty]
Parameter: pB: String
Parameter: pA: String
Local Formula: formQ: ##pB+" "+$BaseUnits:StockItem:$StockItemName+"="+##pA+" "+$AdditionalUnits:StockItem:$StockItemName
1: Set Value: BilledQty : $$AsQtyformQ

 

NOT WORKING SIR

 

HOW TO STORE ALT QUANTITY SEPRATE AND FETCH IN STOCK CLOSING WITH INWARD OUTWARD AND OPENING

 

[SYSTEM:UDF]
MyPcs : Quantity : 1208
MyOpening Pcs : Quantity : 1216

;---------------------------------------------------------------------------------------------------------------
For Entry Level(SALE,PURCHASE,STOCK JOURNAL) In Batch allocation
[Field: Pcs Data]
Use : Qty Field
Width : 7
Align : Center
Storage : MyPcs
Format : "No Symbol,No Zero,Decimal:0"
;------------------------------------------------------------------------------------------------------------------------------
For Entry Level InOpening Batch allocation
[Field:Opening Pcs Data]
Use : Qty Field
Width : 7
Align : Center
Storage : MyOpening Pcs
Format : "No Symbol,No Zero,Decimal:0"
;------------------------------------------------------------------------------------------------------------------------------

I have made an entry, data is being saved in it, but how to create batch wise opening inward outward report of my UDF?

please help

 

O

Otherwise, you can't maintain stock.

 

What I understood is you want to see your stock opening, Purchase, Sale and Closing in Pcs but For billing purpose, the rate are per Meter.

You can achieve this using in-built feature whereas Set Mtr as Unit of measurement & Pcs as Alternate units.

At the time of transaction entry enter both unit as

2 pcs = 850 Mtr

This will capture both the unit into single field and all the report can be generated accordingly.

Use F12 to configure report display using alternate units.

Hope, It may help you.

 

↑
I don't want conversion in the second quantity I want, I have to enter it manually

Beacuse

100 mtr 2 pcs
50 mtr 1 pcs
50 mtr 5 pcs like that

 

How you need to show stock in stock summary for this case..?

 

Batch wise stock mtr and pcs

 

You can enter both the unit in same field. Even if there is no fixed ratio between both the units. You'll get all the default report for both the units.

 

Furthermore, if you want to enter both the qty in seperate field, Insert two qty field before Default qty field and set formula in default qty field to capture both the units.

This will completely solve your requirement.

 

NOT WORKING SIR

[system : udf]
newPc : Number : 1001
newMtr : Number : 1002


[#Line: VCHBATCH ColumnOne]
Add: Right Fields: Before:VCH QtyTitle:fldPc,fldMtr
[Field : fldPc]
Use : Name Field
Set as: "Pcs"
Width: 4
Skip: Yes
[Field : fldMtr]
Use : Name Field
Set as: "Mtr"
Width: 5
Skip: Yes
[#Line: STKVCH Batch2]
Add: Right Fields: Before: VCHBATCH ActualQty : fldPc1,fldMtr1

[Field : fldPc1]
Use : Number Field
Width: 4
Storage: strPc
[Field : fldMtr1]
Use : Number Field
Width: 5
Storage: strMtr
On: Accept: Yes: Field Accept
On: Accept: Yes: Call: funcSetQty:$strMtr:$strPc


[Function : funcSetQty]
Parameter: pB: String
Parameter: pA: String
Local Formula: formQ: ##pB+" "+$BaseUnits:StockItem:$StockItemName+"="+##pA+" "+$AdditionalUnits:StockItem:$StockItemName
1: Set Value: BilledQty : $$AsQtyformQ

 

Let me try.... I'll check & revert. I was using the same in past.

 

OK SIR THANK YOU

 

This has been achieved without using any TDL. Please suggest what change you need in this.

 

how to use it sir

 

This is exactly same as said by knsivam89

At the time of entry you have to enter both unit in same field using "=" as seperator

 

result not as same per your screen shot sir