I know how to add your own UDF in invoice, however I want to add two fields in invoice - 1.Name 2.Address . But instead of typing name manually, what I want is that the name is selected from Ledgers I had already created and that the address comes automatically. Is that possible?
No thats the point the things are not coming automatically, I have 10-12 Ledgers with salesman name and address, now what I want is that in Sales Invoice, my custom UDF "Salesman Name" to show the list of ledgers I have
you have a separate database wherein you have a list of salesman name and address? you have just asked query....on what you want? but to understand we need to know what you have and how you have done it? So be more explanatory on your query.
Sorry, I would try to explain in detail. I have 10 Ledgers under Group "Salesman" consisting of Salesman Name and their Address. Now while creating Sales Invoice, I have added new field to enter Salesman Name and another to enter his address, what I need is just like when we enter Buyer's Details we get list of all the ledgers we have and we can select anyone, can I get the Name of all the Ledgers under Salesman Group to select from while I am in "Salesman Name" field
Yes you can....in the field where you are required to enter the Salesman Name, you make a table.... the table will pick up ledgers under Group "Salesman". once you select the NAME of Salesman, the next field will pick up address of that salesman. Refer tally developer to see how to set your field and call up.............in Set As.....
Hey I had proceeded as above and made two fields, first is Salesman Name 2nd is Address which has Set As...I have Salesman Ledgers uder Group Salesman. I am having two problems, 1. In Saleman Name field, how to make table show only ledger under Salesman Group. Currently it shows all Ledgers. 2. The Address field updates only once, i.e. if I selected Salesman1 the address field will show Address1, but if I press backspace and change Salesman Name to Salesman2, the address field continues to show Address2.
Dear, Put FILTER function in ur ledger selection. Second when u select 2nd salesman automatically as per function add. also will be changed? do u want 2 put same add. in other salesman also?!! M i misunderstanding? Regards.
For Ledger Filter [Collection: Abcd] Type : Ledger Child Of : "Salesman" ;; Here your Salesman Group Name For Address Set [Field: SManAddress] Use : Name Field Set as : $$Table:SManLedger:$Address ;;Change SManLedger to your Salesman Ledger Field Name Set Always : Yes
