Versions Compared

Old Version 1

changes.mady.by.user Bryan Alborough

Saved on

compared with

New Version Current

changes.mady.by.user Bryan Alborough

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Like the stock variance report, the actual Cost of Sales is worked out from the following formula:

Opening Stock PLUS Purchases PLUS/MINUS Net Stock Movement MINUS Closing Stock EQUALS Actual Cost of Sales

 

 The report then gives a comparison of the totals, and a final Difference between the two. This is then subtracted from the Net Sales to give you final Actual and Theoretical Gross Profit figures. Ideally, The actual needs to be as close to the theoretical as possible.

Report Footer

 

 NB:

  •  The GP report is very sensitive to price changes. Very often large errors can appear from simple mistakes in GRV's that cause prices to be calculated incorrectly. If you spot large errors, check the Stock Purchase Exceptions report for any indication of incorrect GRV's that need to be fixed. 

  •  The value of the Theoretical stock is worked out using the Stock cost calculation method. Please see the Reports Manual for more information on how Stock calculation works. 

...

Troubleshooting

Any problems with the GP report will usually show up as a large figure in the Difference column. Troubleshooting the GP often means finding out what's causing the difference figure

...

Once fixed, the affected stock values will need to be refreshed. To do this, go to Lists > Stock > Items and click Refresh Costs to update the current stock costings. However, this only fixes current stock costings. You will also need to refresh the values in the stocktakes for the period you're running your report for if you're running fixed, and every stock take in the date range if you're running FIFO stock costing.

NB: To refresh a stocktake, edit it and then re-capture at least one value on the grid Then click Post.

Restart Backoffice so that costs are updated once more, and re-run the report. This process may need to be repeated if there are multiple items.