Showing results for 
Search instead for 
Did you mean: 

Project Code report

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Damien,

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



Former Member
0 Kudos

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

Answers (0)