Inventory - Moving Average

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Shi Jinghai-3]

If moving = shipment, there's a SALES_RETURN in ShipmentType.

You can add a new shipment type for returning to vendor/ factory.

Kind Regards,

Shi Jinghai

-----邮件原件-----
发件人: [hidden email] [mailto:[hidden email]]
发送时间: 2018年1月25日 6:54
收件人: [hidden email]
主题: Inventory - Moving Average


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

[Vaibhav Jain]

Hello James,

What do you mean by "Moving average costs"?

Vaibhav Jain
Sr. Enterprise Software Engineer
HotWax Systems
m: 782-834-1900 e: [hidden email]
<[hidden email]>

On Thu, Jan 25, 2018 at 4:23 AM, <[hidden email]> 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
>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Vaibhav Jain]

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: [hidden email]
<[hidden email]>

On Thu, Jan 25, 2018 at 1:57 PM, <[hidden email]> 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 <[hidden email]>
> Date: Wed, January 24, 2018 10:17 pm
> To: [hidden email]
>
> Hello James,
>
> What do you mean by "Moving average costs"?
>
> Vaibhav Jain
> Sr. Enterprise Software Engineer
> HotWax Systems
> m: 782-834-1900 e: [hidden email]
> <[hidden email]>
>
> On Thu, Jan 25, 2018 at 4:23 AM, <[hidden email]> 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
> >
>

[Paul Foxworthy]

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 <[hidden email]>
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: [hidden email]
> <[hidden email]>
>
> On Thu, Jan 25, 2018 at 1:57 PM, <[hidden email]> 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 <[hidden email]>
> > Date: Wed, January 24, 2018 10:17 pm
> > To: [hidden email]
> >
> > Hello James,
> >
> > What do you mean by "Moving average costs"?
> >
> > Vaibhav Jain
> > Sr. Enterprise Software Engineer
> > HotWax Systems
> > m: 782-834-1900 e: [hidden email]
> > <[hidden email]>
> >
> > On Thu, Jan 25, 2018 at 4:23 AM, <[hidden email]> 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: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]

[Paul Foxworthy]

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 <[hidden email]> 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 <[hidden email]>
> 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: [hidden email]
>> <[hidden email]>
>>
>> On Thu, Jan 25, 2018 at 1:57 PM, <[hidden email]> 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 <[hidden email]>
>> > Date: Wed, January 24, 2018 10:17 pm
>> > To: [hidden email]
>> >
>> > Hello James,
>> >
>> > What do you mean by "Moving average costs"?
>> >
>> > Vaibhav Jain
>> > Sr. Enterprise Software Engineer
>> > HotWax Systems
>> > m: 782-834-1900 e: [hidden email]
>> > <[hidden email]>
>> >
>> > On Thu, Jan 25, 2018 at 4:23 AM, <[hidden email]> 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: [phone] <+61%203%209585%206788>
> Web: http://www.coherentsoftware.com.au/
> Email: [hidden email]
>

--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]