x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 4 replies
  • Subscribers 55 subscribers
  • Views 1078 views
  • Users 0 members are here
Browse Forums
Announcements
764
topics
17
replies
Financial year end
78
topics
177
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
175
topics
311
replies
Install your software
137
topics
375
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
147
topics
321
replies
Protect and repair your data
44
topics
136
replies
Run your accounts remotely
85
topics
197
replies
Working with the bank
114
topics
292
replies
GHolmes

Profit Invoice Report

Posted By

Hi,

I run the profit invoice report each month which we find very helpful however I notice that the report picks up 'Cost based on the average cost price'

Our raw materials are subject to seasonal fluctuations so it is important for us to know the true profit - is there a way this report can be amended to return the actual cost of the product that was sold?

The system knows which batch of a certain product was allocated to a specific Sales Order so it has the information required, i just need to know how to extract it

Thanks in advance for your help,

Parents
  • 0

    The Product Record has the Sales order number, the quantity, the actual cost price and also the sales price so I am sure I should be able to create something in order to breakdown our month GP in to products? There is a Product Profit report I can run however this does not show the supplier who bought the goods.

Reply
  • 0

    The Product Record has the Sales order number, the quantity, the actual cost price and also the sales price so I am sure I should be able to create something in order to breakdown our month GP in to products? There is a Product Profit report I can run however this does not show the supplier who bought the goods.

Children

*Community Hub is the new name for Sage City