web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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

I have the same question (0)
  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    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.

  • Community Member Profile Picture
    Community Member on at

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

  • Community Member Profile Picture
    Community Member on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans