Author Post
WPZ 28/09/2012 18:11 WPZ

Monthly Report

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?
Fabio 28/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, ...) ?
WPZ 01/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.
Fabio 01/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
Fabio 01/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
WPZ 01/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"?
Fabio 03/10/2012 17:07 Fabio

Using STATISTICS it isn't possible. You can compare prices only with FIFO value Sad

The only alternative is to create a custom view on product list, but this method needs  some custom scripts.