You cannot view this unit as you're not logged in yet.
86 thoughts on “Invoice Customization : Part I how to add extra columns and fetch the value”
Leave a Reply
You must be logged in to post a comment.
Total:
₹0.00
Total:
₹0.00
SIR,
this program does not bring in tally Sr. No. and edition No .
We have to type it
Hanif Shaikh
Have you put your code to the DropBox ? If yes, please do let me know the filename so that I can look into the same.
However, I suggest you recheck the entire code, compare your codes with the chapter
Dropbox link 🔗🔗🔗🔗🔗🔗???????
the File name in INV_print.txt
Where is your master file where you have defined the Serial number and the Software edition ?
Both the files must be enabled in the Tally only then your code will work
And why didn’ you give the file name as print It is confusing I guess the objective of your file is not the print but to add the extra columns in the Invoice Section
In Short, you will need
1. Master file which adds 2 files e.g. Serial Number and software edition
2. Extension of this file in which you are adding 2 extra columns and fetch the udf value from the 1st file as described above.
If you are confusing or not getting it, please do contact me at WhatsApp and I suggest you please delete the duplicate files of the same name
or write at the top of the file the purpose of that file so that I can understand and can look up your code
Sir, I have sorted my problem it was :
Set as:$snum:Ledger:PartyLedgerName
actually it should like
Set as:$snum:Ledger:$PartyLedgerName
looking for new chapters on variables and other functions
Great
Please do more practice. Add udf at item level and fetch them in your invoice
Also, submit your project for the TDL configuration file path by adding a new field.
The more you code and practice, the more you will become an expert in your coding skill
New chapters are on its way. will be available in the first week of the September
Unable to see the images in the above project
I have created the file invoice customization in Dropbox. it is giving error in TDL: ‘Field:LedEdition’
Could not find description
Kindly look into it and let me know where I am going wrong. I checked the file 3 to 4 times to see if there are any errors, but could not find any.
Hello,
Description not find are very simple to solve. That means you had definied something and described something else so you must check the spelling mistake.
E.g. from your comment i just looked the led edition
and here is your line definition
[Line: LedEdition]
Field: Medium Prompt, LedEditon
now you can see that you missed “i” in the Edition after the t word
the field you defined as LedEdition
so, please correct the spelling mistake and your issue will be resolved.
why should we modify [#Line:EI ColumnTwo] because above code is also working fine without modifying the above line
please see the file in my drop box name “Invoice_Fetch_Record”
name – Nilesh tjane
email id – removed by the moderator
Hello Nilesh,
Thanks for your comment and the input. The Line EI column Two is to justify the width of the field. If you don’t amend it then your code may work but the display may or may not be the same. It depends on the length of the field and nature of text which contains the field. So, a rule of safety it should be amended.
I have removed your email ID from the comment body section because it is a bad idea to post the email id in the comments body section as it gives chances to spammers and bots to access such email id and you will fed up of the spam mail from those bots
Ok Sir …. Henceforth i will not mention my email id in comment section
i have small query, we have wrote code Adding the new field to Ledger Master
for adding 2 fields Tally Serial No.,Tally Edition
we have modified [#Part: MST LED Details] part to add new line
but in above example we have modified the [#Part:MST LED Explode Sundry] what is the difference.
sir,
i did my two programes but i could get only the heading in the printout but not the data in the print out
plz look into the matter and guide me where i got wrong coding and i already posted my two files on my dropbox
and i am also having the same doubt expressed by mr.swamy santosh, why we need to say [#part: mst led explod sundry] instead of [#part: mst led details]
what is the diference between these two sir?
Hello Sir
In This Code When I Have Entered Serial Number Of Customer It Is Not Storing The Serial Number
[#Line: EI ColumnOne]
Add:Field:After:Vch Item Title:VchSerial,VchEdit
Local:Field:vchSerial:Space Left:15
Local:Field:VchEdit:Space Left:15
[Field:VchSerial]
Use:Name Field
Set as:”Tally Serail No”
Width:9
Skip:Yes
[Field:VchEdit]
Use:Name Field
Set as:”Tally Edition”
Width:9
Skip:Yes
[#Line:EiColumnTwo]
Add:Field:After:Vch Item Title:VchSerial,VchEdit
Local:Field:VchSerial:Set as:””
Local:Field:VchSerial:Space Left:15
Local:Field:VchSerial:Skip:Yes
Local:Field:VchEdit:Set as:””
Local:Field:VchEdit:Space Left:15
Local:Field:VchEdit:Skip:Yes
[#Line:EiInvInfo]
Add:Field:After:Vch StockItem:VchSerno,VchEdition
Local:Field:VchEdition:Space Left:15
[Field:VchSerno]
Use:Number Field
Set as:$SerialNumber:Ledger:$PartyLedgerName
Storage:VchSerno
Width:9
Format:”No Zero,No Comma”
[Field:VchEdition]
Use:Name Field
Set as:$SerialEdition:Ledger:$PartyLedgerName
Storage:VchEdition
Width:9
[#Part:MST Led Explode Sundry]
Add:Line:After:LED AffectsStock:LedSrNumber,LedEdition
[Line:LedSrNumber]
Field:Medium Prompt,LedSrNumber
Local:Field:Medium Prompt:Set as:”Tally Serial Number?”
[Field:LedSrNumber]
Use:Number Field
Format:”No Zero,No Percentage,No Comma”
Storage:”SerialNumber”
Color:Blue
[Line:LedEdition]
Field:Medium Prompt,LedEdition
Local:Field:Medium Prompt:Set as:”Tally Software Edition?”
[Field:LedEdition]
Use:Name Field
Format:”No Zero,No Percentage,No Comma”
Storage:SerialEdition
Color:Blue
[System:udf]
SerialNumber:Number:801
SerialEdition:String:802
VchSerNo:Number:803
VchEditon:String:804
Hello Pramod,
[Field:LedSrNumber]
Use:Number Field
Format:”No Zero,No Percentage,No Comma”
Storage:”SerialNumber”
Color:Blue
Please check the above and storage name me “” use nahi hota hey sirf storagename hi likhne ka
refer the below correct code.
[Field:LedSrNumber]
Use:Number Field
Format:”No Zero,No Percentage,No Comma”
Storage:SerialNumber
Color:Blue
Also the serial number is the default Tally storage so use a differnet name like storage : PramodSrNumber something like that.
Hi sir
Your code is working fine.Thanks.But there is a small gap is coming between the border line.(even in your output image also you can see).How to rectify that.
Try to put the same width at the column title field and the input data field.
If that doesn’t work then you need to test a lot by setting the width.Generally that will work if you set the same width for both the column title and the data field.
This issue is in voucher printing code
Thanks for reply.
I have tried by giving same width in all places but still that gap is coming.Can you please try from your end
Not, an issue, I will fix that.
Giridharan Varadharajan
Sir,
Understanding of me is
1. Alter Ledger master to add two lines to store UDF
2. Then call this in sales invoice
3. Then print
In the Demo You have selected Part: MST LED Explode Sundry to modify
But actually the Line :LED Affects Stock is in Part: MST Led Default.
You should selected this to Modify.
Why you have selected MST LED Explode Sundry..?
MST Led is a common part which is available by default without any specific configuration changes or settings and we can simply use that. While other parts/lines depends on individual settings by user requirement and so that is not common. Most of the people will struggle to search that. many of my students even doesn’t know how to create a ledger and so to handle those stuff becomes too complex and people will feel unnecessary confusion.
Giridharan Varadharajan
Sir,
I have finished the assignment.
Output & code shared in my folder along with my understanding.
only difficulty is locating the exact part if it is invisible and is in exploded part.
I request you explain the students about explosion and invisible situation in tally.
However I shared my understanding. with detailed study I think I can overcome the difficulty.
Since you have given the part to be modified, it will be easy to code but finding them without
your hint in necessary.
Hope with your guidance I will learn in depth.
Dear Sir,
In a course, every chapter has a purpose.
That is to be familiar with one or two elements and not to each and every elements
Tally is having more than 5 lac codes/definitions.
There are many things not just the explode or something like options, switch, subform invisible, functions, list variables skip even can’t make a list of those things
If I try to add everything in one chapter then one video or one chapter in itself will be going for more than 10 hours long which will become too heavy, too complex and majority of us won’t be able to understand anything out of that. Because coding is 10% of understanding and 90% of writing and testing codes. And you can’t write and test code all the codes in one chapter that too when you are completely new to something.
So, the purpose is first get ourselves familiar with the basic purpose and the things which are included in the chapters and when there is no reference to explode, invisible etc we need to skip those stuff in the default definitions. and have to concentrate on our purpose only.
Other things are being explained as and and when they needed.
Yes, learning a coding is always a time consuming and confusing for the initial few months till we get 30% or more familiarity with it. and there is no magic solutions or an easy solution to that.
yes, finding the default definition is the most difficult task for everyone and if that was such an easy then everyone was doing the TDL but again only experience and more and more practice and familiarity with the code can help us. Except that nothing can help.
hello,
in this code, why we modify the EI columntwo line..?
Because without defining the same, my code is working properly
If your code are working fine, then its okay.
Column Two depends on many things and upon activation/deactivation of certain features.
What may be working may not work for others because it all depends on the features we are using.
If you want to to know more then study the column two coding source codes and try to understand what is there and how that works. It also needs a good and expert knowledge of Tally and you can get that only if you worked with various types of business/industries and not just with one type of business/industry.
Sir,
I have created the tile fields and and created the fields for its values in inventory part.
but I am unable to fetch the values stored in ledger master.
I am copying my codes as it is bellow, please guide me.
;; Addition of 2 fields in ledger master ( Serial No and Edition)
[#Part: MST LED Explode Sundry]
;;[#Part: Led Contact]
Lines: Serial, Edition
[Line: Serial]
Fields: Medium Prompt, Sl
Local : Field : Medium Prompt : Set as :”Serial Number”
[Field: sl]
Use: Number Field
Format: ” No zero, No Percentage, No Comma”
Color: Blue
Storage: sl
[System: UDF]
sl: Number: 9001
[Line: Edition]
Fields: Medium Prompt, Ed
Local : Field : Medium Prompt : Set as :”Software Edition”
[Field: Ed]
Use: Name Field
Color: Red
Storage: Ednew
[System: UDF]
Ednew: String : 9003
;; Now we start working on invoice lavel
[#Line: EI ColumnOne]
Add: Right Field: Before: VCH QtyTitle: SlNo, Edition
[Field: SlNo]
Use: Name Field
Set as: ” Serial Number ”
Skip: Yes
[Field: Edition]
Use: Name Field
Set as: ” Edition ”
Skip: Yes
[#Line: EI InvInfo]
Add: Right Field: Before: VCH BilledQty: SlNoValue, EditionValue
;;Fields : EI DeemedPos, VCH StockItem
;;Right Fields: VCH ActualQty, VCH BilledQty, VCH RateIncl, VCH Rate, VCH RateUnit, VCH PrevItem, VCH Discount, VCH Value
[Field: SlNoValue]
Use : Number Field
Set always : Yes
Storage : sl
Inactive : $$IsEnd:$StockItemName OR @@NoBaseUnits
;;[System: UDF]
;; slvalue:Number: 9004
[Field: EditionValue]
Use : Name Field
Set always : Yes
Storage : Ednew
Inactive : $$IsEnd:$StockItemName OR @@NoBaseUnits
;;[System: UDF]
;;ednewvalue: String:9005
Hello Rajesh,
You need to be clear about the exact problem you are facing.
“I have created the tile fields and and created the fields for its values in inventory part.
but I am unable to fetch the values stored in ledger master.”
What do you mean by the Inventory part? Are you talking about the stock Item Master or the voucher or the ledger Master?
and what do you mean by unable to fetch the values? you need to be clear where you are trying to fetch the field from the ledger master?
Without looking or your code, I can assume that you are unable to fetch the storage in the Voucher entry section from the ledger master.
I observed that your code are not matching with the course chapter. Please follow the chapter again 2-3 times. I am sure you will be able to sort out the issues.
[#Line:EI columnone]
Add:Field:After:VCHitemtitle:VCH Sertitle,Vchedititle
Local:Field:VCHitemtitle:Space Left:20
Local:Field:Vchedititle:Space Left:15
[Field:vchedititle]
Use:name field
Set as:”tally edition”
Width:11
Skip:Yes
[Field:vch sertitle]
Use:namefield
Set as:”tally sr no.”
Width:12
Skip:Yes
[#Line: eicolumntwo]
Add:Field:After:VCHitemtitle:VCH Sertitle,Vchedititle
Local:Field:VCHitemtitle:Space Left:20
Local:Field:VCHitemtitle:Set as:”123″
Local:Field:VCHitemtitle:Skip:Yes
Local:Field:Vchedititle:Set as:”456″
Local:Field:Vchedititle:Skip:yes
Local:Field:Vchedititle:Space Left:15
[#Line:ei invinfo]
Add:Field:After:VCHitemtitle:VCH Serno,Vchedition
Local:Field:VCHitemtitle:Space Left:20
[Field:vch serno]
Use:namber field
Set as:$serialnumber:ledger:$partyledgername
Storage:vchsrno
Width:11
Format:”no comma,no zero”
[Field:vchedition]
Use:name field
Set as:$serialedition:ledger:$partyledgername
Storage:VCHedition
Width:11
;;Format:”no zero,no comma”
[#Part: mst led explode sundry]
Add:Line:after: led affectsstock: ledsr number, led edition
[Line:ledsr number]
Field: medium prompt,ledsr number
Local:Field:medium prompt:Set as:”tally serial no.?”
[Field:ledsr number]
Use:number field
Format:”no comma,no zero”
Color: red
Storage:serial number
[Line:led edition]
Field:medium prompt, led edition
Local:Field:medium prompt:Set as:”tally softer edition”
;;yellow
[Field:led edition]
Use:name field
Format:”no comma,no zero”
Color:yellow
Storage:serial edition
[System:UDF]
serialnumber:Number:801
serial edition:String:802
vchsrno:Number:803
vchedition:String:804
Hello Virat,
Are you facing any problem with the code? If yes, you need to specify the issue. Mere by looking the code, I can’t comment anything.
You need to mention your output/results or errors so that I can have a idea.
Hello Virat,
As per the team Viewer session, it is clear that For Dubai the print code will not work. It will work only if the Company is In India.
For Dubai the print code line may be different. I will try to find out the correct line for Dubai country. It will take time for me to do so.
Mean while you can continue with a Indian demo company in Tally as created by me.
[#Line: EI ColumnOne]
Fields : VCH ItemTitle
Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
Add: Field: After: VCH ItemTitle: VCH SerNoTitle, VCH EdsnTitle
Local: Field: VCH SerNoTitle: Space Left: 15
Local: Field: VCH EdsnTitle : Space Left: 15
[Field: VCH SerNoTitle]
Use: Name Field
Set as: “Tally Serial No”
Width: 9
Skip: Yes
[Field: VCH EdsnTitle]
Use: Name Field
Set as: “Tally Edition”
Width: 9
Skip: Yes
[#Line: EI ColumnTwo] ; what is the use of this column and their containing fields, as i execute this filr without this column it is working
Fields : VCH ItemTitle
Right Fields: VCH ActualQtyTitle, VCH BilledQtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
Local: Field: VCH ItemTitle: Set as:””
Add: Field: After: VCH ItemTitle: VCH SerNoTitle, VCH EdsnTitle
Local: Field: VCH SerNoTitle: Set as:””
Local: Field: VCH SerNoTitle: Space Left: 15
Local: Field: VCH SerNoTitle: Skip: Yes
Local: Field: VCH EdsnTitle: Set as:””
Local: Field: VCH EdsnTitle: Space Left: 15
Local: Field: VCH EdsnTitle: Skip: Yes
[#Line: EI InvInfo]
/*
Fields : EI DeemedPos, VCH StockItem
Right Fields: VCH ActualQty, VCH BilledQty, VCH RateIncl, VCH Rate, VCH RateUnit, VCH PrevItem, VCH Discount, VCH Value
*/
Add: Field: After: VCH StockItem: Vch SNo, Vch Ed
Local: Field: Vch Edsn: Space Left: 15
[Field: Vch SNo]
Use: Number Field
Set as: $SerialNumber:Ledger:$PartyLedgerName
Storage: VchSerNo
Width: 9
Format: “No Zero, No Comma”
[Field: Vch Ed]
Use: Name Field
Set as: $SerialEdition:Ledger:$PartyLedgerName
Storage: VchEdsn
Width: 9
;; Adding extra field in ledger master to incorporate serial number and software edition to ledger master
[#Part: MST LED Explode Sundry]
Add: Line: After: LED AffectsStock: LedSrNumber, LedEdition
[Line: LedSrNumber]
Field: Medium Prompt, LedSrNumber
Local: Field: Medium Prompt: Set as:”Tally Serial Number”
[Field: LedSrNumber]
Use: Number Field
Format: “No Zero, No Percentage, No Comma”
Storage: SerialNumber
Color: Blue
[Line: LedEdition]
Field: Medium Prompt,LedEdition
Local: Field: Medium Prompt: Set as: “Tally Software edition”
[Field: LedEdition]
Use: Name Field
Storage: SerialEdition
Color: blue
[System: UDF]
SerialNumber: Number: 801
Serial Edition: String: 802
VchSerNo: Number: 803
VchEdsn: String: 804
Hello Vishal,
Since Dropbox folder is there, you don’t need to post your codes in the comment section. If your code doesn’t work or you are facing any issue then you can let me through Comment.
Your codes are synced to my System if you save them in the Dropbox folder and no need to post here in the comment section.
Also, you need to mention clearly if your codes are working or you are facing any issue. Just by reading codes, I can’t comment anything. Cause many things depends on the Invoice and Tally configuration also.
Dear Sir.., Serial Number, Serial Edition, Does not pick up from master to sales invoice
Sir ,
Not picking the values of serial number and serial edition from master in sales invoice . I have added my codes with images in dropbox .
Please share the coding for customization of Sales Invoice to add Two alternate Unit of Measurement of stock item which total can be added as a field in the Sales Invoice Voucher and Invoice Print
SIR, I DIDN’T GET OUTPUT AT THE TIME OF PRINTING I.E. SERIAL NUMBER AND EDITION IS NOT COME ON INVOICE
Sir i have a confusion
why do we change EI column two?
what is effect its code?
Hello Mohsin,
Best way to know the answer of such questions is testing.
Coding is all about testing. Why don’t you write some code /text/numbers in that line and see the results you will get much better idea rather than an answer from me and it will help you how to do testing and manipulating codes.
Hi Si,
showing TDL Error, Field:VchSerTitle could not fond description
[#Line:EI ColumnOne]
Add:Field:After:VCHItemTitle:VchSerTitle,VchEdiTitle
Local:Field:VchSerTitle:Space Left:15
Local:Field:VchEdiTitle:Space Left:15
[Field:VchSerTitle]
Use: Name Field
Set as:”Tally Serial No”
Width: 9
Skip:Yes
[Field:VchEdiTitle]
Use: Name Field
Set as:”Tally Edition”
Width:9
Skip:Yes
[#Line:EI ColumnTwo]
Add:Field:After:VCHItemTitle:VchSerTtile,VchEdiTitle
Local:Field:VchSerTitle:Set as:””
Local:Field:VchSerTitle:Space Left:15
Local:Field:VchSerTitle:Skip:Yes
Local:Field:VchEdiTitle:Set as:””
Local:Field:VchEdiTitle:Space Left:15
Local:Field:VchEdiTitle:Skip:Yes
[#Line:EI InvInfo]
Add:Field:After:VCH StockItem:VchSerNo,VchSerEdition
Local:Field:VchEdition:Space Left:15
[Field:VchSerNo]
Use:Number Field
Set as:$Sr.No:Ledger:$PartyLedgerName
Storage:VchSerNo
Width:9
Format:”No Zero,No Comma”
[Field:VchEdition]
Use:Name Field
Set as:$Sr.No:Ledger:$PartyLedgerName
Storage:VchEdition
Width:9
;;Format:”No Zero,No Comma”
[#Part:MST LED Explode Sundry]
Add:Line:After:LED AfterStock:LedSr.No,LedEdition
[Line:LedSr.No]
Field:Medium Prompt:LedSr.No
Local:Field:Medium Prompt:Set as:”Tally Serial Number”
[Field:LedSr.No]
Use:Number Field
Format:”No Zero,No Comma”
Storage:Serial Number
Color:Blue
[Line:LedEdition]
Field:Medium Prompt:LedEdition
Local:Field:Medium Prompt:Set as:”Tally Software Edition”
[Field:LedEdition]
Use:Name Field
Format:”No Zero,No Comma”
Storage:Serial Edition
Color:Blue
[system:UDF]
SerialNumber:Number:801
SerialEdition:String:802
VchSer:Number:803
VchEdition:String:804
I told you to read your codes again and again you have a typo error and if you don’t read your codes carefully then no one can help you to become an expert in TDL.
In your line you added VchSerTtile and your field name is VchSerTitle if you had read it carefully you could have find it yourself
Hello sir, i want to customize invoice column size plz help me to do that
Sir,
The above Assignment , you have defined in [#Line: EI ColumnTwo] VchSertitle & VchEdititle. The Same has already defined in [#Line: EI ColumnOne]. In My TDL I have
removed the EI ColumnTwo and the Programme is running Successfully. Please solve my confusion.
You didn’t mentioned what is your confusion?
If your query is related to line two then there is nothing like confusion. That is a silent line by default TDL.
you can ignore that line and your code still will work.
But I used that line because that is per standard coding of TDL. it is there in the Default TDL codes.
Why did we use [EI Column Two] and what is the purpuse of EI Column Two
That is an additional column in The detault TDL code.
You can ignore that.
In the line [#Line:EI InvInfo]
how this storage can be passed because it is under Inventory Info ,So how can serialNo:Ledger:$PartyLedgerName can be used?
please provide proper explanation regarding this line?
Did you write the code and did you tested it?
Yes or No?
if you tested it then what is the result you are getting?
In “set as” attribute $serialnumber:ledger:$partyledgername,
instead of $partyledgername if we use $ledgername then also it is working.
So, what is the difference between $partyledgername and $ledgername??
Which is to be used where and why ?
Hello Sir,
i tried it, at the end its taking the tally serial no & edition No/Name,
when we go to the invoice, it is not skipping the field if tally serial no /edition.
Hi Shamrao,
I am sorry, I didn’t get exactly what issue you are facing.
Please share the screen shot of the output through whatsApp to 7227900879 or put them in your Dropbox along with your code so that I can understand exactly what issue you are facing.
This code works fine.
Sir, I am getting Tally Serial Number fetched correctly whereas Tally Edition is not getting fetched (only blank space is there) using this program. Can you please help me out. My Tally version is Single User (Silver) Release 6..4
;;Program to Fetch the Tally Slno and Edition automatically in the sales Invoice
[#Line: EI ColumnOne]
/*
Fields : VCH ItemTitle
Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle,
VCH AmtTitle
*/
;; End of Code
Hello Kangayan Singaram,
Please do not post your code in the comment section.
Did you read your codes again and again?
Did you compared it with the chapter?
This one is the most simplest coding example.
You should be able to do it without any issue.
You used $$ to retrieve the storage name instead of Single $
Please check your code again and compare it with the code
Sir, We have amended the EI ColumnOne & provided definitions to our user defined titles. Then why we have to amend EI ColumnTwo in above code. There is no changes made in tally by amending EI ColumnTwo.
Pls clarify. And also I can able to do adding fields in voucher but how to make it to print in invoice. I am struggling at the moment. Pls do needful sir.
Default TDL have both these columns so, I just took them as per it is. you may ignore the second line if it is not hurting your codes.
But I don’t like to ignore the default TDL structure thats why I took them as it is. Some times if we have a longer column title then we can take that in the second line without hurting our field alignment. you can do testing for e.g. take a long column title in the first line only like ” my new field is best”
and then don’t code for the second line and test how it looks
then you can spilt the same title in both line
like in the first line you can take ” my new field ” and in the second line you can take the rest and see what output you are getting.
Invoice printing belongs to a different section. the said unit was only for the voucher entry level.
1. What is the relation of above code with figure 1. Invoice Custmisation?
2. First we have to put data in ledger creation then it will reflect in sales voucher during entry, Is it Ok?
Then we found that on every stock item values of Serial Number and Edition are coming automatically.
or 3. If we entered value of Sr. No. and Edition during Sales Voucher Creation, it is limited to voucher only, not reflected in ledger.
1. That is a sample invoice means we will design an invoice which will look like that with 2 additional columns to print sr number and edition.
2. yes you got it right.
3. yes that is also correct. No, it was only for the voucher entry. but you can do the reverse also.
To do the reverse we just need to put the same index number. You can try if that works
like use the same index number for the sr number udf both in ledger master and in voucher and see what happens
you can also test by putting the same udfname both in ledger master and in the voucher
Testing, testing and test is the best way to learn quickly and to understand how things works.
You should always do your own testing and should think a way to do the testing in different ways!
Hi sir, I gone answer, it’s picking the value from ledger.
I have few doubts
Does the storage name should be same
Created in ledger and now in voucher
If had studied the chatper carefully, you could have noticed that I used two different storage for ledger master and for vouchers
Ofcourse you can use same storage but in that it will fetch the same value in the alternate. I suggest you use different storage name till you understand it by doing various projects and you can test your way by using same storage name and then try to input two different values and see what output you are getting in both place.
You will need a lot of testing to understand the effect. An answer won’t help you to understand it clearly.
At the moment, I suggest you to use 2 different storage name
I had picked the value from the voucher storage. just check the chapter and compare with your code and you will be able to pick up the value from the voucher also.
If you want to pick up value from the voucher then you just need to use $udfname
from ledger you will need to use $udfname:collection:collectionproperty
like $ledgerphone:Ledger:$Partyledgername
dear sir,
can we change default height of any part in print invoice
My Feedback: Its working for me. The values are stored.
That was wonderful
Sir,
I am bit confused for collection
$SerialEdition:Ledger:$PartyLedgerName
serialedition :- Is a storage name whose value we need to fetch
Ledger:-is form from which we have to fetch the above storage name
PartyLedgerName :- is?
I need to understand it better. Please help.
PartyledgerName belongs to Ledger of sundry Debtors or Creditors
The formuale is to fetch the udf name from master is
$udfname:collection:collectionproperty
like OpeningBalance:Ledger:$partyledgername
so when you select whatever a party name in a voucher it will fetch the udf /storage name from the so selected master
If you want to fetch the udf from a stock item master it will be like
$udfname:stockitem:$itemName
[#Line:EI Columnone]
Add:Field:After:Vch ItemTitle:VchSerTitle,VchEdiTitle
Local:Field:VchSerTitle:Space Left:15
We are not be able to store data on master file
you are not able to save data on master
Do you mean in Debtor’s Master ledger you are not able to save serial number and edition?
Please change serialnumber udfname to mysrnumber and then test it.
Also, plesae don’t mix your codes in one file.
master file should be separate, Voucher level code should be separate.
and after that let me know once you separate your codes
[#Part: MST LED Explode Sundry]
Add:Line:After:LED AffectsStock:LedSrNumber
[Line:LedSrNumber]
Field:Medium Prompt,LedSrNumber
Local:Field:Medium Prompt:Set as :”Tally Serial No?”
[Field:LedSrNumber]
Use:number field
;;Set as:$$Value
Format:”No Zero,No Percentage,No Comma”
Storge:Myserialnumber
Color:blue
[System:UDF]
Myserialnumber:Number:801
i am not be able to store serial number in debtors
Neeraj,
You need to read your codes and should develop a habit of reading it again and again. and checking it with The course chapter.
If you read your codes carefully, you would have noticed that you wrote Storge instead of Storage.
Also, please do not post your codes here in the comment section. But save in the Shared TM Folder which I shared with you. Inside that TM Folder one folder is in your name
It is more easy for me to check the codes through Dropdox.
and use Tally Developer to write codes because it hightlights such issues by color.
Thankx Sir,
Respected sir,
I uploaded my query, code files in dropbox. Pls have look. waiting for your suggestion.
Regards
Rajesh Pawar
8850909921
Please mention the folder name as I couldn’t find your name folder.
Sir,
I tried the code in ledger master is wroking fine and number is storage correctly
but its not fetch in invoice module
in my floder RANGANATHANS->Error->Invoice – 1 Cust is the file name
and while i tried to customize the Invoice print the alignment going so wrong
how to complete this task
Hello Sir
Tally Serial Number & Tally Software Edition not printing in my invoice bill. Can you help me
I trust your query has been resolved as explained in WhatsApp
Hello sir,
In this chapter vch edition and vch serial no are coming as hard coded form where we have to put the valu Or fetch the value…
It has to fetch from the ledger master.
First you need to add two fields in the ledger master and save those two new fields
After that you fetch it in voucher entry
I have droped file in Drop Box. File Name-Extra Column-Fetch Value.
Code note working in Tally Prime.
Please see the code and advise.
Regards,
[#Line:EI ColumnOne]
/* [Line: EI ColumnOne]
Fields : VCH ItemTitle
Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
*/
Add:Field:After:VCH ItemTitle:vchsertitle,vchedititle
Local:Field:vchsertitle:Space Left:15
Local:Field:vchedititle:Space Left:15
[Field:vchsertitle]
Use:name field
Set as: “tally serial no”
Width:9
Skip:Yes
[Field:vchedititle]
Use:name field
Set as:”tally edition”
Width:9
Skip:Yes
[#Line: EI ColumnTwo]
/* Fields : VCH ItemTitle
Right Fields: VCH ActualQtyTitle, VCH BilledQtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
Local : Field : VCH ItemTitle : Setas: “”
*/
Add:Field:After:VCH ItemTitle:vchsertitle,vchedititle
Local : Field : vchsertitle : Setas: “”
Local : Field : vchsertitle : Skip:Yes
Local : Field : vchsertitle : Space Left:15
local : Field : vchedititle : Setas: “”
local : Field : vchedititle : Space Left:15
local : Field : vchedititle : Skip:Yes
[#Line: EI InvInfo]
/*Fields : EI DeemedPos, VCH StockItem
Right Fields: VCH ActualQty, VCH BilledQty, VCH RateIncl, VCH Rate, VCH RateUnit, VCH PrevItem, VCH Discount, VCH Value
Explode : STKVCH AltUnitsExplosion : NOT $$IsEmpty:$StockItemName AND NOT @@NoAltUnits
Explode : EI DutyExplosion : @@IsExciseTraderOn AND NOT @@IsExciseSupplementaryInv AND ((@@IsExciseGoodsTransfer AND NOT @@IsExciseAdValQtm) OR ($$EIDutyExpVal AND NOT @@IsJoborderVouchers AND NOT @@IsJobMaterialIssue AND (If @@IsExciseMfgrInvoice Then NOT @@IsExciseAdValQtm Else Yes)))
Explode : EI ValrmQtmDutyExplosion : @@IsExciseTraderOn AND NOT @@IsExciseSupplementaryInv AND ((@@IsExciseGoodsTransfer AND @@IsExciseAdValQtm) OR ($$EIDutyExpVal AND NOT @@IsJoborderVouchers AND NOT @@IsJobMaterialIssue AND (If @@IsExciseMfgrInvoice Then @@IsExciseAdValQtm Else No)))
Explode : EI DescExplosion : NOT $$IsEmpty:$StockItemName AND ##ICFGAddlDesc AND NOT $$IsEmpty:$BasicUserDescription
*/
Add:Field:After:VCH StockItem:vchserialno,vchedition
Local:Field:vchedition:Space Left:15
[Field:vchserialno]
Use:number field
Set as:$serialnumber:ledger:$partyledgername
Storage:vchserno
Width:9
;;format:”nozero,nocomma”
[Field:vchedition]
Use:name field
Set as:$voucheredition:ledger:$partyledgername
Storage:vchedit
Width:9
;;format:”nozero,nocomma”
[#Part: MST LED Explode Sundry]
Add: Line:after:LED AffectsStock:ledSrNumber, ledEdition
[Line: ledSrNumber]
Field: long Prompt,ledSrNumber
Local: Field:long Prompt : Set as: “tally Serial Number:”
[Field:ledSrNumber]
Use: Number field
Format: “No Zero, No Percentage, No Comma”
Storage: Serialnumber
Color:Blue
[Line: ledEdition]
Field: long Prompt, ledEdition
Local: Field:long Prompt : Set as: “tally software Edition:”
[Field: ledEdition]
Use: Name Field
Format: “No Zero, No Percentage, No Comma”
Storage: serialEdition
Color:Blue
[System:UDF]
Serialnumber:Number:801
voucheredition:String:802
vchserno:Number:803
my invoice field show but not retrived pls correction my code s5r
Not Received Reply to my request.
I have been out of station since may 15 due to personal emergencies so unable to handle any code support.
Also you need to be specific for what is not working without which it would be difficult to understand the issue.
Also have you checked your codes 10 times and compared it with the chapter?
Remember, most of the issues we can solve ourself if we review our codes carefully.
Coding is not just about coded but sometimes we may have to review our codes even for 100 times.
If you don’t develop the habit of code review then when you work on a project, you will face it very hard to solve the problem.
So please check your codes and do your best efforts to solve it your self.
Even after that if it still doesnt work then let me know with full error or issue description and I will solve it in no time.
So please go through