Skip to Content
0

Stock Counting Per Category - Query

Oct 05, 2017 at 11:02 AM

55

avatar image
Former Member

Hi All,

i am looking to build a query that shows the number of Stock Counts Per Category and Per item in a year? We need to identify if the warehouse is counting often enough and that they are counting the right things.

many thanks in advance,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 05, 2017 at 12:27 PM
0

Hell@ James:

Did you review the standard reports?

Go to the Menu - Inventory - Inventory Reports

I think the Inventory Audit Report could help you.

Reg@rds.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Dear Oscar,

The system report it to much detail in comparison to what we need. I am looking for the item and how many times that item has been counted over the year? Is this possible?

Many thanks,

Jamees

0
Zal Parchem
Oct 11, 2017 at 12:30 PM
0

Hello James:

Below is some SQL I wrote for a Customer. It might help you out. This SQL shows what is posted through the Inventory Posting Window (path of Inventory Module > Inventory Transactions > Inventory Counting Transactions > Inventory Posting).

Before using the SQL, please check out the IQR1 table to review the different data fields relating to quantity - there are several and not sure what quantity you might be looking for.

Hope this helps!!!

Regards, Zal

--H-IN Inventory Counts Performed by Warehouse and Date Ver 1 ZP 2016 07 06
--DESCRIPTION:  SQL lists out data found on Inventory Posting Window and arranges it by warehouse item code and count date.
--USAGE:  Finance and Warehouse Personnel
--AUTHOR(s):  
--Version 1 Zal Parchem 06 July 2016

SELECT 
T0.WhsCode,
T0.ItemCode,
T0.ItemName, 
T0.CountDate, 
T0.DocEntry, 
T0.DocLineNum, 
T0.Quantity 

FROM IQR1 T0 

ORDER BY 
T0.WhsCode, 
T0.ItemCode, 
T0.CountDate
Share
10 |10000 characters needed characters left characters exceeded