Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : MW1+j/0D5sH45bf7PE9E0l
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales Dept Target Report

Like (0) ShareShare
ReportReport
Posted on 16 Dec 2020 06:50:13 by 3,110

Hi Experts,

A Requirement was given to me by Sales Dept Manager to Develop a new report with the following Fields:-

1)Salesman Code 2) Salesman Name 3)Branch 4) Traget 5) achieve 6) %(Percentage) 7)Cleared Order 8) Pending Order  

The purpose of my Post is to from where I could get this requirement what will be the tables ??

Note : Some fields I developed by myself which were not exist in ax such as (Salesman Code  2 Salesman name 3 branch) on Form.

Best Regards,

Shabir Ahmad

  • Microsoft Profile Picture
    on 06 Feb 2021 at 00:42:17
    RE: Sales Dept Target Report

    So when you customized one field, you need to customize the UI and let user and input the value and then the value could be saved to database. then customized the report design to include the field label and field value, then the report would have that value.

  • Shabir Ahmad Profile Picture
    3,110 on 13 Jan 2021 at 03:59:54
    RE: Sales Dept Target Report

    Jasmine Wang

    There is not sales target functionality configured in the system otherwise, SMMsalestarget and SMMsalestTargetTrans are good choice, but they give me there own data in excal sheet for target  etc.

  • Suggested answer
    Microsoft Profile Picture
    on 12 Jan 2021 at 13:27:55
    RE: Sales Dept Target Report

    Could you try to check all the related tables which is  refered to salesTable and also check their relation, then you can decide which table you want to add your customized fields.

  • Shabir Ahmad Profile Picture
    3,110 on 31 Dec 2020 at 07:53:08
    RE: Sales Dept Target Report

    TargetReport.png

    Hi both this is the format they want I to make a report. This is a Target Report on the bases of different branches as well as. There is a list of other product in the same manner in this excel sheet but I wanted just these columns to clear your doubts or any further questions.

    Best Regards,

    Shabir Ahmad

  • Shabir Ahmad Profile Picture
    3,110 on 16 Dec 2020 at 17:59:05
    RE: Sales Dept Target Report

    Hi Jasmine Wang,

    Yes, i already added those fields made customization. but now i am looking for the above requirement from which table I can get those.

    Best Regards,

    Shabir Ahmad

  • Microsoft Profile Picture
    on 16 Dec 2020 at 11:53:58
    RE: Sales Dept Target Report

    for the field that not exist in ax, you need to do customization. and add those filed to one existing table.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on 16 Dec 2020 at 08:57:49
    RE: Sales Dept Target Report

    Hi Shabir,

    I think that we need some additional information especially about the following points

    No 4: How do you define the target and where? (monetary, units, bundles, etc.)

    No 7/8: Are you referring to sales orders only or also things that are related to project related invoices or other kinds of sales invoices?

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,425 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,557 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete