News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Inventory Movement Report

Microsoft Dynamics GP (Archived)

Inventory Movement Report

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I need a report for a certain period with beginning stock per item, receivings, adjustments, sales, ending stock

Thanks,

Toni

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Inventory Movement Report

The report provided above could be the base for further customization, in order to make it more dynamics, you could consider the following;

Adding parameters (Start date) and (End date)

Calculating the beginning balance at the stated (Start date) and the ending balance till the stated ending balance

In between, list all the transaction (quantity and cos)

It would be essential to add two "cumulative" columns for quantity and cost as well

Hope this helps,
Community Member Microsoft Employee on at

Like (0)

Report

RE: Inventory Movement Report

Need a report with separate columns for beginning balance, inventory transactions, receiving cost, sales cost, ending balance per item.
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Inventory Movement Report

Find the script below on my Blog for Historical Inventory Trial Balance per Period.

HITB Script per Period
Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Inventory Movement Report

You'll have to develop it. Nothing out of the box in GP will give you that.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans