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
Duplicated Test Database
Can you help with the trigger please
Create Trigger trg_updateprice
ON dbo.item
AS
BEGIN
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.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
