mssit
AVImark
Call Us Today
1.877.838.9273
AVImark Forum::Shared Information Searches::Search Request: Inventory
Home AVImark Forum Shared Information Searches Search Request: Inventory
 AVImark Forum :: Shared Information Searches
Welcome Guest   
 Subject :Search Request: Inventory.. 10-01-2011 04:20:43 
Terina
Advanced User
Joined: 06-09-2009 04:32:31
Posts: 238
Location: Poland, Maine
Hello,
I am looking to create two searches; one to find inventory with quantities below zero, and one to let me know inventory items with no associated vendor.

And I am not sure if this one is possible, but is there a way to create a search to let us know what inventory items have a number in the allocated quantity field?

Thank you!
IP Logged
 Subject :Re:Search Request: Inventory.. 10-03-2011 03:47:50 
Information Search Ideas
Advanced User
Joined: 10-11-2010 09:14:32
Posts: 72
Location
Hello,

Here are the three searches. Let us know if you have any questions.

Items with no associated vendor:

search [Item Category] code 'M$LDR244' name 'items with no associated vendor'
category 'MSS Searches' (
[Item-Vendor] is false
) report (
[Item-Code],
[Item-Description]
)



Items with an negative on-hand quantity:

search [Item Category] code 'M$LDR245' name 'items with negative on hand quantity'
category 'MSS Searches' (
[Item-On Hand] is less than '-1'
) report (
[Item-Code],
[Item-Description]
)


Items with a number in the allocated quantity field:

search [Item Category] code 'M$LDR246' name 'items with a number in the allocated field'
category 'MSS Searches' (
[Item-Allocated Qty] does not equal '0'
) report (
[Item-Code],
[Item-Description]
)
IP Logged
 Subject :Re:Search Request: Inventory.. 10-03-2011 07:56:43 
Terina
Advanced User
Joined: 06-09-2009 04:32:31
Posts: 238
Location: Poland, Maine
Thank you!
I guess my only other request on the allocated search, was to report which clients the inventory is/ are linked to.

Thanks again.
IP Logged
 Subject :Re:Search Request: Inventory.. 10-06-2011 02:18:58 
Information Search Ideas
Advanced User
Joined: 10-11-2010 09:14:32
Posts: 72
Location
If you want to see who the allocated quantity is linked to you would need to run the unposted transactions report under "work with" and then "reports."
IP Logged
Page # 


Powered by ccBoard


" We are very pleased with the software and its potential and use as we grow in the computer involvement to our hospital. "

Suzanne Hiler


Chat Hours:
Monday - Friday
8am - 5pm CST

Mss rewards

Sign up for a year of AVImark technical support and get additional discounts when you use these other services. Click Here to Learn More
MSS Data Vault MSS Pet ID McAllister Payment Solutions MSSITPetwise
Copyright © 2012 McAllister Software Systems, LLC. All rights reserved.