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.