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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

Calculations of GMROI and Inventory Turns Report

(0) ShareShare
ReportReport
Posted on by 114

I have some items that sell very quickly... so quickly that I am not able to receive them into the SO Manager backend before they are sold and gone.

Example: I put the items on the shelf as soon as I get them off the truck (because people are wanting and asking for these items) and they are sold through the MS RMS 2.0 POS before I can fully receive them via the Store Operations backend...

As a result it is sold before it is received into inventory.

MS RMS sees this as being negative inventory and it changes all of the calculations for the individual item... makes the numbers negative and nonsensical at best.

Does any one have a fix for this problem?

A Special Custom Report that accounts for this by using number totals and not the order in which the transactions occur?

Thanks!

*This post is locked for comments

I have the same question (0)
  • The Guns and Gear Store Profile Picture
    114 on at

    Any ideas?

  • Community Member Profile Picture
    on at

    I have a custom report that is designed to work with HQ and/or SO databases using the same executable, and through a simple configuration screen you can decide whether the application connect to HQ database only, SO database only, or both of them. You will be able to know the following details per item: -

    ï‚· Opening quantity and cost value for the selected period

    ï‚· Sales transaction quantity and cost value during the selected period

    ï‚· Transfers in quantity and cost value

    ï‚· Transfers out quantity and cost value

    ï‚· Purchase Orders quantity and cost value

    ï‚· Physical Inventory quantity and cost value

    ï‚· Others (all remaining movement types) quantity and cost value

    ï‚· Closing quantity and cost for the selected period

    So if u r interested, please email me at ahmed.hassan@rmsleaders.com

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans