Hi Everybody

I trying to create an income statement per division by using the General Ledger Transaction report in Pastel's Intelligence Reporting and by employing the Project Codes as the codes for the divisions.

If I add the JobCode field to my pivot table, only the JobCodes for the transactions posted in my cash book appears and not those entered for sales on customer invoices.

On the Project Report the sales and costs are grouped together, however, so I guess they must be linked in a table somewhere - I just do not know where.

I thought that this route might be easier than restructuring the entire COA.

Am I going about this in the wrong way, or is there an easier way?

I am using Partner V14.2.1.

Any assistance would greatly be appreciated.

Many thanks