This all credits Goes to our Experts Only sir. They all are very much of help me. Thanks to all Our Experts.....
Dear knsivam89 sir Can you make a Customer wise VAT Report which shows Invoice Date, Invoice Number, Particulars (Sales/Sales Return), Accessible Amount, VAT Amount, Invoice Amount . Thanks Aloke Debnath
problem in stock summary sir I have come to the cause of the problem The problem occurs because of the cost of each separate godown For example i have tow godowns (godown 1 and godown 2) and i have one item ( item a ) and i will use cost avg If i buy 10 item a in godown 1 rate 10 total amount will be in godown 1 100 and If i buy item a in godown 2 rate 9 total amount will be in godown 2 90 total amount in all 190 this good but the problem is in separate cost to each godown in this case if i transfer 5 unit from godown 2 to godown 1 the rate cost in godown 1 is 9.67 total amount in godown 1 = 15*9.67=145 and the rate cost in godown 2 is 9 total amount in godown 2 =5*9=45 to now no problem but now if i transfer stock 10 unit from godwn 1 to godwn 2 this is the problem here u can find loss 1.64 and cost to godwon 1 will be 5 unit*9.67=48 and cost to godwon 2 will be 15 unit *9.34=140.03 in first i had stock in total in all company =190 now my stock in total company is 188.36 no sales this is just transfer sir solution this problem is very easy 1- transfer stock in stock jv must be without rate and amount 2- if i buy the same item in more than godown in Different rate must be find allocation this cost in each godown (means not godown 1 10 unit *10 =100 and in godown 2 10 unit * 9=90 this is very wrong this is the problem must tally give me cost like in godwon 1 10 unit *9.5= 950 and in godown 2 10 unit * 9.5=950 auto allocation cost in all godowns if tally to that this problem will done ) sir separate cost in each godwon is very wrong must be when purchase by Different rate in any godown must be change all rate in other godown must be the in all godwns is the same 1-sir if we buy stock in godwn 1( 10 unit rate 10 amount will be 100 ) and if i buy the same item in godown 2 (10 unit rate 9 amount will be 90) total amount in godown 1( 100) and total amount in godwn 2 (90) and rate in godown 1 will be (10) and rate in godown 2 will be (9) this is Reason the problem in consumption the is the wrong i want the same rate in all godown ( rate must be in godown 1 (9.5) and in godown 2 ( 9.5) this is no.1 to solution my problem 2-and after that remove stock jv from stock summary 3-and in stock jv voucher i want hidden rate and amount (that in voucher stock jv entry ) this all i want
HI, You have developed one of the best reports. in addition, I have modified further to add up with Alternate Qty against the Sales amount. Which will give additional information and control check on my daily/periodic realization for sales. But I have got stuck with code which gives me result of per Kg Realisation. In last column I am looking for value SaleAmount /Billed Weight. I am giving formula to calculate but the calculation it is taking on Primary Unit Qty, instead of secondary unit Qty. That is why result is showing the Item wise Average rate and not the realization which I am looking against per Kg (Secondary Unit) Can you please help me with the same. --- I am unable to load modified the file on this forum. Local : Field : BWRRealisation : Set as : $SubAmount / $SubActQty Local : Field : BWRAvgRate : Set as : $SubAmount / $SubActQty Local : Field : BWRAmount : Set as : $SubAmount Local : Field : BWRActualQty2 : Set as : $SubActQty Local : Field : BWRActualQty : Set as : $SubActQty Local : Field : BWRPartyName : Align : Right Local : Field : BWRPartyName : Set as : $ItemName Local : Field : Default : Style : Normal Italic Local : Field : SWSno : Set as : "" Delete : Border Use : BWRDetails[Line:BWRExplode] Border : Thin Bottom Repeat : BWRExplode:BWRPartyExplode Line : BWRExplode[Part:BWRExplode] Local : Field : BWRRealisation : Align : Right Local : Field : BWRRealisation : Border : Thin Left Right Local : Field : BWRRealisation : Set as : $$Total:BWRRealisation Local : Field : BWRAmount : Align : Right Local : Field : BWRAmount : Set as : $$Total:BWRAmount Local : Field : BWRActualQty2 : Set as : $$Total:BWRActualQty2 Local : Field : BWRActualQty2 : Type : Quantity : Secondary Units Local : Field : BWRActualQty : Set as : $$Total:BWRActualQty Local : Field : BWRPartyName : Set as : "Grand Total" Local : Field : SWSno : Set as : "" Local : Field : Default : Border : Thin Left Local : Field : Default : Style : Large Bold Local : Field : Default : Align : Right Local : Field : Default : Type : String Use : BWRDetails Border : Totals[Line:BWRTotal] Line : BWRTotal[Part:BWRTotals] Border : Thin Right Space Left : 2 mms Width : 16 Align : Right Set as : $TotAmount / $TotActQty2 ;VoucherTypeName Type : Number : Quantity Use : Qty Secondary Field[Field:BWRRealisation] Max : @@MaxNumberWidth Key : Calculator Align : Right Format : "No Zero, Symbol," + ##ShowForex Width : @@AmountWidth Set as : $TotAmount / $TotActQty ;VoucherTypeName Type : Number Use : Qty Field[Field:BWRAvgRate] Tooltip : "Amount Without TAX" Border : Thin Right Space Right : 2 mms Width : 16 Max : @@MaxNumberWidth Key : Calculator Align : Right Format : "No Zero, Symbol," + ##ShowForex Width : @@AmountWidth Type : Amount Set as : $TotAmount Use : BWRDefault[Field:BWRAmount] Border : Thin Right Space Left : 2 mms Width : 16 Set as : $TotActQty2 ;VoucherTypeName Use : Qty Secondary Field[Field:BWRActualQty2] Border : Thin Left Right Space Left : 2 mms Width : 16 Set as : $TotActQty;VoucherTypeName Type : Quantity Use : Qty Field[Field:BWRActualQty]
error while loading duplicate description in 'party name' please help i am newer in this thanks in advance with best regards, Balkrishna
Dear Sir, Please remove any other tdl u r using from "manage local tdl" it is colliding with the tdl u already loaded.
i am getting this error ""(494): error T0044: duplicate description name variable - PartyName in user TDL . There is no another tdl added.
;=============================================================== ;======================= F11 Feature =========================== ;=============================================================== [#Part: CMP TallyShopFeatures Left] Add : Line : At End : CMP EnableBrokerLine [Line:CMP EnableBrokerLine] Space Bottom : 1.5 mms Field : Long Prompt,CMP EnableBrokerLine Local : Field : Long Prompt : Set as : "Enable Broker wise Report.?:" [Field:CMP EnableBrokerLine] Use : Logical Field Storage : EnableBroker Set as : If $$IsEmpty:$$Value then "No" else $$Value Sub Form: CMP BrokerNameReport: $$Value = "Yes" [Report: CMP BrokerNameReport] Form : CMP BrokerNameForm Object : Company [Form: CMP BrokerNameForm] Part : CMPBrokerDetails Background : White, Petal Pink [Field:CMPName Field] Use : Name Field Skip : Yes Align : Center Border : Thin Bottom [Part:CMPBrokerDetails] Part : CMP BrokerNamePart,CMP TransportPart,CMP LoadManPart Vertical : No Common Border : Yes [Part: CMP BrokerNamePart] Line : CMP BrokerNamePartTit,CMP BrokerName LineDetails Repeat : CMP BrokerName LineDetails: BrokerNameList BreakOn : $$IsEmpty:$BrokerNameList Height : 10 Scroll : Vertical CommonBorder: Yes Space Left : 2 mms Space Right : 2 mms Border : Thin Right [Line:CMP BrokerNamePartTit] Field : CMPName Field Local : Field : CMPName Field : Set as : "Broker Name" [Line: CMP BrokerName LineDetails] Field : CMP BrokerNameList;,CMP TransportList,CMP LoadmanList;,CMP Broker CommissionField [Field: CMP BrokerNameList] Use : Name Field Storage : BrokerNameList Style : Small Bold [Part:CMP TransportPart] Line : CMP TransportPartTit,CMP TransportPart Repeat : CMP TransportPart: TransportList BreakOn : $$IsEmpty:$TransportList Height : 10 Scroll : Vertical CommonBorder: Yes Space Left : 2 mms Space Right : 2 mms Border : Thin Right [Line:CMP TransportPartTit] Field : CMPName Field Local : Field : CMPName Field : Set as : "Transport Name" [Line:CMP TransportPart] Field : CMP TransportList [Field: CMP TransportList] Use : Name Field Storage : TransportList Style : Small Bold [Part:CMP LoadManPart] Line : CMP LoadmanListTit,CMP LoadmanList Repeat : CMP LoadmanList: LoadmanList BreakOn : $$IsEmpty:$LoadmanList Height : 15 Scroll : Vertical CommonBorder: Yes Space Left : 2 mms Space Right : 2 mms [Line:CMP LoadmanListTit] Field : CMPName Field Local : Field : CMPName Field : Set as : "Loadman Name" [Line:CMP LoadmanList] Field : CMP LoadmanList [Field: CMP LoadmanList] Use : Name Field Storage : LoadmanList Style : Small Bold ;=============================================================== ;======================= Add Fields =========================== ;=============================================================== [#PartBLLINE Narration] Add : Line : Before : VCH NarrPrompt : VCHBrokerLine [Line:VCHBrokerLine] Invisible : NOT $EnableBroker:Company:##SVCurrentCompany OR NOT $$IsSales:##SVVoucherType Field : VCHBrokerNameTit,VCHBrokerName,VCHTransportTit,VCHTransport,VCHLoadManTit,VCHLoadMan [Field:VCHBrokerNameTit] Use : Meduim Prompt Set as : "Broker Name :" Skip : Yes [Field:VCHTransportTit] Use : VCHBrokerNameTit Set as : "Transport Name :" [Field:VCHLoadManTit] Use : VCHBrokerNameTit Set as : "Loadman Name :" [Field:VCHBrokerName] Use : Name Field Storage : BrokerName Table : BrokerNameColl,EndofList Show Table : Always Key : CreateBroker [Field:VCHTransport] Use : Name Field Storage : TransportName Table : TransportNameColl,EndofList Show Table : Always Key : CreateBroker [Field:VCHLoadMan] Use : Name Field Storage : LoadmanName Table : LoadmanNameColl,EndofList Show Table : Always Key : CreateBroker [Key:CreateBroker] Key : Alt + C Action : Alter : CMP BrokerNameReport ;;========================================================= ;;================= Broker wise Report ================== ;;========================================================= [#Menu: Gateway of Tally] Add : Key Item : After : @@locSalesRegister : "Broker Report" : R : Display : BrokerReport ;Control : BrokerReport : $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReport] Use : DSP Template Title : "Broker Report" Variable: SVFromDate, SVToDate Repeat : PartyName Form : BrokerReport Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Set : FilterBroker : "" Set : FilterTransport : "" Set : FilterLoadman : "" [Form:BrokerReport] Button : PrintButton, ExportButton Button : ExplodeFlag,ChangePeriod,BtnBroker Bottom Toolbar Buttons : EnterToEdit, BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10 Part : BWRTitle,BWRPeriod,BWRFilter,BWRDetails Bottom Part :BWRTotals Width : 75% Page Space Left : 2 mms Space Right : 2 mms [Key: EnterToEdit] Key : Enter Title : $$LocaleString:"Explode" Type : BottomToolBarBtn2 Action : Explode [Part:BWRTitle] Line : BWRTitle Horizontal Align : Center [Part:BWRPeriod] Line : BWRPeriod [Line:BWRTitle] Field : Simple Field Local : Field : Simple Field : Style : Large Bold Local : Field : Simple Field : Info : "Sales Report" Local : Field : Simple Field : Border: Thin Bottom Local : Field : Simple Field : Align : Center [Line:BWRPeriod] Right Field : Name Field Left Field : Short Prompt,RPTBrokerFilter Local : Field : Name Field : Info : @@DSPDateStr Local : Field : Name Field : Width : 50 Local : Field : Name Field : Align : Right Local : Field : Short Prompt : Set as: "Broker:" Local : Field : Short Prompt : Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Part:BWRFilter] Line : BWRTranFilter,BWRLMFilter Invisible : Not $EnableBroker:Company:##SVCurrentCompany [Line:BWRTranFilter] Field : Short Prompt,RPTTransportFilter Space Top : 1 mms Local : Field : Default : Use : Simple Field Local : Field : Short Prompt : Set as : "Transport:" [Line:BWRLMFilter] Field : Short Prompt,RPTLoadManFilter Space Top : 1 mms Local : Field : Default : Use : Simple Field Local : Field : Short Prompt : Set as : "Loadman:" [Field:RPTBrokerFilter] Inactive : Not $EnableBroker:Company:##SVCurrentCompany Use : Simple Field Style : Normal Bold Set as : @VCHBrokerName Set Always : Yes VCHBrokerName : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then "Show All" Else ##FilterBroker [Field:RPTTransportFilter] Use : RPTBrokerFilter Set as : @VCHTransport VCHTransport : if ##FilterTransport="" or $$IsEndOfList:##FilterTransport Then "Show All" Else ##FilterTransport [Field:RPTLoadManFilter] Use : RPTBrokerFilter Set as : @VCHLoadMan VCHLoadMan : if ##FilterLoadman="" or $$IsEndOfList:##FilterLoadman Then "Show All" Else ##FilterLoadman [Line:BWRHead] Use : BWRDetails Border : Column Titles Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : Default : Border : Thin Left Local : Field : Default : Style : Normal Bold Local : Field : SWSno : Set as : "Sno" Local : Field : SWSno : Border : Thin Left Right Local : Field : BWRPartyName : Set as : "Party Name" Local : Field : BWRPartyName : Align : Left Local : Field : BWRActulQty : Set as : "Actual Qty" Local : Field : BWRActulQty : Align : Left Local : Field : BWRBilledQty : Set as : "Billed Qty" Local : Field : BWRBilledQty : Align : Left Local : Field : BWRAmount : Set as : "Amount" Local : Field : BWRAmount : Border : Thin Left Right Space Top : 1.5 mms Space Bottom: 1.5 mms [Part:BWRDetails] Line : BWRHead,BWRDetails Repeat : BWRDetails:BWRPartyWise Scroll : Vertical Total : BWRActulQty,BWRBilledQty,BWRAmount Common Border : Yes [Line:BWRDetails] Field : SWSno,BWRPartyName Right Field : BWRActulQty,BWRBilledQty,BWRAmount Option : AlterOnEnter : $$IsVoucher Space Bottom: 0.5 mms Space Top : 0.5 mms Border : Thin Top Explode : BWRExplode : ($$KeyExplode OR ##ExplodeFlag) [Field:BWRDefault] Use : Name Field Style : Normal Bold [Field:SWSno] Use : BWRDefault Set as : $$Line Width : 1.5 cm Align : Center Border : Thin Left Right [Field:BWRPartyName] Use : BWRDefault Set as : $PartyName Width : 60 Quick Search: Yes Space Left : 2 mms [Field:BWRActulQty] Use : Qty Field Type : Number Set as : $TotActQty;VoucherTypeName Width : 16 Space Left : 2 mms Border : Thin Left Right [Field:BWRBilledQty] Use : BWRActulQty Set as : $TotBillQty Width : 16 Space Left : 2 mms Border : Thin Right [Field:BWRAmount] Use : BWRDefault Set as : $TotAmount Type : Amount Width : @@AmountWidth Format : "No Zero, Symbol," + ##ShowForex Align : Right Key : Calculator Max : @@MaxNumberWidth Width : 16 Space Right : 2 mms Border : Thin Right Tooltip : "Amount Without TAX" [Part:BWRTotals] Line : BWRTotal [Line:BWRTotal] Border : Totals Use : BWRDetails Local : Field : Default : Type : String Local : Field : Default : Align : Right Local : Field : Default : Style : Large Bold Local : Field : Default : Border : Thin Left Local : Field : SWSno : Set as : "" Local : Field : BWRPartyName : Set as : "Grand Total" Local : Field : BWRActulQty : Set as : $$Total:BWRActulQty Local : Field : BWRBilledQty : Set as : $$Total:BWRBilledQty Local : Field : BWRAmount : Set as : $$Total:BWRAmount Local : Field : BWRAmount : Border : Thin Left Right Local : Field : BWRAmount : Align : Right [Part:BWRExplode] Line : BWRExplode Repeat : BWRExplode:BWRPartyExplode Border : Thin Bottom [Line:BWRExplode] Use : BWRDetails Delete : Border Local : Field : SWSno : Set as : "" Local : Field : Default : Style : Normal Italic Local : Field : BWRPartyName : Set as : $ItemName Local : Field : BWRPartyName : Align : Right Local : Field : BWRActulQty : Type : Quantity Local : Field : BWRActulQty : Set as : $SubActQty Local : Field : BWRBilledQty : Type : Quantity Local : Field : BWRBilledQty : Set as : $SubBillQty Local : Field : BWRAmount : Set as : $SubAmount ;=============================================================== ;======================= Add Filters =========================== ;=============================================================== [Button:BtnBroker] Key : F5 Action : Execute : BrokerReportWise Title : Broker Wise Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReportWise] Form : BrokerReportWise [Form:BrokerReportWise] Part : BrokerReportWise Space Left : 2 mms Space Right : 2 mms [Part:BrokerReportWise] Line : BrokerReportWise,FilterTransport,FilterLoadman [Line:BrokerReportWise] Field : Medium Prompt,BrokerReportWise Local : Field : Medium Prompt : Set as : "Select Broker Name:" Space Bottom : 2 mms [Field:BrokerReportWise] Table : BrokerNameColl,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterBroker Modifies : FilterBroker [Line:FilterTransport] Field : Medium Prompt,FilterTransport Local : Field : Medium Prompt : Set as : "Select Transport Name:" Space Bottom : 2 mms [Field:FilterTransport] Table : TransportNameColl,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterTransport Modifies : FilterTransport [Line:FilterLoadman] Field : Medium Prompt,FilterLoadman Local : Field : Medium Prompt : Set as : "Select Loadman Name:" Space Bottom : 2 mms [Field:FilterLoadman] Table : LoadmanNameColl,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterLoadman Modifies : FilterLoadman ;============================================================= ;================= System Functions ========================= ;============================================================= [System:UDF] EnableBroker : Logical : 4566 BrokerNameList : String : 4567 TransportList : String : 4568 LoadmanList : String : 4569 BrokerName : String : 4570 TransportName : String : 4571 LoadmanName : String : 4572 [System:Formula] BWRFilter : $BrokerName=@@BrokerWise AND $TransportName=@@TransportWise AND $LoadmanName=@@LoadmanWise BrokerWise : If $$IsEndOfList:##FilterBroker or ##FilterBroker="" Then $BrokerName Else ##FilterBroker TransportWise : If $$IsEndOfList:##FilterTransport or ##FilterTransport="" Then $TransportName Else ##FilterTransport LoadmanWise : If $$IsEndOfList:##FilterLoadman or ##FilterLoadman="" Then $LoadmanName Else ##FilterLoadman BWRExplodeFilter: $PartyName=#BWRPartyName [Collection: BWR Voucher] Type : Vouchers : VoucherType Child of : $$VchTypeSales Belongs to : Yes Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount,BrokerName,TransportName,LoadmanName Filter : NOTIsOptionalVoucher,BWRFilter [Collection:BWRPartyWise] Source Collection : BWR Voucher Walk : Inventory Entries By : PartyName : $PartyLedgerName Aggr Compute: TotActQty : Sum : $ActualQty Aggr Compute: TotBillQty: Sum : $BilledQty Aggr Compute: TotAmount : Sum : $Amount Sort : Default : $PartyName [Collection:BWRPartyExplode] Source Collection : BWR Voucher Walk : Inventory Entries By : PartyName : $PartyLedgerName By : ItemName : $StockItemName Aggr Compute: SubActQty : Sum : $ActualQty Aggr Compute: SubBillQty: Sum : $BilledQty Aggr Compute: SubAmount : Sum : $Amount Filter : BWRExplodeFilter [Collection:BrokerNameColl] Type : BrokerNameList: Company Childof : ##SVCurrentCompany Format : $BrokerNameList,25 Title : List of Brokers [Collection:TransportNameColl] Type : TransportList: Company Childof : ##SVCurrentCompany Format : $TransportList,25 Title : List of Transports [Collection:LoadmanNameColl] Type : LoadmanList: Company Childof : ##SVCurrentCompany Format : $LoadmanList,25 Title : List of Loadmans [Variable: PartyName] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterBroker] Type : String [Variable:FilterTransport] Type : String [Variable:FilterLoadman] Type : String [System:Variables] FilterBroker : "" FilterTransport : "" FilterLoadman : "" when installing above tdl, we get an error saying duplicate description error and the screen shot is being uploaded for reference. please advice the solution for it to be made in tdl code.
Thanks Shivam Its very nicely written code, It helped me a lot to get some filter concepts for Collection. Using those i can write code for my requirement, Thanks Once Again
plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.
plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.
plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.
plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. pla advice.
plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. plz advice.
plz modify the code so that duplicate description error with variable partyname doesnt come while loading the tdl. we have no other tdl installed but still this comes. it has been in forum for several months but no solution as yet. plz advice.
cud not understand by this??/ plz provide the solution for the error faced in tally erp 9 v 6.2 duplicate description error with variable PartyName even though there are no TDL loaded.