x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 4 replies
  • Subscribers 81 subscribers
  • Views 705 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
92
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
963
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
christopher olson

display separate quantities for each warehouse in item look up

Posted By

Hi there!

I'm a fairly new Sage 100 user and work in a call center that handles sales for multiple warehouses. 

I get a lot of questions about the availability of products and in different sizes (which we use different item codes for).  I would like to be use the item look up list to display a column for the inventory in each warehouse and possibly how many on PO and SO, without needing to go into each item individually. I am able to display Total Quantity On Hand but that only shows all of the warehouses and what's on PO combined and isn't accurate for my needs. 

is there a way to create a custom view in "item list" that will allow me show each warehouse's availability for a product?

Thank you!  

Parents
  • 0

    There is a technique for linking to the IM_ItemWarehouse file to show QoH in an item lookup, but it only works for one warehouse.

    An Excel spreadsheet query of that table, (with Refresh-All pulling in current numbers) could do the same thing through ODBC, although searching could be less than user friendly if your product list is long.

Reply
  • 0

    There is a technique for linking to the IM_ItemWarehouse file to show QoH in an item lookup, but it only works for one warehouse.

    An Excel spreadsheet query of that table, (with Refresh-All pulling in current numbers) could do the same thing through ODBC, although searching could be less than user friendly if your product list is long.

Children

*Community Hub is the new name for Sage City