c2c-oerpscenario team mailing list archive

[Kevin McMenamin <806269@xxxxxxxxxxxxxxxxxx>]

Amit

I have attached a spreadsheet which hopefully helps to explain what I
mean.

I see that cost price is stored against each line in
account_invoice_line so you can calculate the actual costs at the same
time as calculating the actual sales.

Personally I think putting purchase information on this screen is
confusing, but over to you.

The screen should calculate for the defined period:
 - actual sales (both units and value)
 - actual costs (based on the same sales records)
 - actual margin (sales $ - cost $)

Thanks
Kevin

** Attachment added: "Explanation for Product_Margin.xls"
   https://bugs.launchpad.net/openobject-addons/+bug/806269/+attachment/2219150/+files/Explanation%20for%20Product_Margin.xls

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/806269

Title:
  product_margin module errors

Status in OpenERP Modules (addons):
  Incomplete

Bug description:
  This module is designed to show the margin per product, but it
  compares sales to purchases not sales to cost of sales. If the
  purchase quantity <> sales quantity then an invalid result is
  calculated.

  the purchases section should be renamed the "Cost of Sales" section.
  The #invoiced value should always equal the sales #invoiced value.

  The #Avg Unit Price should probably look at the purchases over the
  same period as the sales and calculate. While not always correct (as
  ignores stock on hand at start of period) is it a reasonable solution.
  Alternative is to to take current average cost, but that has issues if
  prices are moving through the reported period.

  Once the above is fixed the margin will calculate correctly.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/806269/+subscriptions