Deleting inventory showing stock on hand
I have some inventory items showing stock on hand that was set up by a previous employee, these items we have never had and I have no idea how he entered the stock quantity. I need to delete this items and it will not let me as there is stock showing, if I do an inventory adjustment back to zero it will not let me delete it as there is an transaction against the item. I tried to export the items do delete the stock count but it does not export this field. I am thinking my only option to delete these items is to do an inventory adjustment back to zero, mark the item as inactive and after we roll over to a new year go back and delete them? If anyone has another option it would be greatly appreciated.Solved
Entering a Stocktake after EOY date, and new year invoices already entered.
We would usually do a count and enter a stockate for the 31 March, but due to the lockdown only essential employees have been at our worksite, so no stocktake completed as yet. Because we are still providing parts, I have already started entering in the invoices/jobcards for April. We will hopefully get a stockate done by the end of this month (April) but how do we count it? When I do the actual count, - do I need to take into consideration the parts that have been added for April? and take them off the count? - Or, do I count the actual number on the day we count? My problem is, if I do count the actual number on the day (which will be in April), change the date back to 31 March and THEN tick End of Year on the stocktake, will that cancel out the items for April that have already been entered? and mess up my numbers again? Hope I'm explaining this OK?? Example: At the 31 March we should have had (3) SFmats in stock, (1) was used on a job in April, (4) more were charged to us and entered on April. On the EOY would I review the stock used since 31 March and count 3? or would I count 6?Solved
2 locations and same item in both .
Just started using AR 2020 and since we have 2 locations with the same items in both , one for picking and one for backup stock, we need a report with total on hand . The only reports I have found shows the items/itemnr and then what is in Loc1 and what is in Loc2 and I need a total without the split between locations. The field On hand total or Quantity on hand cant be inserted or modified when you do a customreport . Up comes the On handfield only but then also loc 1 and loc 2 and we only want the totals The same applies if we want the total values for an item we have in 2 locations. It sems all reports insists on show per location. When I look at Inventory from Command centre and the Items list I can see the total and here it is called On hand but when you look at the item information the field I want is called Quantity On HandSolved1.3KViews0likes3Comments
AccountRight: Build Items using labour
Hi MYOB community - Hoping someone can help with this inventory dilemma I have an existing item (Product A: 1 pallet load of product) which is being converted to another existing item (Product B: 120 x 10kg bags of product). However the conversion involves a significant labour cost. How do I convert Product A into Product B and include the labour component? Thank you JennySolved
Beginning inventory balance, add items
Hi, we currently maintain a spreadsheet of inventory items with the ending value recorded in the assets account for inventory and matched to the spreadsheet. I want to move these items into MYOB - 1. I have managed to import all the items using a code and their description, and accounts for buy, sell and inventory. 2. My question is how do I get the quantities of the items into MYOB so that the COGS calculates? Would I need to enter in the last cost of the item into the "standard cost" box to ensure that happens? 3. Going forward, whatever the last cost of the item is would be what we would use. I understand there is a check box in preferences that I should not select to ensure this happens. Please confirm/advise how to proceed?Solved1.2KViews0likes3CommentsInventory Management Software Add On Suggestions - WMS
Hi, Just wondering if any one has experience and recommendation for a WMS Warehouse Management System Add on that works well with Account Right? We want a more robust warehouse inventory management system that can handle batch numbers, serial numbers, barcodes etc. Small to medium size business. I have had a look at Datapel so far. Any recommendations or experienceswould be appreciated. Thanks, NathanCurrent value/ Average cost wrong.
Hi, I am having trouble with a few items that are showing the wrong average cost and current value. I spoke to someone at MYOB yesterday for over an hour but he said it just happens. But it is causing problems as when I try to zero the products out as we have none it wont let me as the total won't be zero. I have included a snapshot of the profile of the product and the buying details page. Hoping you can help. DeanneSolvedImprovement: Now you can check stock on hand quantities from invoices and other transactions
We have released yesterday a nice improvement for inventory users: from any transaction (invoices, bills and inventory adjustments) you can check the item's: - Stock on and quantity - Quantity on Order with Supplier - Average cost of the item This way you can make decisions without living the page. Additionally, if needed, you can now go to any item directly from transactional pages by clicking on the edit item link.1KViews3likes0Comments
Improvement: Now you can check stock on hand quantities from invoices and other transactions
We have released yesterday a nice improvement for inventory users: from any transaction (invoices, bills and inventory adjustments) you can check the item's: - Stock on and quantity - Quantity on Order with Supplier - Average cost of the item This way you can make decisions without living the page. Additionally, if needed, you can now go to any item directly from transactional pages by clicking on the edit item link.
