Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Actual Cost of Invento...
Microsoft Dynamics GP (Archived)

Actual Cost of Inventory by Lot/Serial Number

(0) ShareShare
ReportReport
Posted on by Community Member

Hi fellow GP users,

Just wondering if anyone knows how to generate a stock report down to the Lot number/site level, that includes the ACTUAL cost the stock was received in at, as opposed to the current  cost.

I know i can get most of this data from the IV10200 table, however what this is missing is the Serial Numbers.  I have not been able to work out how to join this data together as i cannot make sense of how GP does this.

If anyone has a sql view or smartlist builder report that lists all your stock by site, serial/lot # and the ACTUAL cost, as opposed to Current Cost, would you mind sharing?

Thanks


Matt

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Actual Cost of Inventory by Lot/Serial Number

    I actually had the same view created already, until i realised it was missing all the Non Tracked items, and this is where i got stuck.

  • Community Member Profile Picture
    Community Member on at
    RE: Actual Cost of Inventory by Lot/Serial Number

    Thanks for the reply, however that does not give me Non Tracked Items, only Serial/Lot, so is still not what i was after.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Actual Cost of Inventory by Lot/Serial Number

    For that, you will want to base your report on the Item Serial Number Master (IV00200) for serial numbers and the Item Lot Number Master (IV00300) tables. You can mostly do a UNION ALL between the two tables, as follows:

    select 'Serial' as [Item Type], ITEMNMBR as [Item Number], LOCNCODE as [Location], DATERECD as [Date Received], SERLNMBR as [Serial/Lot Number], UNITCOST as [Unit Cost] from IV00200
union all
select 'Lot' as [Item Type], ITEMNMBR as [Item Number], LOCNCODE as [Location], DATERECD as [Date Received], LOTNUMBR as [Serial/Lot Number], UNITCOST as [Unit Cost] from IV00300

    You can use the above query to create a SQL view, which you can then use in a SmartList Designer.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans