Inventory Count Sheet - add Columns
Is it possible to add a column for the BIN numbers on this sheet?
Forum Discussion
Hi Rebecca711 , the Count inventory report doesn't have an option for bin numbers. Are you using locations for bin numbers?
Does anyone have a solution or work around. We will be using the Count Invetory sheet "Live" for our end of year stocktake but the items numbers are not listed in BIN order so have to search for items which is quite time consuming as to ensure data accuracy we have to search for the exact Item Number. Have looked at exporting data but even more time consuming and worried when we import that we will have to check items all items - we have around 5000 or more items. Basically staff will use a printout stock sheet by BIN order, and manually tick off or adjust then give to admin to enter Live onto MYOB Accountright Count Inventory and I cannot seem to find a way to make this an easy option for our admin to data enter. I am not even considering data entering onto excel spreadsheet as the Item Numbers when you go into Count Inventory are all over the place, our Item Numbers are all numeric to match up with our supplier Item Numbers so cannot change. Help would be appreciated. Thank you
Hi Rebecca711,
Thanks for sharing your post. At the moment, there isn't an option to add a column. I suggest submitting this suggestion to our product ideas page Product Ideas. Other users can see and vote for it, increasing the chance of our developers including it in a future update.
For further guidance, you can check out this help article: "Set up inventory items" and then proceed to "Optional item setup tasks"
Feel free to post again, we're happy to help!
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
Regards,
EarlI have just set up the same sort of thing not knowing how difficult it would be to filter the reports.
I have set up locations with the Primary Location called 'Warehouse - Picking Locations' with a location also set for 'Display' and separate locations for our 'Bulk' items (Aisle E and F in our warehouse).
To stop the stocktake report crashing, I set up individual custom reports in Inventory for WH, Display and Bulk locations (there are 45 bays in bulk) to run separately, with display and bulk hiding zero quantities. Since the Display items don't move or change, and bulk has to be manually moved in MYOB when stock is being physically moved in the warehouse to a pick location, this means we now only have to actually count Aisles A-E at stock take.
Hope this helps give you an idea on a work around!
