financial reporting..?

2007-04-21
2013-05-02
  • hello friends... i have problem on finanv=cial reporting...
    i tried to create report on financial reporting using report and column lines .. but i can't see any record added for income statement and balance sheet... can any body tell me what the possible problems the cause not to generate record please...
    thanks

     
    • somebody.... please...

       
    • Enrique Ruibal
      Enrique Ruibal
      2007-04-23

      Hi,

      1. First you have to make sure that your transactions are posted, check,

         >Performance Analisys>Accounting Rules>Unposted Documents

      2. Then you have to update accounting balances, you can do that when you generate financial reports, just tick the update balances mark,

      3. If the above doesn't work, pls try to attach a trace log.

      Regards,

      Enrique R.

       
    • hello Enrique, thanks very much...
      i have tried the above, of course there were many unposted documents, and i have posted most of them...but there are five transaction which are not posted.. i have tried ..but i can't to post them.. but should i post every records? i mean if i want financial report for april 2007, does it not sufficient just to post only April's record?
      any way i have attached those records which don't posted.... and in the financial report there are no records seen...
      ***** here were the records not posted*****
      Garden World HQ    03 Sales transaction           01/24/2006  C_invoice_invoice      #10000067#
      Garden World HQ    10000005 Sales transaction no 04/09/2007 C_invoice_invoice    #10000234#
      Garden World HQ    10000259 Sales transaction no 03/05/2007 C_AllocationHdr_alloca    #10007894#
      Garden World HQ    1452121 Sales transaction no 03/05/2007 C_AllocationHdr_alloca    #10002175#
      Garden World HQ    145211 Sales transaction 01/23/2005   C_order_order             #10000457#
      **** not posted records end here *****
      the pproblem on the unposted document is mainly because the records have noline but voided and can't delete... or reactivate and post
      thanks...

       
    • Enrique Ruibal
      Enrique Ruibal
      2007-04-24

      I can not tell from that what is going on with your report, it is better if you can attach a trace log, goto preference window and select trace level all, then copy-paste this log from the part that you are generating the report, maybe then I can see what is going on.

      Enrique R.

       
    • i think the following is some from many... thanks again Enrique...
      *** 2007-04-25 00:02:18.093 Compiere Log (CLogFile) ***
      ===========> Doc_Invoice.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=03 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Invoice [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Invoice.<init>(Doc_Invoice.java:42)
          at org.compiere.acct.Doc.get(Doc.java:277)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Invoice.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=10000362 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Invoice [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Invoice.<init>(Doc_Invoice.java:42)
          at org.compiere.acct.Doc.get(Doc.java:277)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Order.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=TAM5 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Order [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Order.<init>(Doc_Order.java:42)
          at org.compiere.acct.Doc.get(Doc.java:289)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> EMail.setFrom: you @ company.org: javax.mail.internet.AddressException: Illegal whitespace in address in string ``you @ company.org'' [12]
      ===========> EMail.addTo: admin @ gardenworld.com: javax.mail.internet.AddressException: Illegal whitespace in address in string ``admin @ gardenworld.com'' [12]
      -----------> EMail.isValid: From is invalid=null [12]
      -----------> EMail.isValid: From is invalid=null [12]
      -----------> MClient.sendEmailNow: Could NOT Send Email: Inactivity Alert: Request 10000002 to admin @ gardenworld.com: Invalid Data (GardenWorld) [12]
      ===========> Doc_Invoice.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=03 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Invoice [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Invoice.<init>(Doc_Invoice.java:42)
          at org.compiere.acct.Doc.get(Doc.java:277)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Invoice.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=10000362 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Invoice [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Invoice.<init>(Doc_Invoice.java:42)
          at org.compiere.acct.Doc.get(Doc.java:277)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Order.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=TAM5 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Order [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Order.<init>(Doc_Order.java:42)
          at org.compiere.acct.Doc.get(Doc.java:289)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Invoice.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=03 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Invoice [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Invoice.<init>(Doc_Invoice.java:42)
          at org.compiere.acct.Doc.get(Doc.java:277)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Invoice.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=10000362 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Invoice [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Invoice.<init>(Doc_Invoice.java:42)
          at org.compiere.acct.Doc.get(Doc.java:277)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Order.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=TAM5 [11]
      ===========> AcctProcessor.postSession: GardenWorld Accounting Processor: C_Order [11]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Order.<init>(Doc_Order.java:42)
          at org.compiere.acct.Doc.get(Doc.java:289)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

      ===========> Doc_Order.setDocumentType: No DocBaseType setup for C_DocType_ID=0, DocumentNo=216364 [13]
      ===========> AcctProcessor.postSession: Glorious - Accounting Processor: C_Order [13]
      java.lang.IllegalStateException: Document Type not found
          at org.compiere.acct.Doc.setDocumentType(Doc.java:913)
          at org.compiere.acct.Doc.<init>(Doc.java:380)
          at org.compiere.acct.Doc_Order.<init>(Doc_Order.java:42)
          at org.compiere.acct.Doc.get(Doc.java:289)
          at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:107)
          at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:63)
          at org.compiere.server.CompiereServer.run(CompiereServer.java:208)

       
    • Enrique Ruibal
      Enrique Ruibal
      2007-04-25

      I am sorry, I don't think this is the right portion of the trace log that we need to see..you have to copy-paste it from the debugging window (the one opened in a MS-DOS session at the client

       
    • hi Enrique.. tahnks again and sorry for mis understanding....
      remember there are five records some are  which says no to be post .. but tell me weather we have to post all records( transactions) in the Client to generate the financial report or is this enough to post only for the desired month(period)?
      and remember i can generate records using trial balance...
      10:08:28.328 LayoutEngine.layoutTable: Balance Sheet Current Month - Balance She
      et Current Month [32]

      10:08:28.875   GridController.dataStatusChanged: (MTab #0 Financial Report (372)
      ) Col=0: DataStatusEvent - Refreshed  :  1/7 [11]
      10:08:28.875   GridController.dynamicDisplay: MTab #0 Financial Report (372) - R
      ows=7 [11]
      10:08:28.875         MField.isEditable: AD_Client_ID NO - FieldUpdateable=false
      [11]
      10:08:28.875         MField.isEditable: AD_Org_ID NO - FieldUpdateable=false [11
      ]
      10:08:28.875         Evaluator.evaluateLogicTuple: @ListSources@=Y => "Y" = "Y"
      => true [11]
      10:08:28.875         MField.isDisplayed: ListTrx (@ListSources@=Y) => true [11]
      10:08:28.875         Evaluator.evaluateLogicTuple: @ListSources@=Y => "Y" = "Y"
      => true [11]
      10:08:28.875         MField.isDisplayed: ListTrx (@ListSources@=Y) => true [11]
      10:08:28.875         MField.isEditable: AD_PrintFormat_ID NO - TabRO=false, Fiel
      dRO=true [11]
      10:08:28.875   GridController.dynamicDisplay: MTab #0 Financial Report (372) - f
      ini - complete [11]
      10:08:28.875 APanel.dataStatusChanged:  1/7 [11]
      10:08:28.875     APanel.setStatusLine: Data refreshed [11]
      10:08:28.875     MTab.setCurrentRow: Row=0 - fire=true [11]
      10:08:28.875       Env.setContext: Context(2) PA_Report_ID==100 [11]
      10:08:28.875       Env.setContext: Context(2) AD_Client_ID==11 [11]
      10:08:28.875       Env.setContext: Context(2) AD_Org_ID==11 [11]
      10:08:28.875       Env.setContext: Context(2) C_AcctSchema_ID==101 [11]
      10:08:28.875       Env.setContext: Context(2) C_Calendar_ID==102 [11]
      10:08:28.875       Env.setContext: Context(2) Name==Balance Sheet Current Month
      [11]
      10:08:28.875       Env.setContext: Context(2) Description==null [11]
      10:08:28.875       Env.setContext: Context(2) IsActive==Y [11]
      10:08:28.875       Env.setContext: Context(2) PA_ReportLineSet_ID==100 [11]
      10:08:28.875       Env.setContext: Context(2) PA_ReportColumnSet_ID==100 [11]
      10:08:28.875       Env.setContext: Context(2) ListSources==Y [11]
      10:08:28.875       Env.setContext: Context(2) ListTrx==N [11]
      10:08:28.875       Env.setContext: Context(2) Processing==N [11]
      10:08:28.875       Env.setContext: Context(2) AD_PrintFormat_ID==1000105 [11]
      10:08:28.875       Env.setContext: Context(2) Created==2003-02-09 13:38:06 [11]
      10:08:28.875       Env.setContext: Context(2) CreatedBy==100 [11]
      10:08:28.875       Env.setContext: Context(2) Updated==2007-04-25 08:09:11 [11]
      10:08:28.875       Env.setContext: Context(2) UpdatedBy==100 [11]
      10:08:28.875     MTab.fireDataStatusChanged: DataStatusEvent - Refreshed  :  1/7
      [11]
      10:08:28.875   GridController.dataStatusChanged: (MTab #0 Financial Report (372)
      ) Col=0: DataStatusEvent - Refreshed  :  1/7 [11]
      10:08:28.875   GridController.dynamicDisplay: MTab #0 Financial Report (372) - R
      ows=7 [11]
      10:08:28.890         Evaluator.evaluateLogicTuple: @ListSources@=Y => "Y" = "Y"
      => true [11]
      10:08:28.890         MField.isDisplayed: ListTrx (@ListSources@=Y) => true [11]
      10:08:28.890         Evaluator.evaluateLogicTuple: @ListSources@=Y => "Y" = "Y"
      => true [11]
      10:08:28.890         MField.isDisplayed: ListTrx (@ListSources@=Y) => true [11]
      10:08:28.890         MField.isEditable: AD_PrintFormat_ID NO - TabRO=false, Fiel
      dRO=true [11]
      10:08:28.890   GridController.dynamicDisplay: MTab #0 Financial Report (372) - f
      ini - complete [11]
      10:08:28.890 APanel.dataStatusChanged:  1/7 [11]
      10:08:28.890     APanel.setStatusLine: Data refreshed [11]
      10:08:28.890   GridController.dynamicDisplay: MTab #0 Financial Report (372) - R
      ows=7 [11]

      10:08:28.890         Evaluator.evaluateLogicTuple: @ListSources@=Y => "Y" = "Y"
      => true [11]
      10:08:28.890         MField.isDisplayed: ListTrx (@ListSources@=Y) => true [11]
      10:08:28.890         Evaluator.evaluateLogicTuple: @ListSources@=Y => "Y" = "Y"
      => true [11]
      10:08:28.890         MField.isDisplayed: ListTrx (@ListSources@=Y) => true [11]
      10:08:28.890         MField.isEditable: AD_PrintFormat_ID NO - TabRO=false, Fiel
      dRO=true [11]
      10:08:28.890   GridController.dynamicDisplay: MTab #0 Financial Report (372) - f
      ini - complete [11]

      thanks...

       
    • Enrique Ruibal
      Enrique Ruibal
      2007-04-25

      Financial Reports will only show posted transactions, so if something it's not posted yet it will not appear reflected in the financial reports..this may cause your information to be inaccurate and differing from other Compiere data, e.g. if you don't have all your invoices posted correctly it will differ your receivables accounting data from your open items reports otherwise they should match 100%.

      I don't see any problem with your report from the trace long you sent, maybe if you check the sample financial reports in GardenWorld you can probably find if you are skipping something important..if the financial reports are working in GW then you have error in configuring your own reports.

      Enrique Ruibal

       
    • Enrique...
      it shows no record on the Garden World sample report too... the thing is it make 0.00 for calculation based lines and no record for others.. like
      asset =0.00
      account recievables = ---
      but as i have told you i can generate trial balance for all posted records...
      any body?
      thanks

       
      • Stephan Keller
        Stephan Keller
        2007-04-26

        Mr. uhelpihelp,

        This could happend if the default account element tree is not correct.
        You might want to define a reporting hierarchy to make sure you know what trees are being used.

        Stephan,
        Sodexis.

         
    • enrique...
      or can you tell me the table at the database level so that i can try from that?
      thanks

       
    • Enrique Ruibal
      Enrique Ruibal
      2007-04-26

      I don't understand..I am getting these reports OK in GW as of Sep02 for instance and they work fine..

       
    • i saw that is ok since i have one accounting schema and i tried by generating the reporting heirarchy, i don't think the problem is this...but what about the Account sign?... in compiere document it says the account sign in the account element window may affect the financial report.... and my all accounts are natural not debit neither credit.. does it make problem...
      thanks

       
    • n2roo
      n2roo
      2007-04-30

      Hi uhelpihelp,

      Have you ever thought of using the jasperreport integration method in Compiere and do all your reporting of it? Writing reports using any of the jasperreport designers like iReport is definitely faster. I use this method for all my implementations and all reports, even forms like invoice and credit notes are written using iReport. Users will call the reports from within Compiere.

      n2roo

       
    • i don't understand n2roo

       
    • hello friends... how about the following trace error?.. this will be generated when i run financial report.... enrique please see this errors again..?
      ===========> DB.executeUpdate:
      INSERT INTO Fact_Acct_Balance ab
      (AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, DateAcct, Account_ID
      , PostingType, M_Product_ID, C_BPartner_ID,     C_Project_ID, AD_OrgTrx_ID, 
         C_SalesRegion_ID,C_Activity_ID, C_Campaign_ID,
      C_LocTo_ID, C_LocFrom_ID, User1_ID, User2_ID,
      GL_Budget_ID, AmtAcctDr, AmtAcctCr, Qty)
      SELECT AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, TRUNC(DateAcct), Account_ID, PostingType, M_Product_ID, C_BPartner_ID, C_Project_ID, AD_OrgTrx_ID, C_SalesRegion_ID,C_Activity_ID, C_Campaign_ID, C_LocTo_ID, C_LocFrom_ID, User1_ID, User2_ID, GL_Budget_ID, COALESCE(SUM(AmtAcctDr),0), COALESCE(SUM(AmtAcctCr),0), COALESCE(SUM(Qty),0) FROM Fact_Acct a WHERE C_AcctSchema_ID=1000001 AND NOT EXISTS (SELECT * FROM Fact_Acct_Ba
      lance x WHERE a.AD_Client_ID=x.AD_Client_ID AND a.AD_Org_ID=x.AD_Org_ID AND a.C_AcctSchema_ID=x.C_AcctSchema_ID AND TRUNC(a.Dat
      eAcct)=TRUNC(x.DateAcct) AND a.Account_ID=x.Account_ID AND a.PostingType=x.PostingType AND COALESCE(a.M_Product_ID,0)=COALESCE(
      x.M_Product_ID,0) AND COALESCE(a.C_BPartner_ID,0)=COALESCE(x.C_BPartner_ID,0) AND COALESCE(a.C_Project_ID,0)=COALESCE(x.C_Proje
      ct_ID,0) AND COALESCE(a.AD_OrgTrx_ID,0)=COALESCE(x.AD_OrgTrx_ID,0) AND COALESCE(a.C_SalesRegion_ID,0)=COALESCE(x.C_SalesRegion_
      ID,0) AND COALESCE(a.C_Activity_ID,0)=COALESCE(x.C_Activity_ID,0) AND COALESCE(a.C_Campaign_ID,0)=COALESCE(x.C_Campaign_ID,0) AND COALESCE(a.C_LocTo_ID,0)=COALESCE(x.C_LocTo_ID,0) AND COALESCE(a.C_LocFrom_ID,0)=COALESCE(x.C_LocFrom_ID,0) AND COALESCE(a.User1_ID,0)=COALESCE(x.User1_ID,0) AND COALESCE(a.User2_ID,0)=COALESCE(x.User2_ID,0) AND COALESCE(a.GL_Budget_ID,0)=COALESCE(x.G
      L_Budget_ID,0) ) GROUP BY AD_Client_ID,AD_Org_ID, C_AcctSchema_ID, TRUNC(DateAcct), Account_ID, PostingType, M_Product_ID,
      C_BPartner_ID, C_Project_ID, AD_OrgTrx_ID, C_SalesRegion_ID, C_Activity_ID, C_Campaign_ID, C_LocTo_ID, C_LocFrom_ID, User1_ID, User2_ID, GL_Budget_ID [null] [12]
      java.sql.SQLException: ORA-00001: unique constraint (COMPIERE.FACT_ACCT_PK) violated
      ; State=23000; ErrorCode=1
              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
              at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
              at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
              at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:3753)
              at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:8829)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2886)
              at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
              at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:157)
              at org.compiere.util.DB.executeUpdate(DB.java:813)
              at org.compiere.util.DB.executeUpdate(DB.java:723)
              at org.compiere.report.FinBalance.updateBalance(FinBalance.java:194)
              at org.compiere.report.FinReport.doIt(FinReport.java:240)
              at org.compiere.process.SvrProcess.process(SvrProcess.java:103)
              at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:80)
              at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:444)
              at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:228)

       
    • any body?

       
    • somebody please...