web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) STOCK MOVEMENT REPORT

Microsoft Dynamics GP (Archived)

STOCK MOVEMENT REPORT

(0) Share

Report

Report

Posted on by Community Member

Hello

I need a stock movement report on Microsoft GP 10.0 that will show the following

Date, Document number, Document Type, Qty in , Qty out, Balance ,Unit Cost, Exteded Qty.

How can i design the report because have check stock actvity under report i can't find it there.

Thanks for your responce.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

I'm guessing you're trying to rebuild a FIFO valuation / record for your inventory.

You can build a report based on the Inventory Goods Received Work file - IV10200.

This is basically the FIFO table...and lists each receipt transaction for an Item, the unit cost from the receipt, the receipt quantity...and the quantity of this receipt that has been sold.

Hope this helps,

Best regards,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your reply.

I have reviewed the Inventory Good Received Work File IV10200. But i want to have a column for Document Type and Document Date so as to Clearly differentiate each transaction (i.e Quantity received and Quantity Sold seperately)

Appreciate your quick response

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

What you need is the Inventory Transaction History table or IV30200

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Community Member 2

#2

#2

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans