We are creating a report that pulls all prior years P&L activity for each job to create a profitability report per hour for each job. However when we closed out the prior years in NAV it is not pulling the full balance of the cost and revenue we need. We think this is due to retained earning netting against all the prior years activity when closing prior years. Is there a filter that can bypass those close entries so we can pick up rev and expense activity without the items netting to 0?
The report is set up as follows:
1) P&L account numbers listed
2) All job numbers stretched across header columns after account numbers
The Key is attached to the filters (date range, job number, each P&L account no.)
NL("First","G/L Account",,"No.",C19,"Account Type","Posting","Job Number Filter",$E$2,"Date Filter",$E$3)
The fields for the jobs for each P&L account is as follows:
IFERROR(-NF($B18,"Net Change","Job Number Filter",L$4(Column header),"Date Filter",$E$3),"")
Thanks!
