30 thoughts on “Invoice Customisation Part II : How to customisation Invoice Printing”
Thank you Sir,
Your code is working fine with no errors
Submitting code s:
;; HANIF SHAIKH
;; hanif….@yahoo.com
;; DATED : 02-09-2016
;; Prog to Print Invoice with 2 Extra columns
[Line: PRN Webname ]
Field: Name Fld , Web Fld
[ Field: Name Fld ]
Local:Field:Name Fld: Info: ” Web Site :”
[ Field: Web Fld ]
Set as:$Website:##Company:SVCurrentCompany
Full Width: Yes
[#Line: EXPINV Column1]
delete : Field: EXPINV PackagesTitle1
add: Field: after : EXPINV DescTitle : Sr title, Ed title
Local: Field: sr title : Border: Thin Left
Local: Field: Ed title : Border: Thin Left
[ Field: Sr Title ]
Use: Name Field
Set as: ” Tally Sr.No.”
Width: 11
Skip: Yes
[ Field:Ed Title]
Use: Name Field
Set as: ” Edition”
Width: 09
Skip: Yes
[#Line: EXPINV INVDetails]
add: Fields: after : EXPINV Desc: Sr title1, Ed title1
Local: Field: sr title1 : Border: Thin Left
Local: Field: Ed title1 : Border: Thin Left
[ Field: Sr Title1 ]
Use: Number Field
Set as: $Srno11
Width: 11
Format: ” No Zero, No Comma ”
[ Field: Ed Title1 ]
Use: Name Field
Set as: $adno11
Width: 09
Format: ” No Zero, No Comma ”
Good! Please avoid feeding email id in the comments on web. Else your mail box will be flooded by spammers. There are automated bots which find email id over net in comment sections so use email id only where there is a field to input the email ID but never put that in the comment section itself. I had removed your email id from the comment 🙂
Add: Field: After: EXPINV Desc, EXPINV SerialNo, EXPINV Edition
Local : Field : EXPINV SerialNo : Border: thin left
Local : Field : EXPINV Edition : Border: thin left
[Field: EXPINV SerialNo]
Use: number field
Set as:$VchSerNo
Width:11
Format:”No comma, No zero”
[Field: EXPINV Edition]
Use: number field
Set as:$VchEdition
Width:9
Format:”No comma, No zero”
Is this file contains only the Invoice printing or the voucher customisation screen?
If not then please put that code also, I am not able to find the same in your Dropbox Folder
and If this file contains printing and voucher entry screen then you need to comment out your code so that I can know which lines belongs to Voucher entry section and which line belongs to invoice printing
Giridharan varadharajan.
Sir.
I have shared my assignment in my folder.
For your information.
Initially there was no proper alignment. I tried various options , which are reflected in my codings
Please evaluate.
[Field:PRNWEB]
Set as:$WEBSITE:COMPANY:##SVCURRENTCOMPANY
Full Width:Yes
[#Line: EXPINV column1]
Delete:Field:expinv packagestitle 1
Add:Field:After:expinvdesc title:expinv tallysrtitle 1,expinv edtitle 1
Local:Field:expinv tallysrtitle1:Border:thin right
Local:Field:expinv edtitle:Border:thin left
;;Local:Field:expinvdesc title:Border:thin right
[Field:expinv tallysrtitle1]
Use:name field
Set as:”tally serial no.”
Width:11
Skip:Yes
;;Color:red
;;Background:blue
[Field: expinv edtitle1]
Use:name field
Set as:”edition”
Width:11
Skip:Yes
;;Color:blue
;;Background:yellow
[#Line:expinv inv details]
Add:Field:After:EXPINV Desc:expinv serno,expinvedition
Local:Field:expinv serno:Border:thin left
Local:Field:expinvedition:Border:thin right
[Field:expinv serno]
Use:number field
Set as:$vchserno
Width:11
Format:”mo comma, no zero”
[Field:expinvedition]
Use:number field
Set as:$vchedition
Width:9
Format:”no comma, no zero”
[#Field: VCH QtyTitle]
Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:”tally Quantity”
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
sir plz help to because i cannot see this report in print area
plz help me to what i am doing wroung in this code
Did you re check your code with the Course Project?
I suggest you recheck your code.
Also your codes are fetching the Serial Number in the Invoice Printing
It is not fetching the Edition of the software because you have mistake in your code so, go through the course project again and try to find out the issue. and revert back to me in case if you are unable to find out it.
Hello Sir,
I was trying to make changes in invoice print configuration i able to change “description of goods” to “description of service” but now try to change “Quantity” to “Number of Days” not able to do with same code.
[#Part: EXPINV Column]
Lines : EXPINV Column1
Local : Field : Default : PrePrinted : Yes
SpaceBottom : 0.5
CommonBorder: Yes
Border : Thin Left Right
[#Line : EXPINV Column1]
Delete : Field : EXPINV DescTitle , EXPINV QtyTitle
Add : Field : After : EXPINV SLNoTitle : ins title
Add : Field : After : EXPINV VATPercTitle : ins qty
[Field: ins title]
Set as : “Description of Services”
FullWidth : Yes
Style : Small
Align : Centre
Cells : @@ExcelItemColumn
[Field : ins qty]
Use : QtyTitleField
Info : $$LocaleString:”Number Of Days”
;; Border : Thin Left
Align : Centre
Style : Small
Width : If @@IsJobWorkVouchers Then @@QtyWidth Else If (@@InvWithActQty AND $$InPixelMode) Then (@@QtyWidth + @@QtyWidth + .65) Else @@QtyWidth
Invisible : NOT @@InvWithQty
Cells : If (@@InvWithActQty AND (NOT @@IsJobWorkVouchers)) Then 2 Else 1
Option : AsRightSubTitle : If @@IsJobWorkVouchers Then No Else @@InvWithActQty AND $$InPixelMode
Option : AsRightSubTitleComprehensive : If @@IsJobWorkVouchers Then No Else (NOT ##SASimple AND @@InvWithActQty AND $$InPixelMode AND (@@IsNonExciseTrader OR (@@IsExciseTraderOn AND ##SATraderCommercial)))
Local:Field:vchedititle:Space Left:15
[Field:VCHserialTITLE]
Use:Name Field
Set as:”tally Serial Number”
Width: 9
Skip:Yes
[Field:vchedititle]
Use:tITLE Field
Set as:”Tally Edition”
Width:9
Skip:Yes
[#Line:ei columntwo]
Add:Field:After:VCH ItemTitle :VCHserialTITLE,vchedititle
Local:Field:VCHserialTITLE:Set as:””
Local:Field:VCHserialTITLE:Space Left:15
Local:Field:VCHserialTITLE:Skip:Yes
Local:Field:vchedititle:Set as:””
Local:Field:vchedititle:Space Left:15
Local:Field:vchedititle:Skip:Yes
/* Fields : VCH ItemTitle
Right Fields: VCH ActualQtyTitle, VCH BilledQtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
Local : Field : VCH ItemTitle : Setas: “”
Local : Field : VCH RateTitle : Setas: “”
Local : Field : VCH RateUnitsTitle: Setas: “”
DescExplosion : NOT $$IsEmpty:$StockItemName AND ##ICFGAddlDesc AND NOT $$IsEmpty:$BasicUserDescription*/
[#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:vchserno,vchedition
Local:Field:vchedition:Space Left:15
[Field:vchserno]
Use:number field
Set as:$serialnumber:ledger:$partyledgername
Storage:vchserno
Format:”NO ZERO, NO COMMA”
Width:9
[Field:vchedition]
Use:NAME FIELD
Set as:$SERAILEDITION:LEDGER:$PARTYLEDGERNAME
Storage:VCHEDITION
Width:9
[Line:prn website]
Field:name field,prnweb
Local:Field:name field:Info:”website”
[Field:prnweb]
Set as:$website:company:##svcurrentcompany
Full Width:Yes
[#Line:expinvcolumn1]
Delete:Field: EXPINV PackagesTitle1
Add:Field:After:expinvdesctitle:expinvtallysrtitle1,expinvedtitle1
Local:Field:expinvtallysrtitle1:Border:thin left
Local:Field:expinvedtitle1:Border:thin left
[Field:expinvtallysrtitle1]
Use: name field
Set as:”tally serial”
Width:11
Skip:Yes
[Field:expinvedtitle1]
Use: name field
Set as:”edition”
Width:9
Skip:Yes
[#Line:expinvinvdetails]
Explode : EXPINV ServiceCategory : ($$IsServiceTaxOn AND @@IsMalaysia AND @@IsSTTaxenabledDate_Vch)AND (NOT $$IsSysNameEqual:NOTApplicable:$STItemServiceCategory) AND $ForServiceTax:Ledger:$PartyLedgerName
Explode : EXPINV AltQty : @@InvWithQty AND NOT $$IsEmpty:$StockItemName AND NOT @@NoAltUnits and (Not @@AltUnitasCol and @@InvWithAltunit)
*/
Add:Field:After:EXPINV Desc:expinvserno,expinvedition
Local:Field:expinvserno:border:thin left
Local:Field:expinvedition:border:thin left
[ Field : EXPINVserNo]
;;Use:number field
Set as:$vchserno
Width:11
Format:”NO ZERO,NO COMMA”
[Field:expinvedition]
;;Use:number field
Set as:$vchedition
Width:9
Format:”NO ZERO,NO COMMA”
;;END
What is the reason for putting so much CODE?
THISH HERE
/*
[#Part:MST LED EXPLoDE SUNDRY]
Add:Line:After:LED AFFECTSTOCK:LEDSRNUMBER,LEDEDITION
[Line:LEDSRNUMBER]
Field:MEDIUMPROMPT,LEDSRNUMBER
Local:Field:MEDIUMPROMPT:Set as:”TALLY SERIAL NO?”
[Field:LEDSRNUMBER]
Use:NUMBER FIELD
Format:”NO ZERO,NO CAMMA,NO PERCENTAGE”
Storage:SERIAL NUMBER
Color:BLUE
[Line:LEDEDITION]
Field:MIDIUM PROMPT,LEDEDITION
Local:Field:MEDIUMPROMPT:Set as:”Tally Softer Edition?”
[Field:LEDEDITION]
Use: name field
Format:”NO ZERO,NO CAMMA,NO PERCENTAGE”
Storage:SERIAl edition
Color:BLUE
[system:udf]
SERIAL NUMBER:Number:801
SERIAl edition:String:802
vchserno:Number:803
vchedition:String:804
I think there is a cast study in the same project for the alignment. If it is not coming proper you may need to struggle with it.
Try to increase the reduce with the field width and see its effects.
If you don’t do efforts or try yourself then how can you solve the issue.
You will need to play with the codes
try by changing width , space etc
[Field : my field]
Width : 18
space right : 1
space left : 1
When all your efforts are fail, you can share the screenshot of the output result to my whatsApp number and I will help you to solve it.
but first, you must do efforts on your own.
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]
Add : Field : After: VCH ItemTitle : VchSerTitle,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,VchEdition
; Local : Field : VchEdition : Space Left : 15
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 : “NoZero, 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 : “NoZero, No Percentage, No Comma”
Storage :SerialEdition
Color : Blue
[System : UDF]
[Line : Prn Website]
Field : Name Field, prnWEb
Local : Field : Name Field : Info:”Website:”
[Field : PrnWEB]
Set as : $Website:Company:##SVCurrentCompany
Full Width : Yes
[#Line: EXPINV Column1]
Delete : Field : EXPINV Packages Title1
Add : Field : After : EXPINV DescTitle : EXPINV TallySrTitle1, EXPINVEdTitle1
Local : Field : EXPINV TallySrTitle1 : Border : Thin Left
Local : Field : EXPINVEdTitle1 : Border : Thin Left
;Local : Field : EXPINV DescTitle : Border : Thin Right
;Local : Field : EXPINV DescTitle : Style : Small
[Field : EXPINV TallySrTitle 1]
Use : Name Field
Set as : “Tally Serial No.”
Width : 11
Skip : Yes
[Field : EXPINVEdTitle1]
Use : Name Field
Set as : “Edition”
Width : 9
Skip : Yes
[#Line: EXPINV InvDetails]
Add : Field : After : EXPINV Desc : EXPINVSerNo,EXPINVEdition
Local : Field : EXPINVSerNo : Border : Thin Left
Local : Field : EXPINVEdition : Border : Thin Left
[Field : EXPINVSerNo]
Use : Number Field
Set as : $VchSerNo
width : 11
Format : “No Zero, No Comma”
[Field : EXPINVEdition]
; Use : Number Field
Set as : $VchEdition
Width : 9
Format : “No Zero, No Comma”
Sir,
I am using tally prime developer
most of the time file or folder mentioned to open in ide does not exist.
Like for this chapter there is no folder named print, or file invoice.500
Please let me know how to check what was old name and what is new name
as of now i have to search filed or part mentioned in your code and then find particular , its taking too much time.
You need to go through chapter from starting one by one.
If you miss the chapters in between then you will get confused.
In the default defintions modules I have put a video and explained the updated file structure and Folder name
In Prime only File name and foder names are changed and they are explained in the Default definitions Modules.
Also, I will suggest you please strat from chatper 1st without missing anything so that you can understand it.
You can also drop a message in Zopim chat or to my whatsApp number if you are unable to understand a concept.
Thank you Sir,
Your code is working fine with no errors
Submitting code s:
;; HANIF SHAIKH
;; hanif….@yahoo.com
;; DATED : 02-09-2016
;; Prog to Print Invoice with 2 Extra columns
[ #Part: EXPINV Company ]
Line : PRN Webname
;; Line: EXP Subtilte , EXP Company, EXP Address
[Line: PRN Webname ]
Field: Name Fld , Web Fld
[ Field: Name Fld ]
Local:Field:Name Fld: Info: ” Web Site :”
[ Field: Web Fld ]
Set as:$Website:##Company:SVCurrentCompany
Full Width: Yes
[#Line: EXPINV Column1]
delete : Field: EXPINV PackagesTitle1
add: Field: after : EXPINV DescTitle : Sr title, Ed title
Local: Field: sr title : Border: Thin Left
Local: Field: Ed title : Border: Thin Left
[ Field: Sr Title ]
Use: Name Field
Set as: ” Tally Sr.No.”
Width: 11
Skip: Yes
[ Field:Ed Title]
Use: Name Field
Set as: ” Edition”
Width: 09
Skip: Yes
[#Line: EXPINV INVDetails]
add: Fields: after : EXPINV Desc: Sr title1, Ed title1
Local: Field: sr title1 : Border: Thin Left
Local: Field: Ed title1 : Border: Thin Left
[ Field: Sr Title1 ]
Use: Number Field
Set as: $Srno11
Width: 11
Format: ” No Zero, No Comma ”
[ Field: Ed Title1 ]
Use: Name Field
Set as: $adno11
Width: 09
Format: ” No Zero, No Comma ”
File name in drop box is INV_PRINT.TXT
Good! Please avoid feeding email id in the comments on web. Else your mail box will be flooded by spammers. There are automated bots which find email id over net in comment sections so use email id only where there is a field to input the email ID but never put that in the comment section itself. I had removed your email id from the comment 🙂
I have successfully completed the Invoice Customization.
HOW CUSTOMIZED INVOICE , CAN YOU SEND ME MAIL..
Sir please check the codes .. when i run this in tally along with previous unit-1 coding, Serial no. and edition in not printing on invoice
[#Part: EXPINV Company]
Lines : EXPINV SubTitle, EXPINV Company, EXPINV Address, Prnwebsite
[Line: Prnwebsite]
Field: name field, Prnweb
Local: Field: name field: Info:”Website”
[Field: Prnweb]
Set as:$website:company:##SVCurrentcompany
Full Width: Yes
[#Line: EXPINV Column1]
Delete: Field : EXPINV PackagesTitle1
Add: Field: After:EXPINV DescTitle: EXPINV TallySrTitle1, EXPINV Edtitle1
Local : Field : EXPINV TallySrTitle1 : Border: thin left
Local : Field : EXPINV Edtitle1 : Border: thin left
[Field: EXPINV TallySrTitle1]
Use: name field
Set as:”Tally Serial No.”
Width:11
Skip:Yes
[Field: EXPINV Edtitle1]
Use: name field
Set as:”Edition”
Width:9
Skip:Yes
[#Line: EXPINV InvDetails]
/* Left Fields : EXPINV SLNo, EXPINV Marks, EXPINV Packages, EXPINV Desc
Right Fields: EXPINV PartNo, EXPINV MRPValue, EXPINV VATPerc, EXPINV DueOn, EXPINV ActualQty, EXPINV Qty, EXPINV Rate, EXPINV RatePer, EXPINV Discount, EXPINV Amount
*/
Add: Field: After: EXPINV Desc, EXPINV SerialNo, EXPINV Edition
Local : Field : EXPINV SerialNo : Border: thin left
Local : Field : EXPINV Edition : Border: thin left
[Field: EXPINV SerialNo]
Use: number field
Set as:$VchSerNo
Width:11
Format:”No comma, No zero”
[Field: EXPINV Edition]
Use: number field
Set as:$VchEdition
Width:9
Format:”No comma, No zero”
Is this file contains only the Invoice printing or the voucher customisation screen?
If not then please put that code also, I am not able to find the same in your Dropbox Folder
and If this file contains printing and voucher entry screen then you need to comment out your code so that I can know which lines belongs to Voucher entry section and which line belongs to invoice printing
I am not able to see the udf definitions here
sir I have my code in my dropbox having file name invoice customisation.
plz check
Sure, I will check it by tomorrow.
Giridharan varadharajan.
Sir.
I have shared my assignment in my folder.
For your information.
Initially there was no proper alignment. I tried various options , which are reflected in my codings
Please evaluate.
Please refer Module 7 : Case Study I explained through a video how to sort out the issues like borders.
[#Line: LED Contact]
Fields : Medium Prompt, LED Contact
Local : Field : Medium Prompt : Set as : $$LocaleString:”TALLY SERIAL NUMBER”
[#Line: LED Phone]
Fields : Medium Prompt, LED Phone
Local : Field : Medium Prompt : Set as : $$LocaleString:”EDITION”
[#Line:ei columnone]
;;Fields : VCH ItemTitle
Add:Field:After:VCH ItemTitle:VCH SERTITLE,VCH EDITITLE
Local:Field:VCH SERTITLE:Space Left:15
Local:Field:VCH EDITITLE:Space Left:15
Local:Field:VCH EDITITLE:Background:WHITE
Local:Field:VCH SERTITLE:Background:GREEN
[Field:VCH SERTITLE]
Use:NAME FIELD
Set as:”TALLY SERIAL NUMBER”
Width:9
Skip:Yes
Color:RED
[Field:VCH EDITITLE]
Use:NAME FIELD
Set as:”TALLY EDITION”
Width:9
Skip:Yes
Color:BLUE
[#Line: EI COLUMNTWO]
Add:Field:After:VCH ItemTitle:VCH SERTITLE,VCH EDITITLE
Local:Field:VCH SERTITLE:Space Left:15
Local:Field:VCH SERTITLE:Set as:””
Local:Field:VCH SERTITLE:Skip:Yes
Local:Field:VCH EDITITLE:Space Left:15
Local:Field:VCH EDITITLE:Skip:Yes
Local:Field:VCH EDITITLE:Set as:””
[#Line:EI INVINFO]
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 COMMA, NO ZERO”
[Field:VCHEDITION]
USE :NAME FIELD
Set as:$SERIALEDITION:LEDGER:$PARTYLEDGERNAME
Storage:VCHEDITION
Width:9
Format:””
[#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]
Format:”mo comma,no zero”
Use:number field
Storage:serial number
Color: RED
[Line:lededition]
Field:MEDIUM PROMPT,lededition
Local:Field:medium prompt:Set as:”tally softwer edition”
[Field:lededition]
Use:name field
Storage:serial edition
Color:RED
[System:UDF]
serial edition:String:801
serial number:Number:802
VCHSERNO:Number:803
VCHEDITION:String:804
[#Part: EXPINV Company]
Lines : EXPINV SubTitle, EXPINV Company, EXPINV Address, PRN WEBSITE
[Line:PRN WEBSITE]
Field:NAME FIELD, PRNWEB
Local:Field:NAME FIELD:Set as:”WEBSITE”
[Field:PRNWEB]
Set as:$WEBSITE:COMPANY:##SVCURRENTCOMPANY
Full Width:Yes
[#Line: EXPINV column1]
Delete:Field:expinv packagestitle 1
Add:Field:After:expinvdesc title:expinv tallysrtitle 1,expinv edtitle 1
Local:Field:expinv tallysrtitle1:Border:thin right
Local:Field:expinv edtitle:Border:thin left
;;Local:Field:expinvdesc title:Border:thin right
[Field:expinv tallysrtitle1]
Use:name field
Set as:”tally serial no.”
Width:11
Skip:Yes
;;Color:red
;;Background:blue
[Field: expinv edtitle1]
Use:name field
Set as:”edition”
Width:11
Skip:Yes
;;Color:blue
;;Background:yellow
[#Line:expinv inv details]
Add:Field:After:EXPINV Desc:expinv serno,expinvedition
Local:Field:expinv serno:Border:thin left
Local:Field:expinvedition:Border:thin right
[Field:expinv serno]
Use:number field
Set as:$vchserno
Width:11
Format:”mo comma, no zero”
[Field:expinvedition]
Use:number field
Set as:$vchedition
Width:9
Format:”no comma, no zero”
[#Field: VCH QtyTitle]
Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:”tally Quantity”
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
sir plz help to because i cannot see this report in print area
plz help me to what i am doing wroung in this code
Hello Virat,
Did you re check your code with the Course Project?
I suggest you recheck your code.
Also your codes are fetching the Serial Number in the Invoice Printing
It is not fetching the Edition of the software because you have mistake in your code so, go through the course project again and try to find out the issue. and revert back to me in case if you are unable to find out it.
Hello Sir,
I was trying to make changes in invoice print configuration i able to change “description of goods” to “description of service” but now try to change “Quantity” to “Number of Days” not able to do with same code.
[#Part: EXPINV Column]
Lines : EXPINV Column1
Local : Field : Default : PrePrinted : Yes
SpaceBottom : 0.5
CommonBorder: Yes
Border : Thin Left Right
[#Line : EXPINV Column1]
Delete : Field : EXPINV DescTitle , EXPINV QtyTitle
Add : Field : After : EXPINV SLNoTitle : ins title
Add : Field : After : EXPINV VATPercTitle : ins qty
[Field: ins title]
Set as : “Description of Services”
FullWidth : Yes
Style : Small
Align : Centre
Cells : @@ExcelItemColumn
[Field : ins qty]
Use : QtyTitleField
Info : $$LocaleString:”Number Of Days”
;; Border : Thin Left
Align : Centre
Style : Small
Width : If @@IsJobWorkVouchers Then @@QtyWidth Else If (@@InvWithActQty AND $$InPixelMode) Then (@@QtyWidth + @@QtyWidth + .65) Else @@QtyWidth
Invisible : NOT @@InvWithQty
Cells : If (@@InvWithActQty AND (NOT @@IsJobWorkVouchers)) Then 2 Else 1
Option : AsRightSubTitle : If @@IsJobWorkVouchers Then No Else @@InvWithActQty AND $$InPixelMode
Option : AsRightSubTitleComprehensive : If @@IsJobWorkVouchers Then No Else (NOT ##SASimple AND @@InvWithActQty AND $$InPixelMode AND (@@IsNonExciseTrader OR (@@IsExciseTraderOn AND ##SATraderCommercial)))
in this coding “website not printed ”
[#Part: EXPINV Company]
Lines : EXPINV SubTitle, EXPINV Company, EXPINV Address, prn WEb
[Line:prn web]
field : name field, prnweb
Local:Field:name filed:Info:”website : ”
[Field:prnweb]
Set as:$website:Company:##SVCurrentCompany
Color: red
Full Width:Yes
Hello Friends
;; work hard keep smile;;
I just sharing my mistake with you by this mistake I don’t gate value into Print of Invoice.
In this Unit2 if you are facing any issue related to printing of value then pls look your coding in unit1 (UDF related).
Happy Learing 🙂
[#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:VCHserialTITLE,vchedititle
Local:Field:VCHsErialTITLE:Space Left:15
Local:Field:vchedititle:Space Left:15
[Field:VCHserialTITLE]
Use:Name Field
Set as:”tally Serial Number”
Width: 9
Skip:Yes
[Field:vchedititle]
Use:tITLE Field
Set as:”Tally Edition”
Width:9
Skip:Yes
[#Line:ei columntwo]
Add:Field:After:VCH ItemTitle :VCHserialTITLE,vchedititle
Local:Field:VCHserialTITLE:Set as:””
Local:Field:VCHserialTITLE:Space Left:15
Local:Field:VCHserialTITLE:Skip:Yes
Local:Field:vchedititle:Set as:””
Local:Field:vchedititle:Space Left:15
Local:Field:vchedititle:Skip:Yes
/* Fields : VCH ItemTitle
Right Fields: VCH ActualQtyTitle, VCH BilledQtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
Local : Field : VCH ItemTitle : Setas: “”
Local : Field : VCH RateTitle : Setas: “”
Local : Field : VCH RateUnitsTitle: Setas: “”
DescExplosion : NOT $$IsEmpty:$StockItemName AND ##ICFGAddlDesc AND NOT $$IsEmpty:$BasicUserDescription*/
[#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:vchserno,vchedition
Local:Field:vchedition:Space Left:15
[Field:vchserno]
Use:number field
Set as:$serialnumber:ledger:$partyledgername
Storage:vchserno
Format:”NO ZERO, NO COMMA”
Width:9
[Field:vchedition]
Use:NAME FIELD
Set as:$SERAILEDITION:LEDGER:$PARTYLEDGERNAME
Storage:VCHEDITION
Width:9
[System:udf]
vchserno:Number:10015
VCHEDITION:String:10016
/*
[#Part:MST LED EXPLoDE SUNDRY]
Add:Line:After:LED AFFECTSTOCK:LEDSRNUMBER,LEDEDITION
[Line:LEDSRNUMBER]
Field:MEDIUMPROMPT,LEDSRNUMBER
Local:Field:MEDIUMPROMPT:Set as:”TALLY SERIAL NO?”
[Field:LEDSRNUMBER]
Use:NUMBER FIELD
Format:”NO ZERO,NO CAMMA,NO PERCENTAGE”
Storage:SERIAL NUMBER
Color:BLUE
[Line:LEDEDITION]
Field:MIDIUM PROMPT,LEDEDITION
Local:Field:MEDIUMPROMPT:Set as:”Tally Softer Edition?”
[Field:LEDEDITION]
Use: name field
Format:”NO ZERO,NO CAMMA,NO PERCENTAGE”
Storage:SERIAl edition
Color:BLUE
[system:udf]
SERIAL NUMBER:Number:801
SERIAl edition:String:802
vchserno:Number:803
vchedition:String:804
*/
[#Part:expinv company]
Lines : EXPINV SubTitle, EXPINV Company, EXPINV Address,prn website
[Line:prn website]
Field:name field,prnweb
Local:Field:name field:Info:”website”
[Field:prnweb]
Set as:$website:company:##svcurrentcompany
Full Width:Yes
[#Line:expinvcolumn1]
Delete:Field: EXPINV PackagesTitle1
Add:Field:After:expinvdesctitle:expinvtallysrtitle1,expinvedtitle1
Local:Field:expinvtallysrtitle1:Border:thin left
Local:Field:expinvedtitle1:Border:thin left
[Field:expinvtallysrtitle1]
Use: name field
Set as:”tally serial”
Width:11
Skip:Yes
[Field:expinvedtitle1]
Use: name field
Set as:”edition”
Width:9
Skip:Yes
[#Line:expinvinvdetails]
/* Left Fields : EXPINV SLNo, EXPINV Marks, EXPINV Packages, EXPINV Desc
Right Fields: EXPINV PartNo, EXPINV MRPValue, EXPINV VATPerc, EXPINV DueOn, EXPINV ActualQty, EXPINV Qty, EXPINV Rate, EXPINV RatePer, EXPINV Discount, EXPINV Amount
Explode : EXPINV ServiceCategory : ($$IsServiceTaxOn AND @@IsMalaysia AND @@IsSTTaxenabledDate_Vch)AND (NOT $$IsSysNameEqual:NOTApplicable:$STItemServiceCategory) AND $ForServiceTax:Ledger:$PartyLedgerName
Explode : EXPINV AltQty : @@InvWithQty AND NOT $$IsEmpty:$StockItemName AND NOT @@NoAltUnits and (Not @@AltUnitasCol and @@InvWithAltunit)
*/
Add:Field:After:EXPINV Desc:expinvserno,expinvedition
Local:Field:expinvserno:border:thin left
Local:Field:expinvedition:border:thin left
[ Field : EXPINVserNo]
;;Use:number field
Set as:$vchserno
Width:11
Format:”NO ZERO,NO COMMA”
[Field:expinvedition]
;;Use:number field
Set as:$vchedition
Width:9
Format:”NO ZERO,NO COMMA”
;;END
What is the reason for putting so much CODE?
THISH HERE
/*
[#Part:MST LED EXPLoDE SUNDRY]
Add:Line:After:LED AFFECTSTOCK:LEDSRNUMBER,LEDEDITION
[Line:LEDSRNUMBER]
Field:MEDIUMPROMPT,LEDSRNUMBER
Local:Field:MEDIUMPROMPT:Set as:”TALLY SERIAL NO?”
[Field:LEDSRNUMBER]
Use:NUMBER FIELD
Format:”NO ZERO,NO CAMMA,NO PERCENTAGE”
Storage:SERIAL NUMBER
Color:BLUE
[Line:LEDEDITION]
Field:MIDIUM PROMPT,LEDEDITION
Local:Field:MEDIUMPROMPT:Set as:”Tally Softer Edition?”
[Field:LEDEDITION]
Use: name field
Format:”NO ZERO,NO CAMMA,NO PERCENTAGE”
Storage:SERIAl edition
Color:BLUE
[system:udf]
SERIAL NUMBER:Number:801
SERIAl edition:String:802
vchserno:Number:803
vchedition:String:804
*/
Sir not able to get this part
Can u plz help
Please contact me through Zopim/ WhatsApp chat to understand the issue.
Sir, As per the instructions given i have worked out this but field value not fetching from voucher. but fetching from master working.
You can adda storage in your voucher and then you can fetch the same from the voucher also.
alignment of this program in print is not in line attached to line
module 7 unit -2 Invoice customisation Part 2
I think there is a cast study in the same project for the alignment. If it is not coming proper you may need to struggle with it.
Try to increase the reduce with the field width and see its effects.
If you don’t do efforts or try yourself then how can you solve the issue.
You will need to play with the codes
try by changing width , space etc
[Field : my field]
Width : 18
space right : 1
space left : 1
When all your efforts are fail, you can share the screenshot of the output result to my whatsApp number and I will help you to solve it.
but first, you must do efforts on your own.
SIR IT DOES not work
[#Line: EI ColumnOne]
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]
Add : Field : After: VCH ItemTitle : VchSerTitle,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,VchEdition
; Local : Field : VchEdition : Space Left : 15
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 : “NoZero, 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 : “NoZero, No Percentage, No Comma”
Storage :SerialEdition
Color : Blue
[System : UDF]
SerialNumber : Number : 801
SerialEdition: String : 802
Vchedition:String:803
VchSerNo:Number:804
[#Part: EXPINV Company]
Lines : EXPINV SubTitle, EXPINV Company, EXPINV Address, Prn Website
[Line : Prn Website]
Field : Name Field, prnWEb
Local : Field : Name Field : Info:”Website:”
[Field : PrnWEB]
Set as : $Website:Company:##SVCurrentCompany
Full Width : Yes
[#Line: EXPINV Column1]
Delete : Field : EXPINV Packages Title1
Add : Field : After : EXPINV DescTitle : EXPINV TallySrTitle1, EXPINVEdTitle1
Local : Field : EXPINV TallySrTitle1 : Border : Thin Left
Local : Field : EXPINVEdTitle1 : Border : Thin Left
;Local : Field : EXPINV DescTitle : Border : Thin Right
;Local : Field : EXPINV DescTitle : Style : Small
[Field : EXPINV TallySrTitle 1]
Use : Name Field
Set as : “Tally Serial No.”
Width : 11
Skip : Yes
[Field : EXPINVEdTitle1]
Use : Name Field
Set as : “Edition”
Width : 9
Skip : Yes
[#Line: EXPINV InvDetails]
Add : Field : After : EXPINV Desc : EXPINVSerNo,EXPINVEdition
Local : Field : EXPINVSerNo : Border : Thin Left
Local : Field : EXPINVEdition : Border : Thin Left
[Field : EXPINVSerNo]
Use : Number Field
Set as : $VchSerNo
width : 11
Format : “No Zero, No Comma”
[Field : EXPINVEdition]
; Use : Number Field
Set as : $VchEdition
Width : 9
Format : “No Zero, No Comma”
sir
I completed the codes .but when i am trying in Tally it showing error.
Note: – Error code T004:-Duplicate description Name Line.EXPINV Column1 in user tdl
Please verify this tdl sir
[#Part:EXPINV Company]
Line:EXPINV SubTitle,EXPINV Company,EXPINV Address,Prn Website
[Line:Prn Website]
Field:Name Field,PrnWeb
Local:Field:Name field:Info:”Website:”
[Field:PrnWeb]
Set as:$Website:Company.##SVCurrentCompany
Full Width:Yes
[Line:EXPINV Column1]
Delete:Field:EXPINV Packages Title1
Add:Field:After:EXPINV Desc Title:EXPINV TallySrTitle,EXPINVEdTitle1
Local:Field:EXPINV TallySr Title1:Border:Thin Right
Local:Field:EXPINVEdTitle1 :Border:Thin Left
/*
Local:Field:EXPINV DescTitle:Border:Thin Left
Local:Field:EXPINV DescTitle:Style:Small
Local:Field:EXPINV DescTitle:Space Right:20
Local:Field:EXPINV SLNO Title:Info:$$LocaleString:”SR.”
Local:Field:EXPINV DescTitle:Info:$$LocaleString:”ITEM DESCRIPTION”
*/
[Field:EXPINV TallySrTitle1]
Use:Name Field
Set as:”Tally Serial No.”
Width:11
Skip:Yes
[Field:EXPINVEdTitle1]
Use:Name Field
Set as:”Edition”
Width:9
Skip:Yes
[#Line:EXPINV InvDetails]
/*
Left Fields:EXPINV SLNO,EXPINV Marks,EXPINV Packagaes,EXPINV Desc
Right Fields:EXPINV PartNo,EXPNV MRP Value,EXPINV VATPerc,EXPINV DueOn,EXPINV ActualQty,EXPINVQty,EXPINV Rate,EXPINV RatePer,EXPINV Discount,EXPINV Amount
*/
Add:Field:After:EXPINV Desc:EXPINVSerNo,EXPINVEdition
Local:Field:EXPINVSerNo:Border:Thin Left
Local:Field:EXPINVEdition:Border:Thin Left
[Field:EXPINVSerNo]
Use:Number Field
Set as:$VchSerNo
Width:11
Format:”NO Zero,No Comma”
[Field:EXPINVEdition]
;;use:Number Field
Set as:$VchEdtion
Width:9
Format:”No Zero,No Comma”
;; End of the coding
Sir,
I am using tally prime developer
most of the time file or folder mentioned to open in ide does not exist.
Like for this chapter there is no folder named print, or file invoice.500
Please let me know how to check what was old name and what is new name
as of now i have to search filed or part mentioned in your code and then find particular , its taking too much time.
Thank you.
You need to go through chapter from starting one by one.
If you miss the chapters in between then you will get confused.
In the default defintions modules I have put a video and explained the updated file structure and Folder name
In Prime only File name and foder names are changed and they are explained in the Default definitions Modules.
Also, I will suggest you please strat from chatper 1st without missing anything so that you can understand it.
You can also drop a message in Zopim chat or to my whatsApp number if you are unable to understand a concept.
[#Part: EXPINV Company]
Lines:EXPINV SubTitle,EXPINV Company,EXPINV Address, Prn Website
[Line:Prn WEBSITE]
Field:Name Field,prnWEB
Local:Field:Name Field:Info:”Website”
[Field:prnWEB]
Set as:$Website:Company:##SVCurrentCompany
Full Width:Yes
[#Line: EXPINV Column1]
Delete:Field:EXPINV PackagesTitle1
Add:Field:after:EXPINV DescTitle:EXPINV TallySrTitle1,EXPINVEdTitle1
Local:Field:EXPINV TallySrTitle1:Border:Thin left
Local:Field:EXPINVEDTitle1:Border:Thin left
[Field:EXPINV TallySrTitle1]
Use:Name Field
Set as:”Tally Serial No.”
Width:11
Skip:Yes
[Field:EXPINVEDTitle1]
Use:Name Field
Set as:”Edition”
Width:9
Skip:Yes
Add:Field:After:EXPINV Desc:EXPINVSerNo,EXPINVEdition
Local:Field:EXPINVSerNo:Border:Thin Left
Local:Field:EXPINVEdition:Border:Thin Left
[Field:EXPINVSerNo]
Use:number Field
Set as:$VchSerNo
Width:11
Format:”No Zero,No Comma”
[Field:EXPINVEdition]
;;Use:number Field
Set as:$VchEdition
Width:9
Format:”NO ZERO,NO COMMA”
Sir, I am not be able to change report of invoice
Please lets do thing step by step.
First you need to write codes only for the ledger master and then let me know if it is working or not.
it should be only in one file put your code file in the Dropbox and then let me know.
Hello Sir,
Could help me please how do I put a company in center in sales invoice
I trust your query has been resolved as explained in WhatsApp