Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Transfer in and inventory adjustments don't include time and Inventory adjustments are not correct #6

Closed
arbaughj opened this issue Mar 27, 2013 · 3 comments

Comments

@arbaughj
Copy link

The time for inventory adjustments and transfer in's uses a time of 12:00 AM rather than the actual time. This makes the 'Stock History' list potentially out of order.

Additionally, possibly related, the total amount in inventory is invalid. Do the following to reproduce...
1.) Select and inventory item.
2.) Create an incoming shipment and receive it into inventory. In our example, there was no preexisting inventory.
3.) Then create a stock requisition for 700 of the item you received into inventory. Leave the date as today's date. Pick 700 of the 7000 that entered previously.
4.) Go to the inventory for the item, and you will see 6300 in inventory.
5.) Go to adjust stock. Enter 6200 and click "Adjust stock".
6.) View the quantity of items on hand, and you will notice there are now 5500 of that item in stock rather than the 6200 you just said it had in stock.

This happens with...
Application Version: 0.5.5 | Build Number: v0.5.4-16-g13a848b

@jmiranda
Copy link
Member

Thanks James. We are aware of that issue and decided on "midnight" for a reason (we were pretty sure that we wouldn't see multiple transactions on the same day). However, that is no longer valid so I will make a change as soon as I feel confident that this won't have any side effects on existing data. When calculating the quantity, we sort all transactions by transaction date, then created date, which should result in quantity on hand = 6200 EA in this case. So it seems there might be something else wrong with the on hand quantity calculation.

@jmiranda
Copy link
Member

As a workaround, you can edit the transaction date (adding a valid time component) and that should fix it for the time being.

@arbaughj
Copy link
Author

Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants