Free Code : Inclusive Rate In Invoice Print

Dear Sir ,
Ive been getting this following error
Error T0009 Line : TAXINCLU is a duplicate description already defined inD:\......
Please help with this
Also would like to know if the code would work in POS format.
If not could you please help me with that
Thank You

 

I think u r using two TDL of the same line TAXINCLU....

PLZ REMOVE THE FIRST TDL....

 

Did that its working.
But code is not working for POS invoicing
Please Help!

 

Thank U sir ..
it worked well

 

Thank u Sir .
It worked well
There is a minor error. Down beside "Total" the total quantity is showing in rate column.
suppose if quantity is "3" its showing in rate column instead of quantity column down in total line
please solve this minor error.

rest all well worked.

 

FIXED!!!

 

Thank u Sir.
superb it worked well n thank you for making respective changes..

could u provide me with some other few other useful tdls.
tdls regarding sales invoice customization , change format , or any other useful tdl.
Any tdl whichj could be useful in business
thank u

 

GREAT JOB SIR.....

 

Sir, its not showing in Credit note as well in Proforma Invoice as well, Delivery note, can you modify this tdl which can work in everywhere

 

Sir can the code be modified and so that Inclusive of Tax Rate is calculated automatically and printed instead of giving a command in rate inclusive of tax column. So that if we don't want to use inclusive of tax function but the rate will be automatically be printed in our invoice upon adding GST ratee in it by itself.

 

Hello Sir,
How can I use this code for POS Invoice?

 

multi unit total possible in invoice print

 

KYA YE POSSIBLE HAI

 

Qty Total show in rate column

 

[#Line : EI Column One]
Add : Right Field: At Beginning:EBHSNCode
Add:Right Field: After:EBHSNCode:EBGSTPerT

[Field:EBGSTPerT]
Use:Name Field
Set as: "GST %"
Skip: Yes
Border:Thick Left Right
Width:10
Align: Center

[Field:EBHSNCode]
Use:Name Field
Set as: "HSN Code"
Skip: Yes
Border:Thick Left Right
Width:10
Align: Center

[#Line : EI Inv Info]
Add: Right Field:At Beginning:EBHSNCodeNo
Add: Right Field: After: EBHSNCodeNo: EBGSTPer

[Field:EBHSNCodeNo]
Use: Name Field
Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode
Width:10
Align: Center
Set Always: Yes
Skip: Yes

[Field:EBGSTPer]
Use: Number Field
Set as:$(Stockitem,$stockitem).GSTDetails[First].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate
Format: Percentage
Width:10
Align: Center
Set Always: Yes
Skip: Yes

[#Part: VTYP BehaviourMain]
Option : EBY Vch Type Confirmation: @@IsEBYInv

[!Part : EBY Vch Type Confirmation]
Add : Line : After : VTYP PrintSave :EBY Confirm Vch Type
[Line : EBY Confirm Vch Type]
Field : Long Prompt, Logical Field
Local : Field : Long Prompt : Set as : "Print Bulldozer Invoice Format?"
Local : Field : Long Prompt : Width : @@LongWidth
Local : Field : Logical Field : Storage : EBYCustomizedFormat

[System : Formula]
IsEBYInv : $$IsSales:$Parent
IsEBYCustomFormat : $EBYCustomizedFormat:VoucherType:$VoucherTypeName

[System : UDF]
EBYCustomizedFormat : Logical : 0001

[#Form : Sales Color]
Option: EBY Customized Invoice: @@IsEBYCustomFormat

[!Form:EBY Customized Invoice]
Delete : Print
Add : Print : EBY Custom Invoice

[Style:O9]
Font:Calibri (Body)
Height:9

[Style:O9B]
Use:O9
Bold: Yes

[Style:O11B]
Font: Adobe Garamond Pro Bold
Height:15
Bold: Yes

[Report :EBY Custom Invoice]
Use : Printed Invoice
Delete: Form : Printed Invoice
Form : EBY Custom Invoice

[Form:EBY Custom Invoice]
Space Top : 0.25 inch
Space Right : 0.25 inch
Space Left : 0.50 inch
Space Bottom: 0.25 inch

Part: EBY Opening Page Break, EBY Invoice Body
Bottom Part:EBY Bottom Part

Page Break : EBY Closing Page Break, EBY Opening Page Break

[Part:EBY Closing Page Break]
Lines :EBY Closing Page Break Line

[Line: EBY Closing Page Break Line]
Fields : Simple Field
Local : Field: Simple Field : Set As : "Continued..."
Local : Field: Simple Field : FullWidth : Yes
Local : Field: Simple Field : Align : Right
Border : Full Thin Top

[Part:EBY Opening Page Break]
Part: EBY Invoice Title, EBY Invoice Company Details, EBY Invoice Customer Details, EBY Body Coloumns Title
Vertical: Yes

[Part: EBY Invoice Title]
Line: EBY Invoice Title
Border: Thick Cover

[Line:EBY Invoice Title]
Field: Simple Field
Right Field:Name Field
Local: Field: Simple Field: Set as: "TAX INVOICE"
Local: Field: Simple Field: Style: O9B
Local: Field: Simple Field: Space Left: 45
Local: Field: Simple Field: Full Width: Yes
Local: Field: Name Field: Set as:If @@GetCopyNum = 1 Then "ORIGINAL FOR RECIPIENT" Else +
If @@GetCopyNum = 2 Then $$LocaleString:"DUPLICATE FOR SUPPLIER" Else +
If @@GetCopyNum = 3 Then $$LocaleString:"TRIPLICATE FOR TRANSPOTER" Else +
If @@GetCopyNum = 4 Then $$LocaleString:"EXTRA COPY" Else $$LocaleString:"EXTRA COPY"

Space Top: 0.25
Space Bottom: 0.25

[Part:EBY Invoice Company Details]
Line: EBY Company Name, EBY Company Address
Border: Thick Cover

[Line: EBY Company Name]
Field: Name Field
Local: Field: Name Field: Set as: @@CmpMailName
Local: Field: Name Field: Style:O11B
Local: Field: Name Field: Full Width: Yes
Space Top: 0.25

[Line:EBY Company Address]
Field: Name Field
Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address
Local: Field: Name Field: Width:60% Page
Local: Field: Name Field: Style:O9
Local: Field: Name Field: Line:0

[Part:EBY Invoice Customer Details]
Left Part: EBY Customer Details Left
Right Part: EBY Invoice Details
Border: Thick Cover

[Part:EBY Customer Details Left]
Line: EBY Customer Side Title,EBY Customer Name, EBY Customer Address,EBY Customer State Name, EBY Customer GST No, EBY Customer Contact
Width:50% Page

[Line:EBY Customer Side Title]
Field: Name Field
Local: Field: Name Field: Set as: "Details for Buyer (Billed & Shipped To )"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style:O9B
Space Top: 0.50
[Line:EBY Customer Name]
Field: Name Field
Local: Field: Name Field: Set as: $PartyLedgerName;@@BuyerName
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Stylep:O9B
Space Top:0.25

[Line:EBY Customer Address]
Field: Name Field
Local: Field: Name Field: Set as: $$FullList:BasicBuyerAddress:$BasicBuyerAddress
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Line: 0
Local: Field: Name Field: Style:O9

[Line:EBY Customer State Name]
Field: Simple Field
Local: Field: Simple Field: Set as: "State Name"+" : "+ $StateName +" "+ "Code :"+" "+ $$getgststatecodeStateName
Local: Field: Simple Field: Local Formula:StateName : If NOT ($$IsEmpty:$StateName OR $$IsSysName:NotApplicable:$StateName) Then $StateName Else $LedStateName:LedgerPartyName
Local: Field: Simple Field: Full Width: Yes
Local: Field: Simple Field: Style: O9

[Line:EBY Customer GST No]
Field: Simple Field
Local: Field: Simple Field: Set as: "GSTIN No : " +" "+ $PartyGSTIN +" "+" PAN No :"+" "+$IncomeTaxNumber:Ledger:$BasicBuyerName
Local: Field: Simple Field: Full Width: Yes
Local: Field: Simple Field: Style: O9

[Line:EBY Customer Contact]
Field: Simple Field
Local: Field: Simple Field: Set as: "Contact Details :"+" "+ @@VchContactNo
Local: Field: Simple Field: Style: O9
Local: Field: Simple Field: Full Width: Yes

[Part:EBY Invoice Details]
Line:EBY Invoice Number Date, EBY Delivery Challanno Date, EBY eWayBillNo, EBY Disptach Doc, EBY Destination, EBY LR No, EBY Order No, EBY Credit Days
Border: Thick Left
Common Border: Yes

[Line:EBY Invoice Number Date]
Field: Simple Prompt, Simple Field, Medium Prompt, Name Field
Local: Field: Simple Prompt: Set as: "Invoice No :"
Local: Field: Simple Prompt: Style: O9
Local: Field: Simple Prompt: Width:10
Local: Field: Simple Field: Set as: $VoucherNumber
Local: Field: Simple Field: Style:O9B
Local: Field: Simple Field: Width:12
Local: Field: Medium Prompt: Set as: "Date :"
Local: Field: Medium Prompt: Width:10
Local: Field: Medium Prompt: Style: O9
Local: Field: Medium Prompt: Border: Thick Left
Local: Field: Name Field: Set as: $Date
Local: Field: Name Field: Style:O9B
Local: Field: Name Field: Width:12
Space Top:0.25
Space Bottom: 0.25
Border: Thick Bottom

[Line:EBY Delivery Challanno Date]
Use:EBY Invoice Number Date
Local: Field: Simple Prompt: Set as: "Challan No"
Local: Field: Simple Prompt: Style:O9
Local: Field: Simple Field: Set as: $BasicShipDeliveryNote
Local: Field: Simple Field: Style: O9B
Local: Field: Medium Prompt: Set as: "Date"
Local: Field: Medium Prompt: Style: O9
Local: Field: Name Field: Set as: $BasicShippingDate

[Line:EBY eWayBillNo]
Use:EBY Invoice Number Date
Local: Field: Simple Prompt: Set as: "e-Way Bill No."

Local: Field: Simple Field: Set as: If @@IsGSTewayApplicable Then @@GSTPrinteWayBillNumber Else +
If $$IsEmpty:$VATTransBillNo Then $UDFVATWayBillNo Else $VATTransBillNo

Local: Field: Medium Prompt: Set as: "Date"

Local: Field: Name Field: Set as: $Date

[Line:EBY Disptach Doc]
Use:EBY Invoice Number Date
Local: Field: Simple Prompt: Set as: "Dispatch Doc No"
Local: Field: Simple Field: Set as: $BasicShipDocumentNo
Local: Field: Medium Prompt: Set as: "Destination"
Local: Field: Name Field: Set as: $BasicFinalDestination;$BasicShippedBy

[Line:EBY Destination]
Use:EBY Invoice Number Date
Local: Field: Simple Prompt: Set as: "Through"
Local: Field: Simple Field: Set as: $BasicShippedBy
Local: Field: Medium Prompt: Set as: "Vehical No"
Local: Field: Name Field: Set as: $BasicShipVesselNo

[Line:EBY LR No]
Use:EBY Invoice Number Date
Local: Field: Simple Prompt: Set as: "LR No"
Local: Field: Simple Field: Set as: $BillofLadingNo
Local: Field: Medium Prompt: Set as: "Date"
Local: Field: Name Field: Set as: $BillofLadingDate

[Line:EBY Order No]
Use:EBY Invoice Number Date
Local: Field: Simple Prompt: Set as: "Order No"
Local: Field: Simple Field: Set as: $BasicPurchaseOrderNo
Local: Field: Medium Prompt: Set as: "Date"
Local: Field: Name Field: Set as: $BasicOrderDate

[Line:EBY Credit Days]
Field: Simple Prompt, Simple Field
Local: Field: Simple Prompt: Set as: "Credit Days"
Local: Field: Simple Prompt: Width: 10
Local: Field: Simple Field: Set as:$BasicDueDateOfPymt
Local: Field: Simple Field: Width: 10
Local: Field: Simple Prompt: Style:O9B
Local: Field: Simple Field: Style:O9B

[Part:EBY Body Coloumns Title]
Line: EBY Coloumns Title1, EBY Coloumns Title2
Border: Thick Cover
Common Border: Yes

[Line: EBY Coloumns Title1]
Use: EBY Invoice Body
Local: Field: Default: Type: String
Local: Field: Default: Style: O9B
Local: Field: Default: Align: Center

Local: Field: EBY SrNo: Set as: "Sr"
Local: Field: EBY Description:Set as:" Item "
Local: Field: EBY HSN Code: Set as:"HSN"
Local: Field: EBY GST Per: Set as:"GST"
Local: Field: EBY Qty: Set as:"Qty"
Local: Field: EBY Rate: Set as:"Rate"
Local: Field: EBY SGST Per: Set as:"SGST"
Local: Field: EBY SGST Amt: Set as:"SGST"
Local: Field: EBY CGST per: Set as:"CGST"
Local: Field: EBY CGST Amt: Set as:"CGST"
Local: Field: EBY IGST Per: Set as:"ISGT"
Local: Field: EBY IGST Amt: Set as:"IGST"
Local: Field: EBY GrossAmt: Set as:"Gross"

[Line:EBY Coloumns Title2]
Use: EBY Invoice Body
Local: Field: Default: Type: String
Local: Field: Default: Style: O9B
Local: Field: Default: Align: Center

Local: Field: EBY SrNo: Set as: "No"
Local: Field: EBY Description:Set as:"Description"
Local: Field: EBY HSN Code: Set as:"Code"
Local: Field: EBY GST Per: Set as:"%"
Local: Field: EBY Qty: Set as:""
Local: Field: EBY Rate: Set as:""
Local: Field: EBY SGST Per: Set as:"%"
Local: Field: EBY SGST Amt: Set as:"Amt"
Local: Field: EBY CGST per: Set as:"%"
Local: Field: EBY CGST Amt: Set as:"Amt"
Local: Field: EBY IGST Per: Set as:"%"
Local: Field: EBY IGST Amt: Set as:"Amt"
Local: Field: EBY GrossAmt: Set as:"Amount"
Border: Thick Bottom

[Part:EBY Invoice Body]
Line: EBY Invoice Body
Repeat:EBY Invoice Body: Inventory Entries
Bottom Line: EBY Coloumn Total
Border: Thick Cover
Scroll: Vertical
Float: No
Common Border: Yes

[Line: EBY Invoice Body]
Field: EBY SrNo, EBY Description
Right Field: EBY HSN Code, EBY GST Per, EBY Qty, +
EBY Rate, EBY SGST Per, EBY SGST Amt, +
EBY CGST per, EBY CGST Amt,+
EBY IGST Per, EBY IGST Amt, EBY GrossAmt

Local: Field: EBY SrNo: Width:2
Local: Field: EBY HSN Code: Width:6
Local: Field: EBY GST Per: Width: 3
Local: Field: EBY Qty: Width:7
Local: Field: EBY Rate: Width: 7
Local: Field: EBY SGST Per: Width:3
Local: Field: EBY SGST Amt: Width: 7
Local: Field: EBY CGST per: Width:3
Local: Field: EBY CGST Amt: Width:7
Local: Field: EBY IGST Per: Width:3
Local: Field: EBY IGST Amt: Width:7
Local: Field: EBY GrossAmt: Width: 7

Local: Field: EBY SrNo: Border: Thick Right
Local: Field: EBY HSN Code: Border: Thick Left
Local: Field: EBY GST Per: Border: Thick Left
Local: Field: EBY Qty: Border: Thick Left
Local: Field: EBY Rate: Border: Thick Left
Local: Field: EBY SGST Per: Border: Thick Left
Local: Field: EBY SGST Amt: Border: Thick Left
Local: Field: EBY CGST per: Border: Thick Left
Local: Field: EBY CGST Amt: Border: Thick Left
Local: Field: EBY IGST Per: Border: Thick Left
Local: Field: EBY IGST Amt: Border: Thick Left
Local: Field: EBY GrossAmt: Border: Thick Left
Space Top: 0.15

[Field:EBY SrNo]
Use: Simple Field
Set as: $$Line
Style: O9

[Field:EBY Description]
Use: Simple Field
Style: O9
Set as: if NOT $$IsSysName:$StockItemName then @@InvItemName else ""
Full Width: Yes
Line: 0

[Field:EBY HSN Code]
Use: Simple Field
Set as:$GSTItemHSNCodeEx
Style: O9

[Field:EBY GST Per]
Use: Simple Field
Set as:If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx
Style:O9

[Field:EBY Qty]
Use: Simple Field
Set as: $BilledQty
Style:O9

[Field:EBY Rate]
Use: Simple Field
Set as: $Rate
Style:O9

[Field:EBY SGST Per]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx /2
Style: O9
Invisible: If @@IGST > 0 then yes else no

[Field:EBY SGST Amt]
Use:Amount Field
Set as:$Amount * #EBYSGSTPer / 100
Style: O9
Invisible: If @@IGST > 0 then yes else no

[Field:EBY CGST per]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx /2
Style: O9
Invisible: If @@IGST > 0 then yes else no

[Field:EBY CGST Amt]
Use: Amount Field
Set as:$Amount * #EBYCGSTper / 100
Style: O9
Invisible: If @@IGST > 0 then yes else no

[Field:EBY IGST Per]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx
Style: O9
Invisible: If @@SGST > 0 then yes else no

[Field:EBY IGST Amt]
Use: Amount Field
Set as:$Amount * #EBYIGSTPer / 100
Style: O9
Invisible: If @@SGST > 0 then yes else no

[Field:EBY GrossAmt]
Use: Amount Field
Set as: $Amount
Style:O9

[Line:EBY Coloumn Total]
Use:EBY Invoice Body
Border: Thick Top Bottom

Local: Field: EBY SrNo: Set as: ""
Local: Field: EBY Description:Set as:"Total"
Local: Field: EBY HSN Code: Set as:""
Local: Field: EBY GST Per: Set as:""
Local: Field: EBY Qty: Set as:""
Local: Field: EBY Rate: Set as:""
Local: Field: EBY SGST Per: Set as:""
Local: Field: EBY SGST Per: Type: String
Local: Field: EBY SGST Amt: Set as:$$FilterAmtTotal:LedgerEntries:SGST1:$Amount
Local: Field: EBY CGST per: Set as:""
Local: Field: EBY CGST Per: Type: String
Local: Field: EBY CGST Amt: Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
Local: Field: EBY IGST Per: Set as:""
Local: Field: EBY IGST Per: Type: String
Local: Field: EBY IGST Amt: Set as:$$FilterAmtTotal:LedgerEntries:IGST1:$Amount
Local: Field: EBY GrossAmt: Set as:$$CollAmtTotal:InventoryEntries:$Amount

[System: Formula]
SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount
SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST"

CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"

IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount
IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST"

Round :$$FilterAmtTotal:LedgerEntries:Round1:$Amount
Round1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"Round"

[Part:EBY Bottom Part]
Part:EBY Bottom Part 1,VCH GST AnalysisDetails, EBY Bottom Part 2
Vertical: Yes

[Part:EBY Bottom Part 1]
Right Part: EBY Bottom Part 1 Right
Left Part: EBY Bottom Part 1 Left
Border: Thick Cover

[Part:EBY Bottom Part 1 Left]
Line: EBY Amount in Word

[Line: EBY Amount in Word]
Field: Medium Prompt, Name Field
Local: Field: Medium Prompt: Set as: "Amount In Word"
Local: Field: Medium Prompt: Style: O9
Local: Field: Name Field: Set as: $$InWords:$Amount
Local: Field: Name Field: Style: O9B
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Line:0
Space Top: 0.5

[Part: EBY Bottom Part 1 Right]
Line: EBY Invoice Ledger Entries
Repeat: EBY Invoice Ledger Entries:LedgerEntries
Bottom Line: EBY Invoice Amount
Common Border: Yes
Border: Thick Left

[Line: EBY Invoice Ledger Entries]
Field: Name Field, Amount Field
Local: Field: Name Field: Set as:$LedgerName
Local: Field: Name Field: Style: O9
Local: Field: Name Field: Width:22.6
Local: Field: Name Field: Align: Right
Local: Field: Amount Field: Set as: $Amount
Local: Field: Amount Field: Style: O9B
Local: Field: Amount Field: Border: Thick Left
Local: Field: Amount Field: Width:7
Remove if: $LedgerName contains $PartyLedgerName
Space Top:0.25

[Line:EBY Invoice Amount]
Field: Name Field, Amount Field
Local:Field: Name Field: Set as: "INVOICE TOTAL"
Local:Field: Name Field: Style: Large Bold
Local:Field: Name Field: Width:22.6
Local:Field: Name Field: Align: Right
Local:Field: Amount Field: Set as: $Amount
Local:Field: Amount Field: Style: Large Bold
Local:Field: Amount Field: Width: 7
Border: Thick Top
Space Top: 0.5
Space Bottom: 0.5

[Part:EBY Bottom Part 2]
Right Part: EBY Signature
Left Part: EBY Terms and Conditions
Border: Thick Box

[Part:EBY Terms and Conditions]
Line: EBY0,EBY1, EBY2, EBY3,

[Line: EBY0]
Field: Simple Field
Local: Field: Simple Field: Set as: "Terms and Conditions"
Local: Field: Simple Field: Style: O9B
Space Top: 0.25

[Line: EBY1]
Field: Simple Field
Local: Field:Simple Field: Set as:"1. Goods Once Sold will not be taken back."
Local: Field: Simple Field: Full Width: Yes
Local: Field: Simple Field: Line:0
Local: Field: Simple Field: Style: Tiny

[Line: EBY2]
Use: EBY1
Local: Field: Simple Field: Set as: "2. If Cheque Bounced, Rs 500/- will be taken as charges"

[Line: EBY3]
Use: EBY1
Local: Field: Simple Field: Set as: "3. Rs 100/- per day will charged for delayed payment after due date."

[Part:EBY Signature]
Line: EBY Signature,

[Line:EBY Signature]
Right Field: Simple Field
Local: Field: Simple Field: Set as: "For" +" "+ @@CmpMailName
Space Top:3





Can anyone help me to print seal & sign in this invoice format

 

SUPERB....... One ERR.. EBY4 not declared... it remove... and its working super.....

 

[Part:EBY Terms and Conditions]
Line: EBY0,EBY1, EBY2, EBY3, EBY4

 

Sir

The TDL is working fine but want to print price inclusive GST in this format. EBY4 is added for some instructions

 

I'm getting error t0001. I punched the file name and address correctly. Please help