# \[16.5.61\] Inventory items can be selected under "Items" column

**URL:** <https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167>\
**Category:** Uncategorized\
**Created:** [June 25, 2016, 2:52am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167 "2016-06-25T02:52:13Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 2:52am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/1 "2016-06-25T02:52:13Z")

</div>

In the latest version, when you are buying or selling inventory items, you don’t have to select an account `Inventory on hand` or `Inventory - sales` anymore.

All inventory items are now available under `Items` column.

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/c/c0a5016c7227e27508922eb66008a18ead0729ef.png)

When inventory item is selected, account name will be filled-in automatically based on the context.

- If you are selling inventory item, the account name will say `Inventory - sales`.
- If you are purchasing inventory item, the account name will say `Inventory on hand`.

### How does this affect invoice items?

`Sales invoice items` & `Purchase invoice items` have been merged and renamed to `Non-inventory items` as items are now used across the whole program and no longer limited to only invoices. So the previous terminology was no longer applicable.

Also, to keep behavior under `Items` column consistent. If you select an item (inventory item or non-inventory item), you won’t be able to select an account. The item itself will determine into which account the transaction should be posted to.

For example, if you setup non-inventory item called `Delivery fees`, do not leave `Account` field empty.

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/c/c98b5a409bde015bbd970d7e1432a6202ceaa151.png)

If you do, on your invoice or receipt to customer where you charge them delivery fees, the amount will be posted to `Suspense` account.

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/fa565857245bcd85bd1ddb94eb4531230003d949.png)

The quick solution is to simply set the account on your non-inventory item. This will automatically update all transactions where item was used in so the transaction won’t longer be posted to `Suspense`.

### How does this affect delivery notes?

`Delivery notes` never had `Account` column so it wasn’t possible to select inventory item. This usually wasn’t a problem as delivery notes have been usually created out of quotes or invoices. However if you tried to create delivery notes from scratch, it wasn’t that easy. By making it possible to select inventory item from `Items` column, you can now create delivery notes from scratch quite easily.

### How does this affect quotes & orders?

Quotes & orders don’t have any impact on general ledger. However in order to allow selecting inventory items on these documents, account column was present in previous versions.

Since inventory items are now available under `Items` column, there is no need to have `Account` column on non-accounting documents such as quotes & orders. So this column has been removed on quotes & orders. This should make data-entry more straightforward and less confusing.

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/f/fdea00edda27e0a1db6dd3b8b368c628ad41cc70.png)

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 3:48am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/4 "2016-06-25T03:48:02Z")

</div>

Pinned globally on June 25, 2016, 3:48am UTC



---

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [June 25, 2016, 4:45am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/5 "2016-06-25T04:45:56Z")

</div>

Something is wrong with the latest release (Manager 16.5.61).  
Under Inventory Items tab now I have zero Qty on Hand and thousands (!!!) under Back Order column.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 5:30am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/6 "2016-06-25T05:30:01Z")

</div>

OK, there was an issue with upgrading. Could you try the latest version (16.5.64)?

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [June 25, 2016, 5:39am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/7 "2016-06-25T05:39:50Z")

</div>

@lubos I haven’t downloaded the latest version yet, am on bed. 😁 but just wanted to know if Items are showing under `Receive and Spend Money`

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 5:43am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/8 "2016-06-25T05:43:12Z")

</div>

Yes, they are.

---

<div class="post-metadata">

**Author:** ![Abeiku](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abeiku/32/44970_2.png) [@Abeiku](https://forum.manager.io/u/Abeiku)\
**Post date:** [June 25, 2016, 5:44am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/9 "2016-06-25T05:44:19Z")

</div>

Awesome, this is a massive leap forward.

---

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [June 25, 2016, 5:45am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/10 "2016-06-25T05:45:20Z")

</div>

Version 16.5.64. Some of Inventory Items fixed but most of them still showing Back order qty.

---

<div class="post-metadata">

**Author:** ![ahmedansar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ahmedansar/32/2478_2.png) [@ahmedansar](https://forum.manager.io/u/ahmedansar)\
**Post date:** [June 25, 2016, 6:19am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/11 "2016-06-25T06:19:32Z")

</div>

Good Update, I was waiting for this update.

Many thanks.

---

<div class="post-metadata">

**Author:** ![norfolkislandam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/norfolkislandam/32/40_2.png) [@norfolkislandam](https://forum.manager.io/u/norfolkislandam)\
**Post date:** [June 25, 2016, 7:37am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/12 "2016-06-25T07:37:41Z")

</div>

This has created a bit of a problem for me.  
I buy and sell Inventory items which is not a problem, but I do buy some chemicals which are used when I do a service job such as pest control, and because of small quantities and many variations my accountant suggested that when entering my purchase order items, I allocate those inventory items I buy and sell to inventory on hand, but those chemicals which I use for a service, to simply put those in as Business Consumable - Chemicals.

With your new system it does not allow me to do that. I must allocate to an inventory item,

My old purchase items that I had allocated to Business Consumable - Chemicals now show as an ###

Can you please help.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 8:05am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/13 "2016-06-25T08:05:16Z")

</div>

You can still use non-inventory items like before.

And if you don’t select any item, you can just select general ledger account.

---

<div class="post-metadata">

**Author:** ![ntrim](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ntrim/32/18838_2.png) [@ntrim](https://forum.manager.io/u/ntrim)\
**Post date:** [June 25, 2016, 10:09am UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/14 "2016-06-25T10:09:51Z")

</div>

I agree with @norfolkislandam

 ![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/9/967aa68a8df553097c3c339e3f036676731ad034.png)

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 2:13pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/15 "2016-06-25T14:13:54Z")

</div>

@norfolkislandam, the latest version (16.5.69) should fix the issue.

---

<div class="post-metadata">

**Author:** ![norfolkislandam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/norfolkislandam/32/40_2.png) [@norfolkislandam](https://forum.manager.io/u/norfolkislandam)\
**Post date:** [June 25, 2016, 7:26pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/16 "2016-06-25T19:26:32Z")

</div>

Thank you for that, but unfortunately while it has removed the ###, it will not allow me to enter the item purchased and assign it to business consumable, it says because it is an inventory item it must go to inventory on hand.  
The problem is that some of my inventory items are also used for my general work where I do not want to show as an inventory sale.

For example I buy and sell buckets of rodent bait in 8kg pails. Not a problem. I purchase 8 of those pails, and assign 6 to inventory on hand, but assign 2 to Business Consumable - Chemicals because I also break those pails open for when I go around and replenish bait stations as part of my pest control service.  
I might only use 4or5 out of a pail of 250, so instead of making each blox an inventory item, I simply assign the whole bucket to my expense account as mentioned

---

<div class="post-metadata">

**Author:** ![itmoto](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/itmoto/32/12177_2.png) [@itmoto](https://forum.manager.io/u/itmoto)\
**Post date:** [June 25, 2016, 8:02pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/17 "2016-06-25T20:02:45Z")

</div>

You need to allocate all items to inventory then create an inventory write off to expense those items to the appropriate expense account.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 8:11pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/18 "2016-06-25T20:11:14Z")

</div>

Well, that’s one way but you don’t have to select an item at all. If you don’t select an item, you can select account name.

So if you purchase 8kg of product and you need to split it between `Inventory on hand` and `Business consumables`, you will have two line items. In the first one, you select an inventory item so it gets posted to `Inventory on hand`. On second line item, you don’t select any item which means you will be able to select an expense account such as `Business consumables`.

---

<div class="post-metadata">

**Author:** ![norfolkislandam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/norfolkislandam/32/40_2.png) [@norfolkislandam](https://forum.manager.io/u/norfolkislandam)\
**Post date:** [June 25, 2016, 8:28pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/19 "2016-06-25T20:28:35Z")

</div>

I simply have 2 purchase items for the one item I assign one to inventory on hand and one to Businesss consumables

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 8:43pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/20 "2016-06-25T20:43:51Z")

</div>

Yeah, that’s also an option. But as you can see, this change is not taking anything away from you while solving a lot of various issues for others.

---

<div class="post-metadata">

**Author:** ![norfolkislandam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/norfolkislandam/32/40_2.png) [@norfolkislandam](https://forum.manager.io/u/norfolkislandam)\
**Post date:** [June 25, 2016, 8:50pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/21 "2016-06-25T20:50:37Z")

</div>

Can you please expand that. Will that be suitable way to do it for my accountant. Just not quite sure what you meant by “But as you can see, this change is not taking anything away from you while solving a lot of various issues for others”

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 25, 2016, 8:54pm UTC](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167/22 "2016-06-25T20:54:32Z")

</div>

The only change for you is that when you select non-inventory item, you can’t select an account. So how do you select an account?

- Select non-inventory item, which is linked to the desired account (you can create such an item upfront)
- Leave the item field empty so you can select any account you like.

I think we are going in circles. It would be more helpful if you post screenshot of what you really struggle with. I don’t see any issue.

[Next page](https://forum.manager.io/t/16-5-61-inventory-items-can-be-selected-under-items-column/6167.md?page=2)
