cancel
Showing results for 
Search instead for 
Did you mean: 
SaulA
Level 3

Profit & Loss by Job not working correctly

The "Profit & Loss by Job" report (any job-related report, really) does not work. When will this be fixed?

 

For example, my "Profit & Loss by Job" report shows much of my COGS, and all of my non-inventory COGS,  under "No sales rep" even though every transaction is associated with a job that has a sales rep.

 

P&L by Job.PNG

 

That the data is there, and correct, is easily verified by drilling down / clicking through from the report; it's just the report that is not correct.

 

All of the "by Job" reports, no matter how they are sorted (by Rep, or Customer, etc.) have similar anomalies. (Nevermind that the revenue numbers don't match the income statement, which don't match the sales reports... that's a rant for a different post.)

 

For our business, the "by Job" reports would be the most useful set of reports if only they'd work. Besides helping us to understand profitability by customer/job, we (would if it worked) use this report to calculated sales commissions.

 

Is this a known defect? Is there an estimate of when this will be repaired? Has anyone devised work-arounds to properly report cost by job? 

2 Comments 2
BigRedConsulting
Community Champion

Profit & Loss by Job not working correctly

The report in your picture is not a P&L by Job, but a P&L by rep.

 

Normally the COGS will appear in the correct column, unless that is  you sell your inventory before you buy it, and in that case the COGS is recorded not on your sales, but on your subsequent purchases.

 

If you quickZoom on the offending COGS amounts, what type of transactions appear on the resulting detail report?

Saul Ackovitz
Level 1

Profit & Loss by Job not working correctly

Yes, the picture I showed happens to be set so that "Show Columns" is by Rep, but the report generated was the P&L by Job, and shows similar errors when left at its default column setting of Customer Job.

 

As mentioned in my original post, drilling down (by Quick Zoom or any other route) into individual transactions shows them to be coded correctly: they are associated with a Customer:Job, that Job has a Sales Rep assigned, they are assigned to the correct G/L code, etc.

 

Quickzoom the Total field shows a transaction list:

 

TrasnList.JPG

and quickzoom on any of those transactions shows it coded properly:

singletran.JPG

 

So... the transaction is correct, the detail report is correct, but the P&L view is not correct as far as I can tell.

Need to get in touch?

Contact us