Hello, Your idea is indeed interesting. However, this is more a wishlist than a real bug. We currently do not plan to integrate that sort of calculation.
Best regards, Thibault Delavallée. ** Changed in: openobject-addons Importance: Low => Wishlist -- You received this bug notification because you are a member of OpenERP Indian Team, which is subscribed to OpenERP Addons. https://bugs.launchpad.net/bugs/743630 Title: Cost price - decimal accuracy Status in OpenERP Addons (modules): Confirmed Bug description: This bug might be related to https://bugs.launchpad.net/openobject- addons/+bug/726816. I'm sorry that I'm this late with "my idea".... product_product.standard_price field shouldn't gets its precision neither from 'account' nor from 'purchase price' - it should have it's own accuracy entry in 'decimal accuracy' I don't want my purchase orders calculated or printed with 6 digits, and I don't want any outgoing invoice calculated or printed with 6 digits. But for average price calculation I NEED more than 2 digits! example: Create new product, costing method = average price (set to 0,00) Create PO_1: 10 pce, price 1,- Euro, reception -> move anlaysis (total): qty 10, value 10,- Euro -> product.form average price = 1,- Create PO_2: 10 pce, price 1,50 Euro, reception -> move analysis (total): qty 20, value 25,- Euro -> product.form average price = 1,25 Create delivery order: 10 pce, process and validate -> move analysis (total): qty 10, value 12,50 Euro -> product.form average price = 1,25 Create PO_3 10 pce, price 1,- Euro, reception -> move analysis (total): qty 20, value 22,40 Euro Product.form average price = 1,12 This is how OpenERP book explains the average price calculation formula: NP = (OP * QS + PP * QR) / (QS + QR), where the following notation is used: • NP: New Price, • OP: Old Price, • QS: Quantity actually in Stock, • PP: Price Paid for the quantity received, • QR: Quantity Received. In my example (last recalculation of average price through reception PO_3) it would mean: OP = 1,25 QS = 10 PP = 1,00 QR = 10 NP = (1,25 * 10 + 1,00 * 10) / (10 + 10) = 1,125 first issue: The stock value after the last reception (PO3) is 22,50 Euro (1,25 * 10 + 1,00 * 10), move analysis says: 22,40 Euro second issue: Rounding cost price: 1,125 should have get rounded up to 1,13 instead of down to 1,12 So, I don't need 6 digits when I purchase for 1,50 Euro; I don't need 6 digits when I sale for 2,75 Euro. But I need a solution for A) wrong stock value B) wrong average price To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/743630/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
