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
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.
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
Also there is a localization feature called 'Kardex' for Andean region, in case your GP Install is set for Andean region.
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.
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!!!
You can use Item Stock inquiry (Inquiry >> Inventory >> Item Stock) window to know this info. Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (