cancel
Showing results for 
Search instead for 
Did you mean: 

GMROI query

Former Member
0 Kudos


I am looking for a query to calculate GMROI for an inventory item that I can then display as a UDF in the item master.

Thank you

Stacy

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Stacy,

Have you found any solution for GMROI, because i have the same requirement.

Can you please help me out.

Thanks in Advance.

Former Member
0 Kudos

We are still working on this.  If we come up with something I will be happy to share!

Former Member
0 Kudos

Ya i got it.

We need Inventory value of material per month (we get from this table MBEWH), COGS of that material from GL 40100100 , Sales for that material from delivery data.

Get this per material/Vendor.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

What you mean by GMROI?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Gross Margin return on investment. 

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

How do you calculate?  Any formula?

Thanks & Regards,

Nagarajan