web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Field Service forum

Field Service

(0) ShareShare
ReportReport
Posted on by 522

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:
I have the same question (0)
  • Suggested answer
    antc Profile Picture
    2,911 on at

    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.

    cap2.JPG

  • Suggested answer
    Andreas Cieslik Profile Picture
    9,267 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Field Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans