Return-Path: Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: (qmail 30443 invoked from network); 2 Oct 2008 07:21:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 2 Oct 2008 07:21:10 -0000 Received: (qmail 15892 invoked by uid 500); 2 Oct 2008 07:21:07 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 15884 invoked by uid 500); 2 Oct 2008 07:21:07 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 15873 invoked by uid 99); 2 Oct 2008 07:21:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2008 00:21:07 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.246.23.145] (HELO mail.hotwaxmedia.com) (63.246.23.145) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2008 07:20:05 +0000 Received: (qmail 12225 invoked by uid 89); 2 Oct 2008 07:19:39 -0000 Received: by simscan 1.1.0 ppid: 12209, pid: 12215, t: 6.6001s scanners: regex: 1.1.0 clamav: 0.93.3/m: spam: 3.2.5 X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on hwm03.managed.contegix.com X-Spam-Level: Received: from unknown (HELO ?192.168.2.55?) (jacopoc@hotwaxmedia.com@87.2.179.200) by mail.hotwaxmedia.com with ESMTPA; 2 Oct 2008 07:19:32 -0000 Message-Id: <6DD0B038-B4A4-4424-9A02-6443FF304CED@hotwaxmedia.com> From: Jacopo Cappellato To: user@ofbiz.apache.org In-Reply-To: <6af6f2f70810012220w5ac90a59ge43c29d648e94a92@mail.gmail.com> Content-Type: multipart/signed; boundary=Apple-Mail-1--188370715; micalg=sha1; protocol="application/pkcs7-signature" Mime-Version: 1.0 (Apple Message framework v929.2) Subject: Re: unit cost and computing for product cost Date: Thu, 2 Oct 2008 09:19:24 +0200 References: <6af6f2f70810012220w5ac90a59ge43c29d648e94a92@mail.gmail.com> X-Mailer: Apple Mail (2.929.2) X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-4.3 required=7.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.2.5 --Apple-Mail-1--188370715 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit You can manage it using the "Cost" tab in the Catalog>Edit Product screens. You can manually enter a record or automatically generate one using the form at the bottom of the screen. However, for products that are purchased, the algorithm is very simple: the purchase price of the "primary" supplier is taken from the SupplierProduct entity (you can edit that information using the "Suppliers" tab). There is also a service that you can submit from Webtools to bulk create the Cost records (using the above algorithm) for all the products. Right now there is no support for the creation of cost information based on average in last purchases or similar. It would be a nice enhancement and we could enhance the form at the bottom of the Cost screen to let the user select the algorithm for cost creation (passing additional parameters such as: num of months to go back for the average etc...) Jacopo On Oct 2, 2008, at 7:20 AM, ian tabangay wrote: > Hi. I was looking into product costing and is wondering where the > unit cost > specified in the InventoryItem entity is placed in. The only time > the unit > cost was used in the computation was when a product is of a > manufactured > type. What I was looking for is a way to get the average cost of my > products. These products were purchased from a supplier and are sold > as is. > > ~ ian --Apple-Mail-1--188370715 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIOPDCCAz8w ggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0 ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcx KDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0 ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxA dGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpB MSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUg UGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA xKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7d yfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/ p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDow OKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3Js MAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgw DQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A 9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYI Tq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8wggM/MIICqKADAgECAgENMA0GCSqGSIb3 DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlD YXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0 aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg Q0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNMDMwNzE3 MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENv bnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElz c3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f 6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYk KhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGj gZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRo YXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0R BCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM 0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZ GwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZ Nd4ksdMdRv9dX2VPMIIDwDCCAymgAwIBAgIQMRr4i+/FrjMrUy7h6G/7fjANBgkqhkiG9w0BAQUF ADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEs MCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDgwNzEwMDky NDQwWhcNMDkwNzEwMDkyNDQwWjCByjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEh MB8GCSqGSIb3DQEJARYSamFjb3BvY0BhcGFjaGUub3JnMSYwJAYJKoZIhvcNAQkBFhdqYWNvcG9j QGhvdHdheG1lZGlhLmNvbTEwMC4GCSqGSIb3DQEJARYhamFjb3BvLmNhcHBlbGxhdG9AaG90d2F4 bWVkaWEuY29tMSowKAYJKoZIhvcNAQkBFhtqYWNvcG8uY2FwcGVsbGF0b0BnbWFpbC5jb20wggEi MA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC6Ym2Kx076cLTom52OqqaFAU2ysKxmVa8LELaM UewkIKubKtV7VbG0VFVBIdez+5e0vZUjGffQvE60AJOfQoM3rPVpfa/pM2vkxSlMldcbESVLk63J ImRUh7VLaL/ptbBfL4m5wioLyUrvDLfjS0nIbnUpL8Ghd94sXhKczDTZbT9P3GHAYHbBiB35lq5q VIi4h6sLiJjVWSVy1fXSBGya93fAeuJKuQEffthLgbgAHxgx7EA38PcCz6tXCWPxhdPA2LD2MgxG T8bjthXXShXMiDwwmKQqMJ7tjTzg1L70Rp+oMvFMUm+n5R54n1WG8fK+VdGNDuMsByuCldW+maYh AgMBAAGjgYkwgYYwdgYDVR0RBG8wbYESamFjb3BvY0BhcGFjaGUub3JngRdqYWNvcG9jQGhvdHdh eG1lZGlhLmNvbYEhamFjb3BvLmNhcHBlbGxhdG9AaG90d2F4bWVkaWEuY29tgRtqYWNvcG8uY2Fw cGVsbGF0b0BnbWFpbC5jb20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQAgS1Vhg1lL cECMmxg0YLJi4HZIKePDrsZWG8gF1BbtzLjNsUv9EvosRHNSstwy2873Ra5nCl0YC5YD9laaXxVr /DJ9u5j4o4pFlUUC5rtwFcV+iF4rxbFy0uoA6a7MUdJDkXswHdgF4Usl8HPDyN8Pb1c+x2w89wa/ jlSNgjknRTCCA+4wggNXoAMCAQICEGfYpArUIF6f5EKXm1+Nq4gwDQYJKoZIhvcNAQEFBQAwYjEL MAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV BAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MTAxNzE5MDM1OFoX DTA4MTAxNjE5MDM1OFowgegxHzAdBgNVBAMTFlRoYXd0ZSBGcmVlbWFpbCBNZW1iZXIxHDAaBgkq hkiG9w0BCQEWDXRpekBzYXN0YXUuaXQxITAfBgkqhkiG9w0BCQEWEmphY29wb2NAYXBhY2hlLm9y ZzEqMCgGCSqGSIb3DQEJARYbamFjb3BvLmNhcHBlbGxhdG9Ac2FzdGF1Lml0MSYwJAYJKoZIhvcN AQkBFhdqYWNvcG9jQGhvdHdheG1lZGlhLmNvbTEwMC4GCSqGSIb3DQEJARYhamFjb3BvLmNhcHBl bGxhdG9AaG90d2F4bWVkaWEuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA31iO YHMFEAnD4/Mc+2rx8g6CEg82RB6OWaFu3xTJXHRyF7bp5ZZDfHg0Azt71P1nz+UuwbUoq+AkVG/g ZzAzhEsdPDoPx/05Zo0UB4E9K5X4agTUWJHL5V85x/xjR5diMxIlBAX7XOTjEiGygCznT6dr2zf3 FBsH4i4be8c4EShyBPjgV1cQxL7JNMq2aAFeaO5cIu7BTFj/G0Yv5AxwMuv2VSovmj0tmqjnK2r/ b9If4HrA5yuzeUu0GtJVOsp2RKxtHqLHf9avm6AjgVCp5O93iUMGnB9JrnEGlRNrfkZKXVH2g0ln BIBzXnl1TZGM4d/8DwwvA9dM5H9r0umtiwIDAQABo4GZMIGWMIGFBgNVHREEfjB8gQ10aXpAc2Fz dGF1Lml0gRJqYWNvcG9jQGFwYWNoZS5vcmeBG2phY29wby5jYXBwZWxsYXRvQHNhc3RhdS5pdIEX amFjb3BvY0Bob3R3YXhtZWRpYS5jb22BIWphY29wby5jYXBwZWxsYXRvQGhvdHdheG1lZGlhLmNv bTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAFtC/QsK9M0g3QPj1Qd3X30Vzyg1Oryt iJmuz0mlTt6RmHh+l2Xb1draytKrif/6T/0oXWKx05K+LpanjeUu83R0JDojBsoA9Q+0vRatkqAZ UXxRxgjkckvEiZ4GyxonN8MLfqVXUUbm/1gFoK1Yy8ms286ZY1rf0kVNky0nvpnKMYIDEDCCAwwC AQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRk LjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEDEa+Ivvxa4z K1Mu4ehv+34wCQYFKw4DAhoFAKCCAW8wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG 9w0BCQUxDxcNMDgxMDAyMDcxOTI1WjAjBgkqhkiG9w0BCQQxFgQU87GE3zo8I/PH2Mqkv/9gmSVw lJMwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25z dWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1 aW5nIENBAhBn2KQK1CBen+RCl5tfjauIMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMC WkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0 ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBn2KQK1CBen+RCl5tfjauIMA0GCSqGSIb3 DQEBAQUABIIBABQIESt+FWlxgK4EVX+GcpzsOz4Td5xdNc2VjrhaUx+IgecJAqpa1tFVK1IHNYvn Q3PyEwe3dM6ORXfduTbDv5twdggX+QGxs2wHANmB6lWtJS2oW+xMAmhZgryBo5mxio7KZT3hfsvr Ks21141YKghuv9eSRf9yGayAIvJMLBDSPghgjpM/D89cwD/MGP0qOMDJLCpygUO9apYICgeBGVr8 XuzXjuh6yRUIuI1kmdy6yPYjpP6tfC4U/VOsYGIXWTR/uYlD3bVALZcPvUsj9+G8VySnD2DhgpfR Vw350U2iY3EAcBQrMRl31MW0RVduwXP+t5VGoZJFhDq8DTITsP0AAAAAAAA= --Apple-Mail-1--188370715--