We have created a project and require to keep track of the total expenditure on this project. However, currently the system only calculates the project expenditure that has gone through the purchase ledger. Project purchases that are analysed directly to the Nominal Ledger are not included even though they are tagged with the correct project identity. For example, Sub-contract labour is not a purchase ledger item and is therefore posted directly to the Sub-contractors account in the Nominal Ledger and in this case will not be included in the totals for the project. What we require is that all income and expenditure items tagged with a particular project be included in the totals for that project not just the sales and purchase ledger items.
Many thanks in anticipation for your kind assistance.