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....
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
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
[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
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
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
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