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 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
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.
