Tally Expert Tips

Payment QR Code On Invoice

2022-01-10T20:17:00.005+05:30

Payment QR Code On Invoice

As we know most of the customers are now making payments using UPI Payments apps like Phonepe, Google Pay, Paytm, Amazon Pay.

Using this TDL you can generate the QR code in Tally Automatically and print it on your Invoice so that your customer does not have to be at your place to scan the code, or you do not have to send a mobile number to get the money or share the QR code.

Customers can just scan the QR code Printed on the Invoice and send you the money.

Just attached the TDL file to your tally and you will get option like below

Set you UPI id/Bank Account Details or Mobile Number and that it.

Now Create a Sales Invoice and Print it. And you should be able to see the QR code as below.

That is now you can Print/Mail this invoice to customer and they can scan the QR code and make the payment.

Cost only 500/- Only

Sr No. on Sales Screen (Free TDL)

2022-01-08T15:02:00.001+05:30

Serial Number on Sales Screen for Large Invoices

Most of the dealers and consumer products dealers have large product/SKU line and the invoices they prepare has a lot of SKU/Stock item in them.

To manage how many products/SKU are sold in a single invoice before printing it Serial Numbers are required on sales and purchase screen. This tdl will provide you with the same function in tally.

To attach the code in your tally just copy-paste the below code into Notepad and save it. And just attached the same file to your tally and you should be able to get the serial number as below.

[#Line : EI ColumnOne]

Option : Global EI ColumnOne1

[!Line : Global EI ColumnOne1]

add : fields: before:VCH ItemTitle : VCH SlNO

[field : vch slno]

use : name field

setas : "SL"

Align : Centre

width : 5

style : Small bold

Skip : yes

[#Line : EI InvInfo]

Option : Global EI InvInfo1

[#Line : CI InvInfo]

Option : Global EI InvInfo1

[!Line : Global EI InvInfo1]

add : fields:before: VCH StockItem : vchslno1

[field : vchslno1]

Set as : $$Line

Align : Centre

Border : Thin Left Right

Width : 5

Skip : Yes

Free Tally Customization (TDL) HSN Code and GST Percentage During Voucher Entry updated

2018-04-26T16:09:00.000+05:30

View HSN code and GST Percentage of Stock Item During Voucher Entry.

Lot of need know during voucher entry weather the HSN code and GST percentage of Stock Item is entered/updated properly or not. Below code will show you the HSN code and GST percentage of select Stock Item during Voucher entry.

To Attach the code to you Tally Software please follow the instructions in the link below.

http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

You will need to copy and paste the below code and copy and paste it into your txt/tdl file using notepad/word pad.

[#Line : EI Column One]

Add : Right Field: At Beginning:OTSHSNCode

Add:Right Field: After:OTSHSNCode:OTSGSTPerT

[Field:OTSGSTPerT]

Use:Name Field

Set as: "GST %"

Skip: Yes

Border:Thick Left Right

Width:10

Align: Center

[Field:OTSHSNCode]

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:OTSHSNCodeNo

Add: Right Field: After: OTSHSNCodeNo: OTSGSTPer

[Field:OTSHSNCodeNo]

Use: Name Field

Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode

Width:10

Align: Center

Set Always: Yes

Skip: Yes

[Field:OTSGSTPer]

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

GST Invoice Customization with eWay Bill No. in A4 size ( Free Tally TDL Code)

2018-03-28T11:29:00.000+05:30

As we all know that new Financial year is going to being lot of us might be thinking of changing the impression on customer's by changing the invoice format. And as eWay Bill is going to get implemented from 1st of April 2018. here is the new invoice format with eWay Bill no. printed on it.

If you liked the format please find the below TDL code of the same. NOTE :- Please take the backup before attaching any code to your live data. This code is only for educational purpose we will not be responsible for any data lost due to improper following of instructions.

To know how to attache any tdl to Tally please follow the instruction in below Link.
How to Attach any Tally.ERP9 Customization to Tally.ERP9 Software so that you can easily attach this code to your Tally.ERP9 software.

;;;;;;;;;;;;;;; Font Used in Invoice Customization;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

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

[Style:O9B]
Use:O9
Bold: Yes

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

;;;;;;;;;;;;;;;;;;;;;;;;;;;Invoice Customization Code Starts;;;;;;;;;;;;;;;;;;;;;;
[#Part: VTYP BehaviourMain]
Option : OTS Vch Type Confirmation: @@IsOTSInv

[!Part : OTS Vch Type Confirmation]
Add : Line : After : VTYP PrintSave :OTS Confirm Vch Type

[Line : OTS Confirm Vch Type]
Field : Long Prompt, Logical Field
Local : Field : Long Prompt : Set as : "Print Customized Format?"
Local : Field : Long Prompt : Width : @@LongWidth
Local : Field : Logical Field : Storage : OTSCustomizedFormat

[System : Formula]
IsOTSInv : $$IsSales:$Parent
IsOTSCustomFormat : $OTSCustomizedFormat:VoucherType:$VoucherTypeName

[System : UDF]
OTSCustomizedFormat : Logical : 0001

[#Form : Sales Color]
Option: OTS Customized Invoice: @@IsOTSCustomFormat

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

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

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

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

Page Break : OTS Closing Page Break, OTS Opening Page Break

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

[Line: OTS 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

;;;;;;;;;;;;;;;;;;;;;;;OTS Opening Page Break;;;;;;;;;;;;;;;;;;;;;;;;;;;

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

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

[Line:OTS 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:OTS Invoice Company Details]
Line: OTS Company Name, OTS Company Address
Border: Thick Cover

[Line: OTS 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:OTS Company Address]
Field: Name Field
Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address
Local: Field: Name Field: Width:50% Page
Local: Field: Name Field: Style:O9
Local: Field: Name Field: Line:0

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

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

[Line:OTS 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:OTS 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:OTS 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:OTS Customer State Name]
Field: Simple Field
Local: Field: Simple Field: Set as: "State Name"+" : "+ $StateName +" "+ "Code :"+" "+ $$getgststatecode:@StateName
Local: Field: Simple Field: Local Formula:StateName : If NOT ($$IsEmpty:$StateName OR $$IsSysName:NotApplicable:$StateName) Then $StateName Else $LedStateName:Ledger:@PartyName
Local: Field: Simple Field: Full Width: Yes
Local: Field: Simple Field: Style: O9

[Line:OTS 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:OTS 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:OTS Invoice Details]
Line:OTS Invoice Number Date, OTS Delivery Challanno Date, OTS eWayBillNo, OTS Disptach Doc, OTS Destination, OTS LR No, OTS Order No, OTS Credit Days
Border: Thick Left
Common Border: Yes

[Line:OTS 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:OTS Delivery Challanno Date]
Use:OTS 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:OTS eWayBillNo]
Use:OTS 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:OTS Disptach Doc]
Use:OTS 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:OTS Destination]
Use:OTS 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:OTS LR No]
Use:OTS 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:OTS Order No]
Use:OTS 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:OTS 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

;;;;;;;;;;;;;;;;;;;;;;;INVOICE BODY STARTS;;;;;;;;;;;;;;;;;;;;;;;;;;
[Part:OTS Body Coloumns Title]
Line: OTS Coloumns Title1, OTS Coloumns Title2
Border: Thick Cover
Common Border: Yes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[Field:OTS 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:OTS SGST Amt]
Use:Amount Field
Set as:$Amount * #OTSSGSTPer / 100
Style: O9
Invisible: If @@IGST > 0 then yes else no

[Field:OTS 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:OTS CGST Amt]
Use: Amount Field
Set as:$Amount * #OTSCGSTper / 100
Style: O9
Invisible: If @@IGST > 0 then yes else no

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

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

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

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

Local: Field: OTS SrNo: Set as: ""
Local: Field: OTS Description:Set as:"Total"
Local: Field: OTS HSN Code: Set as:""
Local: Field: OTS GST Per: Set as:""
Local: Field: OTS Qty: Set as:""
Local: Field: OTS Rate: Set as:""
Local: Field: OTS SGST Per: Set as:""
Local: Field: OTS SGST Per: Type: String
Local: Field: OTS SGST Amt: Set as:$$FilterAmtTotal:LedgerEntries:SGST1:$Amount
Local: Field: OTS CGST per: Set as:""
Local: Field: OTS CGST Per: Type: String
Local: Field: OTS CGST Amt: Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
Local: Field: OTS IGST Per: Set as:""
Local: Field: OTS IGST Per: Type: String
Local: Field: OTS IGST Amt: Set as:$$FilterAmtTotal:LedgerEntries:IGST1:$Amount
Local: Field: OTS 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"

;;;;;;;;;;;;;;;;OTS Bottom Part;;;;;;;;;;;;;;;;;;;;;;;

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

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

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

[Line: OTS 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: OTS Bottom Part 1 Right]
Line: OTS Invoice Ledger Entries
Repeat: OTS Invoice Ledger Entries:LedgerEntries
Bottom Line: OTS Invoice Amount
Common Border: Yes
Border: Thick Left

[Line: OTS 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:OTS 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:OTS Bottom Part 2]
Right Part: OTS Signature
Left Part: OTS Terms and Conditions
Border: Thick Box

[Part:OTS Terms and Conditions]
Line: OTS0,OTS1, OTS2, OTS3

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

[Line: OTS1]
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: OTS2]
Use: OTS1
Local: Field: Simple Field: Set as: "2. If Cheque Bounced, Rs 500/- will be taken as charges"

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

[Part:OTS Signature]
Line: OTS Signature,

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

Note:- This code is written for Print invoice in A4 portrait mode. You will need to do the required settings in your printer for better view. There might be some case were alignment might not come proper this is because of printer and you will need to write code for alignment.

Tally Password Recovery Free TDL File ( Customization)

2018-03-17T13:04:00.001+05:30

Tally.ERP9 Data Password Recovery Free TDL file (Customization Code)

Here we'll learn to recover our Tally's Data password . Its many of time, tally user face to password forgot problem. In that case, we'll need to go who customizes the tally. for this, Many of time, some tally users don't recover their tally's password because of extra recovery charges

Note:- This tools has being working till Tally version 4.93 after that Tally has encrypted the Normal password too and still there is no tool to de-crypt the Data password.

Please find the below code for Tally data password recovery.

[#Menu: Gatewayoftally]
Add:Item:password:Display:TallyPass

[Report:Tallypass]
Form:Tallypass
Object:COmpany

[Form:Tallypass]
Part:Tallypass
Height:40% page
Width:40% page
Background:White

[Part:Tallypass]
Line:Tallypass_Title,Admin_Details,User_Details
Repeat:User_Details:CmpUser List
Scroll:Vertical
Float:Yes

[Line:Tallypass_Title]
Field:U_Name,U_pass
Border:Totals
Space Bottom:2

[Field:U_name]
Use:Name Field
Set as: "USER NAME "
Align:Center
Color:Red

[Field:U_Pass]
Use:Name Field
Set as:"PASSWORD "
Align:Center
Color:Red

[Line:Admin_Details]
Field:Admin_Name,Admin_Pwd

[Field:Admin_Name]
Use:Name Field
Set as:$OwnerName:Company:##SVCurrentCompany
Color:Blue
Align: Center

[Field:Admin_Pwd]
Use:Name Field
Set as:$OwnerPassword:Company:##SVCurrentCompany
Color:Blue
Align:Center

[Line:User_Details]
Field:V_Username,V_password

[Field:V_UserName]
Use:Name Field
Set as:$Name
Color:Blue

[Field:V_Password]
Use:Name Field
Set as:$password
Color:White
Align:Center

[#Collection:Cmp User list]
Fetch:*.*
Is ODBC Table:Yes

Note:-- Take a Backup of you data before following. No one will be responsible in case of Data loss.

Step 1. Copy the Above code and past it to notepad and save it.

Step 2. Attach the code to Tally. If you don't know please follow the link.

Step 3. If you are not in a position to open the company of which you forgot password using other username and password. Create a new company and do not close the new company because if you close you will not be able to recover password.

If you can open the same company with other username password. Do not follow below step and just go the new option to view password.

Step 4. Copy 2 files CmpSave.900 and Company.900 from the data folder of the company whose password you want to recover and paste it in new company data folder. It will ask you to replace file prompt. click yes.

Step 5 Now go back to tally where the new company is still open and go to the new option on gateway of tally to view the password.

Disclamer:- This is just for educational purpose and for personal use. Do use it for data leakage purpose. If used we are not responsible for this.

Free Tally TDL to make PAN Card Field Compulsory (PAN Card Validation)

2018-03-15T14:09:00.006+05:30

PAN is important especially for financial transactions. According to experts, PAN is a way for Income Tax Department to keep tabs on your financial dealing.

And as we know in Tally.ERP 9 capture PAN card details during ledger creation in Tally most of us skips the same. So to stop this below is a small free Tally TDL code which will make entering PAN card details mandatory in Tally. ERP 9 during Ledger Creation.

[#Field: LED ITNo]
Validate :$$StringLength:$$Value = 10

To attach this code in your Tally.ERP9 software please follow step from below url

http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

Download Free Tally.ERP9 software (Educational version)

1. Microsoft excel Shortcuts

2018-03-14T17:00:00.000+05:30

Sr No	Key	Description
1	CTRL+PgUp	Switches between worksheet tabs, from left-to-right.
2	CTRL+PgDn	Switches between worksheet tabs, from right-to-left.
3	CTRL+SHIFT+(	Unhides any hidden rows within the selection.
4	CTRL+SHIFT+)	Unhides any hidden columns within the selection.
5	CTRL+SHIFT+&	Applies the outline border to the selected cells.
6	CTRL+SHIFT_	Removes the outline border from the selected cells.
7	CTRL+SHIFT+~	Applies the General number format.
8	CTRL+SHIFT+$	Applies the Currency format with two decimal places (negative numbers in parentheses).
9	CTRL+SHIFT+%	Applies the Percentage format with no decimal places.
10	CTRL+SHIFT+^	Applies the Exponential number format with two decimal places.
11	CTRL+SHIFT+#	Applies the Date format with the day, month, and year.
12	CTRL+SHIFT+@	Applies the Time format with the hour and minute, and AM or PM.
13	CTRL+SHIFT+!	Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
14	CTRL+SHIFT+*	Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report.
15	CTRL+SHIFT+:	Enters the current time.
16	CTRL+SHIFT+"	Copies the value from the cell above the active cell into the cell or the Formula Bar.
17	CTRL+SHIFT+Plus (+)	Displays the Insert dialog box to insert blank cells.
18	CTRL+Minus (-)	Displays the Delete dialog box to delete the selected cells.
19	CTRL+;	Enters the current date.
20	CTRL+`	Alternates between displaying cell values and displaying formulas in the worksheet.
21	CTRL+'	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
22	CTRL+1	Displays the Format Cells dialog box.
23	CTRL+2	Applies or removes bold formatting.
24	CTRL+3	Applies or removes italic formatting.
25	CTRL+4	Applies or removes underlining.
26	CTRL+5	Applies or removes strikethrough.
27	CTRL+6	Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
28	CTRL+8	Displays or hides the outline symbols.
29	CTRL+9	Hides the selected rows.
30	CTRL+0	Hides the selected columns.
31	CTRL+A	Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows. Pressing CTRL+A a third time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
32	CTRL+B	Applies or removes bold formatting.
33	CTRL+C	Copies the selected cells. CTRL+C followed by another CTRL+C displays the Clipboard.
34	CTRL+D	Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
35	CTRL+F	Displays the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action. CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
36	CTRL+G	Displays the Go To dialog box. F5 also displays this dialog box.
37	CTRL+H	Displays the Find and Replace dialog box, with the Replace tab selected.
38	CTRL+I	Applies or removes italic formatting.
39	CTRL+K	Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.
40	CTRL+N	Creates a new, blank workbook.
41	CTRL+O	Displays the Open dialog box to open or find a file. CTRL+SHIFT+O selects all cells that contain comments.
42	CTRL+P	Displays the Print dialog box. CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
43	CTRL+R	Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
44	CTRL+S	Saves the active file with its current file name, location, and file format.
45	CTRL+T	Displays the Create Table dialog box.
46	CTRL+U	Applies or removes underlining. CTRL+SHIFT+U switches between expanding and collapsing of the formula bar.
47	CTRL+V	Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
48	CTRL+W	Closes the selected workbook window.
49	CTRL+X	Cuts the selected cells.
50	CTRL+Y	Repeats the last command or action, if possible.
51	CTRL+Z	Uses the Undo command to reverse the last command or to delete the last entry that you typed. CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed.

Connecting Tally.ERP 9 to Microsoft Excel 2007 using ODBC

2018-03-14T16:15:00.000+05:30

Connecting Tally.ERP 9 to Microsoft Excel 2007 using ODBC

Tally ODBC helps you to extract the Data from Tally.ERP 9 and design the reports in MS Excel 2007.

To extract

Step 1: Enable ODBC

1. Start Tally.ERP 9. It should be open till the process is complete.

2. Ensure that the ODBC Server is running. You can confirm this when the message Running as ODBC Server is displayed in the Configuration block of Information Panel (at the bottom) of Tally.ERP 9 screen, as shown:

In case, the ODBC Server is not running, enable the ODBC Server

· From Gateway of Tally or Company Info menu, press F12 Configure > Advanced Configuration.

· In the Client/Server Configuration screen, set Enable ODBC Server to Yes.

Step 2:

1. Start Microsoft Office 2007.

2. Click Data.

The sub options of Data menu appears as shown:

3. Click From Other sources .

4. Select From Microsoft Query .

Choose Data Source dialog box appears.

5. Select TallyODBC.

Tally.ERP 9 connects to data source and displays Query Wizard – Choose Columns dialog box.

6. Select the columns you would want to include in the query. Select Ledger and Click > button to the right of the following fields: (For example, $Parent)

7. Click Next .

The Query Wizard - Filter Data dialog box appears.

8. Set the filter conditions in the Filter Data dialog box to limit the data to those that match your criteria.

9. Click Next .

The Query Wizard - Sort Order dialog box appears.

10. Sort the data in ascending or descending order as per the requirement.

11. Click Next.

The Query Wizard - Finish dialog box appears.

The option Return Data to Microsoft Office Excel will be selected, by default.

12. Click Finish.

Once the Query Wizard process is complete, the dialogue box entitled Import Data appears.

13. Click OK .

The excel sheet will display the report as shown below:

Simple Tally.ERP9 TDL Code for having contact details In Sales Screen

2018-01-13T22:13:00.002+05:30

Most of us you like to have customer's contact details in front of us during Voucher entry and Especially during Sale Invoicing so that we can contact them easily without searching for there contact details here and there.

And using below code you can achieve the same.

NOTE:- This is only for Sales Invoice and will only show the mobile number and contact person.

[#Line: EI PartyLimit]

Add : Field : After : EI CreditLimit : Contact

[Field : Contact]
Invisible : NOT ##CurBalanceFlag
Field : Simple Prompt, Name Field
Local : Field : Simple Prompt : Info : $$LocaleString:"Contact:"
Local : Field : name Field : Set as : $LedgerContact:Ledger:#EIConsignee + " " + $LedgerMobile:Ledger:#EIConsignee
Local: Field: Name Field: Width:25

To attach the above code you will need to follow the steps given in http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

After Attaching the above code you will be able to see the contact details of your customer on sales voucher screen provided it is filled in in your Ledger.

Attach any document to voucher entry in Tally.ERP9

2017-12-19T15:39:00.001+05:30

In this post i have share code for attaching document to voucher entry and opening that document from within Tally.ERP9. This is very useful at the place were we want our documents to be in soft copy and does not want to maintain hard copy of each and every stuff.

To know how to attache any tdl to tally please visit
http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

[#Form: Sales Color]
Add :Button :Open Attachement

[#Form: Contra Color]
Add :Button :Open Attachement

[#Form: Payment Color]
Add :Button :Open Attachement

[#Form: Receipt Color]
Add :Button :Open Attachement

[#Form: Journal Color]
Add :Button :Open Attachement

[#Form: Payroll Color]
Add :Button :Open Attachement

[#Form: Debit Note Color]
Add :Button :Open Attachement

[#Form: Credit Note Color]
Add :Button :Open Attachement

[#Form: Purchase Color]
Add :Button :Open Attachement

[#Form: Memorandum Color]
Add :Button :Open Attachement

[#Form: Reversing Journal Color]
Add :Button :Open Attachement

[#Form: Stock Journal Color]
Add :Button :Open Attachement

[#Form: Delivery Note Color]
Add :Button :Open Attachement

[#Form: Receipt Note Color]
Add :Button :Open Attachement

[#Form: Rejection Inward Color]
Add :Button :Open Attachement

[#Form: Rejection Outward Color]
Add :Button :Open Attachement

[#Form: Physical Stock Color]
Add :Button :Open Attachement

[#Form: Sales Order Color]
Add :Button :Open Attachement

[#Form: Purc Order Color]
Add :Button :Open Attachement

[#Form: Indent Color]
Add :Button :Open Attachement

[#Form: Attendance Color]
Add :Button :Open Attachement

[#Form: JobOrderIn Color]
Add :Button :Open Attachement

[#Form: JobOrderOut Color]
Add :Button :Open Attachement

[Button : Open Attachement]
Title : $$LocaleString:"Open Attachement"
Key : Ctrl + O
Action :Browse Url Ex : #HyperlinkCompany

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[#Part: VCH Narration]
Add : Switch : BankDetRcpt : BankDet VCH Narration

[!Part: BankDet VCH Narration]
Add : Line : HyperlinkCompany

[Line: HyperlinkCompany]
Fields : Short Prompt, HyperlinkCompany
Local : Field : Short Prompt : Info: $$LocaleString:"Supporting Doc."

[System: UDF]
hyper1 : String : 1101

[Key : Execute Hyperlink1]
Title: Exc
Key : Left Click
Action : Browse Url Ex: “www.onetouchsolution.co.in”

[Field: HyperlinkCompany]
Use : Name Field
Color : Blue
;Border : Thin Bottom
Key : Execute Hyperlink1
Storage : hyper1
Local : Key : Execute Hyperlink1 : Action :Browse Url Ex: "D:\DOCUMENTS\" + $VoucherTypeName +"\"+ #HyperlinkCompa
Skip: $$InAlterMode
Fullwidth:yes

After adding this you will bed able to find new field on each voucher shown as below.

you need to specify the complete path of the document including extension as show below and save the voucher.

After that when you edit the voucher you should be able to see the document as shown below.

and now you can open this document from within Tally by pressing Open Attachment Button on the right hand side.

How to create Custom Menu on Tally Start Instead of Gateway of Tally

2017-12-14T14:47:00.000+05:30

In this Post I am sharing sample code about how to change and create custom menu on Tally.ERP9 Start instead of Gateway of Tally. This can be use full for security purpose were we want or employee to have only those options which we want on there screen and which cannot be achieved using default Tally.ERP9 security feature. So lets start.

[System: Formula]
locDefaultGateway : $$LocaleString:"Gateway of Tally"
locInvv :$$LocaleString:"Inventory Vouchers"
locRepo :$$LocaleString:"Reports"

[Menu: Vouchers Entry]
Key Item : @@locInventoryVouchers : T : Create Collection : Company InvVouchers : $$IsInventoryOn:$$CurrentSimpleCompany

[Menu: Reports]
Key Item : @@locDayBook : D : Display : Day Book : NOT $$IsEmpty:$$SelectedCmps
Item : BLANK
Add : Key Item : GodownWise Stock : G : Display Collection : Godown Summary : $$IsMultiGodownOn:$$CurrentSimpleCompany
Control : @@locGodowns : $$IsMultiGodownOn AND @@IndianAccTerminology AND $$Allow:Display:GodownWiseSummary

[Menu: Default Gateway]

Title : $$LocaleString:"Gateway of Tally"
Indent : @@locIndentMasters
Item : BLANK
Key Item : @@locAccountsInfo : A : Menu : Accounts Info. : NOT $$IsEmpty:$$SelectedCmps
Key Item : @@locPayrollInfo : L : Menu : Payroll Info. : NOT $$IsEmpty:$$SelectedCmps AND ($$AddOnInfo:PayrollEnabled) AND $$IsPayrollOn:$$CurrentSimpleCompany
Key Item : @@locInventoryInfo : I : Menu : Inventory Info. : NOT $$IsEmpty:$$SelectedCmps AND $$IsInventoryOn:$$CurrentSimpleCompany
Key Item : @@locQuickSetup : K : Menu : Quick Setup : @@IsIndian AND NOT $$IsEmpty:$$SelectedCmps
Item : BLANK
Indent : @@locIndentTransactions
Item : BLANK
Key Item : @@locAccountingVouchers : V : Create Collection : Company AccVouchers
Key Item : @@locInventoryVouchers : T : Create Collection : Company InvVouchers : $$IsInventoryOn:$$CurrentSimpleCompany
Key Item : @@locOrderVouchers : E : Create Collection : Company OrdVouchers : ($$IsPurcOrdersOn:$$CurrentSimpleCompany OR $$IsSalesOrdersOn:$$CurrentSimpleCompany OR $$IsJobWorkOn:$$CurrentSimpleCompany)
Key Item : @@locPayrollVouchers : Y : Create Collection : Company Payroll Vouchers : $$IsPayrollOn:$$CurrentSimpleCompany
Key Item : @@locAttendanceVouchers : C : Create Collection : Company Attendance Vouchers : $$IsPayrollOn:$$CurrentSimpleCompany AND $$NumAttdTypes >= 1
Item : BLANK
Indent : @@locIndentUtilities
Item : BLANK
Indent : @@locIndentReports
Item : BLANK
Key Item : @@locBalanceSheet : B : Display : Balance Sheet : $$IsAccountingOn:$$CurrentCompany
Key Item : @@locProfitLossAcc : P : Display : Profit and Loss : $$IsAccountingOn:$$CurrentCompany
Key Item : @@locIncomeExpenseAcc : N : Display : Profit and Loss : $$IsAccountingOn:$$CurrentCompany
Key Item : @@locStockSummary : S : Display : Stock Summary : $$IsInventoryOn:$$CurrentCompany
Key Item : @@locRatioAnalysis : R : Display : Ratio Analysis : $$IsAccountingOn:$$CurrentCompany
Item : BLANK
Key Item : @@locDisplay : D : Menu : Display Menu
Key Item : @@locMultiAccPrinting : M : Menu : Printing Menu : (($$LicenseInfo:IsLicensedMode) OR (($$LicenseInfo:RemoteSerialNumber) > 0))
Item : BLANK
Key Item : @@locQuit : Q
Control : @@locAccountsInfo : $$Allow:Create:AccountsMasters OR $$Allow:Alter:AccountsMasters OR $$Allow:Display:AccountsMasters
Control : @@locPayrollInfo : $$IsPayrollOn AND ($$Allow:Create:PayrollMasters OR $$Allow:Alter:PayrollMasters OR $$Allow:Display:PayrollMasters)
Control : @@locInventoryInfo : $$IsInventoryOn AND ($$Allow:Create:InventoryMasters OR $$Allow:Alter:InventoryMasters OR $$Allow:Display:InventoryMasters)
Control : @@locQuickSetup : @@IsIndian
Control : @@locAccountingVouchers : $$Allow:Create:Vouchers AND $$Allow:Create:AccountingVouchers AND $$CheckAllowedAccVchTypeMenu
Control : @@locPayrollVouchers : $$IsPayrollOn:$$CurrentSimpleCompany AND $$Allow:Create:PayrollVouchers AND $$CheckAllowedPayrollVchTypeMenu
Control : @@locAttendanceVouchers : $$IsPayrollOn:$$CurrentSimpleCompany AND ($$Allow:Create:AttendanceVouchers OR $$Allow:Create:Attendance) AND (NOT $$Allow:Create:Payroll OR NOT $$Allow:Create:PayrollVouchers) AND $$CheckAllowedAttendanceVchTypeMenu
Control : @@locInventoryVouchers : $$IsInventoryOn AND $$Allow:Create:Vouchers AND $$Allow:Create:InventoryVouchers AND $$CheckAllowedInvVchTypeMenu
Control : @@locOrderVouchers : $$IsInventoryOn AND ($$IsPurcOrdersOn OR $$IsSalesOrdersOn OR $$IsJobWorkOn) AND $$Allow:Create:Vouchers AND $$Allow:Create:OrderVouchers AND $$CheckAllowedOrderVchTypeMenu
Control : @@locBalanceSheet : $$Allow:Display:BalanceSheet
Control : @@locRatioAnalysis : $$Allow:Display:BalanceSheet
Control : @@locProfitLossAcc : $$Allow:Display:ProfitLossAc AND NOT $PLasIncomeExpense:Company:$$CurrentCompany
Control : @@locIncomeExpenseAcc : $$Allow:Display:ProfitLossAc AND $PLasIncomeExpense:Company:$$CurrentCompany
Control : @@locStockSummary : $$IsInventoryOn AND $$Allow:Display:StockSummary
Control : @@locMultiAccPrinting : (($$LicenseInfo:IsLicensedMode) OR (($$LicenseInfo:RemoteSerialNumber) > 0))
Option : Import Direct : NOT $$IsTallyClient AND NOT $$IsTallyServer
Option : Import InDirect : $$IsTallyClient OR $$IsTallyServer
Option : FinalAcctsMenu : @@UseFinalAcctsMenu
Option : MultiAccountButton : (($$LicenseInfo:IsLicensedMode) OR (($$LicenseInfo:RemoteSerialNumber) > 0))
Button : Select Company
Delete : Key Item : Stock Report : C : Display Collection : Stock Query1

In above code i have change the default Tally.ERP9 Gateway of Tally menu to "Main menu" and added the key items which i want my employees to have it on there screen.

I have also added key item which will take me to Default Tally.ERP9 Gateway of Tally but provided i have access to it. So using the above code my employee will only be able to use all the voucher type which can be accessed using Invoice Voucher Option and reports which I want them to see.

Note:- To have it more secure you will need to use default tally security feature on with security level set so that shortcut cannot be used.

Note:- This is just for education purpose you will need to edit the code as per your requirements.

Block Invoicing After Credit Day Overdue Free Tally TDL

2017-12-07T15:47:00.000+05:30

As we all know that Tally.ERP9 software as the functionality of setting up Credit days and Credit based on Amount in Ledger Master but does not block billing even if Credit days are over due.

Below Code will help you in blocking the billing if any bill is overdue of a particular customer.

;;;;; In below code we have found the field were we want our code to check and block the entry and have applied the control;;;;;;;

[#Field: EI Consignee]

Control : CtrlCreditDays : @@ChkCreditDays>0 and $$InCreateMode and $$IsSales:##SVVoucherType

[Collection: Credit PartyPending Bills]

Type : Bills

Child of : #EIConsignee

Unique : $$Name

Format : @@DateDiff

Format : $BillDate, 8 : Universal Date

Format : $$Name, 10

Format : $BaseClosing,-30 : "AllSymbols, DrCr"

Format : @@DueDate

Format : ##SVCurrentDate

Filter : FltrCreditDays, FltrCrAmt

[System : Formula]

CtrlCreditDays : if @@ChkCreditDays = 1 then "The Customer has " + $$NewLine + $$String:@@ChkCreditDays + $$NewLine + " Bill OverDue." else "The Customer has " + $$NewLine + $$String:@@ChkCreditDays + $$NewLine + " Bills OverDue."

ChkCreditDays : $$Numitems:CreditPartyPendingBills

FltrCreditDays : $$Number:@@DateDiff>=1

DueDate : $$Date:$$String:$BillCreditPeriod:UniversalDate

DateDiff : ##SVCurrentDate - @@DueDate

FltrCrAmt : $$IsDr:$BaseClosing

Common Troubleshooting....

1. After attaching the code to Tally ( http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html ) it is blocking all the invoice even if credit period is not over ?

Answer:- Go to Display-> Statement of Accounts-> Outstanding-> Select Ledger for which you are facing issue-> and check that there is not no of days in overdue column.

Tally TDL How to Add Custom field (UDF) on any screen of Tally.ERP9 Software

2017-10-05T17:27:00.000+05:30

How to Add Custom field (UDF) on any screen of Tally.ERP9 Software

In this post we will learn how to add Custom Field on any Screen of Tally.ERP9 Software. I will be taking example of Sales Screen as this is the one of which we get most enquiry of or we our-self require most of the time to capture more information which is ether required during sales entry or want to print some additional information on our Invoice.

In this post we will be taking example of scenario where we want to view contact person of Customer.

So before we start you will need to have any text editor software installed on your system (e.g Notepad, WordPad etc…) but if you have Tally Developer 9 Application it will help us a lot. I am going to use Tally Developer 9 Application here

If you don’t have Tally Developer 9 application you can download it from http://tallysolutions.com/downloads. To know how to install it please read through my other blog how to install Tally Developer 9Application.

Start your Tally Developer 9 Application. Create a New Project (To know how to use Tally Developer 9 Application click here)

After creating a New Project now we need to decide where we want to have our field placed. In this example I have decided to place my field on the Top Right hand side of the screen in line of Ledger name. You can choose yours.

In the below code we have given a call to the line by using ‘#’ were we want to place are custom field.

[#Line: EI Consignee]

Field : Simple Prompt, EI Consignee, EI CurrConsignee, EI FirstLedger, INVMailName, Name field

RightFields : Short Prompt, EI PriceLevel, EI PrevPriceLevel

The line may contain lot of default field. We have do decide after or before which field we want our custom field. I have decided to place is just before Price level prompt which we see on screen use below code.

Add: Right Field: After:Short Prompt: CustomerNamePrompt, CustomerName

After placing the field we need to provide contain to the field.

[Field:CustomerNamePrompt]

Use: Medium Prompt ;; here I am saying that this is a prompt .

Set as: "Contact Person" ;; The data in the prompt is Contact Person.

[Field:CustomerName]

Use: Name Field ;; This is going to be a normal text field which is called name field in tally

Set as:$LedgerContact:Ledger:$LedgerName ;; At this place I am giving a call to contact person from Ledger Master which is selected.

Set Always: Yes

Skip: Yes

Which mean my code is

[#Line: EI Consignee]

Field : Simple Prompt, EI Consignee, EI CurrConsignee, EI FirstLedger, INVMailName, Name field

RightFields : Short Prompt, EI PriceLevel, EI PrevPriceLevel

Add: Right Field: After:Short Prompt: CustomerNamePrompt, CustomerName

[Field:CustomerNamePrompt]

Use: Medium Prompt

Set as: "Contact Person"

[Field:CustomerName]

Use: Name Field

Set as:$LedgerContact:Ledger:$LedgerName

Set Always: Yes

Skip: Yes

And After attaching this code to you Tally.ERP9 Software you should be able to see the new fields Contact person and its name on sales screen.

Note:- make sure that you have turned on contact details in your ledger from F12 Settings and filled in contact person field.

Half page GST invoice Customization (Free TDL Code)

2017-10-04T20:21:00.000+05:30

What is an Invoice?

An invoice is a commercial document that itemizes a transaction between a buyer and a seller. If goods or services were purchased on credit, the invoice usually specifies the terms of the deal, and provides information on the available methods of payment. An invoice is also known as a bill or sales invoice.

BREAKING DOWN 'Invoice'

Companies may opt to simply send a month-end statement as the invoice for all outstanding transactions. If this is the case, the statement must indicate that no subsequent invoices will be sent.

An invoice must state it is an invoice on the face of the bill. It typically has a unique identifier called the invoice number that is useful for internal and external reference. An invoice typically contains contact information for the seller or service provider in case there is an error relating to the billing. Payment terms may be outlined on the invoice, as well as the information relating to any discounts, early payment details or finance charges assessed for late payments. It also presents the unit cost of an item, total units purchased, freight, handling, shipping and associated tax charges, and it outlines the total amount owed.

Importance of Invoice Date

The invoice date represents the official date in which the goods have been billed. Therefore, the invoice date has essential information regarding payment, as it dictates the credit duration and due date of the bill.

Invoice and Accounts payable

Invoices track the sale of a product for inventory control, accounting and tax purposes. Many companies ship the product and expect payments on a later date, so the total amount due becomes an account payable for the buyer and an account receivable for the seller. Modern-day invoices are transmitted electronically, rather than being paper-based. If an invoice is lost, the buyer may request a copy from the seller. The use of an invoice represents the presence of credit, as the seller has sent a product or provided a service without receiving cash up front.

Invoices and Internal Controls

Invoices are a critical element of accounting internal controls. Charges on an invoice must be approved by the responsible management personal. Alternatively, an invoice is matched to a purchase order and upon reconciling the information payment is made for approved transactions. An auditing firm ensures invoices are entered into the appropriate accounting period when testing for expense cut-off.

GST A5 Invoice customization

After receiving lot of email’s and request for GST Invoice customization on half page i.e. A5 Landscape. I have tried to make a simple design which fits on A5 paper size in Landscape mode. But to achieve it I had to remove few things which were provided to you in A4 Customization which was posted earlier.

Note: - There is no GST Analysis in this code and no bank details and This is only for local sales so no IGST part.

To attach this code in your Tally.ERP 9 Application please visit http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

Please find the below code for A5 GST invoice customization

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;GST Invoice Print;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Style:P9]

Font:Calibri (Body)

Height:9

[Style:P9B]

Use:P9

Bold: Yes

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[#Part: VTYP BehaviourMain]

Option : VTYP BehaveMain KA VchTypeConfirm : @@IsKAVchType

[!Part : VTYP BehaveMain KAVchTypeConfirm]

Add : Line : After : VTYP PrintSave :VTYP KA VchTypeConfirm

[Line : VTYP KA VchTypeConfirm]

Field : Long Prompt, Logical Field

Local : Field : Long Prompt : Set as : "Print GST Format ?"

Local : Field : Long Prompt : Width : @@LongWidth

Local : Field : Logical Field : Storage : KAVchTypeConfirm1

[System : Formula]

IsKAVchType : $$IsSales:$Parent

IsKANewAllow : $KAVchTypeConfirm1:VoucherType:$VoucherTypeName

[System : UDF]

KAVchTypeConfirm1 : Logical : 1782

[#Form : Sales Color]

Option: KASalesKA Color: @@IsKANewAllow

[!Form:KASalesKA Color]

Delete : Print

Add : Print : STC GST INVOICE KA

[Report :STC GST INVOICE KA]

Use : Printed Invoice

Delete: Form : Printed Invoice

Form : STC GST INVOICE KA

[Form:STC GST INVOICE KA]

Width : 8 Inch

Height : 6 Inch

Space Top : 0.10 Inch

Space Right : 0.10 inch

Space Left : 0.50 inch

Space Bottom: 0.10 inch

Part: KA Opening Page Break, KA Invoice Body

Bottom Part: KA Invoice Total, KA Goods Sold

Page Break : ClKA Page Break, KA Opening Page Break

[Part:ClKA Page Break]

Lines : GIKA ClPgBrk

[Line: GIKA ClPgBrk]

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: KA Opening Page Break]

Part: KA Invoice Title, KA CMP Details, KA Leading Details, KA Coloumn Titles

Vertical: Yes

[Part:KA Invoice Title]

Line:KA Invoice Title

[Line:KA Invoice Title]

Field: Simple Field

Right Field:Name Field

Local: Field: Simple Field: Set as: "TAX INVOICE"

Local: Field: Simple Field: Style: Large Bold

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"

[Part:KA CMP Details]

Part: DMICash CMP Name Details

[Part:DMICash CMP Name Details]

Line: KA CMP Name, KA CMP Address

[Line: KA CMP Name]

Field: Name Field

Local: Field: Name Field: Set as: @@CmpMailName

Local: Field: Name Field: Style:Parth CMP Name Cash

Local: Field: Name Field: Full Width: Yes

[Style: Parth CMP Name Cash]

Font: Adobe Garamond Pro Bold

Height:15

Bold: Yes

[Line:KA CMP Address]

Field: Name Field

Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address

Local: Field: Name Field: Width:50% Page

Local: Field: Name Field: Line:0

Local: Field: Name Field: Style:P9

[Part:KA Leading Details]

Left Part: KA Customer Details

Right Part: KA Invoice Details

Border: Thick Cover

[Part:KA Customer Details]

Line:KA Customer Details Title, KA Customer Name, KA Customer Address, KA Customer State Name, KA Customer GST No, KA Customer Contact

Width: 70% Page

[Line:KA Customer Details Title]

Field: Simple Field

Local: Field: Simple Field : Set as: "Details for Buyer (Billed & Shipped To )"

Local: Field: Simple Field: Style:P9B

Local: Field: Simple Field: Full Width: Yes

[Line:KA Customer Name]

Field: Simple Field

Local: Field: Simple Field: Set as: @@SimpleOtherPartyName

Local: Field: Simple Field: Style: P9B

Local: Field: Simple Field: Full Width: Yes

Space Top:0.5

[Line:KA Customer Address]

Field: Simple Field

Local: Field: Simple Field: Set as: $$FullList:BasicBuyerAddress:$BasicBuyerAddress

Local: Field: Simple Field: Style: P9

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Line:0

[Line:KA Customer State Name]

Field: Simple Field

Local: Field: Simple Field: Set as: "State Name"+" : "+ $StateName +" "+ "Code :"+" "+ $$getgststatecode:@StateName

Local: Field: Simple Field: Local Formula:StateName : If NOT ($$IsEmpty:$StateName OR $$IsSysName:NotApplicable:$StateName) Then $StateName Else $LedStateName:Ledger:@PartyName

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9

[Line:KA 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: P9

[Line:KA Customer Contact]

Field: Simple Field

Local: Field: Simple Field: Set as: "Contact Details :"+" "+ @@VchContactNo

Local: Field: Simple Field: Style: P9

Local: Field: Simple Field: Full Width: Yes

[Part:KA Invoice Details]

Line: KA Invoice No, KA Invoice Date

Width: 30% Page

Border: Thin Left

[Line:KA Invoice No]

Field: Medium Prompt,Simple Field

Local: Field: Medium Prompt: Set as: "Invoice No."

Local: Field: Medium Prompt: Style: P9B

Local: Field: Medium Prompt: Width: 15

Local: Field: Simple Field: Set as: $VoucherNumber

Local: Field: Simple Field: Style: P9

Local: Field: Simple Field: Full Width: Yes

Space Top:1

[Line:KA Invoice Date]

Field: Medium Prompt, Simple Field

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

Local: Field: Medium Prompt: Style: P9B

Local: Field: Medium Prompt: Width: 15

Local: Field: Simple Field: Set as: $Date

Local: Field: Simple Field: Style: P9

Local: Field: Simple Field: Full Width: Yes

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Part:KA Coloumn Titles]

Line:KA Invoice Body Title,KA Invoice Body Title1

Border: Thick Cover

Common Border: Yes

[Part: KA Invoice Body]

Part:KA Invoice Body Coloumns

Vertical: Yes

Border: Thin Cover

[Part:KA Invoice Body Title]

Line:KA Invoice Body Title,KA Invoice Body Title1

Common Border: Yes

[Line:KA Invoice Body Title]

Use: KA Invoice Body Coloumns

Local: Field: Default: Type: String

Local: Field: Default: Style: P9B

Local: Field: Default: Align: Center

Local: Field:KA SrNo: Set as: "Sr "

Local: Field:KA Item Description: Set as: "Item"

Local: Field:KA Part No: Set as: "Part"

Local: Field:KA HSN Code: Set as: "HSN "

Local: Field:KA Billed Qty: Set as: "Billed"

Local: Field: KA Rate: Set as: "Rate"

Local: Field:KA CD Amt:Set as: "CD Amt"

Local: Field:KA PD Amt:Set as: "PD Amt"

Local: Field:KA Gross Amt: Set as: "Taxable"

Local: Field:KA CGST Rate: Set as: "CGST"

Local: Field: KA CGST Amt: Set as: "CGST"

Local: Field:KA SGST Rate: Set as: "SGST"

Local: Field:KA SGST Amt: Set as: "SGST "

Local: Field:KA Item Total: Set as: "Total"

Border: Thin Top

Space Top: 0.25

[Line:KA Invoice Body Title1]

Use: KA Invoice Body Coloumns

Local: Field: Default: Type: String

Local: Field: Default: Style: P9B

Local: Field: Default: Align: Center

Local: Field:KA SrNo: Set as: "No"

Local: Field:KA Item Description: Set as: "Description"

Local: Field:KA Part No: Set as: "No"

Local: Field:KA HSN Code: Set as: "Code"

Local: Field:KA Billed Qty: Set as: "Qty"

Local: Field: KA Rate: Set as: ""

Local: Field: KA CD Amt: Set as:""

Local: Field: KA PD Amt: Set as: ""

Local: Field:KA Gross Amt: Set as: "Amount"

Local: Field:KA CGST Rate: Set as: "%"

Local: Field: KA CGST Amt: Set as: "Amt"

Local: Field:KA SGST Rate: Set as: "%"

Local: Field:KA SGST Amt: Set as: "Amt"

Local: Field:KA Item Total: Set as: ""

Border: Thin Bottom

Space Bottom: 0.25

[Part:KA Invoice Body Coloumns]

Line:KA Invoice Body Coloumns

Repeat:KA Invoice Body Coloumns:Inventory Entries

Bottom Line: KA Invoice Body Coloumns Total

Scroll: Vertical

Float: No

Common Border: Yes

[Line:KA Invoice Body Coloumns]

Left Field: KA SrNo, KA Item Description

Right Field: KA HSN Code,KA Billed Qty, KA Rate, KA Gross Amt,KA CGST Rate, KA CGST Amt, KA SGST Rate, KA SGST Amt, KA Item Total

Space Top: 0.25

Local: Field:KA SrNo: Width: 2

Local: Field:KA Part No: Width:7

Local: Field:KA HSN Code: Width: 5

Local: Field:KA Billed Qty: Width: 6

Local: Field: KA Rate: Width: 6

Local: Field: KA CD Amt: Width:6

Local: Field:KA PD Amt:Width:6

Local: Field:KA Gross Amt: Width: 6

Local: Field:KA CGST Rate: Width: 3

Local: Field: KA CGST Amt: Width: 6

Local: Field:KA SGST Rate: Width: 3

Local: Field:KA SGST Amt: Width: 6

Local: Field:KA Item Total: Width: 10

Local: Field:KA SrNo: Border: Thin Right

Local: Field:KA Part No: Border: Thin Left

Local: Field:KA HSN Code: Border: Thin Left

Local: Field:KA Billed Qty: Border: Thin Left

Local: Field: KA Rate: Border: Thin Left

Local: Field: KA CD Amt: Border: Thin Left

Local: Field:KA PD Amt:Border: Thin Left

Local: Field:KA Gross Amt: Border: Thin Left

Local: Field:KA CGST Rate: Border: Thin Left

Local: Field: KA CGST Amt: Border: Thin Left

Local: Field:KA SGST Rate: Border: Thin Left

Local: Field:KA SGST Amt: Border: Thin Left

Local: Field:KA Item Total: Border: Thin Left

[Field: KA Sr NO]

Use: Simple Field

Set as: $$Line

Format: "No Zero"

Style:P9

Align: Center

[Field:KA Item Description]

Use: Simple Field

Set as: if NOT $$IsSysName:$StockItemName then @@InvItemName else ""

Style: P9

Full Width: Yes

Line:0

[Field:KA Part No]

Use:Simple Field

Set as: $PartNo:StockItem:$StockItemName

[Field:KA HSN Code]

Use: Simple Field

Set as: $$GetGSTItemDetails:$StockItemName:$date:"HSNCode":0:"StockItem";$VJSTKIHSNCode:StockItem:$StockItemName

Style:P9

[Field:KA Billed Qty]

Use: Qty Primary Field

Set as: $BilledQty

Style:P9

[Field:KA Rate]

Use: Rate Price Field

Set as: $Rate

Style:P9

[Field:KA CD Amt]

Use: Amount Field

Set as: $KACD

Style: P9

[Field:KA PD Amt]

Use:Amount Forex Field

Set as: $KAPD

Style:P9

[Field:KA Gross Amt]

Use:Amount Forex Field

Set as: $Amount

Style:P9

[Field:KA CGST Rate]

Use: Number Field

Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx /2

Format : "NoZero,Percentage"

Set Always: Yes

Style:P9

[Field:KA CGST Amt]

Use: Amount Field

Set as: $Amount * #KACGSTRate / 100

Style:P9

Set Always: Yes

[Field:KA SGST Rate]

Use: Number Field

Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx /2

Format : "NoZero,Percentage"

Set Always: Yes

Style:P9

[Field:KA SGST Amt]

Use: Amount Field

Set as: $Amount * #KASGSTRate / 100

Style:P9

Set Always: Yes

[Field:KA Item Total]

Use: Amount Field

Set as: #KAGrossAmt + #KACGSTAmt + #KASGSTAmt

Set Always: Yes

Style:P9

[Line:KA Invoice Body Coloumns Total]

Use: KA Invoice Body Coloumns

Local: Field: Default: Type: String

Local: Field: Default: Style: P9B

Local: Field: Default: Align: Center

Local: Field:KA SrNo: Set as: ""

Local: Field:KA Item Description: Set as: "TOTAL"

Local: Field:KA HSN Code: Set as: ""

Local: Field: KA Rate: Set as: ""

Local: Field: KA CD Amt: Set as:""

Local: Field:KA PD Amt:Set as:$$CollAmtTotal:InventoryEntries:$AssoValue

Local: Field:KA Gross Amt: Set as: $$CollAmtTotal:InventoryEntries:$Amount

Local: Field:KA CGST Rate: Set as: ""

Local: Field: KA CGST Amt: Set as: $$FilterAmtTotal:LedgerEntries:CGST1:$Amount

Local: Field:KA SGST Rate: Set as: ""

Local: Field:KA SGST Amt: Set as: $$FilterAmtTotal:LedgerEntries:SGST1:$Amount

Local: Field:KA Item Total: Set as: $Amount

Border: Thin Top Bottom

Space Bottom: 0.25

Space Top: 0.25

[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"

[Part:KA Invoice Total]

Right Part: KA Ledger Entries

Left Part: KA Invoice Sing Off

Border: Thick Box

[Part:KA Ledger Entries]

Line:KA Ledger Entries

Repeat:KA Ledger Entries:Ledger Entries

Float: No

Common Border: Yes

Bottom Line: KA Invoice Total

[Line:KA Invoice Total]

Field: KA Invoice Total Title, KA Invoice Total Amt

[Field:KA Invoice Total Title]

Use: Simple Field

Set as:"INVOICE TOTAL"

Style: Large Bold

Width:20.7

[Field:KA Invoice Total Amt]

Use: Amount Field

Set as: $Amount

Style: Large Bold

Width:10

Border: Thin Left

[Line: KA Ledger Entries]

Remove if : $LedgerName = $PartyLedgerName

Field: KA Ledger Name, KA Ledger Amount

Space Top: 0.5

Border: Thin Bottom

[Field: KA Ledger Name]

Use: Simple Field

Set as: $LedgerName

Style:P9B

Width: 20.7

Border: Thin Left

[Field:KA Ledger Amount]

Use: Amount Field

Set as: $Amount

Style:P9B

Width: 10

Border: Thin Left

Align: Right

[Part:KA Invoice Sing Off]

Part: KA Amount In Word and Declaration, KA Invoice Sing Off Part

Vertical: Yes

[Part:KA Amount In Word and Declaration]

Line: KA Amount In Word, KA Declaration

[Line:KA Amount In Word]

Field: Simple Field

Local: Field: Simple Field: Set as: "TOTAL VALUE (IN WORDS) Rs." +" "+ $$InWords:$Amount

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9B

Local: Field: Simple Field: Line:0

[Line:KA Declaration]

Field: Simple Prompt,Simple Field

Local: Field: Simple Prompt: Set as: "Declaration"

Local: Field: Simple Prompt: Style: P9

Local: Field: Simple Field: Set as: "Certified that the Particulars given above are true and correct."

Local: Field: Simple Field: Line: 0

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9

Space Top: 0.5

[Part:KA Invoice Sing Off Part]

Left Part: For KA

Right Part: For KA Cu

[Part:For KA]

Line: For KA, KA Authorised Signatory

[Line: For KA]

Field: Simple Field

Local: Field: Simple Field: Set as: "For" +" "+ @@CmpMailName

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9B

Local: Field: Simple Field: Align: Left

Space Top: 1

[Line:KA Authorised Signatory]

Field: Simple Field

Local: Field: Simple Field: Set as: "Authorised Signatory"

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9B

Local: Field: Simple Field: Align: Left

Space Top:2

[Part:For KA Cu]

Line:For KA Cu

[Line:For KA Cu]

Field: Simple Field

Local:Field: Simple Field: Set as: "Receivers Stamp & Sign."

Local:Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Align: Right

Local: Field: Simple Field: Style: P9

Space Top:4

[Part:KA Goods Sold]

Line:KA Goods Sold, KA Juridiction

[Line:KA Goods Sold]

Field: Simple Field

Local: Field: Simple Field: Set as: "GOODS ONCE SOLD WILL NOT BE TAKEN BACK"

Local: Field: Simple Field: Align: Center

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9B

[Line:KA Juridiction]

Field: Simple Field

Local: Field: Simple Field: Set as: "JURISDICTION NASHIK"

Local: Field: Simple Field: Align: Center

Local: Field: Simple Field: Full Width: Yes

Local: Field: Simple Field: Style: P9B

Free TDL code for setting Discount or Scheme Amount during Sales Invoice

2017-10-02T12:08:00.000+05:30

TDL code for setting Discount or Scheme Amount during Sales Invoice

As we all know Tally.ERP 9 does not have the feature to give discount or Scheme based on Amount and has feature of percentage only. This TDL code will allow you to set the discount or Scheme based on Amount.

Note:- You might need to check the Tax calculation depending on how the transaction is This is code will just help you to set discount or scheme by amount.

To learn how to attached this code to Your Tally.ERP9 software please follow the instructions at
http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

Code:----

[#Line : EI Column One]
Add : Right Field: After: VCH RateUnitsTitle: OTSCustomerSchemeAmountTitle

[Field:OTSCustomerSchemeAmountTitle]
Use: Name Field
Set as: "Scheme Amt"
Align: Centre
Skip: Yes
Border: Thick Left Right
Width:10
Invisible: If @@IsSales then No else Yes

[#Line : EI Inv Info] ;; Inventory Repeat Line - - With out Class
Add : Right Fields: After : VCH RateUnit: OTSCustomerSchemeAmount

[#Line : CI Inv Info] ;; Inventory Repeat Line - - With Class

Add : Right Fields: After : VCH RateUnit: OTSCustomerSchemeAmount

[Field:OTSCustomerSchemeAmount]
Use: Amount Field
Width:10
Storage:OTSSchemeAmount
Invisible: If @@IsSales then No else Yes

[System:UDF]
OTSSchemeAmount:Amount:1234

[#Field: EI Value] ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Change the code as per your requirement in my code the ledger name should contain the word scheme to get the total
SetbyCondition : $LedgerName Contains "Scheme" : $$AsAmount:$$CollAmtTotal:Inventoryentries:$OTSSchemeAmount
Set Always: Yes

After attaching the code you will find one new column Named sch
eme (in my case and as per above code but you can change the name of the column by editing the code).

Step 1 Select the Party ledger.

Step 2 Select the sales ledger (if use common ledger for account allocation is no ).

Step 3 Select the stock Item. Put the Qty, Rate and in then scheme column use the (-) minus sing and put the amount if you don't use the sing it will add it to the invoice amount.

Step 4 After selecting all the items and filling scheme amount were ever you need. Select the Scheme ledger in which you want to post this figure ( Note the Ledger name should contain the word "Scheme" ) in above code case. But it you want something different just edit the code. It will take the total of scheme column and put the total with minus or the plus sing depending what is used.

GST Invoice Customization with Outstanding, GST Analysis Details, Bank Details ( Free TDL Code)

2017-10-01T13:59:00.001+05:30

What is Invoice?

An Invoice is a commercial document issued by businesses to indicate a transaction and request payment for the product or service provided. In today's business world, there are certain expectations around how we talk about money. An invoice is a powerful communication tool that ensures payment in a timely manner, it also makes a good impression on clients and sets the stage for long-term relationships. This Blog gives you the free code so that you can have a beautiful custom invoice design, with outstanding details, bank details printed from within your Tally.ERP9 software.

Before moving ahead please read our previous post How to Attach any Tally.ERP9 Customization to Tally.ERP9 Software so that you can easily attach this code to your Tally.ERP9 software.

You can download the customization file from https://drive.google.com/file/d/0B636Y5AGDeBeNUd3RzN1NVpwSjA/view?usp=sharing

Or Just copy the below code.

Code :--

[#Part: VTYP BehaviourMain]
Option : VTYP BehaveMain OTS VchTypeConfirm : @@IsOTSVchType

[!Part : VTYP BehaveMain OTSVchTypeConfirm]
Add : Line : After : VTYP PrintSave :VTYP OTS VchTypeConfirm

[Line : VTYP OTS VchTypeConfirm]
Field : Long Prompt, Logical Field
Local : Field : Long Prompt : Set as : "Print GST Format ?"
Local : Field : Long Prompt : Width : @@LongWidth
Local : Field : Logical Field : Storage : OTSVchTypeConfirm1

[System : Formula]
IsOTSVchType : $$IsSales:$Parent
IsOTSNewAllow : $OTSVchTypeConfirm1:VoucherType:$VoucherTypeName

[System : UDF]
OTSVchTypeConfirm1 : Logical : 1781

[#Form : Sales Color]
Option: OTSSalesOTS Color: @@IsOTSNewAllow

[!Form:OTSSalesOTS Color]
Delete : Print
Add : Print : STC GST INVOICE OTS

[Report :STC GST INVOICE OTS]
Use : Printed Invoice
Delete: Form : Printed Invoice
Form : STC GST INVOICE OTS

[Line:OTSBlog]
Field: Name Field
Local: Field: Name Field: Set as: "Follow us on :- https://tallyexperttips.blogspot.com/"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Align: Center
Space Top: 1

[Form:STC GST INVOICE OTS]
Space Left: 0.50 Inch
Space Bottom: 0.50 Inch
Space Right: 0.50 Inch
Space Top:0.50 Inch

Part: OTS Opening Page Break, OTS Invoice Body
Bottom Part:OTS GST analisys Bankdetails ledgerentries, OTSInvoiceAmtwordandamount, OTSSingnatureClosingBalanceTerms,OTSJuri;;OTS Invoice Total, OTS Sing Off, OTS Terms, OTS Age, OTS Juridiction

Page Break : ClOTS Page Break, OTS Opening Page Break

[Part:ClOTS Page Break]
Lines : GIOTS ClPgBrk

[Line: GIOTS ClPgBrk]
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

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

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

[Style:P10]
Font:Calibri (Body)
Height:10

[Style:P9B]
Use:P9
Bold: Yes

[Style:P9Bold]
Use: P9
Bold: Yes

[Style: Parth CMP Name]
Font: Adobe Garamond Pro Bold
Height:20
Bold: Yes

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[Part: OTS Opening Page Break]
Part: OTS Invoice Title, OTS CMP Details, OTS Leading Details, OTS Coloumn Titles
Vertical: Yes

[Part:OTS Invoice Title]
Line:OTS Invoice Title

[Line:OTS Invoice Title]
Field: Simple Field
Right Field:Name Field
Local: Field: Simple Field: Set as: "TAX INVOICE"
Local: Field: Simple Field: Style: Large Bold
Local: Field: Simple Field: Space Left: 65
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 TRANSPOTER" Else +
If @@GetCopyNum = 3 Then $$LocaleString:"TRIPLICATE FOR SUPPLIER " Else +
If @@GetCopyNum = 4 Then $$LocaleString:"EXTRA COPY" Else $$LocaleString:"EXTRA COPY"

;;
[Part:OTS CMP Details]
Part: OTS CMP Name Details

[Part: OTS CMP Name Details]
Line: OTS CMP Name, OTS CMP Address, OTS CMP Contact Details

[Line: OTS CMP Name]
Field: Name Field
Local: Field: Name Field: Set as: @@CmpMailName
Local: Field: Name Field: Style:Parth CMP Name
Local: Field: Name Field: Full Width: Yes

[Line:OTS CMP Address]
Field: Name Field
Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style:P9
Local: Field: Name Field: Line:0

[Line:OTS CMP Contact Details]
Field: Medium Prompt, Simple Field, Simple Prompt, Name Field
Local: Field: Medium Prompt: Set as: "Contact No"
Local: Field: Medium Prompt: Style: P9B
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Set as: $PhoneNumber:Company:##SVCurrentCompany +" "+ $MobileNumbers:Company:##SVCurrentCompany
Local: Field: Simple Prompt: Style:P9B
Local: Field: Simple Prompt: Set as: "PAN No."
Local: Field: Simple Prompt: Space Left: 5
Local: Field: Name Field: Style: P9
Local: Field: Name Field: Set as: $IncomeTaxNumber:Company:##SVCurrentCompany

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

[Part:OTS Customer Details]
Line:OTS Customer Details Title, OTS Customer Name, OTS Customer Address, OTS Customer State Name, OTS Customer GST No, OTS Customer Contact
Width: 70% Page

[Line:OTSProductdetails]
Field: Name Field
Local: Field: Name Field: Set as: "Tally Sales & Services, Customization,Integration, Web Developement, Customized Software, Android App Development"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Align: Center
Space Top: 1

[Line:OTS Customer Details Title]
Field: Simple Field
Local: Field: Simple Field : Set as: "Details for Buyer (Billed & Shipped To )"
Local: Field: Simple Field: Style:P9B
Local: Field: Simple Field: Full Width: Yes

[Line:OTS Customer Name]
Field: Simple Field
Local: Field: Simple Field: Set as: @@SimpleOtherPartyName
Local: Field: Simple Field: Style: P9B
Local: Field: Simple Field: Full Width: Yes
Space Top:1

[Line:OTS Customer Address]
Field: Simple Field
Local: Field: Simple Field: Set as: $$FullList:BasicBuyerAddress:$BasicBuyerAddress
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes
Local: Field: Simple Field: Line:0

[Line:OTS Customer State Name]
Field: Simple Field
Local: Field: Simple Field: Set as: "State Name"+" : "+ $StateName +" "+ "Code :"+" "+ $$getgststatecode:@StateName
Local: Field: Simple Field: Local Formula:StateName : If NOT ($$IsEmpty:$StateName OR $$IsSysName:NotApplicable:$StateName) Then $StateName Else $LedStateName:Ledger:@PartyName
Local: Field: Simple Field: Full Width: Yes
Local: Field: Simple Field: Style: P9

[Line:OTS 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: P9

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

[Part:OTS Invoice Details]
Line: OTS Invoice No, OTS Invoice Date, OTS PO No,OTS PO Date, OTS DC No, OTS DC Date
Width: 30% Page
Border: Thin Left

[Line:OTS Invoice No]
Field: Medium Prompt,Simple Field
Local: Field: Medium Prompt: Set as: "Invoice No"
Local: Field: Medium Prompt: Style: P9B
Local: Field: Medium Prompt: Width: 15
Local: Field: Simple Field: Set as: $VoucherNumber
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes
Space Top:1

[Line:OTS Invoice Date]
Field: Medium Prompt, Simple Field
Local: Field: Medium Prompt: Set as: "Dated"
Local: Field: Medium Prompt: Style: P9B
Local: Field: Medium Prompt: Width: 15
Local: Field: Simple Field: Set as: $Date
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes

[Line:OTS PO No]
Field: Medium Prompt, Simple Field
Local: Field: Medium Prompt: Set as: "PO No."
Local: Field: Medium Prompt: Style: P9B
Local: Field: Medium Prompt: Width: 15
Local: Field: Simple Field: Set as: $BasicPurchaseOrderNo
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes

[Line:OTS PO Date]
Field: Medium Prompt, Simple Field
Local: Field: Medium Prompt: Set as: "PO Date."
Local: Field: Medium Prompt: Style: P9B
Local: Field: Medium Prompt: Width: 15
Local: Field: Simple Field: Set as: $BasicOrderDate
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes

[Line:OTS DC No]
Field: Medium Prompt, Simple Field
Local: Field: Medium Prompt: Set as: "Delivery Challan No"
Local: Field: Medium Prompt: Style: P9B
Local: Field: Medium Prompt: Width: 15
Local: Field: Simple Field: Set as: $BasicShipDeliveryNote
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes

[Line:OTS DC Date]
Field: Medium Prompt, Simple Field
Local: Field: Medium Prompt: Set as: "Delivery Challan Date"
Local: Field: Medium Prompt: Style: P9B
Local: Field: Medium Prompt: Width: 15
Local: Field: Simple Field: Set as:$BasicShippingDate
Local: Field: Simple Field: Style: P9
Local: Field: Simple Field: Full Width: Yes

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[Part:OTS Coloumn Titles]
Line:OTS Invoice Body Title,OTS Invoice Body Title1
Border: Thick Cover
Common Border: Yes

[Part: OTS Invoice Body]
Part:OTS Invoice Body Coloumns
Vertical: Yes
Border: Thin Cover

[Part:OTS Invoice Body Title]
Line:OTS Invoice Body Title,OTS Invoice Body Title1
Common Border: Yes

[Line:OTS Invoice Body Title]
Use: OTS Invoice Body Coloumns

Local: Field: Default: Type: String
Local: Field: Default: Style: P9B
Local: Field: Default: Align: Center

Local: Field:OTS SrNo: Set as: "Sr "
Local: Field:OTS Item Description: Set as: "Item"

Local: Field:OTS HSN Code: Set as: "HSN "

Local: Field:OTS Billed Qty: Set as: "Billed"
Local: Field: OTS Rate: Set as: "Rate"
Local: Field:OTS Discount: Set as: "Dis"
Local: Field:OTS Gross Amt: Set as: "Gross"
Local: Field:OTS GST Per: Set as: "GST"
Local: Field:OTS CGST Rate: Set as: "CGST"
Local: Field: OTS CGST Amt: Set as: "CGST"
Local: Field:OTS SGST Rate: Set as: "SGST"
Local: Field:OTS SGST Amt: Set as: "SGST "
Local: Field:OTS IGST Rate: Set as: "IGST"
Local: Field:OTS IGST Amount: Set as: "IGST"
Local: Field:OTS Item Total: Set as: "Total"

Border: Thin Top
Space Top: 0.25

[Line:OTS Invoice Body Title1]
Use: OTS Invoice Body Coloumns

Local: Field: Default: Type: String
Local: Field: Default: Style: P9B
Local: Field: Default: Align: Center

Local: Field:OTS SrNo: Set as: "No"
Local: Field:OTS Item Description: Set as: "Description"

Local: Field:OTS HSN Code: Set as: "Code"

Local: Field:OTS Billed Qty: Set as: "Qty"
Local: Field: OTS Rate: Set as: ""
Local: Field:OTS Discount: Set as: "%"
Local: Field:OTS Gross Amt: Set as: "Amount"
Local: Field:OTS GST Per: Set as: "%"
Local: Field:OTS CGST Rate: Set as: "%"
Local: Field: OTS CGST Amt: Set as: "Amt"
Local: Field:OTS SGST Rate: Set as: "%"
Local: Field:OTS SGST Amt: Set as: "Amt"
Local: Field:OTS IGST Rate: Set as: "%"
Local: Field:OTS IGST Amount: Set as: "Amt"
Local: Field:OTS Item Total: Set as: ""

Border: Thin Bottom
Space Bottom: 0.25

[Part:OTS Invoice Body Coloumns]
Line:OTS Invoice Body Coloumns
Repeat:OTS Invoice Body Coloumns:Inventory Entries
Scroll: Vertical
Float: No
Common Border: Yes

[Line:OTS Invoice Body Coloumns]
Left Field: OTS SrNo, OTS Item Description
Right Field: OTS HSN Code,OTS Billed Qty, OTS Rate, OTS Discount, OTS Gross Amt, OTS GST Per,OTS CGST Rate, OTS CGST Amt, OTS SGST Rate, OTS SGST Amt,OTS IGST Rate, OTS IGST Amount, OTS Item Total
Space Top: 0.15
Explode : EI DescExplosion : NOT $$IsEmpty:$StockItemName AND ##PRNWithItemDesc AND NOT $$IsEmpty:$BasicUserDescription
Local: Field:OTS SrNo: Width: 3

Local: Field:OTS HSN Code: Width: 7

Local: Field:OTS Billed Qty: Width: 7
Local: Field: OTS Rate: Width: 7
Local: Field:OTS Discount: Width: 3
Local: Field:OTS Gross Amt: Width: 7
Local: Field:OTS GST Per: Width: 3
Local: Field:OTS CGST Rate: Width: 3
Local: Field: OTS CGST Amt: Width: 7
Local: Field:OTS SGST Rate: Width: 3
Local: Field:OTS SGST Amt: Width: 7
Local: Field:OTS IGST Rate: Width:3
Local: Field:OTS IGST Amount: Width:7
Local: Field:OTS Item Total: Width: 8

Local: Field:OTS SrNo: Border: Thin Right
Local: Field:OTS Part No: Border: Thin Left
Local: Field:OTS HSN Code: Border: Thin Left
Local: Field:OTS MRP Qty: Border: Thin Left
Local: Field:OTS Shipped:Border: Thin Left
Local: Field:OTS Billed Qty: Border: Thin Left
Local: Field: OTS Rate: Border: Thin Left
Local: Field:OTS Discount: Border: Thin Left
Local: Field:OTS Gross Amt: Border: Thin Left
Local: Field:OTS GST Per: Border: Thin Left
Local: Field:OTS CGST Rate: Border: Thin Left
Local: Field: OTS CGST Amt: Border: Thin Left
Local: Field:OTS SGST Rate: Border: Thin Left
Local: Field:OTS SGST Amt: Border: Thin Left
Local: Field:OTS IGST Rate: Border: Thin Left
Local: Field:OTS IGST Amount: Border: Thin Left
Local: Field:OTS Item Total: Border: Thin Left

[Field: OTS Sr NO]
Use: Simple Field
Set as: $$Line
Format: "No Zero"
Style:P9
Align: Center

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

[Field:OTS HSN Code]
Use: Simple Field
Set as: $$GetGSTItemDetails:$StockItemName:$date:"HSNCode":0:"StockItem";$VJSTKIHSNCode:StockItem:$StockItemName
Style:P9

[Field:OTS Billed Qty]
Use: Qty Primary Field
Set as: $BilledQty
Style:P9

[Field:OTS Rate]
Use: Rate Price Field
Set as: $Rate
Style:P9

[Field:OTS Discount]
Use: Number Field
Set as: ""
Set as: $Discount
Format : "NoZero,Percentage"
Style:P9

[Field:OTS Gross Amt]
Use:Amount Forex Field
Set as: $Amount
Style:P9

[Field:OTS GST Per]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx
Format : "NoZero,Percentage"
Set Always: Yes
Style:P9

[Field:OTS CGST Rate]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx /2
Format : "NoZero,Percentage"
Set Always: Yes
Style:P9
Invisible: If @@IGST > 0 then yes else no

[Field:OTS CGST Amt]
Use: Amount Field
Set as: $Amount * #OTSCGSTRate / 100
Style:P9
Set Always: Yes
Invisible: If @@IGST > 0 then yes else no

[Field:OTS SGST Rate]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx /2
Format : "NoZero,Percentage"
Set Always: Yes
Style:P9
Invisible: If @@IGST > 0 then yes else no

[Field:OTS SGST Amt]
Use: Amount Field
Set as: $Amount * #OTSSGSTRate / 100
Style:P9
Set Always: Yes
Invisible: If @@IGST > 0 then yes else no

[Field:OTS IGST Rate]
Use: Number Field
Set as: If NOT $GSTIsTransLedEx Then "" Else $GSTClsfnIGSTRateEx
Format : "NoZero,Percentage"
Set Always: Yes
Style:P9
Invisible: If @@SGST > 0 then yes else no

[Field:OTS IGST Amount]
Use: Amount Field
Set as: $Amount * #OTSIGSTRate / 100
Style:P9
Set Always: Yes
Invisible: If @@SGST > 0 then Yes else no

[Field:OTS Item Total]
Use: Amount Field
Set as: #OTSGrossAmt + #OTSCGSTAmt + #OTSSGSTAmt
Set Always: Yes
Style:P9

[Line:OTS Invoice Body Coloumns Total]
Use: OTS Invoice Body Coloumns

Local: Field: Default: Type: String
Local: Field: Default: Style: P9B
Local: Field: Default: Align: Center

Local: Field:OTS SrNo: Set as: ""
Local: Field:OTS Item Description: Set as: "TOTAL"
Local: Field:OTS HSN Code: Set as: ""
Local: Field:OTS MRP Qty: Set as: ""
Local: Field:OTS Billed Qty: Set as: ""
Local: Field: OTS Rate: Set as: ""
Local: Field:OTS Discount: Set as: ""
Local: Field:OTS Gross Amt: Set as: $$CollAmtTotal:InventoryEntries:$Amount
Local: Field:OTS GST Per: Set as: ""
Local: Field:OTS CGST Rate: Set as: ""
Local: Field: OTS CGST Amt: Set as: $$FilterAmtTotal:LedgerEntries:CGST1:$Amount
Local: Field:OTS SGST Rate: Set as: ""
Local: Field:OTS SGST Amt: Set as: $$FilterAmtTotal:LedgerEntries:SGST1:$Amount

Local: Field:OTS Item Total: Set as: $Amount
Border: Thin Top Bottom
Space Bottom: 0.25
Space Top: 0.25

[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:OTS GST analisys Bankdetails ledgerentries]
Left Part:VCH GST AnalysisDetails
Right Part: OTSBankDetails, OTSLedgerEnteries
Border: Thick Cover
Common Border:Yes

[#Part:VCH GST AnalysisDetails]
Delete:Border : Thin Box

[#Part:VCH GST AnalysisDetails]
Width:50% Page

[Part:OTSBankDetails]
Use:EXPINV BankDetails
Border: Thick Left

[#Line: EXPINV BankTitle]

Fields : Simple Field
Local : Field : Simple Field : Set as : $$LocaleString:"Company's Bank Details" ;;; To Display Company's Bank Details
Local : Field : Simple Field : Full Width: Yes
Local : Field : Simple Field : Style:P9B
Space Top:0.5
Space Bottom:0.25

[#Line: EXPINV BankName]

Fields : Medium Prompt, EXPINV BankName
Local : Field : Medium Prompt : Set as : $$LocaleString:"Bank Name :" ;;; To Display Bank Name
Local : Field : Medium Prompt : Width : 18% Page
Local : Field : Medium Prompt : Style:P9B
Local : Field:EXPINV BankName:Style:P9

[#Line: EXPINV BankAccNo]

Fields : Medium Prompt, EXPINV BankAccountNo
Local : Field : Medium Prompt : Set as : $$LocaleString:"A/c No. :" ;;; To Display A/c No.
Local : Field : Medium Prompt : Width : 18% Page
Local : Field : Medium Prompt : Style:P9B
Local : Field:EXPINV BankAccountNo:Style:P9

[#Line: EXPINV BankBranchInfo]

Fields : Medium Prompt, EXPINV BankBranchName
Local : Field : Medium Prompt : Set as : $$LocaleString:"Branch & IFS Code :" ;;; To Display Branch & IFS Code
Local : Field : Medium Prompt : Width : 18% Page
Local : Field : Medium Prompt : Style:P9B
Local : Field:EXPINV BankBranchName:Style:P9

[Part:OTSLedgerEnteries]
Line:OTSLedgerEnteries
Repeat:OTSLedgerEnteries:Ledger Entries
Border: Thick Left
Common Border: Yes
;Scroll: Vertical
Float: No

[Line:OTSLedgerEnteries]
Field: OTSLedgerName, OTSLedgerPercentage,OTSPercentageSing, OTSLedgerAmount
Remove if: $LedgerName = $PartyLedgerName

[Field:OTSLedgerName]
Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS then $$LocaleString:"TCS : Income Tax" else +
if NOT $$IsSysName:$LedgerName then $LedgerName else "" ;;; used to print on invoice

Style:P9B
Align : Right
FullWidth : Yes
AbatementVal: If $$Number:$STXAbatementRate = 0 Then $$String:"0" Else $$String:$STXAbatementRate
LedNarr : (@@IsSales AND ##SALedgerNarr) OR (@@IsPurchase AND ##PULedgerNarr) AND $$Filtercount:LedgerEntries:LedgerNarrFltr > 0
Option : LeftAlignField : @@AcctsInvoice
Width:8.7

[Field:OTSLedgerPercentage]
Use : Rate Price Field
Type : Number
Align : Right
Format : "NoZero,Decimals:-1"
Style:P9
Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS AND NOT $$IsSysName:$TDSRateName:Ledger:$LedgerName then @@TCSITTaxRate else +
$BasicRateOfInvoiceTax
Inactive : $$IsSysName:$LedgerName
Invisible : NOT @@InvWithRate
Border: Thick Left
Width: 4

[Field:OTSPercentageSing]
Set as:if $$IsEmpty:$BasicRateOfInvoiceTax then "" else "%"
Set By Condition : @@TaxLedgerHasTCS AND NOT ($$IsSysName:$TDSRateName:Ledger:$LedgerName) : If $$IsEmpty:@@TCSITTaxRate Then "" Else "%"
Inactive : $$IsSysName:$LedgerName
Invisible : NOT @@InvWithRate
Width: 2
Style:P9

[Field:OTSLedgerAmount]
Use : Amount Forex Field
Set as : $$SignedAmount:$Amount:@@VchOpposite
Border: Thick Left
Align: Right
Width: 8
Style:P9

[Part:OTSInvoiceAmtwordandamount]
Left Part: OTSAmountinWord
Right Part:OTSInvoiceAmount
Border: Thick Cover
Common Border: Yes

[Part:OTSAmountinWord]
Line:OTSAmountinWord

[Line:OTSAmountinWord]
Field: Medium Prompt, Name Field
Local: Field: Medium Prompt: Set as: "Amount In Words"
Local: Field: Medium Prompt:Style:P9B
Local: Field: Name Field: Set as:$$InWords:$Amount +" "+ "Only."
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Line:0
Local: Field: Name Field:Style:P9
Space Top:0.25
Space Bottom:0.25

[Part:OTSInvoiceAmount]
Line:OTSInvoiceAmount

[Line:OTSInvoiceAmount]
Field: Name Field, Amount Field
Local: Field: Name Field: Set as: "Invoice Total"
Local: Field: Name Field: Border: Thick Left
Local: Field: Name Field: Width:26.5
Local: Field: Name Field: Align: Right
Local: Field: Name Field: Style:P9B
Local: Field: Amount Field: Set as: $Amount
Local: Field: Amount Field: Width:8
Local: Field: Amount Field: Border: Thick Left
Local: Field: Amount Field: Style:P9B
Space Top:0.25
Space Bottom:0.25

[Part:OTSSingnatureClosingBalanceTerms]
Left Part: OTSTermsandClosing
Right Part: OTSCustomer Signature, OTSSignature
Border:Thick Box

[Part:OTSTermsandClosing]
Part: OTSTermsPart, OTSClosing
Vertical:Yes
Width:50% Page

[Part:OTSTermsPart]
Line:OTSTermsPart
Border: Thick Bottom

[Line:OTSTermsPart]
Field: Name Field
Local: Field: Name Field:Set as: "GOODS ONCE SOLD WILL NOT BE TAKEN BACK OR EXCHANGED"
Local: Field: Name Field: Style: P9B
Local: Field: Name Field: Align: Center
Local: Field: Name Field: Full Width: Yes

[Part:OTSClosing]
Line: OTSOutStandingDetailsTitle, OTSPreviuosOutstandingBalance, OTSCurrentInvoice, OTSTotalOutStanding

[Line:OTSOutStandingDetailsTitle]
Field:Name Field
Local: Field: Name Field: Set as: "Outstanding Details"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style:P9B
Space Top:0.5

[Line:OTSPreviuosOutstandingBalance]
Field: Medium Prompt, Amount Field
Local: Field: Medium Prompt: Set as:"Previous Outstanding"
Local: Field: Medium Prompt: Style:P9B
Local: Field: Amount Field: Set as:$$ToValue:($date-1):$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries
Local: Field: Amount Field:Style:P9

[Line:OTSCurrentInvoice]
Field: Medium Prompt, Amount Field
Local: Field: Medium Prompt: Set as:"Current Invoice"
Local: Field: Medium Prompt: Style:P9B
Local: Field: Amount Field: Set as:$Amount
Local: Field: Amount Field:Style:P9

[Line:OTSTotalOutStanding]
Field: Medium Prompt, Amount Field
Local: Field: Medium Prompt: Set as:"Total Outstanding"
Local: Field: Medium Prompt: Style:P9B
Local: Field: Amount Field: Set as:$$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries
Local: Field: Amount Field:Style:P9

[Part:OTSCustomer Signature]
Line: For OTSCustomer Signature, OTSAcceptance
Border: Thick Left

[Line:For OTSCustomer Signature]
Field: Name Field
Local: Field: Name Field: Set as: "For" +" "+ @@SimpleOtherPartyName
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style: P9B
Local: Field: Name Field: Align: Center
Space Top:0.5

[Line:OTSAcceptance]
Field: Name Field
Local: Field: Name Field: Set as: "I received goods in good condition and I have read the terms & condition. I agree with it."
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style: P9
Local: Field: Name Field: Line:0
Space Top:3

[Part:OTSSignature]
Line: ForOTSSignature, OTSAuthorised
Border: Thick Left
Width:36.5

[Line:ForOTSSignature]
Field: Name Field
Local: Field: Name Field: Set as: "For" +" "+ @@CmpMailName
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style: P9B
Local: Field: Name Field: Align: Center
Space Top:0.5

[Line:OTSAuthorised]
Field: Name Field
Local: Field: Name Field: Set as: "Proprietor/Manager"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Style: P9B
Local: Field: Name Field: Align: Center
Space Top:3

[Part:OTSJuri]
Line:OTS Juridiction

[Line:OTS Juridiction]
Field: Name Field
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Set as: "SUBJECT TO NASHIK JURISDICTION"
Local: Field: Name Field: Align: Center

[#Menu:GatewayofTally]
Add: Key Item: For Support :F:Display:For Support

[Report:For Support]
Form:For Support

[Form:For Support]
Part:OTSName
Width: 100% Page
Height: 50% Page
Background: White

[Part:OTSName]
Line:OTSName, OTSProductdetails, OTSContactdetails,OTSBlog

[Line:OTSName]
Field: Name Field
Local: Field: Name Field: Set as: "One Touch Solution"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Align: Center
Space Top: 3

[Line:OTSContactdetails]
Field: Name Field
Local: Field: Name Field: Set as: "Mobile:- +91-9822444696 email :- enquiry@onetouchsolution.co.in website:- http://onetouchsolution.co.in"
Local: Field: Name Field: Full Width: Yes
Local: Field: Name Field: Align: Center
Space Top: 1

Note:- This code is written for Print invoice in A4 Landscape mode. You will need to do the required settings in your printer for better view. There might be some case were alignment might not come proper this is because of printer and you will need to write code for alignment.

How to Start Tally.ERP9 Application/Software in Developer Mode

2017-10-01T11:35:00.000+05:30

In my Last blog you have learnt basic structure of Tally Developer Language which is also know as TDL. And as Promised in Last blog we will be learning some simple steps About how to start Tally.ERP9 Software/Application in Developer mode.

So before this you should know the path of Tally.ERP9 application were it is installed.

In my case it is installed at D:\Tally.ERP9.

If you don't know were it is installed just right click on the Tally.ERP9 icon on your desktop and select open file location option and it will open up the folder were the Tally.ERP9 software is installed and you can copy the path of installation from the address bar.

So once you know the path just press windows key on your keyboard + R. or open run from Start menu -> Accessories-> Run

As soon as Run is Started paste the complete path (in my case) D:\Tally.ERP9\tally.exe with space and word /devmode so that it should look like below.

and then click on OK. And your Tally.ERP9 software should start but this time it will be in developer mode.

And will look like below

So now you have your Tally.ERP9 Software running in developer mode and you can now easily know the names used by Tally Solutions Pvt Ltd Company for Field using which we can easily navigate to the line in which it is and then the part and then the report.

For Example lets take a example of Ledger name on Sales voucher Screen.

Step 1. Open your Tally in Developer mode using Above steps.

Step 2. Open the your Data.

Step 3. Go to Accounting Voucher->Sales or Press F8.

Step 4. Just take your mouse over the field of which you want to know the name. In our case ledger name on sales screen.

Step 5. It as soon as you take your mouse over the field it will show its real name used for development. like below

In above example the real name of the field is EI Consignee which is used for development purpose. In this why you can know real names of each and every field of Tally.ERP9 Software and use it in and for your development.

Learn Tally Developer Language (TDL, Tally Customization)

2017-09-22T23:18:00.000+05:30

What is Tally Developer Language

Tally Definition Language is the application development language of Tally. The user interface of Tally.ERP 9 and Tally.Server 9 is built using TDL. Tally.Developer 9 is a comprehensive development environment that is designed to enable a TDL programmer to develop, build, and deploy solutions for Tally.ERP 9.

Tally.Developer 9 application which is used and helpful to develop Tally Customizations can be downloaded from https://tallysolutions.com/tally-developer9/

This application can be used in 3 modes.

1. Licensed mode :- Were we can develop or code compile it to our customer's serial numbers. So that the code is encrypted and cannot be used by anyone else apart from you and use customer (That too on the specified Tally.ERP9 Serial no. on which it is compiled). You code is encrypted and cannot be viewed without de-compiling it which can be only done by the person who has compiled it. Even Tally Solutions Pvt Ltd. cannot de-compile it. And in the mode you get technical support from Tally Solutions Pvt Ltd but no Educational support which mean Tally Solutions Pvt Ltd will not tech you how to write code.

2. Educational mode:- In this mode you can develop your code, you can attach this code to any Tally.ERP9 but you cannot compile it. So you code is open to the world and anyone can use it. In Educational mode there is no support from Tally Solutions Pvt Ltd.

3. Evaluation Mode:- This mode is as good as Educational mode as you cannot compile your code. But you get the evaluation license free of cost. In which Tally Solutions Pvt Ltd gives you Technical Support and again Tally Solutions Pvt Ltd does not tech you how to write code.

So here we are going to learn some simple and useful tdl code writing step by step and in various posts.

Note :- It is assumed that you have downloaded Tally.Developer9 application from https://tallysolutions.com/tally-developer9/ and it is running on your system in any one of the modes. If you are note comfortable with Tally.Developer9 you can also write your code in simple Notepad or Wordpad in you system.

Session 1.

What is the Basic Structure of Tally Development Language ?

Tally codes has to be written in a particular structure format only other wise your code with not get attached to Tally.ERP9 software and will give error. so below is the structure of TDL

[#Menu: Gateway of Tally]

Item: First TDL: Display : My Report

[Report : My Report]

Form : My Form

[Form : My Form]

Part : My Part

[Part: My Part]

Line : My Line

[Line : My Line]

Field: My Field

[Field: My Field]

Set as: "My First TDL"

You can attach the above code in your Tally.ERP9 application by following simple steps given in http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

You will find that a new option will be seen on your main screen of your Tally.ERP9 software after Opening up your Tally Data. That main screen is also called as Gateway of Tally.

The new option name will be My Report which we have provided in your code

[#Menu: Gateway of Tally]

Item: First TDL: Display : My Report

When you select that option it will show you the REPORT with a FORM in which there is PART with a LINE which contains FIELD containing My First TDL.

So I believe that you have understood the basic structure of TDL.

In Tally.ERP9 each options on the screen are or can be called MENU which can have SUB Menus or Report. REPORT have FORM.

FORM can have SUB FORMS or MULTIPLE PARTS.

PARTS can have SUB PARTS or MULTIPLE LINES.

LINES can have MULTIPLE FIELDS

FIELDS are in which DATA can be Punched, Viewed, Or Edited.

Note :- I am trying to write this Blog in the simplest language in which i can if you have any queries or if you do not understand you can simply post your queries or leave you email i will get back to you as soon as possible.

In Next Post I will tech now to use Tally.ERP9 in Developer mode so that we can come to know what are the name used or given by Tally Solution Pvt Ltd to there fields and How to use Tally.Developer 9 application and its benefits.

Email directly from Tally.ERP9 Software (Free TDL / Tally.ERP 9 Customization

2017-09-19T11:08:00.002+05:30

Most of us does not know that Tally.ERP9 has a In-build Feature were you can email any thing directly from Tally.ERP9 Software. Any by following simple below given steps you can achieve the same.

Open you Tally.ERP9 Software.
Open the Data in which you want to setup the Emailing Feature.
Press F12 and there you will find option E-Mailing.

Select the E-Mailing option.

You will be taken to above screen. Do the appropriate settings here so that Tally.ERP9 can connect to your email server and send email. Bu default Tally Company have given settings for Gmail, Hotmail and Yahoo Mail as you can see in drop down list.
After doing all the above setting you can send email from within Tally.ERP9 software of almost any voucher or report.

To Get Prompt of sending email after saving any voucher please add the below code and attached it to your Tally.ERP9 Software.

[#Part: VTYP BehaviourMain]

Add : Line : After : VTYP PrintSave : VCS_VTYP EmailSave

[Line: VCS_VTYP EmailSave]

Fields : Long Prompt, VCS_VTYP EmailSave
Local : Field : Long Prompt : Info : $$LocaleString:"Email after saving Voucher ?"
Local : Field : Long Prompt : Width : @@LongWidth

[Field: VCS_VTYP EmailSave]

Use : Logical Field
Storage : VCS_EmailAfterSave
Set always : Yes

[System: UDF]

VCS_EmailAfterSave : Logical : 1500

[#Form: Voucher]

On : FormAccept : @@VCS_VTYPVCS_EmailAfterSave : Mail Report

[System: Formula]

VCS_VTYPVCS_EmailAfterSave : $VCS_EmailAfterSave:VoucherType:##SVVoucherType

Copy this code to the notepad and save it. To attach this code in Tally.ERP 9 Software please follow the instruction on http://tallyexperttips.blogspot.in/2017/09/how-to-attach-any-tallyerp9.html

After attaching this code you will need to enable emailing in voucher type. by following below steps.

Step. 1 Open Tally.ERP9 Software.
Step. 2 Open Data in which you want to use the above customization.
Step. 3 Go to Accounts Info -> Voucher Type-> Alter.
Step. 4 Select the voucher type to which you want to get email prompt.
Step. 5 You will find one new option Email after saving Voucher turn that to yes and now it will prompt you to send email after saving voucher.

How to Attach any Tally.ERP9 Customization to Tally.ERP9 Software

2017-09-18T11:10:00.001+05:30

This Post will guide you how to attached Tally.ERP9 Customization to Tally.ERP9 Software (Locally)

Step 1. Open Tally.ERP9 Software.

Step 2. Press F12 and go to Product and Features Option.

Step 3. Press F4 Manage Local TDL

Step 4. Provide complete path of the tdl file with its extension as shown below.

Note:- Tally.ERP9 Software accepts the customization files with extension .txt, .tdl, .tcp

.txt or .tdl file extension are the file which can easily be edited in Notepad, Word pad, or Tally Developer Software.
.tcp file extension file are the compiled file and can only be edited by the person using the account that file was complied.

After Completing above steps you should be able to see below information in your Tally.ERP9.

If you see the Above screen it means that you have successfully attached the customization to Tally.ERP9 Software

Disable / De-activate Stock Item from List (Free Tally.ERP9 TDL)

2017-09-15T23:09:00.000+05:30

There are lot of time you cannot delete Stock Item which are already used in voucher from Tally.ERP 9 software and you want to remove that Stock Item from the list so that it is not wrongly selected during entry.

And there comes the need to Disable or De-activate that stock item from the list. Below code will help you in doing so.

Step 1. Copy the below code and past it in Notepad and save it.

Note: Files extensions which can be attached to Tally.ERP9 software are .tcp , .tdl, .txt

[#Part: STKI Basic Features]
Add:part:After:STKI Batch:STKI Control

[Part:Stki Control]
Line:Stki Control

[Line:STKI Control]
Field:Stki Control,Stki Control1

[Field:Stki Control]
Use:name Field
Info:"De-Activate this Stock Item ?"
Width: 22
Background: Yellow

[Field:Stki Control1]
Use : Logical Field
Storage :isStockITEMcontrol
Set As : Yes
Set Always : Yes

[System:udf]
isStockITEMcontrol:Logical:3015

[System:Formula]
USEDStockitem:Not $isStockITEMcontrol

[#Collection: Vch Stock Item Extract]
Filter: usedstockitem

[#Collection: List of POSStockItems]
Filter: usedstockitem

Step 2. Open your Tally.ERP9 Software And Press F12 on your key board.

Step 3. Go to Product and Features

Step 4. Press F4 to manage local tdl

Step 5. Provide Full Path of the code file which you have saved in Step 1

Note: Files extensions which can be attached to Tally.ERP9 software are .tcp , .tdl, .txt

Step 6. If you see tdl loaded on below screen it mean you have successfully attached the code.

Step 7. Open your company in which you want to disable or de-activate Stock Item.

Step 8. At Gateway of Tally Screen ( Main Screen after opening Tally.ERP9 Software). Go to Inventory Info.

Step 9. Select Stock Item then select Alter then from the drop-down list select the stock item which you want to disable/de-activate.

Step 10. You will find one new option "De-Activate this Stock Item ?" turn that option to YES and your stock item will get disabled from Tally.ERP9 software.

Note:- By doing this you are only hiding the stock item from the list but it will be there in your

Tally Data. And all the Data related to it will still be there.

To Actually delete that stock item from your Tally Data you will need to delete all the voucher related to that stock item which you want to delete

Edit those voucher and select different Item in place of that stock item and then Tally.ERP9 software will allow you to delete that Stock Item.

How to auto back up your Tally.ERP9 or any data using Cobian Backup?

2017-09-15T16:19:00.002+05:30

Cobian Backup is a simplified approach to back up and restore your data in a scheduled manner. You can connect the application to a domain or a local system account and schedule the execution of the backup process as per your set up.

The following is the detailed procedure for installing and setting up Cobian Backup.

Step 1: Downloading Cobian application

Click here to download the application. The whole setup is around 18.7 MB. Save the .exe in any of the local drives.

Step 2: Installing Cobian application

1. Double-click cbSetup.exe, and click Run.

2. In the setup window, click Next.

3. Click I accept the conditions, and then click Next.

4. Type or locate the installation path, and click Next.

5. Under installation type select As a service.

6. Under service options:

● If you are on a domain, select Use a regular account and provide your Username and Password to prevent any Domain controller restrictions.

● If it is a stand-alone PC, select Use Local System account.

7. Click Next.

8. Click Yes to continue.

9. Click Install.

10. Once installation process is complete, click Done.

Step 3: Setting up backup

1. Open the application.

2. Click Task and select New task or press Ctrl+A.

3. Under the General tab, enter Task name (for example, Backup001) and click Files.

4. Under Source, click Add, select Files, directory, FTP or manual from the list. Select the folder where Tally data is saved; for example, C:\Tally.ERP9\Data.

5. Click Destination and select the path where the data needs to be saved. Select any existing folder or create a new folder, and click OK.

6. Click the Schedule tab.

You can schedule the frequency of the backup with different intervals. Choose the schedule depending up on the updates you need.

7. Click the Dynamics tab.

Select number of backups you need under Full copies to keep. For instance if you backup daily, you can keep last 3 backups – but again it depends upon your need.

8. Click the Archive tab.

Select the compression type; that is, you can use Zip, 7zip, or No compression.

Note: 7zip provides better compression.

You can encrypt files up to AES 256 bits.

9. Click the Filter tab.

You need to filter the choice; that is, a specific set of files, File size, Date Modified, and so on.

You can exclude files (*.tsf) from scheduled backup. User can continue accessing the data during the backup process.

10. Click Add and browse for .tsf files from Tally Data folder. Next, click OK.

Note: During Backup process no need to stop working on Tally Since the tsf files are already excluded

11. Click the Advanced tab and enable required options as per your need.

12. Click OK.

As per the scheduled time, day and date, backup will take automatically. Cobian application shows the backup status and backup size as shown below:

Backup taken from Cobian application to the destination location will appear as shown below.

13. In order to restore the data, right-click the data backup (taken from Cobian application), and then click 7-Zip > Extract here.

The data is extracted in the folder with the same naming convention used in Tally.ERP9 (for example, 10000, 10001).

How to Correct GSTR-3B?

2017-09-14T16:53:00.003+05:30

The deadline for filing the first GST return, the Form GSTR-3B ended last month on dates August, 25 and August, 28, 2017. Yet, there are many businesses which are still in the process of filing Form GSTR-3B. This being the first GST return and understating the plight of the businesses, the committee has decided to waive the late fee for all the businesses who could not file GSTR-3B for the month of July 2017. However, for late payment, an interest at maximum of 18% will be levied.

Form GSTR-3B is the first return, some mistakes or errors are expected in its filing process. Few examples are listed below.

“I missed out on adding some outward supplies before arriving at my Outward Supplies Summary and thereby shown less tax liability. How can this be corrected?”
“I skipped adding tax liability on account of inward supplies liable for reverse charging.”
“ITC is declared less in Table 4 of Form GSTR-3B.”
“There is excess claim since I missed out to reverse the ITC.”…. and so on.

No matter what the reason for mistakes, the important question is – “How to correct GSTR-3B?” How to change the details in GST-3B?

No concept of revised return in GST

Businesses need to take note of the fact that under GST, there is no concept of revised return, whether for Form GSTR-3B or your regular return which you will be filing from September onwards. This means, once you have submitted the return in the GSTN portal, you cannot modify it. The same holds good for Form GSTR-3B as well. As long as the form is in save mode (before submitting), details can be modified and corrected, but not after submitting it.

How to correct GSTR-3B?

You need not worry about this!

As you know, the Form GSTR-3B is only an interim return and the actual return for July needs to be filed in Form GSTR-1 by 10 October; Form GSTR-2 by 31 October ; and Form GSTR-3 by 10 November, 2017 (revised dates). Therefore, any correction in GSTR-3B have to be reported in Form GSTR-1 and Form GSTR-2.
Any correction related to outward supplies has to be reported in Form GSTR-1. Outward supplies might have been under-reported or excess reported in FORM GSTR-3B, both of which need to be correctly reported when filing Form GSTR-1.

Similarly, any correction towards the eligible ITC, tax liability of inward supplies liable for reverse charge; or any other correction in the details of inward supplies submitted in the Form GSTR-3B, need to be reported in Form GSTR-2.

Based on the correct details declared in the Form GSTR-1 and Form GSTR-2, the revised tax liability and eligible ITC will reflect your e-ledger. Also, these details will get auto-populated in Form GSTR-3 of July 2017.

View HSN code of Stock Item During Entry ( Free Tally.ERP9 TDL)

2017-09-12T17:24:00.000+05:30

To View HSN code of the stock Item during Sale or Purchase Entry. Please follow the below steps.

Just copy the below code and paste it to the notepad file and save the file with .tdl or txt extension and follow the below steps.

[#Line : EI Column One]
Add : Right Field: At Beginning:OTSHSNCode

[Field:OTSHSNCode]
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:OTSHSNCodeNo

[Field:OTSHSNCodeNo]
Use: Name Field
Set as: $$GetGSTItemDetails:$StockItemName:$date:"HSNCode":0:"StockItem"
Width:10
Align: Center
Set Always: Yes
Skip: Yes

Step 1. Open Tally.ERP9 Software.

Step 2. Press F12 and go to Product and Features Option.

Step 3. Press F4.

Step 4. Provide complete path of the tdl file with its extension as shown below.

.

After Completing above steps you should be able to see below information in your Tally.ERP9.

This means that your customization is successfully attached now you can go to sales or purchase screen and you will find one new column which will automatically show the HSN code on Item selection.

Note:- This has being tested on Release 6.1 and HSN code were provided at stock item Level

Reverse Charge for Inward Supply of Services

2017-09-12T11:54:00.000+05:30

To record a purchase entry

1. Go to Gateway of Tally > Accounting Vouchers > F9: Purchase.

2. Enter the details as required.

3. Click A: Tax Analysis > F1: Detailed to view the detailed Tax Analysis report that displays the reverse charge amount.

4. Press Escape (Esc) to go back to the purchase voucher.

5. Press Ctrl+A to save.

Recording a journal voucher to raise the tax liability

To record a journal voucher to raise the liability

1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal.

2. Click J: Stat Adjustment.

3. Select the options as shown below:

4. Debit the expense ledger, or the ledger grouped under Current Assets and credit the GST ledgers.

5. Press Enter to save.