web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Price Customization for Retail POS

(0) ShareShare
ReportReport
Posted on by 55

I am working on a task to configure the min price for each product.

In a POS transaction If the sales price after the discount that is configured falls under the level of the minimum price, the minimum price need to be taken in consideration.
Is there any option in AX that i can set up it, if not a customization is needed in the code of AX or in POS?

Scenario:

- Sales price agreements for this product (price 133$) 
- Sales line discount for this product (line discount, 5$)
- Min Price 130$ (this field needs to be created on released product form)

The sales price on POS normally goes 128$ after the discount is applied, so in this case the min price needs to be taken in consideration.


Any help would be appreciated! :) 

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Manvendra Singh Profile Picture
    360 on at

    Hi Flutura,

    There's no such as standard functionality available in AX.

    The only way around is customization in both AX and POS. In AX you have to create a field where you can define minimum price. At POS you have to customize to pick that price if sales price cross to that threshold.

    Thanks!

  • FGj Profile Picture
    55 on at

    Hi Manvendra,

    Thanks for your answer.

    Based on your professional experience, have you faced the same case or similar before?  Can you give me a more detailed answer from the technical part?

    Thanks!

  • Suggested answer
    Community Member Profile Picture
    on at

    Hello Flutura.

    Is truth there is no standard form nothing to perform this functionality, what occurs to me is the following:

    1. In Table InventTableModule of AX and POS to add a new field "minimum sales price".
    2. If you want what you add in the master of products for the user configuration.

    min.JPG

    4. Configure this new field in the Pjob to1040 and N1040 in the above mentioned table, this way mandaras this data to the database of POS and you can validate that if you apply a discount to such article XYZ is not less than the minimum value and if it is to take the field "minimum selling price"

    min.JPG

    5. In POS you should perform validation in the project PRICE method GetPrice() (this method you returns the value of the article), what you should do is go to search for that data in the new in the BD with SQL statements on the basis of the item and module which in this case would be sales and already with this simply valid and assigning the new price if you pass your value.

    price.JPG

    6. Compilas the DLL and the remplazas and should in theory funcionarte.

    Bye
    Pablo
  • Suggested answer
    Manvendra Singh Profile Picture
    360 on at

    Hi FGj,

    So for I didn't experience such as requirement. It depends on business requirement.

  • FGj Profile Picture
    55 on at

    Hello Pablo,

    Thanks for your suggestions. :)

    I am testing them but i am facing some difficulties :

    I am not finding the P-job N-1040?

    About the field "campo de destino" is it enough creating a new record in the table RetailConnSchedularSubJobFieldList or should i take any other action?

    Thank you again!

  • Community Member Profile Picture
    on at

    Hello Flutura!

    Regarding the Job you should find more by the description by the Id. In theory should be the same, looking for something in the description as "products, prices and bar codes", because you find sees the work of the developer and verifies whether jobs subordinates is the table that you draw.

    2728.s.JPG

    Then to find that if you go at the number of subordinate work and to the list of fields and add it to your new field, if you do not know how to do this please query in the portal Dynamics about jobs subordinates.

    2728.s.JPG

    Bye Pablo.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 44

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans