Hi again, Adjustment to COGS for returns are handled within the createAcctgTransForCustomerReturnInvoice service.
You can see the current average cost in the Inventory Valuation report (Accounting - Organization GL Settings - Reports - Inventory Valuation, https://demo-trunk.ofbiz.apache.org/accounting/control/InventoryValuation?organizationPartyId=Company ). Cheers Paul Foxworthy On 28 January 2018 at 11:39, Paul Foxworthy <p...@cohsoft.com.au> wrote: > Hi James, > > https://issues.apache.org/jira/browse/OFBIZ-9500 and the thread at > http://ofbiz.135035.n4.nabble.com/AccountingQuantity- > COGS-method-and-inventory-valuation-td4700867.html that preceded the Jira > might be relevant here. > > Cheers > > Paul Foxworthy > > On 27 January 2018 at 16:37, Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> > wrote: > >> Hello James, >> >> If you are looking for COGS methods of inventory valuation then >> *cogsMethodId* of *PartyAcctgPreference* entity defines the valuation >> method. >> >> *cogsMethodId* for average costing of Inventory valuation is >> *COGS_AVG_COST* >> >> I hope that this will help you :) >> >> Vaibhav Jain >> Sr. Enterprise Software Engineer >> HotWax Systems >> m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com >> <desiree.jenkin...@hotwax.co> >> >> On Thu, Jan 25, 2018 at 1:57 PM, <ja...@productive1.com> wrote: >> >> > Inventory Valuation. We have selection Average Costing. Where can I >> > see the average costs of a product. How is it calculated in the system? >> > >> > >> > -------- Original Message -------- >> > Subject: Re: Inventory - Moving Average >> > From: Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> >> > Date: Wed, January 24, 2018 10:17 pm >> > To: user@ofbiz.apache.org >> > >> > Hello James, >> > >> > What do you mean by "Moving average costs"? >> > >> > Vaibhav Jain >> > Sr. Enterprise Software Engineer >> > HotWax Systems >> > m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com >> > <desiree.jenkin...@hotwax.co> >> > >> > On Thu, Jan 25, 2018 at 4:23 AM, <ja...@productive1.com> wrote: >> > >> > > >> > > Does anyone know where I can find the moving average costs for each of >> > > the products in Ofbiz? What about how the system calculates moving >> > > average and how it is affected by returns from customers and returns >> to >> > > vendor? >> > > >> > > Thanks, >> > > >> > > James >> > > >> > >> > > > > -- > Coherent Software Australia Pty Ltd > PO Box 2773 > Cheltenham Vic 3192 > Australia > > Phone: +61 3 9585 6788 <+61%203%209585%206788> > Web: http://www.coherentsoftware.com.au/ > Email: i...@coherentsoftware.com.au > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: i...@coherentsoftware.com.au