Skip to Content
avatar image
Former Member

Stock Counting Per Category - Query

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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.

    Add comment
    10|10000 characters needed 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

  • Oct 11, 2017 at 12:30 PM

    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
    
    Add comment
    10|10000 characters needed characters exceeded