nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

2 locations and same item in both .

Texet

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

Find more posts tagged with

locations

Inventory

Items

Reporting

Accepted answers

Tracey_H

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.

All comments

Texet

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 .

CloverQ

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.