Stock Item Opening Balance for particular Godown

Discussion in 'Tally Developer' started by vanandd, Sep 21, 2014.

    
  1. vanandd

    vanandd Member


    Dear Experts,

    I am trying one TDL for stock movements. I am facing two problems in that. 1. I want to get the Stock Item Opening Balance of particular Godown as on Date. For Example, I have three godowns like Finished Goods -1, Finished Goods - 2, Finished Goods -3. I need, the stock Item opening balance of Finished Goods-3 godown only. How to get this.....?

    2. I want to get the finished product quanity from Manufacturing Journal. I tried to get the Qty as follows,
    Walk: All Inventory Entries
    Compute : MGFR Qty : $InventoryEntriesIn[1].ActualQty
    Its showing all stock Items in that voucher including all Raw Materials names. But, I need only Finished Good Qty only. So, please help me....?

    waiting for your reply..

    Regards,

    vanandd
     



  2. Hi,

    For fist issue, add a button in the report on which you have to trigger a collection which will display all the godowns with the help of small report and filter out the report on selection of the Godwon (It is same like you select any voucher type in day book)
    For the second issue, again you are not filtering the collection on for finished items only. Just try to filter it out for the finished items only.

    Other experts will may also advice in a better way.

    :)

    Thanks!
     


  3. vanandd

    vanandd Member


    Dear Sir,
    Thanks for your reply...I will try to get the Godown Name with Button sir..
    But, can you please give me example for second issue...Because, I have tried with filter. Even though raw materials are appearing in that report.

    Waiting for your reply sir..

    Regards,
    vanandd
     


  4. vanandd

    vanandd Member


    Dear Admin,

    Can you please help me on this regard...

    Regards
    vanandd
     


  5. sushil pote

    sushil pote New Member


    Dear Sir,

    I have same problem in tdl
    can you give me filter programing???? please
     


  6. Mohan.S

    Mohan.S Member


    How to i get previous invoice Stockitem level UDF Value in Next Invoice
     


  7. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Create aCollection using

    [collection : salescoll]
    Type : Vouchers: Vouchertype
    Child of : $$VchTypesales
    Belongs to Yes
    Fetch : voucherumber

    [Collection : Salesinvcoll]
    Source Collection : SalesColl
    Walk : Inventory entries
    Search Key : $Vouchernumber+$UDFNAME
    Compute: Udfname: $UDFName

    use Collectionfieldbykey formula using Vouchernumber+UDFNAME
     


  8. Mohan.S

    Mohan.S Member


    Thanking you sir, I will try and revert back you.



    hanking you
     


Share This Page