A blog on Tally Integration, to import and export data from Tally.ERP programmatically using VB6, VB.NET,C#,ASP.NET etc

Monday, September 3, 2007

ExplodeFlag tag does not work with "Bills Receivable" Report

ExplodeFlag tag does not work with "Bills Receivable" Report.

It has been confirmed by Tally Solutions, Bangalore that the above is a problem with Tally Software (Tally 7.2 & Tally 9).

Problem Description:-
ExplodeFlag is used to fetch / export data in Detailed format. It works fine with reports like "Trial Balance", "Balance Sheet" but does not work with report "Bills Receivable".

My Query to Tally Solutions has been given underneath for your reference:-

a) I am trying to use ExplodeFlag=Yes xml-tag to retrieve the "Bills Receivable" report data in Detailed format, but am getting the report output in Condensed format.
File attached (Receivables.xml)

b) When I tried ExplodeFlag=Yes with other Reports like "Trial Balance", it works fine and I get the Result in Detailed format.
File attached (TB1.xml)

c) Next, I tried to manually export both the Reports mentioned above viz. "Bills Receivable" and "Trial Balance" using the Tally 7.2 Software

Try out the following to understand my query:-

SITUATION ONE (Tally 7.2 Release 3.12)

Export Trial Balance in Condensed XML
1) Use option "Gateway of Tally -> Trial Balance" to display it.
2) Now, press "Ctrl+E" to export the Trial Balance. Select the format as Condensed; XML format.
3) View the XML output generated.

Export Trial Balance in Detailed XML
1) Use option "Gateway of Tally -> Trial Balance" to display it..
2) Now, press "Ctrl+E" to export the Trial Balance. Select the format as Detailed; XML format.
3) View the XML output generated.

RESULT: You can see that the output is different in both the cases. You will get correct output in both the cases.

SITUATION TWO (Tally 7.2 Release 3.12)

Export Bills Receivable in Condensed XML
1) Use option "Gateway of Tally -> Display -> Statement of Accounts -! > Outstanding -> Receivables" to display the Bills Receivable report.
2) Now, press "Ctrl+E" to export it. Select the format as Condensed; XML format.
3) View the XML output generated.

Export Bills Receivable in Detailed XML
1) Use option "Gateway of Tally -> Display -> Statement of Accounts -> Outstanding -> Receivables" to display the Bills Receivable report.
2) Now, press "Ctrl+E" to export it. Select the format as Detailed; Show Qty Info as Yes; XML format.
3) View the XML output generated.

RESULT: Notice that the XML output in case of Bills Receivable is same in both the cases, whether we select Detailed or Condensed.

The same happens when we programmatically use EXPLODEFLAG=YES to fetch the Bills Receivable report, but the output is always in condensed format.

Conclusion:-
ExplodeFlag=Yes when used with Trial-Balance works fine, but does not work with "Bills Receivable"

No comments: