Add Coloumn in sales Invoice

Dear sir,

I want to add the picture one column in picture two screen.

I try a lots but not success. pls help.

Thanks & regards

Code is Here:

;;Line : VCHBATCH ColumnOne, VCH Batch InclusiveTax, VCHBATCH ColumnTwo
;;[!Line: VCH BatchSuppleInv Info]
;[#Line: STKVCH Details]



[#Line : EI ColumnOne]
Option : Global EI ColumnOne

[!Line: Global EI ColumnOne]
Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT , IAMCGST ,IAMSGST, Mani

[Field : IAHSNCodeT]
Info : "HSN/SAC Code"
Align : Centre
Width : 15
Style : Small bold
COLOR : BLUE
background : yellow

[Field : IAMVAT]
Info : "Gross Wt."
Align : Centre
Width : @@NumberWidth
Style : Small bold
COLOR : RED
background : yellow

[Field : IAMCGST]
Info : "Tare Wt."
Align : Centre
Width : @@NumberWidth
Style : Small bold
COLOR : BLUE
background : yellow
[Field : IAMSGST]
Info : "All Wt."
Align : Centre
Width : @@NumberWidth
Style : Small bold
COLOR : RED
background : yellow

[Field : Mani]
Info : "RATE PER KHANDI"
Align : Centre
Width : @@NumberWidth
Style : Small bold
COLOR : RED
;; background : yellow
Line : 2

[#Line : EI InvInfo]
Option : Global EI InvInfo

[#Line : CI InvInfo]
Option : Global EI InvInfo

[!Line: Global EI InvInfo]
Add : Right Fields : At Beginning : IAHSNCode, IAMVA ,IAMCGS , IAMSGS ,ManiM


[Field : IAHSNCode]
Use : Short Name Field
Set As : $GSTHSNCode:StockItem:$StockItemName
Align : Centre
Border : Thin Left Right
Width : 15
Skip : YES
COLOR : BLUE
background : YELLOW
border : thin box
[Field : IAMVA]
Use : Number Field
Set As : $GWT ;;$GSTIGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
COLOR : RED
background : YELLOW
border : thin box
Storage : gwt
[Field : IAMCGS]
Use : Number Field
Set As : $Twt ;;$GSTCGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
Storage : TWT
COLOR : BLUE
background : YELLOW
border : thin box
[Field : IAMSGS]
Use : Number Field
Set As : $ALLWT ;;$GSTSGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
Storage : Allwt
COLOR : RED
background : YELLOW
border : thin box

[Field : ManiM]
Use : Number Field
Set As : $Khandi ;;$GSTSGSTRate:StockItem:$StockItemName
Format : "NoZero, NoPercentage"
Align : Centre
Border : Thin Left Right
;; Skip : YES
COLOR : RED
;; background : YELLOW
border : thin box
Storage : Khandi

;[#Field : Rate]
[#Field: Rate Field]

Width : @@RateWidth
Max : @@MaxNumberWidth
Set as : $Khandi * .2812
;; Type : Rate
Style : Small Bold
;; Key : Calculator
Align : Right
;; Format : "Symbol," + ##ShowForex
;; Option : SetAlignLeft : @@IsRightToLeftScript


[System : UDF]
khandi : Number : 18001
GWT : Number : 18002
TWT : Number : 18003
ALLWT : Number : 18004





;;=====HSN-SAC CODE IN VOUCHER ENTRY

[#Collection: List of Stock Items]

Use : Alias Collection
Title : $$LocaleString:"List of Stock Items"
Type : Stock Item
Fetch : Name
Report : Stock Item
Variable : SStockItem
Trigger : SStockItem
IsODBCTable : Yes
;;Unique : $StockItemName

;;Add :Format :$GSTIGSTRate
Fetch :GSTIGSTRate

Add :Format :$GSTHSNCode
Fetch :GSTHSNCode /*


[#menu: Gateway of Tally]

Button : New TallyPrime

[Button : New TallyPrime]
Title : New TallyPrime
Key : f5
Action : Browse URL : www.youtube.com/c/NewTallyPrime/?sub_confirmation=1

[#menu: Gateway of Tally]

Button : TallyTDL

[Button : TallyTDL]
Title : Tally Free TDL
Key : f6
Action : Browse URL : www.youtube.com/watch?v=UO3ey3j2Yg8&list=PLqTVKzf7tqbPyQBdMcwHvHj7kE957MzX8

;;=====END OF CODE========

 

Amit Sir,

Pls help guide me sir.

Thanks & Regards,

 

Respected Amit Sir & all members,

Pls guide me which Line i have choose that add the additional column in sub form Yellow screen after activate the Sale order voucher.

My humble request you pls guide me i will try a lot but not success.

Thanks & Regards.


[#Line : EI ColumnOne]
Option : Global EI ColumnOne

[!Line: Global EI ColumnOne]

;;=======================

[#Line : EI InvInfo]
Option : Global EI InvInfo

[#Line : CI InvInfo]
Option : Global EI InvInfo

[!Line: Global EI InvInfo]

 

Amit Sir Pls Pls help me

 

Dear Sir,

Finally i have done this . But i want little bit changes. can you pls help me.

Awaiting for your replay .

i want Modify Qty & Rate Field. For Example:

Gross - TearWt+AllWt. in Quantity field

& In Rate Field $Khandi * .2812

Code as under :

[Field : IAMVA]
Use : Number Field
Set As : $GWT ;;$GSTIGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
COLOR : RED
background : YELLOW
border : thin box
Storage : gwt
[Field : IAMCGS]
Use : Number Field
Set As : $Twt ;;$GSTCGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
Storage : TWT
COLOR : BLUE
background : YELLOW
border : thin box
[Field : IAMSGS]
Use : Number Field
Set As : $ALLWT ;;$GSTSGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
Storage : Allwt
COLOR : RED
background : YELLOW
border : thin box

[Field : ManiM]
Use : Number Field
Set As : $Khandi ;;$GSTSGSTRate:StockItem:$StockItemName
Format : "NoZero, NoPercentage"
Align : Centre
Border : Thin Left Right
;; Skip : YES
COLOR : RED
;; background : YELLOW
border : thin box
Storage : Khandi

;[#Field : Rate]

[#Field: VCHBATCH BilledQty]
Set as : $GWT - $TWT + ALLWT


[#Field: Rate Field]

Set as : $Khandi * .2812
;; Type : Rate
Style : Small Bold
;; Key : Calculator
Align : Right
;; Format : "Symbol," + ##ShowForex
;; Option : SetAlignLeft : @@IsRightToLeftScript

 

Try This
[#Field: VCHBATCH BilledQty]
Set as : $GWT - $TWT + $ALLWT
set always:yes

 

P

Pankaj Ji,
Thanks for your quick replay. Sir its not working its give me errer Incorrect type of Field! Conflicts with STORGE! .
I think in [System : UDF ] having conflict.

khandi : Number : 18001
GWT : Number : 18002
TWT : Number : 18003
ALLWT : Rate : 18004

Pls Guide me.

Thanks & Regards

 

Allwt:number:18004

 

Pankaj Ji Its not Working i submit the complete code pls guide me.Also i post required screen shoot.

Thanks & Regards,


[#Part: VCHBATCH Column]
Width : 50% Screen

[#Line: STKVCH Batch1]
Add : Fields : At Beginning : IAHSNcodeT, IAMVAT , IAMCGST ,IAMSGST, Mani
Indent : 3
[Field : IAHSNCodeT]
Info : "HSN/SAC Code"
Align : Centre
Width : 15
Style : Small bold
COLOR : BLUE
background : yellow

[Field : IAMVAT]
Info : "Gross Wt."
Align : Centre
Width : @@QtyWidth
Style : Small bold
COLOR : RED
background : yellow

[Field : IAMCGST]
Info : "Tare Wt."
Align : Centre
Width : @@QtyWidth
Style : Small bold
COLOR : BLUE
background : yellow
[Field : IAMSGST]
Info : "All Wt."
Align : Centre
Width : @@QtyWidth
Style : Small bold
COLOR : RED
background : yellow

[Field : Mani]
Info : "RATE PER KHANDI"
Align : Centre
Width : @@RateWidth
Style : Small bold
COLOR : RED
Line : 2

[#Line: STKVCH Batch2]
Add : Fields : At Beginning : IAHSNCode, IAMVA ,IAMCGS , IAMSGS ,ManiM
Indent : 3

[Field : IAHSNCode]
Use : Short Name Field
Set As : $GSTHSNCode:StockItem:$StockItemName
Align : Centre
Border : Thin Left Right
Width : 15
Skip : YES
COLOR : BLUE
background : YELLOW
border : thin box
[Field : IAMVA]
Use : Number Field
Set As : $GWT ;;$GSTIGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
COLOR : RED
background : YELLOW
border : thin box
Storage : gwt
[Field : IAMCGS]
Use : Number Field
Set As : $Twt ;;$GSTCGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
Storage : TWT
COLOR : BLUE
background : YELLOW
border : thin box
[Field : IAMSGS]
Use : Number Field
Set As : $ALLWT ;;$GSTSGSTRate:StockItem:$StockItemName
Format : "NoPercentage,Decimal:3"
Align : Centre
Border : Thin Left Right
Storage : Allwt
COLOR : RED
background : YELLOW
border : thin box

[Field : ManiM]
Use : Number Field
Set As : $Khandi ;;$GSTSGSTRate:StockItem:$StockItemName
Format : "NoZero, NoPercentage"
Align : Centre
Border : Thin Left Right
;; Skip : YES
COLOR : RED
;; background : YELLOW
border : thin box
Storage : Khandi

;;=====================================Midify Quantity Field & Rate Field below
[#Field: VCHBATCH BilledQty]
;;Use : Qty Field ;;Qty Primary Field
Set as : $GWT - $TWT + $ALLWT
set always:yes

[#Field: Rate Field]
Use : Rate Field
Set as : $Khandi * .2812
;; Type : Rate
Style : Small Bold
;; Key : Calculator
Align : Right
;; Format : "Symbol," + ##ShowForex
;; Option : SetAlignLeft : @@IsRightToLeftScript


[System : UDF]
khandi : Number : 18001
GWT : Number : 18002
TWT : Number : 18003
ALLWT : Number : 18004





;;=====HSN-SAC CODE IN VOUCHER ENTRY

[#Collection: List of Stock Items]

Use : Alias Collection
Title : $$LocaleString:"List of Stock Items"
Type : Stock Item
Fetch : Name
Report : Stock Item
Variable : SStockItem
Trigger : SStockItem
IsODBCTable : Yes
Fetch :GSTIGSTRate
Add :Format :$GSTHSNCode
Fetch :GSTHSNCode

 

[#Field:Rate FIELD]
set always:Yes

 

Dear Pankaj Ji,

Yeees Its Work , Also Pls guide how to get quantity field value.

Thanks & Regards,

 

Use functionNR (only hint)