# Search Function on Purchase Invoice

**URL:** <https://forum.manager.io/t/search-function-on-purchase-invoice/38005>\
**Category:** Uncategorized\
**Created:** [November 15, 2021, 3:53pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005 "2021-11-15T15:53:16Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 15, 2021, 3:53pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/1 "2021-11-15T15:53:16Z")

</div>

Purchase Invoice search option does not look for Order Number ? The Order Number is also not listed on the screen.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/7/8793a478d43d285fae1cfbd13905160472ef8973.png)

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [November 15, 2021, 4:37pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/2 "2021-11-15T16:37:19Z")

</div>

There is a limit to what can be shown on the screen before it becomes unreadable - is there a column you would like to get rid of?

---

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 15, 2021, 5:06pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/3 "2021-11-15T17:06:19Z")

</div>

Hi Joe,

As you can see, the columns in Sales Invoice, there is order number after # column… total of 8 columns…

It could be great to have the Order Number for the Purchase Invoice as well… see below picture… total of 7 columns…

 ![image001.png](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/b/7bb74e2c8cfd00d21744dc77a6ec64c9d7a729fd.png)

(Attachment oledata.mso is missing)

---

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 15, 2021, 5:34pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/4 "2021-11-15T17:34:04Z")

</div>

Hi Joe,

As you can see, the columns in Sales Invoice, there is order number after # column… total of 8 columns…

It could be great to have the Order Number for the Purchase Invoice as well… see below picture… total of 7 columns…

 ![image001.png](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/b/7bb74e2c8cfd00d21744dc77a6ec64c9d7a729fd.png)

 ![Manager.jpg](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/7/376cb7b6714afd34e71113a5c82787038d4b81fd.jpeg)

---

<div class="post-metadata">

**Author:** ![Mark](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mark](https://forum.manager.io/u/Mark)\
**Post date:** [November 15, 2021, 5:46pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/5 "2021-11-15T17:46:17Z")

</div>

What version are you using? 'Cos in v21.11.20 I see:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/b/0b187ba88262a342e8ad204fd239057661c983e0.png)

---

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 15, 2021, 6:36pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/6 "2021-11-15T18:36:14Z")

</div>

Yes, I am using 21.11.20…

 ![image001.png](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/d/8d74113984c23f408d940adfaac7da48dc3509b3.png)

 ![image002.png](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/b/8b4770382b757ff87eab5919188dc6fc3f483622.png)

(Attachment oledata.mso is missing)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [November 15, 2021, 7:19pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/7 "2021-11-15T19:19:25Z")

</div>

I also see what @Mark sees. If there is an order number on a purchase invoice displayed on the screen, that column shows.

---

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 15, 2021, 10:04pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/8 "2021-11-15T22:04:39Z")

</div>

I just created a new Purchase Invoice and included Order Number 00000 but on the screen list, order number does not appear. Should i uninstall the manager and install again ? …

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/8/386676a62667b8f85774811165314ab6583a6820.jpeg)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [November 15, 2021, 11:15pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/9 "2021-11-15T23:15:27Z")

</div>

@zikzak, your screen shot in post #6 is cut off, but it looks like you might have a very strange supplier entry, And in post #8 you have no supplier at all. What happens when you have a legitimate supplier selected for the purchase invoice and purchase order?

---

<div class="post-metadata">

**Author:** ![sharpdrivetek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sharpdrivetek/32/34244_2.png) [@sharpdrivetek](https://forum.manager.io/u/sharpdrivetek)\
**Post date:** [November 16, 2021, 2:55am UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/10 "2021-11-16T02:55:20Z")

</div>

The purchase order number will appear as a column when you select it on the Supplier line.  
So make sure you enter the purchase order in the Purchase Orders tab and then select it on the purchase invoice on the Supplier line.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [November 16, 2021, 3:20am UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/11 "2021-11-16T03:20:52Z")

</div>

Good detective work, @sharpdrivetek. @zikzak, in your first partial screen shot, you can just barely see that the linked order number field to the right of the supplier is blank. And, or course, since you did not choose a supplier in the second screen shot (as I mentioned earlier), the order field itself does not appear on the form.

---

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 16, 2021, 12:45pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/12 "2021-11-16T12:45:12Z")

</div>

problem solved… i have checked “Purchase Orders” selection and now it does show Order Number…

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/6/2604d9cf50a45129ead76b7f5fa0eac5dd848b6b.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mark](https://forum.manager.io/u/Mark)\
**Post date:** [November 16, 2021, 1:06pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/13 "2021-11-16T13:06:04Z")

</div>

> [@sharpdrivetek](#):
>
> The purchase order number will appear as a column when you select it on the Supplier line.

In that field you can only select the ref. # of previously created Purchase orders. If you select a Purchase order ref. # there then the Order # field at the top disappears. But it seems that the ref. # in that field is only shown in the Order # column when the Purchase invoice is created from a Purchase order. In the Order # field at the top you can enter whatever ref. # you want and it will show in the Order # column.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [November 16, 2021, 1:15pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/14 "2021-11-16T13:15:17Z")

</div>

> [@zikzak](#):
>
> problem solved… i have checked “Purchase Orders” selection and now it does show Order Number…

So the issue was that you actually had no purchase order numbers to show, because you had no purchase orders.

---

<div class="post-metadata">

**Author:** ![zikzak](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/zikzak/32/35385_2.png) [@zikzak](https://forum.manager.io/u/zikzak)\
**Post date:** [November 16, 2021, 2:38pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/15 "2021-11-16T14:38:11Z")

</div>

i think this is a little glitch. i do not create neither Sales Orders nor Purchase Orders. I create directly Sales Invoice and create a Purchase Invoice from it. When Sales Orders tab is not checked, i can still see the Order Number on Sales Invoice screen… But for some reason, when Purchase Order tab is not checked, i can not see the Order Number on Purchase Invoice screen shot. i think it is all about the Optional Quote Number and Order Number columns that are added on the Purchase Invoice.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [November 16, 2021, 2:41pm UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/16 "2021-11-16T14:41:37Z")

</div>

No, it is not a glitch. The application is programmed to display reference numbers for purchase orders **when they exist**. You did not have the Purchase Orders tab enabled. Therefore, you could not possibly have had any purchase orders. Therefore, there was nothing for the application to show.

The fact that you can manually enter some number into a field on the purchase invoice form does not mean you have created a reference number for a non-existent purchase order.

---

<div class="post-metadata">

**Author:** ![jimmy](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jimmy/32/6255_2.png) [@jimmy](https://forum.manager.io/u/jimmy)\
**Post date:** [June 13, 2024, 2:08am UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/17 "2024-06-13T02:08:06Z")

</div>

@Tut @Mark

Greetings,

I am experiencing a similar issue and, despite navigating through the forum, I have not found a solution. Therefore, I decided to post here instead of creating a new topic.

My problem is that I do not automatically receive an order number when generating a new purchase or sales invoice. In previous versions (more than a year ago), creating a new purchase or sales invoice would automatically generate an order number.

I have managed to insert an order number field in the custom fields under obsolete features, but it remains at the bottom of the page. It appears that the option is still available because if I clone an older purchase or sales invoice, the order number is retained. However, even in the edit column view, there is no order number field unless I create one in custom fields. Unfortunately, older invoices do not display an order number, as the new order number field appears blank at the bottom of the page.

I have attached a few screenshots for reference

 ![PI_old](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/0/90112b61b92ad72032bd4870d2862b4bb8067ca9.png)  
 ![PI_new](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/d/bd2ab46831f2d63597d49929cf5795e0c5a62844.png)  
 ![SalesInv_old](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/8/98f705170da3ffd26304929e214641fe58baf316.png)  
 ![SalesInv_new](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/b/4b7f8c138d3e3f1fe70a01af45f6e92f6359f000.png)  
 ![PI_editcolumn](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/4/4/440ba3df2043beebbe27949ca7bb722f547b9505.png)  
 ![SI_editcolumn](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/8/9882cc6416ec4384e70ace97125cc2a5996247ec.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 13, 2024, 2:14am UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/18 "2024-06-13T02:14:34Z")

</div>

> [@jimmy](#):
>
> However, even in the edit column view, there is no order number field unless I create one in custom fields.

Yeah, that’s the way to do it. If you want to record order number but don’t want to use `Sales Orders` / `Purchase Orders` tabs, then just create custom field.

> [@jimmy](#):
>
> Unfortunately, older invoices do not display an order number, as the new order number field appears blank at the bottom of the page.

I need to make it so the hidden field is converted into custom field. Then you will be able to search by order number across older invoices too.

---

<div class="post-metadata">

**Author:** ![jimmy](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jimmy/32/6255_2.png) [@jimmy](https://forum.manager.io/u/jimmy)\
**Post date:** [June 13, 2024, 2:39am UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/19 "2024-06-13T02:39:25Z")

</div>

Thank you, so will I have a hidden field of Order number as I used to have for years? and will it be at the top of the page next to the reference? Let me know when its done… Thank you in advance

---

<div class="post-metadata">

**Author:** ![jimmy](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/jimmy/32/6255_2.png) [@jimmy](https://forum.manager.io/u/jimmy)\
**Post date:** [June 18, 2024, 5:56am UTC](https://forum.manager.io/t/search-function-on-purchase-invoice/38005/20 "2024-06-18T05:56:32Z")

</div>

@lubos  
Hi there, any update for that issue yet?  
Kind regards  
Jimmy

[Next page](https://forum.manager.io/t/search-function-on-purchase-invoice/38005.md?page=2)
