how to get current item-godown quantity information using xml?

Discussion in 'Tally Developer' started by columbus, Jul 20, 2012.

    
  1. columbus

    columbus New Member


    Hi all,

    I need to dynamically find the number of units of each item at each godown from tally. I have tried googling for a couple of days, but I have not found anything of use here. The best I ended up with was a total summary of item with quantity details using the following xml. For example, say godown-1 has 50 item-1 units, godown-2 has 100 item-1 units. Using the following xml, I can determine total units for item-1 (150) but do not get godown-wise distribution. Could someone help me find godown-wise distribution of items?

    Thanks,
    c

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>Stock Category Summary</REPORTNAME>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>

    </STATICVARIABLES>
    </REQUESTDESC>

    </EXPORTDATA>
    </BODY>
    </ENVELOPE>
     


  2. admin

    admin Administrator Staff Member


    Better you can write a seperate Report, to calculate the Stock Items - Particular Godown Closing Balance..

    and call that report using XML file. Make the stock Item and Godowns as Variables.

    Still you need support please contact us.
     


  3. columbus

    columbus New Member


    Can you please elaborate? Is there a report-name that I can use in my XML (see my previous post) that will give me item-godown details? Or are you suggesting that I create a report (how?) that will provide me with that information? I am a bit naive about Tally and would appreciate a little bit of hand-holding.

    many thanks
    c
     


  4. Trushar

    Trushar New Member


    Pls anybody can help me out to get closing balance of particular godown, i havent get format to get the same.Please help me.Thanks in advance...
     


  5. admin

    admin Administrator Staff Member


    Use report godown summary
     


  6. Trushar

    Trushar New Member


    Thank you sir,
    But i got godown's totals stocks closing balance .I want closing balance for each item contented in godown.So please help me out to get the same.
     


  7. rbyarra1

    rbyarra1 New Member


    Anybody is able Crack this? I am also looking for the Database Table which gives me Closing balance of each stock item godownwise
     


  8. rbyarra1

    rbyarra1 New Member


    Can you Please suggest the Database Table which gives me Closing balance of each stock item godown wise
     


Share This Page