Campaign with prerequisits

(0) Share

Report

Posted on by Community Member Microsoft Employee

It is easy to create a campaign to sell a specific product, to a specific segment at a specific price in a specific time period.

This works just fine but I want to add one more factor to this equation. I want this special price only to be active when a reference number/campaign number is used. Any thoughts?

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Campaign with prerequisits

You are right, standard does so.

You need a little customization. The price is handled in codeunit 7000 (FindSalesLinePrice). Here there's a function called CalcBestUnitPrice(TempSalesPrice).

If a campaign is active in the Sales Header, you can filter TempSalesPrice (table 7002) by only sales price lines with Sales Type = Campaign.

If no campaign is selected, than you can consider only Sales Price records with Sales Type <> Campaign.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Campaign with prerequisits

Hi Stefano, thanks for the quick response. Campaign is in place but customer gets this special campaign price with every order. I want this to happen only when I want it to. In the order, refering to the campaign number or not, it makes no difference. The special campaign price is ALLWAYS generated for this product for this customer.

Is there a checkbox I am missing?
Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Campaign with prerequisits

You can create sales prices for a particular campaign.

When you create a Sales Order, you can specify a Campaign No. in the header and this affects the sales prices. Check here:

https://msdn.microsoft.com/en-us/library/hh165250(v=nav.90).aspx

msdn.microsoft.com/.../hh165212(v=nav.90).aspx

https://msdn.microsoft.com/en-us/library/hh174278(v=nav.90).aspx