News and Announcements icon

Dynamics 365 CommunityForums Field Service forum Field Service

Field Service forum

Field Service

(0) Share

Report

Report

Posted on by megha18

520

Hello,

I need to see the inventory history for example, inventory is moved from warehouseA to warehouseB.

Lets say the no of items in warehouse A is 10 and in B is 12.Now if I move inventory from A to B say 3 units.So i should the see the old value and new values i.e. Total Items : 10, Moved Items : 3, Remaining Items : 9

and in B it should show Total Items : 12, Moved Items : 3, Total Items Items : 15

Something like this, how can i approach to achieve this scenario?

Do I have to customize the entity and then create report?

Any other approach?

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Andreas Cieslik 9,265 on at

Like (0)

Report

RE: Field Service

When look at this article neilparkhurst.com/.../field-service-inventory-quantities written by Neil Parkhurst you can see how Inventory Journals look like.

I could image you could add additional fields to that entity to include the total and the remaining numbers. The quantity column is the moved amount (- => removed; + => added)

A plugin could fetch and calculate the right figures.

The create a report or dashboard and view on that.
Suggested answer

antc 2,909 on at

Like (0)

Report

RE: Field Service

Hello,

You could use a workflow however not sure how you beneficial it would be after more than 1 transfer.

We utilize a mixture of Auditing on Product Inventory and the Journals.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans