[Question] JobCodes on sales invoices to appear in GL report

[DewaldSmit]

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

[VLW]

I would rather restructure the COA, less room for error if there is more than one person working on the data set. So many people overlook project codes. I'm not too familiar with partner ito account segments but pastel evolution works like a dream.

Sent from my SM-A500FU using Tapatalk

[DewaldSmit]

Many thanks VLW. It is a very small business and there is basically no budget for reporting, so I will have to do with what is available. Currently I am the only one doing the processing. I have considered restructuring the COA with the divisions being sub-accounts 100,200,300,etc. . This works if I want to report on the divisions individually, but when I want to report on the business as a whole, I want to group the Accounting fees (for example) as one line item on the summary report and not as 4 line items (one for each division).