How to generate Income Statement from Crystal Report

Advertisement

Hi, Experts,
I have:
SAP BUSINESS ONE 2007A
CRYSTAL REPORT 2008
I have a problem with generating Income Statement related reports from CRYSTAL.
For example,
My revenue accounts are: '411000-00-00' and '412000-00-00', my expense accounts are: '510000-00-00' and '520000-00-00'.
I'd like to generate the Income statement for Dec 1 - 31, 2008. Please advise how to generate this report. Thanks!
Lorrie

Advertisement

Hi, Experts,
Currently, what I tested to generate the income statement is:
1. find out the account detail table: JDT1. My database path: Company Name -> dbo -> Tables -> JDT1
2. follow the standard report menu: add 'JDT1', show 'RefDate', 'ContraAct'; group by'Account', summarize by 'Account'.
I have the following problems:
1. with this method, I am not able to find the amount for each transaction. Because the amount does not have a name as 'RefDate' or some other fields.
2. the 'Account' and 'ContraAct' are all shown as 'SYS00000001685'. It's sysmtem message but not the actual account number or contra account number.
Thanks!
Lorrie

November 30, -0001

How to generate Income Statement from Crystal Report

Hi, Experts, I have: SAP BUSINESS ONE 2007A CRYSTAL REPORT 2008 I have a problem with generating Income Statement related reports from CRYSTAL. For example, My revenue accounts are: '411000-00-00' and '412000-00-00', my expense accounts are: '510000-

How B.I accelerator differs from Crystal Reports

Hi B.I's,     I like to know which (B.I accelerator or Crystal Reports ) has better perfomance and fastest query response timeHi Bala, We have the BI Accelerator for high performance analytics (i.e. hardware and extra license fees) to make your large

How to extract embedded SQL from crystal reports 8.5

I have a report created in version 8.5 with data source as crystal query (.qry) published on Crystal enterprise server. I have lost Qry file but the report is running by executing the embedded SQL. Is there any option where I can extract the SQL stat

JNDI error while generating pdf from crystal reports in java

Hi, i want to generate PDF from crystal reports in java. I have the .PDF file with database configured into the report. Following details are available in report. 1. Server Name      = testdb 2. Database Name  = testdb 3. User 4. Password I am using

Assessing Lotus Domino from Crystal reports

Hi, I am going to work in Crystal reports XI reports and Lotus notes 7.0 for database.( I dont have experience in lotus notes). I am going to fix issues in already existing reports. I have Crystal reports XI and Lotus notes 7 client installed in my s

Income Statement & Balance Sheet Reporting via a single ASO cube

Hi All, I wanted to get some perspective on industry best practices as it relates to performing Income Statement & Balance Sheet reporting via a single Essbase ASO cube. As both these areas share a lot of common dimensions, do most of the companies i

Can't Print Landscape from Crystal Reports Viewer XI

Post Author: conrad CA Forum: General Product: Crystal Reports Viewer XI, version 12.0.0.r130_v20070725 and Crystal Reports XI, version 11.0.0.1282 Patches Applied: none Operating System(s): XP Pro SP2 Database(s): Error Messages: noneSteps to Reprod

Migrating from crystal report 8.5 to 10.0 giving error 01S00:error

migrating from crystal report 8.5 to 10.0 giving error I am working in migrating my cr application to 10th ver from the existing 8.5 where we have to explicitly make a query in query builder and then attach it. I was using dsn in ms odbc for oracle d

Consuming a Web service from Crystal reports 2008 - Error

Hi, I want to consume a web service from Crystal Reports 2008. I created a New Connection using "XML and Web Services" and given WSDL url as the Web Service location. Crystal Report is able to connect to the WSDL and is displaying the tags corre

From Crystal report XI R2 files to Crsytal Report 2008  files

Hi All, Can I convert  from Crystal report XI R2 files to Crsytal Report 2008  files? Please let me know. Thanks, Manjunath N JoginHi, Here are a few more facts about up gradation to CR 2008. 1)     Crystal Reports should be the same version of the E

How to call a Workflow from a Report in SE38?

How to call a Workflow from a Report in SE38? Please can Anyone Send me a Source code (with Explanation)which I can use for calling Workflow >> WS99900253? Regards, Shashank.you can use FM SAP_WAPI_CREATE_EVENT SWE_EVENT_CREATE OR SAP_WAPI_START_WOR

How to create .csv file from ABAP report

Hi We have a requirement to generate .csv file from abap report. Currently user saves data from abap report to spreadsheet(.xls format) in desktop.  Then opens excel file and save as .csv format.  Need option to save directly in .csv format instead o

Help with calling packages from crystal reports

hi I am trying to call a package from crystal reports, but geting an error Failed to open a rowset 4200:datadirect:odbcdriver:odbc oracle driver: unrecognised escape sequence. im sure its somthing realy stupid im doing wrong any ideas???? the command

CR2008 Not enough memory while exporting reports from Crystal Reports 2008

I have recently upgraded our Crystal Reports version from Crystal Reports Basic for Visual Studio 2008 to Crystal Reports 2008. After upgradation I am facing the problem "Memory full.OtherErrorFailed to export the report. Not enough memory for operat

Step- by- Step on How to Load Excel data into Crystal Reports?

Hi Friends,                   Can anyone send me a Step- by- Step on How to Load Excel data into Crystal Reports? Pls help me. Thanks in Advance. VijayIt's also important to 'prep' the excel file prior to connecting to it. Give the data tab a meaning

How to generate an idoc from invoice cancellation (VF11)

Hi How to generate an idoc from invoice cancellation (VF11)? Can someone help .. Regards PratikshaHi, You can generate an IDOC from invoice cancellation.Define a new "Z" output type for this cancellation billing document type and select the medi

Create PDF from Crystal Reports

Hi, We are using Crystal Reports XI with Adobe Acrobat Professional 8. When we create a pdf from crystal reports its giving crw32.exe encountered problem. Reinstall both the softwares are not useful. Adobe support professional says problem could be i

OBIEE metadata from Crystal reports

Hello, I am trying to connect to the OBIEE metadata from Crystal Reports using an ODBC connection. I am able to see the column definitions but the data is not shown - anyone have any suggestions on getting this to work?At least one of the 3rd-party C

How to link a webi report from crystal report

Hello everyone,                       I am trying to link a webi report from crystal XI. In my crosstab, the data is divided grouped by periods. So for every country it shows data along a period of time. The details for the value of the crosstab are

How to set Command Timeout in Crystal report while calling from C# code

I am using Crystal report XI R2.  I am calling SQL server 2005 stored procedure as source in the report. I want the report should timeout from the website if the stored procedure doesn't return resultset after 5 minute. Could you please assist how sh