Total: ₹0.00
Total: ₹0.00

L: Sales report Customization XII

You cannot view this unit as you're not logged in yet.
Prev post K. Sales Report XI
Next post Case Study : Border issue in the Poonam Corporation

8 thoughts on “L: Sales report Customization XII”

  1. Aliasgar Petiwala says:

    If i want to Filter The Value From Particular Voucher Type Ex : Cash Sales is the Voucher Type name. what is the Formula I have to Apply here

  2. FARRAKH HAYAT says:

    Hi,
    Everything is working fine but “BilledQty” and “Rate” is not showing.
    I have tried to set Fetch and Walk but could not.
    Can you please help me to sort out?
    Thanks.

    [#Menu:GateWay of Tally]

    Add:Item :Explode Report : Display: MyExplodeReport

    [Report: MyExplodeReport]
    Form : MyExplodeForm

    [Form : MyExplodeForm]

    Parts : MyExplodePart
    Use : DSP Template
    Height : 100% Screen
    Width : 100% Screen
    ;;Background : My Form Bg
    Button : ExplodeFlag

    [Part : MyExplodePart]
    line : MyExplodeHeadingLine, MyExplodeDataLine
    Repeat : MyExplodeDataLine : MyExplodeCollection ;;Repeating “Line” and “Collection” under Part level.

    Scroll : Vertical
    Vertical : Yes

    1. Please do not pose code in comment section. You can post it in the Dropbox thats why we use Dropbox.
      And check your codes with the course chapter 2 times

      if all your efforts fail then save your code in the dropbox and I will fix that.

  3. Muruga Vel says:

    Dear Sir,

    My Code Billed QTY, Rate, Stock Name not show in my report
    Please Check Shared My code & Screen Image in drop box Folder name is Sales Vch Report, File Name Sales VchRpt_ Unit 12.txt

  4. Ozair Ahmad says:

    ;;Ozair Ahmad, E-mail:blissghazal@gmail.com
    ;;Date: 24-11-2021
    [Field: My Sales VchAmount]
    Use : Amount Field
    Style : Normal
    ;;œ Below line ‘$Amount’ retrieves method value of the Voucher Object
    Set as : $Amount ;;$ToT ————————————————-
    ;; œ Storage ‘Amount’ is included IGST @5% also
    ;; If we find IGST storage then we find the amount
    ;; without IGST i.e., ($Amount – GST_Storage)
    ;; But I doesn’t find GST Storage till now (23/11/21)
    ;; I try alternate way by using System Formula but
    ;; System Formula $ToT is giving zero while at explode
    ;; level $ToT is working.
    ;;************** Repeated body line fields ends **************;;
    [System : Formula]
    nQty : $$Number:$$StringPart:$BilledQty:0:(($$StringLength:$BilledQty)-4)
    nRate : $$Number:$$StringPart:$Rate:0:(($$StringLength:$Rate)-4)
    ToT : @@nQty*@@nRate ;; at LedgerEntries level is not working

    1. It is difficult to understand what you are looking for. but I suppose you are trying to get the GST amount
      Storage for all amount field is $Amount means for gst, invoice value product amount for all those the storage name is $Amount only

      but in tdl just the storage name is not enough you need to find out the collections also to which belongs then use the storage name along with that collections to solve a problem
      For that purpose you need to understand Tally software
      Tally invoices contains serval parts like
      main form which contains most of the things
      then there inventories which are controlled by Aggregate udf like InventoryEntries
      then tax discount and other ledgers which are controlled ny the Agg. udf like Ledgerentries
      so in Tally developer mode you can search for ledgerEntries through Control + D and you can find out some sample codes
      Also somewhere I shared a pdf guide getting started with tally developer in which also you can search for filtervalue or ledger entries and you can solve the problem yourself.

      1. Ozair Ahmad says:

        I’ve pasted mycode and a screen shot in my drop box which indicates the purpose.
        TM( TDL) > Ozair_Ahmad > Project01 > L-Sales

Leave a Reply