Problem with the Job Profitability Detail Report & Open Orders Report

Adie

First timer here ;)

I have run the job profitability report for one specific job and it is showing an amount of $134,789.28 at Act.Cost. It should be $269,578.55 which is the amount of the bills receipted for this job. It is only showing exactly half the amount. The strange thing is that the Sales Order for this same job is showing is showing an open balance of $157,482.34, but in reality it is only $120,822.84 that still needs to be invoiced.

Please help !

Adie

Acctd4

Hi @Adie

Welcome to the forum!

The job profitability reports are quite comprehensive.

The "Act Cost" for stock Items is determined by the Item's quantity, multiplied by the most recent (Bill) cost price, in relation to each sale (invoice) of it.

If we look at this one for instance:

The drill down shows this:

HOWEVER, although the cost column displays an invoice, this isn't actually the amount invoiced:

Instead, it's the value of that particular Item at the point it was sold:

In your company file Preferences, (accessed via the Edit dropdown menu along the top toolbar) you can specify if you want only on-hand or also qtys reserved for builds & on Sales Orders taken into account:

Your selection here will therefore also impact the qty considered for the "profitability" value.

Hope that makes sense ! 😊

Adie

Thank you so much for responding to my query and going into such a detailed explanation. Explains everything.

Acctd4

Good to hear Adie ☺️