Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Strange first line in Fin Report

Yan
2008-10-14
2013-05-02
  • Yan
    Yan
    2008-10-14

    Hi everyone,

    I made a financial report based on a report line set which is made of a unique line (segment value) and the source is type=product.
    There are 13 columns (one for each month, and one which add range from january to december).

    When the report is created, i can see all my products (I'm not selecting one in parameters).
    But i got a first line which gives me an amount that i can't explain.

    Seeing the log, i notice that Compiere runs this SQL to calculate this amount :

    (SELECT SUM(acctBalance(Account_ID,AmtAcctDr,AmtAcctCr)) FROM Fact_Acct_Balance WHERE DateAcct BETWEEN TO_DATE('2008-01-01','YYYY-MM-DD') AND TO_DATE('2008-01-31','YYYY-MM-DD') AND PostingType='A' AND C_AcctSchema_ID=1000002)

    This is done on the 12 month columns.

    If i lauch the report selecting one produt as a parameter, i don't have this line.

    I'm using Compiere 302.
    Has somebody laready see such a thing ?

    Is this a bug ?

    Regards,

    Yan

     
    • That first line isn't the sum of all following product lines?

       
      • Yan
        Yan
        2008-12-19

        no, it's a bit more complicated...

        in fact, this line came from nowhere, i don't know what it refers to.

        i manage to erase it by creating a summary product and putting all non summary article in it

        don't know why, but it works !

        :-)

        Yan