Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
March 2020
March 2020
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 hand field 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 Hand
Solved! Go to Solution.
March 2020
March 2020
Hi @Texet
If you run the Item List [Summary] report or the Analyse Inventory [Summary] report, they both displays the item On Hand quantity per location, as well as the total on hand number as well. The Item List [Summary] report also shows the item value, per location and the total as well.
If you want to customise these reports further to only display the total figures, then it's best to export these reports to Excel for further customization. Alternatively, you can also explore the available Add-on solutions for AccountRight, some offers advanced/customisable reporting options.
Kind regards,
Clover
MYOB Community Support
Online Help| Forum Search|Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
March 2020
March 2020
Sorry but I dont think this will wont work.
The list should only have 3 fields
ITem nr, item name and On hand Total per item. Not the field On Hand.
We upload this information daily via a CSV file to our website and our customer can see how many we have of each item . They dont care which warehouse the items are in.
The same report from Enterprise gave us this but now we cant select On Hand Total or Quantity On Hand only On Hand per item and per location .
April 2020
April 2020
Hi @Texet
The Price List (summary) report is another option that may be suitable. It can be customised to display the Units on Hand, which is the total quantity on hand regardless of location. The only issue for you may be that it does include the Base Selling Price.
As mentioned by @CloverQ you may be able to export this report to excel and customise it to suit your needs.
Cheers,
Tracey
Previously @bungy15
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others