Hello, I am trying to generate monthly sales reports using ReadyPro but I am finding it difficult to include the purchase price of an item in the report. What is the best way of producing a report that shows an accurate cost of sales?
Fabio28/09/2012 18:53
Fabio
Hello, exactly which data you would see in the report and grouped in what way? (for ex. detailed by product, detailed by customer, ...) ?
WPZ01/10/2012 10:31
WPZ
Hello, it needs to be detailed by products sold, indicating the quantities sold, sale price, and LIFO purchase price for the product. It is the LIFO purchase price that I am having difficulty with.
Fabio01/10/2012 15:13
Fabio
Quote: needs to be detailed by products sold, indicating the quantities sold, sale price,
You can create a report from ACCOUNTING / STATISTICS menu
Fabio01/10/2012 15:15
Fabio
Quote: and LIFO purchase price for the product
A report can be generated from WHS / WAREHOUSE VALORISATION You cannot have a report with LIFO and sales data together
WPZ01/10/2012 16:27
WPZ
Quote: You cannot have a report with LIFO and sales data together
Wouldn't a link between Purchase Price of a product and Sales Data be necessary in order to work out an accurate "Cost of Goods Sold"?
Fabio03/10/2012 17:07
Fabio
Using STATISTICS it isn't possible. You can compare prices only with FIFO value
The only alternative is to create a custom view on product list, but this method needs some custom scripts.
