Project Code report

[Former Member]

Hi im having problems creating a Project Code Report, in one in SAP Business One is good, but i would like to see the account name beside the Account code and omitt certain codes i.e. sales etc - this i can do by the Where statement (T1.Segment_0 < [%1] which im happy enough with.

im having problems in the Query Generator.

I cannot get the Debit and Credit to total up and cannot seem to group by Project Code.

Any help in this matter, would be appreciated.

[former_member201110 · Accepted solution]

Hi Damien,

Could you post your query as this might make it easier for people to comment on what needs to be done?

Thanks,

Owen

[Former Member · Accepted solution]

the Query is as follows:-

SELECT T0.TransId, T1.Segment_0, T1.Segment_1, T1.Segment_2, T1.AcctName, T0.RefDate, T0.Debit, T0.Credit, T0.Project FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode WHERE T0.RefDate >= '[%0]' and T0.RefDate <= '[%1]' and T1.Segment_0 >'[%2]' and T0.Project Like '%%_%%'

I would like to be able to group by Project Code and have the total amount for the Project.

Many thanks