Physical Inventory - wrong accounting entries

[Kevin McMenamin]

v 6.0.2 latest release, anglo-saxon installed

I initially thought this was a simple accounting issue, but the problem is worse. When I import inventory balances for a single location it picks up stock from other locations (that are within the same tree?). This means that even though I don't change stock numbers there are journal entries being created.

Also the accounting entries for any stock adjustment arising from a physical inventory should be:
For a stock reduction:
DR Price Difference Account
CR Stock Variation Account

For a stock increase:
DR Stock Variation Account
CR Price Difference Account

The stock variation account is being used, but the offset is going to Stock Input Account.

I have enclosed a video to show what is happening, but this is a serious problem.

[Amit Parik (amit-parik)]

Hello,

I have faced the same problem at my end.

I have attached a video for more reference so would you please check it.

Thanks.

[Kevin McMenamin (kevin-mcmenamin)]

You are getting my results on the quantities. Graeme has pointed out that that in the location I should be able to put in the correct offset account for the loss/gain - I have set this up for location Inventory Loss and reran the process - the correct account for the loss is now there, so you can ignore the accounting issue - just the stock number & source issue to resolve.

Thanks

[Graeme Gellatly (gdgellatly)]

Hi Kevin,

I emailed you privately so they won't quite understand your comment.
 Basically and correct me if I'm wrong, the only bug (as opposed to
configuration issue) that we are now interested in is

When you use the import inventory wizard, it returns the incorrect stock
quantity for the location, which appears to be the quantity of the entire
tree rather than the individually selected location.

What we no longer think is a bug (or perhaps never thought)

Stock quantities related from validating the inventory. (I think this was
always correct)
Accounting entries related to validating the inventory. (I think this was
corrected by amending Inventory Loss location properties)

So just the wizard!

On Fri, Aug 19, 2011 at 10:09 AM, Kevin McMenamin <<email address hidden>
> wrote:

> You are getting my results on the quantities. Graeme has pointed out
> that that in the location I should be able to put in the correct offset
> account for the loss/gain - I have set this up for location Inventory
> Loss and reran the process - the correct account for the loss is now
> there, so you can ignore the accounting issue - just the stock number &
> source issue to resolve.
>
> Thanks
>
> --
> You received this bug notification because you are subscribed to OpenERP
> Addons.
> https://bugs.launchpad.net/bugs/828370
>
> Title:
> Physical Inventory - wrong accounting entries
>
> Status in OpenERP Modules (addons):
> Confirmed
>
> Bug description:
> v 6.0.2 latest release, anglo-saxon installed
>
> I initially thought this was a simple accounting issue, but the
> problem is worse. When I import inventory balances for a single
> location it picks up stock from other locations (that are within the
> same tree?). This means that even though I don't change stock numbers
> there are journal entries being created.
>
> Also the accounting entries for any stock adjustment arising from a
> physical inventory should be:
> For a stock reduction:
> DR Price Difference Account
> CR Stock Variation Account
>
> For a stock increase:
> DR Stock Variation Account
> CR Price Difference Account
>
> The stock variation account is being used, but the offset is going to
> Stock Input Account.
>
> I have enclosed a video to show what is happening, but this is a
> serious problem.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/828370/+subscriptions
>

[Rohan Nayani(Open ERP) (ron-tinyerp)]

Hello kevin,
 I have checked in latest trunk from my side, Its working fine.

 This was not accounting issue, it was returning the incorrect stock quantity for the location(When you used the import inventory wizard for particular location) also said by Graeme Gellatly,
 so, I am closing this bug for now,

For more information i have attached video so would you please check it.

Thanks.

[Amit Parik (amit-parik)]

Hello Rohan,

I have checked this again with the latest trunk and the issue are resolve which is related incorrect stock quantity.

But in past it's reproducible which is described in comment #1 and comment#3 's video.

So this bug 's status should be "Fix released " not an "Invalid".

Thanks.