Invoice Customisation with Drug Licence , Transportation,Batch ,Expiry and Packing

;;;---
[#PART: CMP TAX INFO]

ADD : LINE : AT END : CMP DLNNOTL

[LINE: CMP DLNNOTL]

RIGHT FIELD : MEDIUM PROMPT
LOCAL : FIELD : MEDIUM PROMPT : SET AS : "DRUG LIC NO. :"
OPTION : SMALL SIZE LINE
SPACE TOP : 0.4

[#PART: CMP TAX VALUE]

ADD : LINE : AT END : CMP DLNNOVAL

[LINE: CMP DLNNOVAL]

FIELD : NAME FIELD
LOCAL : FIELD : NAME FIELD : STORAGE : CMPDLNNOVAL
LOCAL : FIELD : NAME FIELD : FULL WIDTH : YES
LOCAL : FIELD : NAME FIELD : MAX : 200
LOCAL : FIELD : NAME FIELD : LINE : 2
OPTION : SMALL SIZE LINE
SPACE TOP : 0.4


[#PART: LED OTHER DETAILS]

ADD : LINES : AT END : LED DLNO

[LINE: LED DLNO]

FIELDS : MEDIUM PROMPT, LED DLNO
LOCAL : FIELD : MEDIUM PROMPT : SET AS : $$LOCALESTRING:"DRUG LIC.NO :"
INVISIBLE : NOT @@ISINDIAN



[FIELD: LED DLNO]

USE : NAME FIELD
STORAGE : LEDDLNO
FULL WIDTH : YES
LINE : 2
MAX : 200

[#PART: EXPINV SALESALESTAX]
;;[#PART:EXPINV VATDETAILS]
ADD : LINES : AT END : SALESHCMPDLICNO,SALESBUYERDLIC

LINE: SALESHCMPDLICNO

[LINE: SALESHCMPDLICNO]

SPACE TOP : 0.05
FIELD : SHORT PROMPT,NAME FIELD
LOCAL : FIELD : SHORT PROMPT : SET AS : "OUR DL NO:"
LOCAL : FIELD : NAME FIELD : SET AS : $CMPDLNNOVAL:COMPANY:##SVCURRENTCOMPANY
LOCAL : FIELD : NAME FIELD : FULL WIDTH : YES
LOCAL : FIELD : NAME FIELD : STYLE : NORMAL

[SYSTEM: UDF]

CMPDLNNOVAL : STRING : 21110
LEDDLNO : STRING : 21111


[LINE: SALESBUYERDLIC]

FIELD : SHORT PROMPT ,NAME FIELD
LOCAL : FIELD : SHORT PROMPT: SET AS : "PARTY DL NO:"
LOCAL : FIELD : NAME FIELD : SET AS : $LEDDLNO:LEDGER:$PARTYLEDGERNAME
LOCAL : FIELD : NAME FIELD : FULL WIDTH : YES
LOCAL : FIELD : NAME FIELD : STYLE : NORMAL

[#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 :- SKILL BILL ON YOUTUBE "
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

[STYLE10]
FONT:CALIBRI (BODY)
HEIGHT:10

[STYLE9B]
USE9
BOLD: YES

[STYLE9BOLD]
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: "GST INVOICE"
LOCAL: FIELD: SIMPLE FIELD: STYLE: LARGE BOLD
LOCAL: FIELD: SIMPLE FIELD: SPACE LEFT: 40
LOCAL: FIELD: SIMPLE FIELD: FULL WIDTH: YES

[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: STYLEARTH CMP NAME
LOCAL: FIELD: NAME FIELD: SPACE LEFT: 25
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: STYLE9
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: P9
LOCAL: FIELD: SIMPLE FIELD: STYLE: P9
LOCAL: FIELD: SIMPLE FIELD: SET AS: $PHONENUMBER:COMPANY:##SVCURRENTCOMPANY +" "+ $MOBILENUMBERS:COMPANY:##SVCURRENTCOMPANY
LOCAL: FIELD: SIMPLE PROMPT: STYLE9
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+" "+ "DL NO. :"+" "+$CMPDLNNOVAL: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"
LOCAL: FIELD: SIMPLE FIELD: STYLE9B
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 :"+" "+ $$GETGSTSTATECODESTATENAME
LOCAL: FIELD: SIMPLE FIELD: LOCAL FORMULA:STATENAME : IF NOT ($$ISEMPTY:$STATENAME OR $$ISSYSNAME:NOTAPPLICABLE:$STATENAME) THEN $STATENAME ELSE $LEDSTATENAME:LEDGERPARTYNAME
LOCAL: FIELD: SIMPLE FIELD: FULL WIDTH: YES
LOCAL: FIELD: SIMPLE FIELD: STYLE: P9

[LINE:OTS CUSTOMER GST NO]
FIELD: SIMPLE FIELD
LOCAL: FIELD: SIMPLE FIELD: SET AS: "GSTIN NO : " +" "+ $PARTYGSTIN +" "+" PAN NO :"+" "+$INCOMETAXNUMBER:LEDGER:$BASICBUYERNAME+" "+"DL NO.:"+" "+$LEDDLNO:LEDGER:$PARTYLEDGERNAME
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 TRANSPORT NAME,OTS DISPATCH DESTINATION, 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 TRANSPORT NAME]
FIELD: MEDIUM PROMPT, SIMPLE FIELD
LOCAL: FIELD: MEDIUM PROMPT: SET AS: "TRANSPORT NAME."
LOCAL: FIELD: MEDIUM PROMPT: STYLE: P9B
LOCAL: FIELD: MEDIUM PROMPT: WIDTH: 15
LOCAL: FIELD: SIMPLE FIELD: SET AS: $MYUDF:LEDGER:$LEDGERNAME
LOCAL: FIELD: SIMPLE FIELD: STYLE: P9
LOCAL: FIELD: SIMPLE FIELD: FULL WIDTH: YES


[LINE:OTS DISPATCH DESTINATION]
FIELD: MEDIUM PROMPT, SIMPLE FIELD
LOCAL: FIELD: MEDIUM PROMPT: SET AS: "DISPATCH DESTINATION."
LOCAL: FIELD: MEDIUM PROMPT: STYLE: P9B
LOCAL: FIELD: MEDIUM PROMPT: WIDTH: 15
LOCAL: FIELD: SIMPLE FIELD: SET AS: $MYUDF1:LEDGER:$LEDGERNAME
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: BRISTLEITEMSDES]

LINE : BRISTLESTOCKGROUP
REPEAT : BRISTLESTOCKGROUP : BRISTLESTOCKGROUP

[LINE: BRISTLESTOCKGROUP]

USE : BRISTLEITEMSDESHEAD

LOCAL : FIELD : BRISTLEITEMMARKS : SET AS : ""
LOCAL : FIELD : BRISTLEITEMPACKAGES : SET AS : ""
LOCAL : FIELD : BRISTLEITEMDESCRIPTION : SET AS : $NAME
LOCAL : FIELD : BRISTLEITEMQTY : SET AS : ""
LOCAL : FIELD : BRISTLEITEMRATE : SET AS : ""
LOCAL : FIELD : BRISTLEITEMAMOUNT : SET AS : ""

LOCAL : FIELD : BRISTLEITEMDESCRIPTION : STYLE : NORMAL BOLD

LOCAL : FIELD : BRISTLEITEMDESCRIPTION : ALIGN : CENTRE

LOCAL : FIELD : BRISTLEITEMDESCRIPTION : VARIABLE : STOCKGROUPNAME

LOCAL : FIELD : BRISTLEITEMDESCRIPTION : SUBTITLE : YES

LOCAL : FIELD : BRISTLEITEMDESCRIPTION : BORDER : FLUSH THIN BOTTOM


EXPLODE : BRISTLESTOCKITEMSPART : NOT $$ISEMPTY:$VCHSTKGRPVALUE
EMPTY : NOT @@INVOUCHERLIST
[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 NAME: SET AS: "ITEM"
LOCAL: FIELD:OTS PACK:SET AS:"PACK"
LOCAL: FIELD:OTS BATCH:SET AS:"BATCH"
LOCAL: FIELD:OTS EXPIRY DATE:SET AS:"EXPIRY"
LOCAL: FIELD:OTS HSN CODE: SET AS: "HSN "
LOCAL: FIELD:OTS BILLED QTY: SET AS: "QTY"
LOCAL: FIELD:OTS MRP: SET AS: "MRP"
LOCAL: FIELD:OTS RATE: SET AS: "RATE"
LOCAL: FIELD:OTS DISCOUNT: SET AS: "DIS"
LOCAL: FIELD:OTS GST PER: SET AS: "GST"
LOCAL: FIELD:OTS GROSS AMT: SET AS: "AMOUNT"

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 NAME: SET AS: "NAME"
LOCAL: FIELD:OTS PACK:SET AS:""
LOCAL: FIELD:OTS BATCH: SET AS: "NO"
LOCAL: FIELD:OTS EXPIRY DATE: SET AS: ""
LOCAL: FIELD:OTS HSN CODE: SET AS: "CODE"
LOCAL: FIELD: OTS MRP: SET AS: ""
LOCAL: FIELD: OTS RATE: SET AS: ""
LOCAL: FIELD:OTS DISCOUNT: SET AS: "%"
LOCAL: FIELD:OTS GST PER: SET AS: "%"
LOCAL: FIELD:OTS GROSS AMT: 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 NAME
RIGHT FIELD:OTS PACK, OTS BATCH,OTS EXPIRY DATE,OTS HSN CODE,OTS BILLED QTY,OTS MRP, OTS RATE, OTS DISCOUNT, OTS GST PER,OTS GROSS AMT
SPACE TOP: 0.15
LOCAL: FIELD:OTS ITEM NAME: WIDTH: 30
LOCAL: FIELD:OTS SRNO: WIDTH: 3
LOCAL: FIELD:OTS PACK: WIDTH: 10
LOCAL: FIELD:OTS BATCH: WIDTH: 10
LOCAL: FIELD:OTS EXPIRY DATE: WIDTH: 6
LOCAL: FIELD:OTS HSN CODE: WIDTH: 4

LOCAL: FIELD:OTS BILLED QTY: WIDTH: 7
LOCAL: FIELD: OTS MRP: WIDTH: 7
LOCAL: FIELD: OTS RATE: WIDTH: 7
LOCAL: FIELD:OTS DISCOUNT: WIDTH: 3
LOCAL: FIELD:OTS GST PER: WIDTH: 3
LOCAL: FIELD:OTS GROSS AMT: WIDTH: 7

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 MRP: BORDER: THIN LEFT
LOCAL: FIELD: OTS RATE: BORDER: THIN LEFT
LOCAL: FIELD:OTS DISCOUNT: BORDER: THIN LEFT
LOCAL: FIELD:OTS GST PER: BORDER: THIN LEFT
LOCAL: FIELD:OTS GROSS AMT: BORDER: THIN LEFT

[FIELD:OTS ITEM NAME]
USE: SIMPLE FIELD
SET AS: IF NOT $$ISSYSNAME:$STOCKITEMNAME THEN @@INVITEMNAME ELSE ""
STYLE: P9
FULL WIDTH: YES
;LINE:0


[FIELD: OTS SR NO]
USE: SIMPLE FIELD
SET AS: $$LINE
FORMAT: "NO ZERO"
STYLE9
ALIGN: CENTER

[FIELD:OTS HSN CODE]
USE: SIMPLE FIELD
SET AS: $GSTITEMHSNCODEEX
STYLE9



[FIELD:OTS BILLED QTY]
USE: QTY PRIMARY FIELD
SET AS: $BILLEDQTY
STYLE9



[FIELD:OTS PACK]
USE:SIMPLE FIELD
SET AS:$BASICUSERDESCRIPTION
STYLE9
BORDER : THIN LEFT




[FIELD:OTS BATCH]
USE:SIMPLE FIELD
SET AS:$BATCHNAME
STYLE9
BORDER : THIN LEFT

[FIELD:OTS EXPIRY DATE]
USE:SIMPLE FIELD
SET AS:$EXPIRYPERIOD
STYLE9
BORDER : THIN LEFT

[FIELD:OTS MRP]
USE: MRP FIELD
SET AS: $MRP RATE
STYLE9
BORDER : THIN LEFT




[FIELD:OTS RATE]
USE: RATE PRICE FIELD
SET AS: $RATE
STYLE9

[FIELD:OTS DISCOUNT]
USE: NUMBER FIELD
SET AS: ""
SET AS: $DISCOUNT
FORMAT : "NOZERO,PERCENTAGE"
STYLE9

[FIELD:OTS GROSS AMT]
USE:AMOUNT FOREX FIELD
SET AS: $AMOUNT
STYLE9

[FIELD:OTS GST PER]
USE: NUMBER FIELD
SET AS: IF NOT $GSTISTRANSLEDEX THEN "" ELSE $GSTCLSFNIGSTRATEEX
FORMAT : "NOZERO,PERCENTAGE"
SET ALWAYS: YES
STYLE9


[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 NAME: SET AS: "TOTAL"
LOCAL: FIELD:OTS BATCH: SET AS: ""
LOCAL: FIELD:OTS EXPIRY DATE: SET AS: ""
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 : STYLE9B
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 : STYLE9B
LOCAL : FIELD:EXPINV BANKNAME:STYLE9

[#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 : STYLE9B
LOCAL : FIELD:EXPINV BANKACCOUNTNO:STYLE9

[#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 : STYLE9B
LOCAL : FIELD:EXPINV BANKBRANCHNAME:STYLE9



[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

STYLE9B
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"
STYLE9
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
STYLE9

[FIELD:OTSLEDGERAMOUNT]
USE : AMOUNT FOREX FIELD
SET AS : $$SIGNEDAMOUNT:$AMOUNT@VCHOPPOSITE
BORDER: THICK LEFT
ALIGN: RIGHT
WIDTH: 8
STYLE9

[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:STYLE9B
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:STYLE9
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
LOCAL: FIELD: NAME FIELD: ALIGN: RIGHT
LOCAL: FIELD: NAME FIELD: STYLE9B
LOCAL: FIELD: AMOUNT FIELD: SET AS: $AMOUNT
LOCAL: FIELD: AMOUNT FIELD: WIDTH:8
LOCAL: FIELD: AMOUNT FIELD: BORDER: THICK LEFT
LOCAL: FIELD: AMOUNT FIELD: STYLE9B
SPACE TOP:0.25
SPACE BOTTOM:0.25

[PART:OTSSINGNATURECLOSINGBALANCETERMS]
LEFT PART: OTSTERMSANDCLOSING
RIGHT PART: OTS BANK, 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: STYLE9B
SPACE TOP:0.5

[LINE:OTSPREVIUOSOUTSTANDINGBALANCE]
FIELD: MEDIUM PROMPT, AMOUNT FIELD
LOCAL: FIELD: MEDIUM PROMPT: SET AS:"PREVIOUS OUTSTANDING"
LOCAL: FIELD: MEDIUM PROMPT: STYLE9B
LOCAL: FIELD: AMOUNT FIELD: SET AS:$$TOVALUE$DATE-1):$CLOSINGBALANCE:LEDGER:$$COLLECTIONFIELD:$LEDGERNAME:1:LEDGERENTRIES
LOCAL: FIELD: AMOUNT FIELD:STYLE9

[LINE:OTSCURRENTINVOICE]
FIELD: MEDIUM PROMPT, AMOUNT FIELD
LOCAL: FIELD: MEDIUM PROMPT: SET AS:"CURRENT INVOICE"
LOCAL: FIELD: MEDIUM PROMPT: STYLE9B
LOCAL: FIELD: AMOUNT FIELD: SET AS:$AMOUNT
LOCAL: FIELD: AMOUNT FIELD:STYLE9

[LINE:OTSTOTALOUTSTANDING]
FIELD: MEDIUM PROMPT, AMOUNT FIELD
LOCAL: FIELD: MEDIUM PROMPT: SET AS:"TOTAL OUTSTANDING"
LOCAL: FIELD: MEDIUM PROMPT: STYLE9B
LOCAL: FIELD: AMOUNT FIELD: SET AS:$$TOVALUE:$DATE:$CLOSINGBALANCE:LEDGER:$$COLLECTIONFIELD:$LEDGERNAME:1:LEDGERENTRIES
LOCAL: FIELD: AMOUNT FIELD:STYLE9

[PART:OTS BANK]
LINE: OTS BANK
BORDER: THICK LEFT


[LINE:OTS BANK]
FIELD: NAME FIELD
LOCAL: FIELD: NAME FIELD: SET AS: "BANK OF INDIA IFSC CODE -BKID0005000 ACCOUNT NO-500010110002346 "
LOCAL: FIELD: NAME FIELD: FULL WIDTH: YES
LOCAL: FIELD: NAME FIELD: WIDTH:26
LOCAL: FIELD: NAME FIELD: STYLE: P9B
LOCAL: FIELD: NAME FIELD: LINE:0
SPACE TOP:3


[PART:OTSSIGNATURE]
LINE: FOROTSSIGNATURE
BORDER: THICK LEFT
WIDTH:36.025

[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



[PART:OTSJURI]
LINE:OTS JURIDICTION

[LINE:OTS JURIDICTION]
FIELD: NAME FIELD
LOCAL: FIELD: NAME FIELD: FULL WIDTH: YES
LOCAL: FIELD: NAME FIELD: SET AS: "ALL SUBJECT TO PATNA JURISDICTION"
LOCAL: FIELD: NAME FIELD: ALIGN: CENTER

 

I TRIED AND ITS WORK GREAT, JUST WANT TO UPLOAD TDL ON TALLY PRIME
CAN YOU PLEASE GUIDE US

 

please check second page sir.second page columns not perfectly sitting.

 

sir it is showing like
could not find "CMP TAX INFO"

 

Dear Sir,

Just delete the following portion

[#PART: CMP TAX INFO]

ADD : LINE : AT END : CMP DLNNOTL

[LINE: CMP DLNNOTL]

RIGHT FIELD : MEDIUM PROMPT
LOCAL : FIELD : MEDIUM PROMPT : SET AS : "DRUG LIC NO. :"
OPTION : SMALL SIZE LINE
SPACE TOP : 0.4

[#PART: CMP TAX VALUE]

ADD : LINE : AT END : CMP DLNNOVAL

[LINE: CMP DLNNOVAL]

FIELD : NAME FIELD
LOCAL : FIELD : NAME FIELD : STORAGE : CMPDLNNOVAL
LOCAL : FIELD : NAME FIELD : FULL WIDTH : YES
LOCAL : FIELD : NAME FIELD : MAX : 200
LOCAL : FIELD : NAME FIELD : LINE : 2
OPTION : SMALL SIZE LINE
SPACE TOP : 0.4

And add ...

Code:

[#Part: CMP TallyShopFeatures Left]

ADD : LINE : AT END : CMP DLNNOTL

[LINE: CMP DLNNOTL]

RIGHT FIELD : MEDIUM PROMPT, NAME FIELD
LOCAL : FIELD : MEDIUM PROMPT : SET AS : "DRUG LIC NO. :"
LOCAL : FIELD : NAME FIELD : STORAGE : CMPDLNNOVAL
LOCAL : FIELD : NAME FIELD : FULL WIDTH : YES
LOCAL : FIELD : NAME FIELD : MAX : 200
LOCAL : FIELD : NAME FIELD : LINE : 2

You are done!!!