This topic contains 2 replies, has 0 voices, and was last updated by Mikemacx 7 years ago.

  • Author
    Posts
  • #8226 Score: 0

    Mikemacx
    • Contributions: 0
    • Level 1

    I am stumped…..

    I created a report for inventory by locations that is greater than zero. I thought it was working well, but on closer inspection, I see that the quantity on hand in each location is the total amount on hand, not the quantity in that individual location. I can’t find a “Location – Quantity on Hand” column to work with. Anyone know how I can create a report to see

    1 Grouped locations

    2 Item in that location

    3 exact quantity on hand in that location only

    Thank you
    This is a cached copy. Click here to see the original post.

  • #8227 Score: 0

    JCirocco
    • Contributions: 0
    • Level 1

    I believe what you are looking for is the “Inventory Location” to represent the location being reported by that line and then Location Available, Location On Hand, etc.

  • #8228 Score: 0

    Mikemacx
    • Contributions: 0
    • Level 1

    I tried using a customized Stock Ledger report which seems to give me most of the information i needed. It works with my database to fill in a couple fields not available in theis report. Thank you responding.

You must be logged in to reply to this topic.