Is there a reason why we cannot customise lists and windows to add more columns. For instance in the Inventory Items list it would be helpful to have a customer or job number column. Alternatively being able to add colums from the custom list on the card detail tab from the Card List.
"Add columns to list and windows"
I run a business with thousands of different parts and they are in ther own bins which are in allocated bays on wharehouse shelving.For example part number ABC is in bay 17B. At a glance on the "Inventory" Tab, under "Itemls List", which tells me quantity on hand, price etc..., i need a column also showing this wharehouse location. I am amazed this feature doesnt exist. I have all my parts with the locations on an excel spreadsheet and it would be good if i could just import that info into MYOB.
Would love to here MYOB's feedback on this.
Frank
Hello Frank,
I have clients with a similar need to you and for them we use the Customs List or the Custom Fields feature in MYOB Items Details tab.
Depending on how many Bays / bins you have you could use the Custom Lists. If there are a very large number then the Custom Field would be used .
For more information see this MYOB Support Note.
http://myobaustralia.custhelp.com/app/answers/detail/a_id/9074/kw/9074
I hope this helps.
Cheers
David
10 YEARS ON AND THIS FEATURE STILL NOT AVAILABE IN MYOB. PARTS LOCATION IS A BASIC FUNCTION ON ALL OTHER PLATFORMS .....NOT MYOB THOUGH
Does anyone else think that the inventory should have customisable fields?
Only having item number, item name, qty on hand, last price, and sell price seems very restricting.
I suggest this as a business owner with thousands of products and trying to remember every items most important information is impossible, and with the extra fields for custom information sorting through inventory lists could be much quicker and easier.
I think this would be helpful for alot of businesses that stock variants of items that are greatly similar to each other, eg
the same items in different colours
the same items in a different size
for second hand dealers wether or not something is new in box or second hand
And of course the added advantage of being able to filter the list with custom fields to see all items of one category together would be massively helpful.
Having fields you could see in your inventory list would help when looking for a specific item and make the parctice of managing the stock data base much easier
Thank you very much for your suggestion BoutiqueGaming
While the Item List Summary report can be customised to display the Custom Lists, having the ability to view the Custom List directly from the Item List screen would make inventory managing easier.
We would love to hear what everyone thinks, please do cast your vote if you wish to see this option in AccountRight, and leave comments if required.
Hi there Formpac
Could you please provide more details as in where exactly would you like the Customer, Job Number or Custom List columns to pull information from? Currently when setting up items you can only specify a Primary Supplier for Reorders, there are no default customer or job number set up for items. Are you looking for the ability to create default customer, job number for item setup as well as showing them in the Item List window?
Hi CloverQ
On the Item Details tab of the Item card there are 3 custom lists and 3 custom fields. I would like to be able to rename the custom lists (which I have done) to Customer Name and Job Number and to see these columns in the Item List. I cannot seem to find any way to customise the columns in the Item List. Currently the only columns supplied are:
Item number
Name
On hand
Last cost
Sell price.
Many thanks
Hi Formpac
Thank you for clarifying your idea and providing additional information
Currently you can only add in certain columns to certain windows/lists. To see which columns you can add right click on the header of the table and select Column Chooser. For most users this would be blank as by default most clients have the full set of columns displayed.
However I would encourage clients that would like to see additional columns to be selected, such as the Custom List fields for the Item List window, to vote and comment if required for this idea.
Add Custom List 1/2/3 and Field 1/2/3 to the Column Chooser in the Item List
Add the ability to lookup an Item by data stored in the Item Custom Fields.
This could then be used to store and lookup items via their barcodes.
Currently the only solution would be to use the item barcode as the Item Number, which totally breaks the ability to do a manual lookup, so you're stuck with having to choose either one method or the other (Manual or Barcode) which in this day and age seems almost prehistoric and it staggers me that this is not already built in, how long have barcodes been around now...?
Realistically there should already be an inbuilt field, either on the Item Details or Selling Details tab for the entry of an item's barcode.
MYOB: If doing a lookup on all three would cause too much overhead, then maybe just Custom Field 1.
I've just started in anew job and proceeded to install 2015.3 knowing that it had 'cloud' functionality, only to be dissapointed to find out that that only means that the data file is stored online. The interface is pretty much the same as in the past, it's unresponsive, even on the powerful PC I've built and looking up items to process an order it still tedious. MYOB, surely you can do better than this...?
I'm always stuck asking myself why using MYOB feels like using software from the 80's, has the source not ever been recoded since then?
I would really appreciate this option being added into the software. We rely on this Items list to quickly find where we store each of our items, which we have listed under custom field #1. However, I can't add this column into the Item List screen so have had to add the location at the start of each item's name (i.e. P1 Finger Nut). This then means that when I generate invoices for our customers, I can't use the description because it comes up saying 'P1 Finger Nut' rather than just 'Finger Nut'. This is a huge cause of frustration for our business.
I would like to be able to add custom 1 to the items list view. At the moment i have to search in excel to find the records by the category as i am unable to view that field inside myob accountright.
It would be EXTREMELY helpful to be able to show the primary supplier and the supplier item number on the Items List screen.
