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.3KViews0likes3CommentsBeginning 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.2KViews0likes3CommentsItems register
I have printed out a report to do my stocktake (report Items Register [Summary]) as of 30 April 2020 and noticed that not all of my purchases are listed in this report. I went back to the window itself and there I can see that the items register does not work anymore for most of the items. this is a selected item for March. I purchased the item and with this purchase a current value and stock on hand was recorded. Unfortunately, the current value and the stock on hand value is zero in Apri despite a purchase recorded: these are my settings (have not changed this in almost five years) for this item: Can anyone helpSolvedItem Number / Description Query
Hi All I have a quick query. I have added all of my item numbers and item name thinking that when I go in and enter the item number (which is the colum in the Invoice / Item ) it brings up the description... for example I have: Item Number 90 Item Name CTN 90cl Trim I assumed that if i entered the item number only in the item number colum it would bring up the description, HOWEVER, it does not recognise the item number and only the full item name.... Is there a solution to this? I thought the whole point of adding item numbers was so that it was a shortcut and the full item description would appear from what was entered in the Item Name. NOTE: the description does come up in full, but I just can enter the item number I have to search for the actual item name in the item number column. Anyone??? Thanks in Advance.Solved961Views0likes1CommentGenerate Price List Report if items are only set as " I buy this item"
Hi there I would like to track the purchase price of the items by downloading the pricing list which shows the last price. However, when I click the price list report, all of the items that i selected as " I buy this item" are not showing at all. I guess it could be related to my set up for items as per below: I dont't know what went wrong. Could you please help me with this to get the last unit price list for items that are purchased. ThanksSolved932Views0likes2CommentsKeeping track of supplier costs and item costs
Hi MYOB, I've currently set-up individual cost of sale accounts for each of our ingredients e.g. pork trim, pork shoulder, pork fat. I"ve also created a cost of sale account for each supplier. At the moment I am able to keep track of how much of each ingredient I am buying in a dollar value however, I cannot see how much I am spending with each supplier. We have 4 suppliers of pork which we regularly buy from. Is their a way to maintain this current set-up but also have MYOB keep track of how much I am spending with each supplier in total? This would be extremely helpful if we are able to do this. Please help.Solved842Views0likes3Commentsinventory register changes from month to month
I have a strange problem. My average cost is way wrong and have no idea why - all purchases coming in are correct but the total value of the inventory is much more than we pay for it. If I look at the inventory register for the period of eg Dec 2019 it give me a current on hand value on 2nd December of approx $7000. this is the opening entry for the period. If I look at the period Decmber to January - the same entry for Dec 2nd is now $8600. How can the value change like this - it is still the opening entry - it just now has the month of January added after the december entries. It gtes worse - if i have negative stock on hand the value of stock instead of being negative is postive and bears no relation to anything that we pay for this stock. so I have the value of my stock being meaningless how do I fix it.SolvedLast Cost of the item picking value before discount is applied
In ARL 2020.3 version, when you use the Disc% when receiving a suppliers invoice the last purchase price isn't correct. It uses the Price before discount and not the Total divided by the qty We are aware of the scenario where it behaves the same in AR Classic(v19) versions as well. But this caused the Items list and items profit margin report are incorrect AT THE VERY LEAST THEY SHOULD MAKE USERS AWARE OF THE PROBLEM. I have hundreds of items with incorrect last cost. The cost of an item is the price less the discount. This is reflected in the cost of goods sold in the MYOB software but not the last cost, it is incorrect and an error in the softwareSolved