Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Inventory History Listing

Posted on by 140

Hi Everyone

I would like to know how many oil filters I issued last year.

I issued them thru Asset work order and or Project costing.

Is there a way to get a listing showing the qty issued as well an the qty that i bought and put into stock, sorted by year or item #

Thanks

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Inventory History Listing

    Yes Richard is correct. You can create a custom report for your requirement with helps of Smartlist Builder or report writer or some other reporting tools.

    Hope this helps!!!

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Inventory History Listing

    Use the inventory transaction table and filter for filters and issue transactions.  Link the table to the tables that might contain the documents.  If you have smartlist builder you can do this inside that tool.  Otherwise most report writers will do it.

  • Partsman Profile Picture
    Partsman 140 on at
    RE: Inventory History Listing

    Thanks Everyone,

    That did not quite answer my question.

    I am using Diamond Software (Canada) & Microsoft Dynamics GP 2010

    Diamond Software says that the Inventory Module is Microsoft, and they don't have an answer for me.

    I should have included that I also need to see where the items went,

    Example with Part # 1G8878 filter

    May 1, 2013 I issued 1 to Asset # 845

    June 5, 2013 2 Issued to Workorder/project # Division 1

    October 14, 2013 I issued 9 to Asset 053A.

    Total of 12 used in 2013

    Total of 14 used in 2012 Etc.

    I can use the inquiries suggested, and manually calculate the total used for the year, but was hoping for a report or Inquiry to do that for me.

    Because I am not using the system to sell anything, The Inventory cards don't record these transactions.

    Looking for a report or inquiry that will include the following fields;

    Item #

    Qty issued

    Date of Transaction

    Item cost at the time of the transaction.

    Asset (Equipment) or the Work Order / Project issued to.

    Total that was received from the Vendor

    Date received from Vendor

    Vendor Name that i bought the filters from

    Price paid for each filter.

    I would like to be able to filter the transactions by date ( how many did i use in 2013 or 2012), or any of the fields above .

    Thanks for your help

    Mike

  • Naga Kiran Profile Picture
    Naga Kiran on at
    RE: Inventory History Listing

    Also there is a localization feature called 'Kardex' for Andean region, in case your GP Install is set for Andean region.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory History Listing

    I have previously worked on a customized solution that would just be to the point, check them out; 

    HITB Per Period (Cumulative) – Inventory Balance on a Prior Date

    Please be aware that the scripts above are built on the HITB (SEE30303) table, otherwise, in case you have upgraded from previous GP versions without deploying the inventory reset tool, you will not be able to get any use of the above.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Inventory History Listing

    You can use either Item Stock inquiry(Inquiry-->Inventory-->Item Stock) or Item Transaction Inquiry(Inquiry-->Inventory-->Item Transaction) window to view the report.

    Note: You can set date filter in Item Transaction Inquiry window.

    Hope this helps!!!

  • Suggested answer
    Naga Kiran Profile Picture
    Naga Kiran on at
    RE: Inventory History Listing

    You can use Item Stock inquiry (Inquiry >> Inventory >> Item Stock)  window to know this info. Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans