web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Profit Margin Set

Microsoft Dynamics RMS (Archived)

Profit Margin Set

(0) Share

Report

Report

Posted on by Community Member

Is there a way i can lock my profit margin to % even if new items come in ?

We only use one particular profit margin scheme like lock it 30% default if it need to change we would change the value

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

NO option for this in RMS directly.

If you absolutely require this:

You could create a trigger in the database attached to the [Item] table that would set the price based on the cost and margin. This would then update the price anytime a change was made to the item table (update price, or other item properties)

You need to be careful to not have a circular trigger since you could be updating the item table via the trigger.

Backup database and test when you are closed.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Duplicated Test Database

Can you help with the trigger please

Create Trigger trg_updateprice

ON dbo.item

AS

BEGIN

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans