Item wise Godown wise closing balance

Discussion in 'Free Source Codes' started by tally.manish, Mar 4, 2015.

    
  1. tally.manish

    tally.manish Member


    Dear Experts and Admin

    I want item wise godown wise closing balance on given period

    I wrote code but it is not working

    pls read that and solve this issue
     

    Attached Files:



  2. Hemant Pathak

    Hemant Pathak New Member


    What you want exactly?
    1. Godown wise Item stock
    Or
    2. Godown wise Item Sales report
    Or
    3. Godown wise & Party wise Item Sales report

    Please give a report format for better understanding
     


  3. tally.manish

    tally.manish Member


    dear sir
    i want godown wise stock
     


  4. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Godownwise Stock summary report is already available in Tally.

    From Gateway of Tally

    Stock Summary Report

    F9- Inv Rep- Godown Summary

    Ctrl + N (Auto Column)

    Auto Repeat Columns :

    Repeat using : Godowns
     
    Ras Raj likes this.


  5. Rajan Pillai

    Rajan Pillai New Member


    Sir,
    Can you please give me a "Stock Items with Batch wise MRP & Selling Price / Purchase Price"
    Thanks
    Rajan Pillai
    # 09446075725
     


  6. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Presently I am working on this

    "Stock Items with Batch wise MRP & Selling Price / Purchase Price"

    I will update u ASAP
     


  7. vyadav

    vyadav Member


    Dear NagarajKmar Subramanian,,

    i want to need don't show zero value item while Sales Invoice please sir,,,
     


  8. vipul patel

    vipul patel New Member


    Dear Admin,

    Can i get "2. Godown wise Item Sales report" this report please.
     


  9. mahgs

    mahgs Member


    Dear Experts:

    i want the Same Solution,Kindly help me

     


  10. mahgs

    mahgs Member


    Dear Admin,

    Can you help me for this report
     


  11. Manoj Aggarwal

    Manoj Aggarwal New Member


    Sir,
    There is a problem in this. Tally gives a godown summary considering the main group name and the next sub group when you select detailed. They donot go into subgroup of subgroup and you have to press Shift-Enter for each sub group. That is a very tedious work to do. I give an example

    In an electonic instrument manufacturing unit..
    Main group name : Raw material
    --------sub group : Electronic components
    -------------------------Sub group : Capacitors
    ------------------------------------Item : 10mfd/63V

    So, if you go for godown summary, with detailed report and selecting auto column too.
    You would get a report of Raw materal and electronic component..
    to get more details you have to manually shift+enter electronic component and then again shift+ enter capacitor.
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  13. Mohan.S

    Mohan.S Member



  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Copy and Paste the link........... right click and select....copy link address......
     


  15. uttam100

    uttam100 Member



  16. Sanjeev S

    Sanjeev S Active Member


    Try this ......

    Code:
               [Field: CFBKRR Rep Party]
                Use            : Number Field
                Set as   : If $$IsEmpty:$$AsSignedQty:$$GodownItemValue:##PName:$Name:$ClosingBalance Then 0 Else $$AsSignedQty:$$GodownItemValue:##PName:$Name:$ClosingBalance
                Format        : "NoZero"
                Border        : Thin Left
    
     


  17. Suneel Kumar

    Suneel Kumar New Member


    Dear Sir,

    As per above coding all godowns are showing in report but i need only the list of godowns have transactions.
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use Filter in the Collection to exclude Godown having no transactions
     


  19. Suneel Kumar

    Suneel Kumar New Member


    Sir,
    I tried this command but all godown list disappears
    Filter : NonEmptyQty : NOT $$IsEmpty: $BilledQty

    but i am failed sir.

    Please help me.
     


  20. Suneel Kumar

    Suneel Kumar New Member


    Dear Sir,

    Actually I am using this report for Item Movement Report by Stock Transfer for Inter-Godowns
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    In your Collection .......... Add this............. Filter : EmptyGodownItemValue

    Code:
    {System : Formula]
    EmptyGodownItemValue        : ($$IsEmpty:($$GodownItemValue:##DSPGodownName:$Name:$InwardQuantity))     AND +
                                        ($$IsEmpty:($$GodownGroupValue:##DSPGodownName:$Name:$InwardQuantity))    AND +
                                        ($$IsEmpty:($$GodownItemValue:##DSPGodownName:$Name:$InwardValue))        AND +
                                        ($$IsEmpty:($$GodownGroupValue:##DSPGodownName:$Name:$InwardValue))     AND    +
                                        ($$IsEmpty:($$GodownItemValue:##DSPGodownName:$Name:$OutwardQuantity))  AND    +
                                        ($$IsEmpty:($$GodownGroupValue:##DSPGodownName:$Name:$OutwardQuantity)) AND    +
                                        ($$IsEmpty:($$GodownItemValue:##DSPGodownName:$Name:$OutwardValue))     AND    +
                                        ($$IsEmpty:($$GodownGroupValue:##DSPGodownName:$Name:$OutwardValue))     AND    +
                                        ($$IsEmpty:($$GodownItemValue:##DSPGodownName:$Name:$OpeningQuantity))    AND +
                                        ($$IsEmpty:($$GodownGroupValue:##DSPGodownName:$Name:$OpeningQuantity)) AND +
                                        ($$IsEmpty:($$GodownItemValue:##DSPGodownName:$Name:$OpeningValue))     AND    +
                                        ($$IsEmpty:($$GodownGroupValue:##DSPGodownName:$Name:$OpeningValue))
    
     


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If you want to FILTER based on only Closing QTY & Value , then change the formula accordingly.
     
    Sanjeev S likes this.


  23. Suneel Kumar

    Suneel Kumar New Member


    THANKS A LOT SIR.

    THIS HELPS ME TO SORT OUT THE PROBLEM.
     


  24. Suneel Kumar

    Suneel Kumar New Member


    Sir,

    is there any TDL for Projecting Purchase order at Sales Order using BOM.

    If available than help me.

    My E-Mail ID is suneel@hellorohtak.com
     


  25. Mohan.S

    Mohan.S Member


    Sir
    i need Closing stock available godown name instead of Qty

    Ex:
    Stock Item Qty Closing Available Godown
    Samsung Mobile 1 Godown - A
    Samsung Charger 1 Godown - c
    Samsung TV 1 Godown - B
    Here i need The Godown Name in my report how to achive this.​
     


Share This Page