You dont have javascript enabled! Please enable it! How to Retrive field value from the stock Item Master -2 |
You cannot view this unit as you're not logged in yet.

8 thoughts on “How to Retrive field value from the stock Item Master -2

  1. Giridharan Varadharajan says:

    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

    1. 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

  2. Yogesh Kanojia says:

    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

    1. 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.

  3. sunil kore says:

    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

  4. Silambarasan Ponnusamy says:

    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.

    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.

Leave a Reply