News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Inventory Stock Status

Microsoft Dynamics GP (Archived)

Inventory Stock Status

(1) Share

Report

Report

Posted on by GPDev2020

25

Hi,

I have a question. I have been tasked with providing an Inventory stack status report for a range of dates. I am using IV10200 to get qty received and qty sold. Problem is, in this table you can have a receipt for an item from say, 2015 and a sale in 2016. But the table saves the 2016 sale under the "Sold" column, even if I request the report for only 2015, I still get the 2016 sale, which I don;t want. There must be something linking the receipt to the sale, but what is it? I need to know so I can "un-link" them

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

sandipdjadhav 18,267 on at

Like (0)

Report

RE: Inventory Stock Status

Hello, I am sure IV10200 won't only help you. IV10200 is summary table where you need to know details about sold/consume details tables which is in SOP , IV transaction etc. Please check SSRS report for Historical Aged IV Trial Balance and find out StoreProcs and can use it.

Thanks much

Sandip

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,430 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans