8 thoughts on “How to Retrive field value from the stock Item Master -2”
Giridharan Varadharajan
Sir,
I have shared the output and tdl code for retrieving the standard rates in sales voucher.
It will be a night mare for beginners. The retrieval code and finding out default in developer is a night mare. You as a professional for long time might feel it easy, but not for us. only when we get ourselves tuned to all in Tdl, then we might find it little bit easy.
Nothing is achievable without hard work
Regards.
Giridharan Varadharajan
Hello Giridharan,
Coding is always a nightmware for everyone. Not only the beginners, but even for the expert it is always like a nightmare.
I didnt’ said that it is very easy for me. I said that you will find many ways to find out the default definitions in the next chapters.
There are 3-4 Chapters, I wrote about how to find out the default definitions. and you will get them in the otter modules.
Even, I have to struggle a lot to get the things.
Recently, one another student Yugal wanted to put a % format in the collection and I really had no idea how to do that.
and can you believe? he did that himself on his own. He joined the course just 2 months ago only.
Not, only that but he gave me formula also how to do that!
Once, I had an issue in my codes, I asked Tally solutions expert guys to help me and can you believe that even after 3 hours of hard work on my system through TeamViewer those guys weren’t able to fix the issue!
So, everyone is like a learner or a beginner only in the matter of coding world, it is like a sea and there is no easy sailing.
No matter how hard we do but some times we have to spend weeks or even months to get the needed things.
This is a hard and bitter reality of the coding world and thats why everyone can’t do it. Most of us quit from the field and only real passionate able to survive and go ahead.
So, don’t think that its hard for beginners and and a easy bread for an expert.
The more hard efforts you do, more it will make you an expert
If it was that easy then everyone is doing the code like the LLB Course and it will lose its charm
Greetings…!!!
Below is the coding to add two fields in sales voucher
1. Fixed Rate
2. MRP
I am fetching the Fixed Rate from Standard Cost Section of Item Master & thus MRP
Everything is perfect. But these values are not being stored in my Sales Voucher.
Please do suggest what to do.
;;Har Har Maahadev
[#Line: EI ColumnOne]
/* Fields : VCH ItemTitle
Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
*/
Add : Right Fields : After : VCH QtyTitle : FixedRateTitle, MRPTitle
[Field:FixedRateTitle]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:”F.Rate”
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[Field:MRPTitle]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:”M.R.P.”
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[#Line: EI ColumnTwo]
/*Fields : VCH ItemTitle
Right Fields: VCH ActualQtyTitle, VCH BilledQtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
*/
Add : Right Fields : After : VCH BilledQtyTitle : FixedRateTitle1, MRPTitle1
[Field:FixedRateTitle1]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:””
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[Field:MRPTitle1]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:””
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[#Line: CI InvInfo]
/*
Fields : EIDeemedPos, VCHStockItem
Right Fields: VCHActualQty, VCHBilledQty, VCH RateIncl, VCHRate, VCHRateUnit, VCHPrevItem, VCHDiscount, VCHValue
*/
Add : Right Fields : After : VCHBilledQty : FixedRate, MRPItem
[Field:FixedRate]
Use : Rate Price Field
Width : @@VCHQtyWidth;;@@VCHRateWidth
Background : Blue
Color : Yellow
Set as : $StandardCost:StockItem:$StockItemName
Skip : Yes
Set Always : Yes
Storage : FR
[Field:MRPItem]
Width : @@VCHQtyWidth;;@@VCHQtyWidth
Use : Rate Field
Set as : $MRPRate
Set Always : Yes
Skip : Yes
Background : Blue
Color : Yellow
Skip : Yes
Format : “Symbol,Forex”
Storage : NM
You will get the course chapters in the subsequently projects. Right now, just move to the next unit. The reason is that every chapter/project has a purpose and we can’t do everything within one project. So once our project is achieved, we have to the next project/modules/unit.
Sir, In this chapter, I have seen the output and the formula also working good. How do we know the Line or Field or Part name to find which one will be used to amend existing coding & write the new one.
It will be better kindly open the tally in developer mode and show how to identify the line name to modify. Else hoping this one in our upcoming chapters to cover.
Did you wrote the codes?
If not then I would suggest please write the codes
once You write the codes and compare /test it with the chapter then do let me know what you didn’t understaood and I will explain you everything.
Only thing is here is that first of all you need to write the codes as per the chapter cause once you do it, it will be very easy to understand
but without writing codes if you try to understand it then it will become very difficult
So, please write codes, test it and then let me know and I will clear all of your doubts.
Giridharan Varadharajan
Sir,
I have shared the output and tdl code for retrieving the standard rates in sales voucher.
It will be a night mare for beginners. The retrieval code and finding out default in developer is a night mare. You as a professional for long time might feel it easy, but not for us. only when we get ourselves tuned to all in Tdl, then we might find it little bit easy.
Nothing is achievable without hard work
Regards.
Giridharan Varadharajan
Hello Giridharan,
Coding is always a nightmware for everyone. Not only the beginners, but even for the expert it is always like a nightmare.
I didnt’ said that it is very easy for me. I said that you will find many ways to find out the default definitions in the next chapters.
There are 3-4 Chapters, I wrote about how to find out the default definitions. and you will get them in the otter modules.
Even, I have to struggle a lot to get the things.
Recently, one another student Yugal wanted to put a % format in the collection and I really had no idea how to do that.
and can you believe? he did that himself on his own. He joined the course just 2 months ago only.
Not, only that but he gave me formula also how to do that!
Once, I had an issue in my codes, I asked Tally solutions expert guys to help me and can you believe that even after 3 hours of hard work on my system through TeamViewer those guys weren’t able to fix the issue!
So, everyone is like a learner or a beginner only in the matter of coding world, it is like a sea and there is no easy sailing.
No matter how hard we do but some times we have to spend weeks or even months to get the needed things.
This is a hard and bitter reality of the coding world and thats why everyone can’t do it. Most of us quit from the field and only real passionate able to survive and go ahead.
So, don’t think that its hard for beginners and and a easy bread for an expert.
The more hard efforts you do, more it will make you an expert
If it was that easy then everyone is doing the code like the LLB Course and it will lose its charm
Dear Sir,,
Greetings…!!!
Below is the coding to add two fields in sales voucher
1. Fixed Rate
2. MRP
I am fetching the Fixed Rate from Standard Cost Section of Item Master & thus MRP
Everything is perfect. But these values are not being stored in my Sales Voucher.
Please do suggest what to do.
;;Har Har Maahadev
[#Line: EI ColumnOne]
/* Fields : VCH ItemTitle
Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
*/
Add : Right Fields : After : VCH QtyTitle : FixedRateTitle, MRPTitle
[Field:FixedRateTitle]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:”F.Rate”
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[Field:MRPTitle]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:”M.R.P.”
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[#Line: EI ColumnTwo]
/*Fields : VCH ItemTitle
Right Fields: VCH ActualQtyTitle, VCH BilledQtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
*/
Add : Right Fields : After : VCH BilledQtyTitle : FixedRateTitle1, MRPTitle1
[Field:FixedRateTitle1]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:””
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[Field:MRPTitle1]
Width : @@VCHQtyWidth;;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth
SubTitle : Yes
Setas : $$LocaleString:””
Style : Small Bold
Align : Centre
Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
Skip : Yes
Fixed : Yes
Color : Yellow
Background : Blue
[#Line: CI InvInfo]
/*
Fields : EIDeemedPos, VCHStockItem
Right Fields: VCHActualQty, VCHBilledQty, VCH RateIncl, VCHRate, VCHRateUnit, VCHPrevItem, VCHDiscount, VCHValue
*/
Add : Right Fields : After : VCHBilledQty : FixedRate, MRPItem
[Field:FixedRate]
Use : Rate Price Field
Width : @@VCHQtyWidth;;@@VCHRateWidth
Background : Blue
Color : Yellow
Set as : $StandardCost:StockItem:$StockItemName
Skip : Yes
Set Always : Yes
Storage : FR
[Field:MRPItem]
Width : @@VCHQtyWidth;;@@VCHQtyWidth
Use : Rate Field
Set as : $MRPRate
Set Always : Yes
Skip : Yes
Background : Blue
Color : Yellow
Skip : Yes
Format : “Symbol,Forex”
Storage : NM
[System:UDF]
FR:Rate:99
NM:Rate:110
You will get the course chapters in the subsequently projects. Right now, just move to the next unit. The reason is that every chapter/project has a purpose and we can’t do everything within one project. So once our project is achieved, we have to the next project/modules/unit.
Error of following code for display gstrate in Sales & purchase entry.
;; Om ram Krishna Hari ;;
;; Sunil kore – sunilkore@gmail.com 9422614133
;; Tdl for Purchase& Sale Entry screen showing Hsn & Gst Rate for Stock Item
[#Line: EI ColumnOne]
/*
Fields : VCH ItemTitle
Right Fields: VCH QtyTitle, VCH InclRateTitle, VCH RateTitle, VCH RateUnitsTitle, VCH DiscTitle, VCH AmtTitle
*/
Add :Field:After:VCH ItemTitle : SIHsnT,SIGstrateT
[Field: SIHsnT]
Use: Namefield
Set as: ” HSN”
Skip: Yes
[Field: SIGstRateT]
Use:Name field
Set as: “GST RATE”
Skip: Yes
[#Line: EI InvInfo]
/* Fields : EI DeemedPos, VCH StockItem
Right Fields: VCH ActualQty, VCH BilledQty, VCH Rate */
Add: Field:After:VCH StockItem :SIHsn,SIGstrate
[Field: SIHsn]
Use: Namefield
Set as: $GSTHSNCode:StockItem:$StockItemname
Skip: Yes
[Field: SIGstRate]
Use: Number Field
Set as: $GstRate:StockItem:$StockItemname
Skip: Yes
Sir, In this chapter, I have seen the output and the formula also working good. How do we know the Line or Field or Part name to find which one will be used to amend existing coding & write the new one.
It will be better kindly open the tally in developer mode and show how to identify the line name to modify. Else hoping this one in our upcoming chapters to cover.
I didn’t understand Stock Item Master Part-1
Did you wrote the codes?
If not then I would suggest please write the codes
once You write the codes and compare /test it with the chapter then do let me know what you didn’t understaood and I will explain you everything.
Only thing is here is that first of all you need to write the codes as per the chapter cause once you do it, it will be very easy to understand
but without writing codes if you try to understand it then it will become very difficult
So, please write codes, test it and then let me know and I will clear all of your doubts.