Forum Discussion

Texet's avatar
Texet
Experienced Cover User
5 years ago
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 ...
Inventory
Items
locations
Reporting
  • Tracey_H's avatar
    Tracey_H
    5 years ago

    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.

CloverQ's avatar
CloverQ
Former Staff
5 years ago

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.

  • Texet's avatar
    Texet
    Experienced Cover User
    5 years ago

    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 .

    • Tracey_H's avatar
      Tracey_H
      Former Staff
      5 years ago

      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.