Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Bob O’Malley]

Hello –

Does anyone have a script/report that would produce what serial numbers for a specific item were on hand for a specific location and date (including Sales and adjusted that day)?  I’ve seen some blogs and articles, but nothing resembling a historical stock status report with serial and lot number details.

Thanks in advance!
Bob

——————————
Bob O’Malley
Lead, Business Analyst
Stanley Healthcare
Waltham MA
——————————

[Steve Erbach]

,

Sounds like you’re outlining a Historical Inventory Serial Number Trial Balance! I’m sorry that I don’t have a solution for you… I’m just admiring the possibility!

It seems ?to me that, since receipts and shipments of serial-numbered products would include the serial numbers, one could construct such a report… but it would be tricky. I cannot even build a prototype because we don’t deal with serial-numbered products.

Sincerely,

——————————
“Sparkly” Steve Erbach – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach

—————
Excel Webinar List as of 22-Mar-2019
——————————
——————————————-

[Bob O’Malley]

?- thank you for the response!  I was able to put together something that I think will do the trick.

Best regards,

——————————
Bob O’Malley
Lead, Business Analyst
Stanley Healthcare
Waltham MA
——————————
——————————————-

[Steve Erbach]

,

Well, that sounds like the perfect thing to share with the Forum, eh? Do tell! How’d you do it?

Sincerely,?

——————————
“Sparkly” Steve Erbach – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach

—————
Excel Webinar List as of 22-Mar-2019
——————————
——————————————-