This code Add a column of Vehicle Number in Sales Voucher. in Daybook or Party Ledger, (First Set Yes to Show Inventory Details in F12) while press Shift+Enter on an Entry, it shows Vehicle Number for Individual Entry but while pressing Alt+F1 (Detailed) Button the vehicle number not showing. Code: [System: UDF] MyVehicleNo : String : 1327 [#Line: EI ColumnOne] Option: GWLW EI ColumnOne : @@IsSales [!Line:GWLW EI ColumnOne] Add: Right Fields: At Beginning : MyVehicleNo Local : Field : Default : Align: Center Local : Field : MyVehicleNo : Info : "Vehicle No. " [#Line: EI InvInfo] Add: Right Fields: At Beginning : MyVehicleNo [Field:MyVehicleNo] Use : Short Name Field Width : 12 Align: Right Border: Thin Left Right Storage : MyVehicleNo Invisible: NOT ##VrVarC1 Skip on: $$IsEnd:$StockItemName [#Part: DayBookVCHINVAlloc Explosion] ; in Daybook Report - Single Entry Local : Line : DSP InvAllocDetails : Delete : Left Field Local : Line : DSP InvAllocDetails : Add : Left Field : DSP VchDate, DSP VchStockItem, MyVehicleNo, DSP VchBilledQty, DSP VchRate, DSP VchValue [#Part: DSP SingLedInvExplosion] ; in Ledger Report - Sinlge Entry Local : Line : DSP SingLedInvExpl : Delete: Fields Local : Line : DSP SingLedInvExpl : Add : Field : DSP VchDate, VCH StockItem, MyVehicleNo, VCH BilledQty, VCH ActQtyTmpl, VCH FullRate, VCH PrevItem, VCH Value, VCH AddlValue Please anyone help me to solve the issue.
Study Both the PARTS in Developer.......... It has further EXPLODES within it ................. Try adding your Fields there too.
the problem is more complicated. In Tally.ERP9 DevMode -> Daybook shows Field Name (on mouse hover) and column for the field name. but Value of UDF not appears. While pressing Shift Enter - it shows Value of UDF in particular Entry only. Screenshots attached herewith for more clarification of problem.
Solved by Updating 2 Collections inspired by http://tdlexpert.com/index.php?threads/cheque-number-in-reports.5999/ last 4 lines of #3
[#Line: DB Title1] Add : Option : RCPDaybook DSP VchAccTitles :$$IsParent:##Vouchertypename:$$VchTypeSales [!Line: RCPDaybook DSP VchAccTitles] Add :Right Fields : Before : DSP VchTypeTitle : RCPLedLocationTitle, RCPLedDriverTitle, RCPLedTruckNoTitle, RCPTruckTypeTittle Sir, How to get the option only for the sales voucher?
You are trying to put conditions without understanding the same......your condition is TOTALLY wrong and opposite to what you want. This is a simple one and I am sure you can work out on your own. So now this is a TEST for you........ BROWSE the Developer and you will find.
$$IsSales:##VoucherTypeName:$$VchTypeSales Thank you Sir. I like the way you motivate and teach people. really it makes curiosity to learn things
You are welcome........ ready answers/codes will not make you learn/understand. You can also use the inbuilt default formula.... Add : Option : RCPDaybook DSP VchAccTitles : @@IsSales
Sir, In both cases, I can get the details if I choose All Sales Vouchers. But if I choose another voucher type (Test Sales <Under-Sales> It won't give the same result. Am I missing something to add the child of Vouchers?
No...that will happen........because the VOUCHER Register Report is common across all VoucherType.........just have different collections. The Collection is not getting refreshed, hence the condition is being ignored. Anytime you press F4 to select other types or refresh teh TDL, this will happen.
Try This....... [System : Formula] OnlySaleTrxn : NOT ($$IsCreditNote:##VoucherTypeName OR + $$IsDebitNote:##VoucherTypeName OR + $$IsPayment:##VoucherTypeName OR + $$IsReceipt:##VoucherTypeName OR + $$IsContra:##VoucherTypeName OR + $$IsPurchase:##VoucherTypeName OR + $$IsJournal:##VoucherTypeName)
Dear friends and Experts, This is to give an Idea to all. Maybe some of you have already done it. ... Instead of creating a UDF aggregate for Vehicle No and Driver name, it's better to create a cost center name with vehicle number and retrieve the employees name from payroll by assigning proper designation to the drivers so that in later we can get a report to compare revenue and expenses made by such vehicle or driver
Most users of Tally do not know how to utilize all the features of Tally based on MIS reports their companies needs. Cost Centres combined with Cost Categories functions as a parallel P&L Account with umpteenth varieties as per reports/MIS needed. But my personal observation is --- most people try to reduce their workload / data entry, by using TDL..... but not taking into consideration that they will have to further process the data on external APPs like Excel, Word etc. Am a businessman and have exposure to many staffers - own and Clients too -- many staffers prefer slow poke work rather than efficient work, because they fear, if their work gets over faster/sooner, they will be given more work. So they are okay with slow work and passing their 8 hour work duty.