Small and medium business | Business Central, N...

Update Sales Price

(0) Share

Report

Posted on by asouiak

121

Hello ;

Hello friends, the communicator of dynamics Navision is asleep I think it's been a long time there is no real discussion whatever problematic or release, ok, please I have a question on the unit price, once I want to create the order and (enter the item that will be programmed in a special price contract) the price of the second line of the same item is discounted by an amount set in a field in the price contract. I show you an example::

Line NO Item Delivery Date Unite Price LEVEL (D 100)

10000 122222 21/02/2021 1000 1

20000 122222 21/02/2021 900 2

30000 122222 21/02/2021 800 3

40000 122222 21/02/2021 800 3

50000 122222 21/02/2021 800 3

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

JAngle 133 on at

Like (0)

Report

Unsure based on your explanation. Is this for an assembly item? You have roll up price and roll up cost available.

Was this reply helpful? Yes No
asouiak 121 on at

Like (0)

Report

Hello ,

Tanhk You for your reply, No it is a specific development in fact it is a contract with header and lines, which is used to manage the sales prices of the Items by customer,this contract in the line we have a discount field which will be applied after the second delivery but to coditions in the same Zone, same delivery date, same item same customer. I will explain the need again, if I create a sales order the system check if this customer had an active price contract if not the unit price can be entered, but when a contract is applied conditions such as same zone in order line as in the contract, also the price in the first line comes from contract price. if we have second shipment (same area, same item, same shipment date,) the price applied is price (sale - discount) the discount also comes from contract as explained in the first publication.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

Based on what you have written, you are looking for the ability for NAV/BC to correctly price the Sales Lines based on a Contract Sales Price catalog and variable conditions that offer-up a different discount percent. This is not straight forward in NAV/BC so I would lean towards a customization. I know of Trade Allowance addons, but nothing specific to your example

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
asouiak 121 on at

Like (0)

Report

hello

Hello

I think you have understood me a little but my objective is to degrade the unit price if there is another shipment in the same day also same zone, a discount field is already existing in my contract, this discount is based on level each level equals a new line in the order if I add a second line the system check the level applied on the contract line compared to the sales order line.

I think it's a maine code.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

When you say a Contract is setup and this is not development, do you have an APP that provides this functionality? Standard BC has discounting but not as you describe.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
asouiak 121 on at

Like (0)

Report

Hi

Hello, no this is a specific development and the field that had a discount value of $ 10 will be applied on the sales order line I show you an explanatory screenshot.

i need statement to calc the discount automatically for this exemple shard in img

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

OK. I will defer to Developers in the Forum who can answer.

Thanks,

Steve

Was this reply helpful? Yes No
asouiak 121 on at

Like (0)

Report

hello, I stay tuned and I would like to have a good answer during the week it is an urgent request.

Was this reply helpful? Yes No